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