SAP Knowledge Base Article - Public

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

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 

 extension.jpg

OR

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

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

Product

SAP SuccessFactors HCM Suite all versions