Symptom
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.
Environment
Successfactors
Reproducing the Issue
Run query process with 10 minute timeout setting for Adhoc API entities with expected volume on the high side.
Cause
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.
Resolution
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
OR
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
Keywords
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