Support Article

DatabaseException: partition of such index is in unusable state

SA-27610

Summary



Database exceptions were seen in log files and poor performance observed in system.

Error Messages



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



Unknown

Root Cause



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.

Resolution



Make the following change to the operating environment:
Rebuild the index.

Published September 2, 2016 - Updated September 13, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.