Error: Unable to Retrieve the Report as It Timed Out

Issue

A report fails to sync with one or both of the following errors, while other reports sync successfully:

• Unable to sync Workday Report
• Unable to retrieve the report as it timed out

Environment

Connector: Workday RaaS

Resolution

To reduce the report runtime, try one or more of the following actions:

In Fivetran, configure dynamic report parameters to limit subsequent syncs to data from the previous sync date through the current date:

1. Go to your Workday RaaS connection page.
2. Select the Settings tab.
3. Click Edit connection.
4. Find the report and click Edit.
5. Set the Enable Dynamic Parameters toggle to ON.
6. Configure the required dynamic query parameters.
7. From the Choose sync strategy for your connector drop-down menu, select Sync updates from last sync.
8. Click Save.

In Workday:

• Remove unnecessary fields, particularly calculated or multi-instance fields.
• Add filters or prompt parameters to reduce the number of rows returned.
• Split the report into multiple smaller RaaS reports.

Cause

This issue occurs when Workday takes longer than the allowed response time to generate and return a large or complex report. Workday RaaS doesn't document a maximum supported number of columns, so sync performance depends on factors such as the number and complexity of fields and the volume of data returned.

The issue is likely specific to the affected report if:

• Connection tests succeed.
• Other reports sync successfully.
• Splitting the report into smaller reports allows the sync to complete.