Cannot load JDBC driver class error causes CA Workflow login to fail

Document ID : KB000050264
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

CA Workflow login fails with the below error messages:

Cannot load JDBC driver class 'com.ca.common.EncodedPwDriver2'
java.lang.NoClassDefFoundError: Could not initialize class com.ca.common.EncodedPwDriver2
at java.lang.Class.forName0(- Cannot load JDBC driver class 'com.ca.common.EncodedPwDriver2'
- Cannot load JDBC driver class 'com.ca.common.EncodedPwDriver2'

Solution:

This error generally occurs when CA Workflow is installed on the Secondary Service Desk Server.

In the NX.env file of the Secondary Server where WF is installed value of @NX_JDBC_DRIVER is blank. Set this NX variable to as

@NX_JDBC_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver

Stop Services in the following order Stop Primary -> Stop Secondary -> Start Secondary -> Start Primary

This will resolve the error.