Troubleshooting
Problem
"ORA-01502 Oracle Index in Unusable State" after upgrading to Sterling v8.5 from v7.9
Symptom
Sterling requires enough temporary table space to build all indexes on the
table during migration/upgrade. In case of lack of temporary table space during
upgrade, all the indices will be loaded but their status will be set to
'INVALID' in the USER_INDEXES table.
Any attempt made
by Sterling application to access those indices in 'INVALID' status will result
in this error.
Error Message
"ORA-01502 Oracle Index in Unusable State"
Resolving The Problem
Sterling recommends the following to resolve this error:
1. Run the query given below to find all the indexes that are in
'INVALID' status
SELECT * from USER_INDEXES WHERE STATUS =
‘INVALID’;
2a. Drop and recreate each
specified index.
OR
2a. Rebuild each
specified index.
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
NFX8611
Product Synonym
[<p><b>]Function Area[</b><p>];Database;[<p><b>]Severity[</b><p>];Normal
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21558318