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

Purpose (problem description)

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.

Observed in CAST Version, CAST Extension Version, CAST Component Version

Observed in RDBMS

Step by Step Scenario

This can vary depending on the actions taken.

Action Plan

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

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

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

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](https://doc-legacy.castsoftware.com/display/DOC83/CMS+-+Current+Version+tab))
      2. Run the following query on the management database to update the rows to add the uuid.
      3. ```sql
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](https://doc-legacy.castsoftware.com/display/DOC83/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

Notes/comments

Ticket # 14463

Related Pages