• 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