Troubleshooting
Problem
Message Received: Oracle Error 1632
Symptom
PART: DCS 6.0 SP2 DCS
COMPONENT: <None>
OS: <None> -
<None>
DATABASE: <None> - <None>
WEB SERVER: <None> - <None>
WEB
BROWSER: <None> - <None>
Cause
Resolving The Problem
Locate the line in the WMS alert log containing the relevant package
name
Sample error:
W34wms_alert.log:W34 |215879 |0 |WH2349 |120 |0 |3
|Oracle |Error |whs_parm.c |1
166 |Oracle Err PK66113222.PR66113222 SqlCode
0 SQLCD -1632 SqlMessage . |2 |20000
427004815 |whprod |WHP106
The
data point PK66113222 is the package name; the three digits after 'PK' are part
of the associated table name (in this example, '661').
To obtain the full
table name, prepend these three digits with 'T074':
Table Name:
T074661
Find the associated indexes:
SQL>select * from
all_indexes where table_name = 'T074661';
Check the maxextents for these
indexes to determine what needs to be increased.
Increase the maxextent
with the following SQL command:
SQL>alter index [table/index name]_INDEX
storage (maxextents unlimited) ;
Historical Number
PRI48096
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21529572