Workato · Recipe job
Temporary job dispatch failure
Short answer
"Temporary job dispatch failure" means the job's actions used up the finite memory allocated to the job container. Redesign the recipe to process data in batches and to stream files instead of loading them whole.
VerifiedLast verified
01Error text
Temporary job dispatch failure02Likely causes
- Actions exhaust the job container's memory allocation.
- Looping through a large batch and running search, update and create for each record.
- Using the
bytesizeformula on a file, which forces a full download. - Using Collections to parse CSV.
03How to fix it
- Replace per-record loops with batch upsert actions, such as the SQL Server upsert rows action.
- When source and destination batch sizes differ, use repeat in batches.
- Use file streaming, especially for files over 100 MB, and use file metadata outputs such as the Size datapill for size checks.
- Use the JDBC Export action for large query results.
- Use CSV Parser instead of Collections to parse CSV.
04Official documentation
→Related errors
- CSV parsing errorThe Workato error type err.data_format.csv_parsing_error means CSV content could not be parsed because of a malformed structure or an invalid delimiter. Check the file for stray delimiters, such as commas inside values, and correct the source.
- java.lang.OutOfMemoryError: Java heap space (on-prem agent)This error in the on-prem agent log means the agent does not have enough memory for a large job or payload. Raise the Java heap with the -Xmx option and restart the agent.
- recipe execution takes too longA Workato API platform endpoint returns 504 with recipe execution takes too long when the API recipe's job does not respond within the endpoint's timeout. The default is 30 seconds and the maximum is 240 seconds, so make the recipe faster or raise the endpoint's timeout.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Workato work:Open Workato jobsWorkato rates and salariesHire a senior Workato developer