Connection errors leading to failure of jobs and issues on portlets

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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

Environment

Release : All

Component : CLARITY ENVIRONMENT

Cause

Database is refusing the connections or there is network issue between Clarity APP server and DB server.

Resolution

1. Validate with Network team about the connectivity between Clarity App Server and the Database (DB) server.
2. 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....