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.

Step by Step scenario

1. Create three modules M1 , M2 and M3
2. Take V1 snapshot
3. Delete M1
4. Take V2 snapshot.
2. Change snasphot version for V1 in CMS
3. 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
   SQL Queries - CAST Central Base - Queries on modules - How to get the ID of the functional module

   Example -

   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 -

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

      -Synchronize the Central Database
      -Launch CED

   2. 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

Ticket # 9605