ETL process is started twice, only one process completes successfully
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Problem Symptoms:
The ETL process is started twice, only one process completes successfully
Example from ETL status report
194 FULL Complete Aug 18, 2013 Aug 18, 2013 7 hours 4 minutes 24 seconds
193 FULL Failed Aug 18, 2013
192 FULL Complete Aug 11, 2013 Aug 11, 2013 7 hours 7 minutes 19 seconds
191 FULL Failed Aug 11, 2013
190 FULL Complete Aug 4, 2013 Aug 4, 2013 6 hours 43 minutes 30 seconds
189 FULL Failed Aug 4, 2013
Even when the process ends with "Complete" a lot of data is missing from ARC.
Checking the ETL error log files on the Aleph server this error is shown:
"SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued."
There were also error messages concerning the incomplete load of records
Table mrr_bib_info Loaded 1616877 of 1064547 - Not all records were loaded
Table mrr_fact_items Loaded 11834731 of 7141817 - Not all records were loaded
Cause:
ETL process was started from test server at the same time $alephe_tab/job_list was copied from production to test server
Resolution:
1. Comment out the lines in $alephe_tab/job_list on test server
2. Reload job_list
util e/16/19 'Reload job_list/job_list.conf in jobd'
- Article last edited: 6-Jun-2016