csk failure applying cop_programScheduleDashboard.xml

Products

• Clarity PPM On Premise

Issue/Introduction

After upgrading Clarity to 16.0.1, when installing the csk it fails with the following error:

ERROR 2022-03-09 12:03:12,692 [main] persistence.PersistenceController Exception due to DB Connection failure
Error Applying XOG: Failure occurred while applying queries/cop_programScheduleDashboard.xml
Check /opt/cappm/logs/content/xog/csk/queries/cop_programScheduleDashboard_out.xml for errors
mar. 09, 2022 12:03:12 P. M. org.apache.tomcat.jdbc.pool.interceptor.ConnectionState reset
GRAVE: Unable to reset autocommit state to connection.
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Object has been closed.

When locating the query in Clarity and previewing it, the same error pops out. The attributes list of the query throws a system error.

Cause

The error is caused by the DISTINCT SQL statement

Resolution

1. Locate the cop.programScheduleDashboard on the installation directory
/META-INF/content/xog/csk/queries/
2. Remove the DISTINCT statement
3. Install csk by running: 

admin content csk

Note: If the DISTINCT statement is to be used, terminate the query with GROUP BY statement