Symptom
When attempting to run an Advanced Extraction Delta Load in SAP Signavio Process Intelligence, it fails with the following error.
Error: JobId=abc1d234-d123-a123-b123-123456789, File size validation failed for /etltmp/123456789.tmp
-
- NOTE: The JobId and .tmp file have been anonymized.
Further analysis by SAP Signavio Support may find the following error.
EtlException: File: /etltmp/123456789.tmp size exceeds the maximum allowed size of 5120000000 bytes. Current file size: n bytes.
-
- Where n is the size of the file when the error occurred.
Cause
Only 1 partition was used, and the amount of data being extracted was too large for an internal file limit.
Resolution
For the Delta Load, set a Delta Load Criteria so that the incoming data is partitioned into files less than the internal file limit.
This may need several attempts to get the partitioning correct.
See Also
Keywords
etl, extract, transform, transformation, load , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem
SAP Knowledge Base Article - Public