After upgrade to SO15850, soitoolbox generates an error about hibernate.cfg.xml

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We upgraded SOI 4.2 to SO15850.

When I run

soitoolbox.exe -x --startAllServices

an error is generated:

C:\Program Files (x86)\CA\SOI\Tools>soitoolbox.exe -x --startAllServices

Started 15/03/2021 at 17:06:36

-> Parsing configuration file soitoolbox.cfg ... Done, 62 lines processed

-> Autodetecting DB configuration... ERROR:  bad content - Auto detection of SOI DB configuration failed.

Reason:Wrong format of the connection string in C:\Program Files (x86)\CA\SOI\tomcat\lib\hibernate.cfg.xml file

Note: Auto detection works only when run on machine running SOI Application Server

Environment

Release : 4.2 with SO15850

Component : Service Operations Insight (SOI) Manager

Cause

Soitoolbox.exe -x generates a new config file if one does not exist.

This file needs to be manually edited to add the correct host and user information for the so environment

Resolution

Fill in the top 3 sections of the C:\Program Files (x86)\CA\SOI\Tools\soitoolbox.cfg

E.G.

#1. Specify Windows credentials for all machines where SOI components are deployed

# Syntax:

#    machine=<machineName>;<userName>;<PlainTextPassword>

machine=<hostname1>;<username>;<password>

machine=<hostname2>;<username>;<password>

 

#2. Specify credentials for SOI database

#

# Syntax:

#     database=<databaseName>;<machineName>;<instance>;<port>;<userName>;<PlainTextPassword>

database=SAMStore;<hostname3>;;;<username>;<password>

 

#3. Specify credentials for SOI UI server access

# Syntax:

#     soiui=<machineRunningUIserver>;<protocol>;<port>;<userName>;<PlainTextPassword>

soiui=<hostname4>;http;7070;samuser;samuser

 

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight-monthly-update-kit/MUK/monthly-update-kits/ca-soi-4-2/SO15850-Mandatory-Patch-December-2020.html

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/administrating/database-maintenance/ca-soi-toolbox-utility_2_3.html

For CA SOI distributed system, enter the CA SOI setup details in the soitoolbox.cfg file (the .cfg file created by using -x command, if it does not exist) before running any CA SOI toolbox commands