Loading

Data Sync or Dataflow error: 'NUMBER_OUTSIDE_VALID_RANGE' in CRM Analytics

게시 일자: Apr 30, 2026
상세 설명

CRM Analytics data sync and dataflows run through the Integration User. The Integration User profile must have "View All Data" as well as the "Read" and "View All Records" Object Permissions for every object in data sync and dataflows. If the "Analytics Cloud Integration User" profile has been cloned and modified, it may not have the necessary permissions and will cause an error like the following: 

When this error occurs you will see in the job log: 'Something went wrong while executing node [node name]: Error in bulk query: NUMBER_OUTSIDE_VALID_RANGE: Maximum SOQL offset allowed is 2000.' This typically means the Analytics Cloud Integration User profile is missing the View All Data permission.

솔루션

Ensure the Analytics Cloud Integration User Profile has "View All Data"

Before performing any other troubleshooting, check the Profile assigned to the Integration User to ensure it has "View All Data". This perm is required for CRM Analytics to function properly.


Ensure the Analytics Cloud Integration User Profile has "Read" and "View All Records" for the Object

Review the Object Permissions for that object within the Profile assigned to the Integration User. Ensure the profile has Read and View All Records granted for the specified object. More information about managing Object Permissions can be found here: Edit Object Permissions in Profiles


Additional Reference:
Control Access to Salesforce Objects and Fields
Best Practices: Manage Integration and Security Users in CRM Analytics

Knowledge 기사 번호

000387057

 
로드 중
Salesforce Help | Article