SYMPTOM:
Users receive error messages similar to the following when running any reports or attempting to edit any objects in Strategy Web or Developer 9.x or 10.x:
Database error <>: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-01502: index `…` or partition of such index is in unusable state
CAUSE:
This error indicates that an attempt to access an index partition or index has been made and that it has been marked unusable by a direct load or by a DDL (Data Definition Language) operation. The problem usually happens when using the Direct Path for the SQL*Loader, Direct Load or DDL operations. This usually requires sufficient temporary space to build all indexes of the table. If the TEMP tablespace does not have sufficient space, all rows will still be loaded and imported, but the indices are left with a STATUS = 'INVALID'.
ACTION:
It is necessary to rebuild the index partition or index that has been marked unusable.
NOTE:
The solution is applicable to users with an Oracle database. Contact the database administrator or vendor to resolve this database issue.
Third Party Products Disclaimer
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
