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