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:
Release | Yes/No |
---|---|
8.3.x |
RDBMS | Yes/No |
---|---|
CSS |
Below is the step-by-step scenario leading to the problem:
- Go to AIC Portal.
- Changed the application name.
- It got reflected in CMS successfully. Taken a snapshot.
- In dashboard in quick access view able to see both the names.
The impact of the problem on the dashboard is: No Impact. Only the old name of the application is displayed.
To fix the problem, proceed as follows:
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 example4;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
Take a backup of Central schema before proceeding further to the below queries.
Identify the corruption:
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.
- 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.