Print this page

Dataflow Error "NUMBER_OUTSIDE_VALID_RANGE" in Wave Analytics

Knowledge Article Number 000230796
Description Wave Analytics dataflows run through the Integration User. The Integration User profile must have "View All Data" as well as the "Read" and "View All" Object Permissions for every object in the dataflow. If the "Analytics Cloud Integration User" profile has been cloned and modified, it may not have the necessary permissions and will cause the following error: 

Error executing node sfdcDigest_Node: Error in bulk query: NUMBER_OUTSIDE_VALID_RANGE: Maximum SOQL offset allowed is 2000
Resolution

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


Retrieve the dataflow JSON

1. Gear Icon > Data Monitor

2. Change view to Dataflow View

3. Click the dropdown options on the right side and select Download

4. Open the resulting file in your favorite JSON editor


Locate the specified sfdcDigest_Node to determine the Object

 

This will appear as follows:

 
"sfdcDigest_Node": {
    "action": "sfdcDigest",
    "parameters": {
      "object": "Object",
 

Review the Object Permissions for that object within the cloned/modified "Analytics Cloud Integration User" profile. Ensure the profile has this Read and View All granted for the specified object. More information about managing Object Permissions can be found here: Edit Object Permissions in Profiles

 

Restart the Dataflow

1. Gear Icon > Data Monitor

2. Change view to Dataflow View

3. Click the dropdown options on the right side and select Start

 

Additional Reference:
Control Access to Salesforce Objects and Fields

Best Practices for the Wave Analytics Integration User





promote demote