By himab9688 on

I am new to Workday HCM, running an integration and getting following error. Can anybody give me direction on troubleshoot this issue or any know solution to this.

An Error occurred when processing the query. The query returned too many results.. Cause: com.workday.exceptions.EndUserException: An Error occurred when processing the query. The query returned too many results.

Comments

Donna09’s picture

Donna09 commented

The error message you faced in workday HCM suggests that the query you executed returned too many results, which exceeded the system's limitations. This error can occur when the query you're running generates a large dataset that exceeds the maximum threshold set by Workday. You want solve this error, then first of you all Refine your query, Use pagination, Check data filters and parameters, Consider optimizing the query and Contact Workday support.

Bigbird230’s picture

Bigbird230 commented

In my opinion,

This error typically occurs when the integration is attempting to retrieve a large number of records that exceed the configured or system-defined limit. To troubleshoot this issue and find a solution, follow these steps:

  1. Review the Query: Double-check the query being used in the integration. Ensure that it's appropriately defined and isn't too broad, causing an excessive number of results.

  2. Apply Filters: Modify the query to include filters or criteria that narrow down the results. This can help reduce the number of records returned by the query.

  3. Pagination: Implement pagination in your integration to fetch results in smaller, manageable batches. This can prevent the error caused by retrieving a large number of records in a single request.

  4. Review Integration Configuration: Check the integration configuration settings in Workday to ensure that any result limits or thresholds are set appropriately and align with the requirements of your integration.

  5. Consult Workday Documentation: Refer to the Workday integration documentation, error logs, or any relevant resources provided by Workday for guidance on resolving this specific error.   I hope it will help.