Oracle error 1502 occurs connecting to the database - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

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.

    SHARED Tip 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)