After applying SOI 4.2 CU2 Manager unable to connect to Database

book

Article ID: 223168

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

After applying SOI 4.2 CU2 Manager unable to connect to Database

soimgr-debug.log show the following message

2021-08-03 15:58:34,120 FATAL [ServletInit] connection.ConnectionProviderFactory.newConnectionProvider(76)  - Could not instantiate connection provider
java.lang.ClassCastException: com.ca.sam.manager.hibernate.Decrypter cannot be cast to org.hibernate.connection.ConnectionProvider
 at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:73)
 at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
 at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414)
 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
 at com.ca.sam.manager.hibernate.HibernateUtil.waitForDatabase(HibernateUtil.java:81)
 at com.ca.sam.manager.servlet.ManagerInitServlet.startComponents(ManagerInitServlet.java:182)
 at com.ca.sam.manager.servlet.ManagerInitServlet.initialize(ManagerInitServlet.java:131)
 at com.ca.sam.common.HttpServlet$InitTask.run(HttpServlet.java:231)
 at com.aprisma.util.thread.JobQueue.runJobThread(JobQueue.java:407)
 at com.aprisma.util.thread.JobQueue.access$400(JobQueue.java:43)
 at com.aprisma.util.thread.JobQueue$JobRunnable.run(JobQueue.java:136)
 at java.lang.Thread.run(Thread.java:748)
2021-08-03 15:58:34,120 INFO  [ServletInit] ?.?(?)  - Manager initialization failed [count=2]. Will try again after 15 seconds.

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

For the original issue after installing CU2, I found the jar file that was causing the error.

For some unknown reason, the hibernate-3.2.6.ga.jar never got removed after installing CU2.

CU2 no longer need this jar file. To fix this error, you need to remove/delete /soi/tomcat/lib/hibernate-3.2.6.ga.jar