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)