• 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