CAST Engineering Dashboard - Snapshots - Wrong Snapshot version

Purpose (problem description)

This page helps you to troubleshoot issues when you are seeing an incorrect snapshot version for modules.

Figure 1

As seen in the above screenshot the Snapshot version name is Version_test_2 for snapshot taken on 08-08-2017

Which is correctly displayed for 9393_issue unassigned objects content and DN_UDM module but incorrect for DB_UDM module.

Observed in CAST AIP

ReleaseYes/No
8.3.x✅

Observed on RDBMS

RDBMSYes/No
CSS✅

Step by Step scenario

  1. Create three modules M1 , M2 and M3
  2. Take V1 snapshot
  3. Delete M1
  4. Take V2 snapshot.
  5. Change snasphot version for V1 in CMS
  6. Snapshot version is updated for M2 and M3 modules except for module M1 (that is created in V1 and deleted in V2).

Action Plan

To troubleshoot this issue, you need the following Relevant input

Perform the below actions:

  1. Check the snapshot version for the module in CB -

select * from dss_snapshot_info where snapshot_id = <snapshot_id> and object_id = <module_id>


   Module\_id and snapshot\_id can be taken from the below pages -  
     
   [SQL Queries - CAST Central Base - Queries on snapshots - How to get the ID and name of a snapshot for a given application](/export-v2/tg/sql-queries/sql-queries-cast-central-base/sql-queries-cast-central-base-sql-queries-on-snapshots/sql-queries-cast-central-base-queries-on-snapshots-how-to-get-the-id-and-name-of-a-snapshot-for-a-given-application/)  
   [SQL Queries - CAST Central Base - Queries on modules - How to get the ID of the functional module](/export-v2/tg/sql-queries/sql-queries-cast-central-base/sql-queries-cast-central-base-sql-queries-on-modules/sql-queries-cast-central-base-queries-on-modules-how-to-get-the-id-of-the-functional-module/)

   Example -

   ```sql
select * from dss_snapshot_info
where snapshot_id = 1
and object_id = 10Result -snapshot_id;object_id;object_version
1;10;Version_1

  1. If the object_version for the module is same as that displayed on the dashboard then you can run the below query by updating the field <new_version> to desired snapshot version -

Update dss_snapshot_info set object_version = ‘<new_version>’ where snapshot_id = <snapshot_id> and object_id = <module_id>


      Example -

      ```sql
Update dss_snapshot_info
set object_version = 'Version_test2'
where snapshot_id = 1
and object_id = 10

  -Synchronize the Central Database  
  -Launch CED
  1. If the object_version for the module is not same as that displayed on the dashboard then please contact CAST Technical Support with the following Relevant input
  2. If your case is not resolved by following the above steps then please contact CAST Technical Support with Relevant input

Relevant input

  1. CAST Support Tool (CST) - alias Sherlock export with the option Export CAST Databases and Export Logs checked
  2. Screenshot of the dashboard pointing to module with incorrect snapshot version showing URLs

Notes/comments

Ticket # 9605

Related Pages