DatabaseException: partition of such index is in unusable state
Database exceptions were seen in log files and poor performance observed in system.
Error in commit()
com.pega.pegarules.pub.database.DatabaseException: ORA-01502: index 'PC_ASSIGN_WORKLIST_PK' or partition of such index is in unusable state
Steps to Reproduce
A defect or configuration issue in the operating environment:
The database table pc_assign_worklist was moved to a new table space. The move left the database index in an unusable state. Without an index on this table, the query performance is poor.
Make the following change to the operating environment:
Rebuild the index.
Published September 2, 2016 - Updated September 13, 2016