Clarity Upgrade fails with ORA-01720 on CMN_INDX_MONITORING_V

Products

• Clarity PPM On Premise

Issue/Introduction

When upgrading Clarity from version 16.4.1 to 16.4.2 on an Oracle database, the process fails during the DB Driver installation phase. The error specifically occurs while attempting to create the CMN_INDX_MONITORING_V view.

 

Install.log

java.sql.BatchUpdateException: error occurred during batching: ORA-01720: grant option does not exist for 'SYS.USER_OBJECT_USAGE'SQL Text: CREATE OR REPLACE FORCE VIEW CMN_INDX_MONITORING_V ... FROM USER_OBJECT_USAGE

Environment

Clarity 16.4.2

Cause

Missing Oracle privilege for the Clarity schema user

Resolution

Install Clarity with Oracle

A script to setup clarity DB user privileges in Oracle is captured here: Set the Database Required Oracle User Privileges 

CREATE USER <ppm> IDENTIFIED BY <ppm> DEFAULT TABLESPACE users_large TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;

GRANT ALTER SESSION TO <ppm>;
GRANT CREATE ANY CONTEXT TO <ppm>;
GRANT CREATE PROCEDURE TO <ppm>;
GRANT CREATE SEQUENCE TO <ppm>;
GRANT CREATE SESSION TO <ppm>;
GRANT CREATE TABLE TO <ppm>;
GRANT CREATE TRIGGER TO <ppm>;
GRANT CREATE VIEW TO <ppm>;
GRANT DROP ANY CONTEXT TO <ppm>;
GRANT QUERY REWRITE TO <ppm>;

Note: Replace <ppm> with your clarity schema name.