SAP Knowledge Base Article - Public

2659636 - Boomi Adhoc API Integration Process Async Query Process Timeout Error : [EXCEPTION] Executing async query timeout


Adhoc API Query response timeout with below error :

[EXCEPTION] Executing async query timeout Job Id: TASK-ADHOC-XXXXXX

**All screenshots in this KBA have been taken from Demo system.



Reproducing the Issue

Run query process with 10 minute timeout setting for Adhoc API entities with expected volume on the high side.


Async query timeout property was set to 10 minutes (timeout) only not able to accomodate the load or lapse time of the whole query process.


Timeout time (async query only) is the time the connector will wait for an Adhoc/Asynchronous query report to run successfully. Some process may require more than 10 minutes. In such use cases, set the Async Timeout to higher values. In boomi it allows for up to 6 hours max.

In Connector and Operation Properties in Boomi. "Timeout time (async query only)"  and "Default Async Query Timeout(async query only)" properties can be used to configure timeout for async query.

Sample Screenshot(s)

Boomi Design Runtime 



Build or design Tab.jpg

Note : Async Job Operations provide an approach to invoke the API asynchronously. Currently the Async Job Operations are limited to running queries on only the Adhoc_XXX entities

See Also

SAP SuccessFactors HCM Suite SFAPI: Developer Guide

SAP SuccessFactors HCM Suite Product Page


Async query, Adhoc API, Boomi Process Property, Boomi Operation / Design Runtime Property, com.boomi.connector.api.ConnectorException: Executing async query timeout, com.successfactors.connector.SFQueryOperation.executeAsyncQuery , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-CUS , SF Boomi & CPI (HCI) Custom Content , Problem


SAP SuccessFactors HCM all versions