Error in ETL status report: "ORA-01722: invalid number" for deletion from STG_FACT_ITEMS
- 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.
Additional Information
Information for the ARC Service Pack can be found in our documentation center at > Aleph > Download Center > Aleph Reporting Center (ARC) > Version 3.
See also article for download information 'Where can I download the latest ARC 3.0 Service Pack?'
https://exlibrisgroup.my.salesforce.com/articles/Q_A/Where-can-I-download-the-latest-ARC-30-Service-Pack?popup=true
Category: ETL (ARC)/ARC
Subject: ARC
- Article last edited: 3/3/2014