Skip to main content

When querying my data from SAP SF or running my package in SSIS, I’m getting the following error message: 

Get data error: rCOE_SNAPSHOT_BAD_REQUEST] We have temporarily blocked the snapshot pagination request from companyUser Test |ODATA for all entities until Thu Mar 20 15:51:40 UTC 2025 because too many consecutive requests have been attempted without accessing subsequent data.

This error comes from a limitation of the SAP SF API and it happens when firing multiple parallel requests to the same entity. It usually happens when trying to query multiple navigation properties for a given entity at once. It seems like the maximum number of threads/concurrent requests allowed by the SAP SF API is 4. If a fifth concurrent request is fired to the same entity, then the given entity is blocked for 30 minutes.

In order to resolve this issue, you need to reduce the number of threads being used by our connector to no more than 4. 

If you are using our SSIS components, please go to your package settings and set MaxConcurrentExecutables=4:

For other editions of the connector such as Power BI, ODBC, etc. the recommended workaround is to change the MaxThreads connection property of the connector to something equal or less than 4. You can start experimenting with MaxThreads=1 and then increasing the value gradually to see what works best for you:

 

CData's Winter 2025 Release
Terms and ConditionsCookie settings