SOI Down tried to install patch 4.2C1 and 4.2C2 didn't work. Went back to previous snap shot SOI did not come back up.
Release : 4.2
Component : Service Operations Insight (SOI) Manager
The SOI Manager was not coming online due to a problem connecting to the SOI Database.
We see the following error in the soimgr-debug.log when it starts up...
2022-01-10 10:52:00,051 INFO [ServletInit] ?.?(?) - Manager initialization failed [count=992]. Will try again after 15 seconds.
2022-01-10 10:52:15,958 INFO [SOICAT] ?.?(?) - resourceBundleLoc=registry:///topology/logical/tenant0/usmschema/localization/
2022-01-10 10:52:15,958 INFO [SOICAT] ?.?(?) - resourceBundle=usmresource
2022-01-10 10:52:17,111 ERROR [SOICAT] ps.PersistentStorageWrapper$1.run(263) - Cannot establish Catalyst PersistenceService reference.
com.ca.ssa.sor.persistence.PersistenceManagerException: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at com.ca.ssa.sor.persistence.impl.PersistenceManagerImpl.getSession(PersistenceManagerImpl.java:119)
at com.ca.ssa.sor.logicserver.PersistenceServiceImpl.getSession(PersistenceServiceImpl.java:66)
at com.ca.sam.manager.catalyst.ps.PersistentStorageWrapper$1.run(PersistentStorageWrapper.java:239)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ca.ssa.sor.persistence.impl.PersistenceManagerImpl.getSession(PersistenceManagerImpl.java:117)
... 2 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
... 4 more
Since customer already reverted back, we went ahead and install CU2, afterward the SOI Manager came online without errors.