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

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: