Recompile Invalid Database Objects from Clarity

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

How can database invalid objects be recompiled from the Clarity server with a command? 

Environment

Release : All supported Clarity releases

Resolution

• On the Clarity PPM application server, run the command from command prompt/shell:
  admin db compile
• This will compile all existing objects and show you any that could not be compiled.
• If any remaining objects, they should be fixed with assistance from the DBA, follow Invalid database objects on the database instance

Additional Information

In some situations it can be normal to have some objects causing this, check out Some database objects show as Invalid in Health Report