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
Release : 15.9.2
Component : CA PPM INTEGRATIONS & INSTALLATIONS
This is a database issue
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:
Ask them to verify all the permissions thoroughly as well.