Clarity PPM: Oracle Database Performance Issues

Document ID : KB000125120
Last Modified Date : 24/01/2019
Show Technical Document Details
Issue:

Our DBA team has been identifying several very long running sessions in the Clarity database. The database sessions needed to be killed and it is a problem that keeps coming back.
We are unable to identify a root cause.

The app and bg log show the following error

java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Object has been closed. 
at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source) 
at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source) 
at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source) 
at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)

Cause:

This issue can be caused by one or more of the following:

1. Load Balancer configuration
2. Database changes
3. Environmental/migration changes

Resolution:

Please have the DBA team review and confirm that the required Oracle database parameters and settings are set in order for Clarity to perform at the most optimal performance.

https://docops.ca.com/ca-ppm/15-5-1/en/installing-and-upgrading/install-ca-ppm#InstallCAPPM-ConfigureaPPMDatabasewithOracle 
Section: Configure a PPM Database with Oracle