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

    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