SOI Manager not coming online

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

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. 

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

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.