Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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


    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?'

    Category: ETL (ARC)/ARC

    Subject: ARC

    • Article last edited: 3/3/2014