After upgrade of AutoSys components on IXP host, AutoSys instances do not respond

Products

• CA Workload Automation iXP

Issue/Introduction

iXpdaemon.log has errors like this

08-13 01:42:32:   db-S21:java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
08-13 01:42:32:   db-S21:at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1353)
08-13 01:42:32:   db-S21:at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1162)
08-13 01:42:32:   db-S21:at java.lang.Class.forName0(Native Method)
08-13 01:42:32:   db-S21:at java.lang.Class.forName(Class.java:264)
08-13 01:42:32:   db-S21:at com.pgti.ixp.core.db.DbConnector.getPhysicalConnectionY(DbConnector.java:495)
08-13 01:42:32:   db-S21:at com.pgti.ixp.core.db.DbConnector.access$000(DbConnector.java:54)
08-13 01:42:32:   db-S21:at com.pgti.ixp.core.db.DbConnector$1.run(DbConnector.java:435)
08-13 01:42:32:   db-S21:com.pgti.ixp.core.exception.IxpException:com.microsoft.sqlserver.jdbc.SQLServerDriver
08-13 01:42:32:      S21:connecting:primary
08-13 01:42:32:   db-S21:java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
08-13 01:42:32:   db-S21:at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1353)
08-13 01:42:32:   db-S21:at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1162)
08-13 01:42:32:   db-S21:at java.lang.Class.forName0(Native Method)
08-13 01:42:32:   db-S21:at java.lang.Class.forName(Class.java:264)
08-13 01:42:32:   db-S21:at com.pgti.ixp.core.db.DbConnector.getPhysicalConnectionY(DbConnector.java:495)
08-13 01:42:32:   db-S21:at com.pgti.ixp.core.db.DbConnector.access$000(DbConnector.java:54)
08-13 01:42:32:   db-S21:at com.pgti.ixp.core.db.DbConnector$1.run(DbConnector.java:435)
08-13 01:42:32:   db-S21:com.pgti.ixp.core.exception.IxpException:com.microsoft.sqlserver.jdbc.SQLServerDriver

Resolution

• Copy the needed sqljdbc jar file to appropriate iXP tomcat location, for example:

cp -p mssql-jdbc-9.4.0.jre8.jar /opt/apache-tomcat-9.0.102/lib

cp -p mssql-jdbc-9.4.0.jre8.jar $AUTOSYS/jre/lib/ext

 

• Restart iXP