CAST Engineering Dashboard - Application - Incorrect Application name

Description

This page provides the solution to the problem of dashboard showing old and new application name in the Quick Access view even after changing it from AIC Portal and CMS.

Please refer to the below screenshot for clarity on the issue:

Observed in CAST AIP

Observed on RDBMS

Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

1. Go to AIC Portal.
2. Changed the application name.
3. It got reflected in CMS successfully. Taken a snapshot.
4. In dashboard in quick access view able to see both the names.

Impact of the Problem

The impact of the problem on the dashboard is: No Impact. Only the old name of the application is displayed.

Action Plan

To fix the problem, proceed as follows:

1. Get the SNAPSHOT_ID of the application which has the old name of the application. To know which snapshot_id should be fetched, run the query based on the name of the snapshot that is coming on the dashboard. Snapshot name is shown on the top right corner of the CED dashboard. For eg. run the below query on Central Schema:

select * from dss_snapshot where snapshot_name = ‘Computed on 201608040943’

   Pick up the snapshot\_id which is the one that had old application name:

   **Query result example**

   4;251;"2016-08-04 00:00:00";3;"Computed on 201608040943";"";"2016-08-04 09:44:24.623";"2016-08-04 09:44:09.74";"2016-08-04 09:45:27.138";2;0;4;"8.1.0.1";-1

   <div class="alert alert-info" role="alert"><div class="h4 alert-heading" role="heading">Info</div>


Take a backup of Central schema before proceeding further to the below queries.
</div>

2. Identify the corruption:

   ```sql
1. select * from DSS_OBJECT_INFO 
where SNAPSHOT_ID = 4 --snapshot_id that you get from the above query

2. select * from dss_objects 
where object_id in (3,4,52) 

3. select *
from dss_links 
where next_object_id in (3,4,52)

4. select *
from dss_links 
where previous_object_id in (3,4,52)

5. select *
from dss_translation_table 
where object_id in (3,4,52)

If any of the above queries returns rows, then the CB has some corrupt values in it. 3. Run the below query on Central schema to remove the corrupt entries:

1. delete from DSS_OBJECT_INFO 
where SNAPSHOT_ID = 4 --snapshot_id that you get from the above query

2. delete from dss_objects 
where object_id in (3,4,52) 

3. delete 
from dss_links 
where next_object_id in (3,4,52)

4. delete 
from dss_links 
where previous_object_id in (3,4,52)

5. delete 
from dss_translation_table 
where object_id in (3,4,52)

The above queries will remove the linked data which is corrupt and is bringing the old name of the application on the dashboard.

3, 4 and 52 are the object_id’s that are linked to the applications.

After applying the above solution, below is the screenshot with only the new name displayed.

Impact of the solution on the dashboard is: Only the latest name of the application will be displayed.

Notes/comments

Ticket  # 5741

Related Pages