• Article Type: General
• Product: Aleph
• Product Version: 3

Problem Symptoms:
ETL status report shows the general error message:

TaskID and Description:4206, DELETE RECORDS FOR INCREMENTAL LOADING STG_FACT_ITEMS Error:ORA-01722: invalid number

Cause:
Defect

Resolution:
The error 'ORA-01722: invalid number' is solved by ARC 3.0 rep_change #3.

Incremental ETL - When an item history record is deleted from Aleph, deletion from STG_FACT_ITEMS creates an "invalid number" error message in the ETL "General Error Messages" report. This has been corrected.

This rep_change is included in ARC Service Pack 1-9.

Install the Service Pack and re-run the incremental ETL.