Symantec Identity Manager - Upgrading Java for Tibco Jaspersoft causes PoolableConnectionFactory error

Products

• CA Identity Suite
• CA Identity Manager

Issue/Introduction

After upgrading java on the Jasperreport server and removing the old version, the below error is being thrown.

2022-01-06 11:29:25,915 ERROR JDBCExceptionReporter,localhost-startStop-1:101 - Cannot create PoolableConnectionFactory ([Tibcosoftware][SQLServer JDBC Driver]Error establishing socket to host and port: MachineName:1433. Reason: D:\CA\Java\jdk1.8.0_181\jre\lib\security\cacerts (The system cannot find the path specified))

Environment

Release : 7.1.1

Component : Broadcom Identity Manager / Tibco Jasperreport

Resolution

There are two locations to check to resolve this error.

First navigate to Tomcat\bin run tomcatw > Java and set the Java Virtual Machine variable  (note the name tomcatw needs to match your service name example ServiceName = Tomcat8.1 then the filename needs to be renamed to Tomcat8.1w)

Next, Navigate to webapps\jasperserver-pro\Meta-inf\context.xml and set the JVM patch accordingly.

Once this was corrected the application started successfully with valid DB connections.