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

    p_manage_01: 350: Syntax error at line 1. Expecting keyword LOAD, found "1".

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Running p_manage_01 in ABC01, in the ./abc01/scratch/p_manage_01_c.log:

    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    table_type = FIX load_mode = NONDIRECT option = go
    Username:SQL*Loader-350: Syntax error at line 1.
    Expecting keyword LOAD, found "1".
    01XXXXX000025906

    The jobs is not progressing: all logs are showing “sleeping...” at the end of the file.
    I’m going to kill it.


    **[A second run:]**

    p-manage-01 finished in ABC01 with two errors:

    cd /exlibris/aleph/u20_1/abc01/scratch
    view p_manage_01_d1.log

    table_type = VAR load_mode = DIRECT option = go
    Username:SQL*Loader-951: Error calling once/load initialization
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

    table_type = VAR load_mode = DIRECT option = go
    Username:SQL*Loader-951: Error calling once/load initialization
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

    Resolution:
    Word index finished w/o errors after I ran aleph_shutdown and Oracle restart.

    • Article last edited: 10/8/2013