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

book

Article ID: 210553

calendar_today

Updated On:

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

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

Environment

Release : 4.2 with SO15850

Component : Service Operations Insight (SOI) Manager

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=lvndev0014;administrator;interOP0041

machine=lvndev0015;administrator;interOP0015

 

#2. Specify credentials for SOI database

#

# Syntax:

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

database=SAMStore;lvndev0016.bpc.broadcom.net;;;sa;interOP0016

 

#3. Specify credentials for SOI UI server access

# Syntax:

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

soiui=lvndev0017;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