• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
The p_manage_01 job completed this morning. It's seems to have finished OK, but I see the following in the log:

Commit point reached - logical record count 14853242
Commit point reached - logical record count 14853342
Commit point reached - logical reSQL*Loader-605: Non-data dependent ORACLE erro
r occurred -- load discontinued.

cord count 14853442
Commit point reached - logical record count 14853542
Commit point reached - logical record count 14853642

And later:

mv /exlibris/aleph/u16_3/odn07/files/z98.seq /exlibris/aleph/u16_3/odn07/files/
z98.seq.variable
fixed_size 40
Username:SQL*Loader-605: Non-data dependent ORACLE error occurred -- load disco
ntinued.

SQL*Loader: Release 9.2.0.3.0 - Production on Thu Apr 3 07:20:08 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Commit point reached - logical record count 100
Commit point reached - logical record count 200

Resolution:
As described in KB 16384-2561, this "non-data-dependent ORACLE error" can be due to a lack of space. The job halts. If space is added, it continues. It seems that this is what happened since we see that the job *did* continue, and seems to have finished successfully.

It may be that the tablespace is automatically extensible: this message occurred and after it automatically added the space, it continued.

You can check the alert.log -- which, in this case, is on the $ORA_HOST server. That may show more.

Though it's not always fool-proof, all of the p_manage_01_e.cycles lines have "+ +", indicating success.

• Article last edited: 10/8/2013