CMS Application - Execute - Non Fatal Error - Previous Snapshots not seen in Cast MS

The purpose of this page is to provide assistance when previous snapshots which were seen and available in CAST-MS are no longer seen in CAST-MS.

Some steps are provided below to assist with the remediation of this action.

This can vary depending on the actions taken.

Here are the actions which could have resulted in this and the remediation for them:

1. Delete Application
   1. If you delete an Application (even if you create a new one), or its parent System, it will lead to removal of Application and its snapshots in Dashboard.
      1. The remediation is to not delete an Application from CAST-MS unless you want to remove it completely from Dashboard you can either:
         1. Update the existing application
         2. Create a new application and run snapshots on old saved code (assuming it is still available)
         3. Maintain an old database copy for reference
2. Change Dashboard Service
1. If you change the Dashboard Service in the Delivery Unit, old snapshot will not appear in new Dashboard Service
   1. Keep old Dashboard Service instead of making changes
3. Migration - Missing UUID in management database table CMS_SYNC_TRANSLATION
   1. Check if uuid is missing for certain rows in the management database table CMS_SYNC_TRANSLATION by running the below query on the management database.

      1. SELECT *
         FROM   CMS_SYNC_TRANSLATION
         WHERE  EntryObjPMC NOT LIKE 'uuid:%'
         AND    AdapterClass       = 'com.castsoftware.pmc.actions.centralservice.PortfolioCentralAdapter'

      2. Query result interpretation

         If any rows are returned, there is an issue. A row without a problem looks like this:

         31794,'2018-10-03 12:58:32','uuid:b30bbd42-11f1-4284-9515-a547a52ba395','uuid:b30bbd42-11f1-4284-9515-a547a52ba395',1,'com.castsoftware.pmc.actions.centralservice.PortfolioCentralAdapter',

   2. To re-mediate, do the following:
      1. Restore the databases before migration and make sure that a current version is set if not already (related documentation CMS - Current Version tab)
      2. Run the following query on the management database to update the rows to add the uuid.

      3. UPDATE CMS_SYNC_TRANSLATION
         SET    EntryObjPMC = 'uuid:'
                       || EntryObjPMC
         WHERE  EntryObjPMC NOT LIKE 'uuid:%'
         AND    AdapterClass       = 'com.castsoftware.pmc.actions.centralservice.PortfolioCentralAdapter'

      4. then do the following after running the update query (See the documentation here - Onboarding an Application in CAST AIP- if you need help with any of these steps.)

         1. Migrate the databases
         2. Add new version
         3. Package new code and deliver it
         4. Take a snapshot
4. If the problem you are facing does not match any case listed in this page, contact CAST Technical Support with the relevant input

Ticket # 14463