p_manage_18: "load was aborted because SQL Loader cannot continue."
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
1. I'm loading converted bib files into ABC01 via Util Conv.
2. Util Conv is using p_manage_18 and creates log files in /abc01/report/.
3. There are five input files -- bib.index.a* -- in /abc01/scratch/
4. The first file -- bib.index.aa -- was loaded correctly.
5. A log file for the second and rest of the files contains error:
/abc01/report/p_manage_18_doc_all.ab.20071219.1545.9619.log =>
table_type = VAR load_mode = DIRECT option = go
Username:SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Resolution:
Adding files to the tablespace and re-running p_manage_18 resolved the problem.
Before that:
I have gathered the info shown below about the load. What I would like you to do is to run the load again so we can compare the results of a second run to the "first run" shown below.
The /exlibris directory could run out of space. Please delete the following $data_scratch files before starting your run:
bib.index.ab.js
bib.index.ac.js
bib.index.ad.js
bib.index.ae.js
Results of first run:
The following grep on "Load completed" in the report directory shows the following counts of records loaded:
hopkins1-18(1) NYU01-ALEPH>>grep 'Load comp' *
p_manage_18_doc_all.aa.20071219.1509.9216.log:Load completed - logical record count 999460.
p_manage_18_doc_all.ab.20071219.1545.9619.log:Load completed - logical record count 517165.
p_manage_18_doc_all.ac.20071219.1618.10041.log:Load completed - logical record count 978.
p_manage_18_doc_all.ad.20071219.1652.10572.log:Load completed - logical record count 889.
p_manage_18_doc_all.ae.20071219.1653.10918.log:Load completed - logical record count 1954.
aa: 999460
ab: 517165
ac: 978
ad: 889
ae: 1954
The records above total 1,520,446 while the input files contain records 000000001 - 2996363 (2,996,363 records).
These are the records in each file:
aa: 000000001 - 000999460
ab: 000999461 - 001999020
ac: 001999021 - 002897442
ad: 002897443 - 002920795
ae: 002920798 - 002996363
abc01@ALEPH1> select max (Z00_DOC_NUMBER) from z00 where Z00_DOC_NUMBER > 000999461 and Z00_DOC_NUMBER < 001999020;
**** Hit return to continue ****
MAX(Z00_D
---------
001516091
Records 1516092 - 1999020 have not been loaded.
These records *are* in input file bib.index.ab .
Adding files to the tablespace and re-running p_manage_18 resolved the problem.
- Article last edited: 10/8/2013