Connection errors leading to failure of jobs and issues on portlets
Article ID: 187376
Clarity PPM On PremiseClarity PPM SaaS
Multiple connection errors / DBConnectionError result in failure of Jobs and different issues over the application.
Examples of errors that may be seen in the logs:
[CA Clarity][SQLServer JDBC Driver]Object has been closed.
Failed to retrieve database version java.lang.RuntimeException: Unexpected invocation exception: [CA Clarity][SQLServer JDBC Driver]Object has been closed.
[CA Clarity][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
Exception due to DB Connection failure
Example of job impacted: Datamart Extraction job
Release : All
Component : CLARITY ENVIRONMENT
Database is refusing the connections or there is network issue between Clarity APP server and DB server.
Validate with Network team about the connectivity between Clarity App Server and the Database (DB) server.
Check with the DBA if there is any unplanned maintenance that may have brought the DB Down or bottleneck on the database server such as connection limit being exceeded, etc....