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

    SQL Loader error 605 Non-data dependent ORACLE error -- load discontinued

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

    Description:
    We ran our first full ETL after having Oracle and Cognos upgraded on the test server. There are 5 errors in the logs. 3 of them are normal errors that always appear (2 small data issues on fact_items and bib_info, and the absence of the call_no_topics table). I am not concerned about those errors.

    However, there are 2 additional errors this time that appear to be related to Oracle. These errors appear in the ETL Extract Error List p_arc_extract_error_list.log and appear to be related to the loading of OPAC events:

    /exlibris/aleph/u20_1/abc50/scratch/p_arc_01_c.log:
    Commit point reached - logical record count
    SQL*Loader-605- Non-data dependent ORACLE error occurred
    -- load discontinued.

    /exlibris/aleph/u20_1/abc50/scratch/p_arc_01_c.log:
    Username-SQL*Loader-605- Non-data dependent ORACLE error occurred
    -- load discontinued.

    /exlibris/aleph/u20_1/abc50/scratch/p_arc_01.log:Table mrr_opac
    Loaded 13276384 of 20915261
    - Not all records were loaded

    We are scheduled to have the production server upgraded on July 19-21. We would like to have a better understanding of what the problem is here before proceeding.

    Resolution:
    [From Jerry:] It seems that KB's 16384-2563 and 16384-2561 may be relevant.

    [From site:] Our DBA added more datafiles to the TS_ARC_D tablespace, which appears to have fixed the problem.


    • Article last edited: 10/8/2013