Troubleshooting
Problem
( oerr ora ) Oracle Error PKxxxYYYY.PRxxxYYYY SqlCode 0 SQLCD -XXXX SqlMessage oracle error 1654 on PK5761234 finding the table or index from error
Symptom
Oracle Error on CRT / RF Screen and/or in wms_alert.log
Oracle error
message:
Oracle Err PK4769522.PR4769522 SqlCode 0 SQLCD -1654
SqlMessage
Oracle Err PKxxxYYYY.PRxxxYYYY SqlCode 0 SQLCD -XXXX
SqlMessage
Cause
Resolving The Problem
The 'xxx' stands for 'xxx' in Table Name 'T074xxx' ==> Synonym
'zzzz_YANTRA_DCS_TABLE'
The 'YYYY' indicates 'Package / Procedure' PRxxxYYYY
for that table that gave this error.
This piece of code can be found in
$BASE/database/whse_schema/whsp Directory.
This will be in file
't074xxx.sql'
The SQLCD code is : XXXX or 1654
At the Unix
prompt, use 'oerr ora XXXX (example 1654)' to display error
information
01654, 00000, "unable to extend index %s.%s by %s in
tablespace %s"
// *Cause: Failed to allocate an extent for index segment in
tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add
one or more
// files to the tablespace indicated
For
Tablespace, Data File, or Index related errors please contact System Admin /
DBA first or call Yantra Support for a more detailed explanation of the
message.
Historical Number
PRI48277
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21545758