Health report generation failed for Clarity running on Oracle DB

Products

• Clarity PPM On Premise

Issue/Introduction

When accessing the Clarity Health Report (Administration-> Security and Diagnostics-> Health Report), the following error is seen on some of the tabs:

Error Health report generation failed

In the app-ca.log the following error is seen:

ERROR 2023-05-25 16:21:40,147 [https-openssl-nio2-443-exec-13] services.HealthReportService (clarity:<user>:70702745__E8B8A844-6A5C-4D2D-B95E-962E55768CA3:nmc.healthReport) 
com.niku.union.persistence.PersistenceException: 
SQL error code: 942
Error message: ORA-00942: table or view does not exist

Executed:
 SELECT LOWER(NAME) NAME,VALUE,DESCRIPTION FROM V$PARAMETER
              WHERE UPPER(NAME) IN ('PROCESSES','FILESYSTEMIO_OPTIONS','COMPATIBLE','OPEN_CURSORS','QUERY_REWRITE_ENABLED','OPTIMIZER_MODE',
......

Environment

Clarity On Premise
Oracle DB

Cause

The Clarity user in Oracle does not have access to the V$PARAMETER view.

Resolution

Have the DBA grant select access to the V$PARAMETER view to the Clarity user:

SQL> grant select on v_$parameter to ppmuser;

Then try re-running the Health Report