SQL Queries - Common SQL Queries - How to modify existing version name in all components

Purpose

This page will help you to change the Version name of an application that is already been delivered to CMS in all Cast components.

Observed in CAST AIP

Observed on RDBMS

Action Plan

1. Please take a backup of the Application triplet before you execute the below queries and close the CAST-MS before you execute the queries.

   a. On Management Base execute the below update queries

update CMS_PORTF_Version
  set Object_Name = [New Name]
 where Object_Name = [Previous Name];

update CMS_INF_Snapshot
  set VersionLabel = [New Name]
 where VersionLabel = [Previous Name];

update CMS_INF_VersionInformation
  set VersionLabel = [New Name]
 where VersionLabel = [Previous Name];

update CMS_PORTF_ExecutionReport
  set Version = [New Name]
 where Version = [Previous Name];

b. On Central Base  and Measurement Base execute the below queries

 update DSS_SNAPSHOT_INFO
  set OBJECT_VERSION = [New Name]
 where OBJECT_VERSION = [PreviousName];

2. Now change the Version names to the new names in the below respective files of the application

The below 2 files are related to the configurations -
C:\CastWork\Repo\Delivery\data{APPLICATION_GUID}\index.xml
C:\CastWork\Repo\Delivery\data{APPLICATION_GUID}\Version_GUID.entity.xml

3. Open  CAST-MS and synchronize the Central base and you should be able to see the data updated.

Notes/comments

Ticket # 30255

Related Pages