Apex Code Development You need to sign in to do that
Don't have an account?
R557 CRM Analytics
Hi,
I keep getting the following error as soon as I run a Dataset, containing ReportEvent, for the Analytics App :
Something went wrong while executing the Sync_ReportEvent node: [error category: USER]: MALFORMED_QUERY: ;Id > '0Qu000000000000' ORDER BY Id ASC LIMIT 1 OFFSET 249999; ^;ERROR at Row:1:Column:66;field 'Id' can not be sorted in a query call [error category: USER] [error code: 213] (02KP0000000nlaGMAQ_03CP0000001GTnsMAG)
Need help in getting around this error, in order to build a dashboard in Analytics Studio for Report usage.
I keep getting the following error as soon as I run a Dataset, containing ReportEvent, for the Analytics App :
Something went wrong while executing the Sync_ReportEvent node: [error category: USER]: MALFORMED_QUERY: ;Id > '0Qu000000000000' ORDER BY Id ASC LIMIT 1 OFFSET 249999; ^;ERROR at Row:1:Column:66;field 'Id' can not be sorted in a query call [error category: USER] [error code: 213] (02KP0000000nlaGMAQ_03CP0000001GTnsMAG)
Need help in getting around this error, in order to build a dashboard in Analytics Studio for Report usage.
Looks like you are trying to connect ReportEvent Object into CRM Analytics.
ReportEvent is a big object that stores the event data of ReportEventStream and it is part of Real-Time Event Monitoring Objects:
https://developer.salesforce.com/docs/atlas.en-us.platform_events.meta/platform_events/sforce_api_objects_reportevent.htm
https://developer.salesforce.com/docs/atlas.en-us.platform_events.meta/platform_events/platform_events_objects_monitoring.htm
This is not listed under supported Salesforce Big Objects in Analytics. So we can't pull this object directly into analytics.
https://help.salesforce.com/articleView?id=bi_integrate_salesforce_extract_transformation_big_objects.htm&type=5
If you see Special Access Rules in the above platform guide, it states:
"Accessing this object requires either the Salesforce Shield or Salesforce Event Monitoring add-on subscription and the View Data Leakage Detection Events user permission."
If you want to use this object(other than in analytics) please reach out to your Account Executive for licenses.
We do have existing feature requests(Idea) created on this area. You can up-vote it as well: https://ideas.salesforce.com/s/idea/a0B8W00000GdnTHUAZ/big-objects-from-real-time-event-monitoring-should-be-supported-in-tcrm
If this information helps, please mark the answer as best. Thank you