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

Description:
In running p_manage_32 you get this message:

Username: SQL*Loader-908: Unable to lock table ABC01.Z0102 due to ORACLE error 54.

Resolution:
It seems that this occurs when you try to cancel a run of p_manage_32 (or _320) and you kill the manage_32 (or _320) but not the z0102 load process. When the job is restarted, the log will show messages like this:.

ERROR at line 1:.
ORA-00054: resource busy and acquire with NOWAIT specified.
CREATE TABLE ABC01.Z0102 (.
ERROR at line 1:.
ORA-00955: name is already used by an existing object.

Then later, when actually tries to do the load, you get the "Unable to lock ... due to ORACLE error 54".

• Article last edited: 10/8/2013