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

book

Article ID: 50264

calendar_today

Updated On:

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 KNOWLEDGE TOOLS 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: