function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JBo1980JBo1980 

SF to Tableau Error while pulling queries in the connector

Has anyone seen this error?  We have been pulling queries successful for a year from SF to Tableau and then this past weekend hit this error HTTP Bad request ExceededQuota APIBatchItems Limit exceeded

Unable to clear the error and resume the pulls.
AbhishekAbhishek (Salesforce Developers) 
Hi,

The error you are receiving seems due to you exceeding the ApiBatchItems limit. Check your account to see the limit your ORG is entitled to.

Its a 24hour limit and resets every 24 hours.
This limit hits when the total number of batches processed in a day exceeds the limit. 

Thanks.

 
JBo1980JBo1980
Yes I checked both bulk apis and apis - way under our limits for the past 7 days.  Thanks.
AnudeepAnudeep (Salesforce Developers) 
It appears that you are hitting the Bulk API Limit (You can process 100 million records per 24 hour period(10,000 batches x 10,000 records per batch))

Call the Limits API with a GET request to know your usage. My recommendation would be to wait for 24 hours for the limit to reset. If the issue still persists,  log a case with support should you need an increase or if you want them to provide insights into bulk jobs ran in the last 24 hours and number of records processed per batch
  
GET /services/data/v45.0/limits

You will get a response that shows remaining batches
  
"DailyBulkApiRequests" : {
    "Max" : 10000,
    "Remaining" : 10000,
  }

If you find this information helpful, please mark this answer as Best

Anudeep
 
AbhishekAbhishek (Salesforce Developers) 
Salesforce has a limit of 10,000 batches that can be processed in a 24-hour period. The error message is displayed when the limit is exceeded. ... The only solution is to wait for the 24-hour period to pass

Check this article for reference,

https://support.veeva.com/hc/en-us/articles/360038048774-Error-ExceededQuota-ApiBatchItems-Limit-exceeded-in-MCCP-job

https://success.salesforce.com/answers?id=9063A000000DnViQAK

Thanks.