IM connector failed to start on Identity Portal

Products

• CA Identity Portal

Issue/Introduction

We are seeing the following error while IM connector failed to start on Identity Portal after upgrade to 14.5

java.lang.NoClassDefFoundError: com/microsoft/sqlserver/jdbc/SQLServerBlob
    at com.microsoft.sqlserver.jdbc.DDC.convertStreamToObject(DDC.java:672)
    at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(dtv.java:3891)
    at com.microsoft.sqlserver.jdbc.DTV.getValue(dtv.java:289)
    at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:198)
    at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1926)
    at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1907)
    at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getBlob(SQLServerResultSet.java:2673)
    at org.jboss.jca.adapters.jdbc.WrappedResultSet.getBlob(WrappedResultSet.java:781)

Environment

Identity Portal 14.5

Cause

 Microsoft SQL JDBC driver enables TLS encryption by defaul

Resolution

Add the encryption argument (encrypt=false;trustServerCertificate=true) in the following configuration files for non-TLS communication.

 

Non-Cluster: <AppServer_Install_DIR>\standalone\configuration\standalone.xml

Cluster: <AppServer_Install_DIR>\standalone\configuration\standalone-ha.xml

 

Restart the WildFly or JBoss EAP application server.