Indexes have been marked unusable in the database for Clarity application

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Some indexes have been marked unusable in the database which caused application slowness.

Please help us find the root cause as we are not sure what could have triggered this issue

Here are the details from the database log.

C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.PRTASK have been marked unusable
C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.CMN_PAGE_PORTLETS have been marked unusable
C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.CMN_PAGES have been marked unusable
C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.CMN_INSTANCE_PAGES have been marked unusable
C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.CMN_PAGE_PORTLET_STATUS have been marked unusable
C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.CMN_CAPTIONS_NLS have been marked unusable
C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.CMN_CAPTIONS_NLS have been marked unusable
C2YPR02(3):Some indexes or index [sub]partitions of table NIKU.CMN_ATTRIBUTES have been marked unusable

Environment

Release : Any

Component : Database

Resolution

• The issue you are facing is not a Clarity issue, but an Oracle database issue. Unfortunately we cannot provide a root cause analysis as it's not caused by Clarity application.
• To resolve this issue, please involve your DBA, and ask them to fix the problem.
• Here is a possible solution you can share with them: DBA-ORACLE.COM Solution
• If this doesn't resolve it, we recommend raising a case with Oracle Support to assist.