Clarity Upgrade Fails with error ORA-01031: insufficient privileges

Products

• Clarity PPM On Premise

Issue/Introduction

Clarity Upgrade Fails with error ORA-01031: insufficient privileges

Environment

Release : 15.6

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Cause

This issue is due to DB permissions missing that are required as part of the upgrade process. 

The install.logs will typically indicate the query that is attempted to run that is missing access. Example, if Grant Create Type to PPM_DWH is missing, you may see something similar to the below where it shows the step that it's failing at is Create or Replace Type

8/03/19 4:44 AM (ExecTask) Process - pre-upgrade: DWH_STRING_AGG_FCT1.xml

8/03/19 4:44 AM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CAClarity][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges

8/03/19 4:44 AM (ExecTask) ORA-06512: at line 2

8/03/19 4:44 AM (ExecTask) SQL Text:

8/03/19 4:44 AM (ExecTask) BEGIN

8/03/19 4:44 AM (ExecTask) EXECUTE IMMEDIATE 'CREATE OR REPLACE TYPE vcArray AS TABLE OF VARCHAR2(4000)';

8/03/19 4:44 AM (ExecTask) END;

Resolution

Check to ensure the correct access rights are granted in the database for both Clarity DB and DWH including:

• Grant Sequence to PPM_DWH 
  
• Grant Create Type to PPM_DWH 
  

Additional Information

See Upgrade Clarity PPM for details on upgrade steps.