What is the query that is being executed during the UIM Upgrade to 9.0.2 to validate if enviromment is ready to be upgraded?
Article ID: 202288
Updated On:
Products
Issue/Introduction
Hi,
I need your support for check our production environment of CA Unified Infrastructure Management for upgrade to 9.0.2 version, Is there any query that allow verify if the environment is ready for upgrade to 9.0.2. Next some details of the platform:
UIM Server: current version 8.51 sp1
install_date: 2016-05-04T11:46:17, product_name_abbrev: UIMServer, product_version: 8.4, uimserver_lib_module_version: 8.4.0, uimserver_lib_build_date: 2016-01-26T10:15:57
install_date: 2018-05-17T02:49:00, product_name_abbrev: UIMServer, product_version: 8.51, uimserver_lib_module_version: 8.5.1.1, uimserver_lib_build_date: 2017-08-29T16:25:50
UMP Server: current version 8.51 sp1
Version = 8.5.1Build Label = UMP_851_GABuild Date = February 22, 2017 06:23:59 PM -0700Build Number = 150093
Thanks, regards.
Environment
Release : 9.0.2
Component : UIM - INSTALL
Resolution
1. strTableExistQuery
select count(*) as counta from SSRV2ConfigValue
if count <=0, continue install as SSR tables do not exist
if count >0, check for strMcsOrNotQuery
2. strMcsOrNotQuery
select count(*) as counta from ssrv2version where component = 'mon_config_service';
if count <=0, abort install as mcs does not exist which means ssr created these tables
if count >0, check for strDuplicateCheckQuery
3. strDuplicateCheckQuery
select count(*) as counta from (select COUNT(*) as duplicates from SSRV2ConfigValue WHERE field IS NOT NULL group by profile, field) a where a.duplicates > 1;
if count <=0, continue install as duplicate entries do not exist
if count >0, abort install as duplicate entries exist
Additional Information
Feedback
