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.
Boomi Design Runtime
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
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 , SF API & Adhoc API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , LOD-SF-INT-CUS , Boomi/HCI Custom Content , Problem