Upgrade fails with ORA-00904: "DBMS_METADATA"."GET_DDL": invalid identifier

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Upgrade fails with

5/18/21 3:40 AM (ExecTask) Process - post-upgrade: POSTUPGRADE_CHANGE_EDIT_RIGHT.xml
5/18/21 3:40 AM (ExecTask) com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 107, column 30:
5/18/21 3:40 AM (ExecTask) PL/SQL: ORA-00904: "DBMS_METADATA"."GET_DDL": invalid identifier

Environment

Release : 15.9.2

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Cause

This is a database issue

Resolution

Please run the following query:

SELECT TO_CHAR(DBMS_METADATA.GET_DDL('INDEX',index_name)) object_def,'INDEX' object_type ,index_name object_name,table_owner object_owner from user_indexes

This has to be run with the Clarity DB user and results should be returned.

If you have the same error, provide the query to the DBA and let him know this has to be set up so the Clarity user is able to have the right to execute this. 

This will likely has to do with how the schema and database is setup and the permissions. Check with DBA on this:
https://docs.oracle.com/database/121/ARPLS/d_metada.htm#ARPLS66868 

Ask them to verify all the permissions thoroughly as well.