Oracle error 1502 occurs connecting to the database - HxGN SDx - Update 64 - Administration & Configuration

When connecting to the database, the following error is displayed, indicating an index for the database is unusable:

• ORA-01502: index 'XXXX_Data.PK_SCHEMAOBJDETAIL' or partition of such index is in unusable state

Solution

Perform the following procedure to make the index usable:

1. Run IIS reset on the selected site.

2. Log in to the site database and run the following SQL commands.

   Each command should be executed one at a time, rather than in a batch.

   select status from user_indexes where index_name ='PK_PUBOBJPRDETAIL'; (the status should be unusable)

   alter table "PUBOBJPRDETAIL" drop constraint "PK_PUBOBJPRDETAIL";

   drop index PK_PUBOBJPRDETAIL;

   alter table "PUBOBJPRDETAIL" add constraint "PK_PUBOBJPRDETAIL" primary key ("OBJPROBID");

   select status from user_indexes where index_name = 'PK_PUBOBJPRDETAIL'; (the status should be usable)