CAST Console - Application Onboarding/Delivery - Version Overview - Error - DSS snapshot cannot be found

When trying to view the details of the version, we get the error - 

12:32:46.319 [getMultipleThreadsTaskExecutor-1] ERROR com.castsoftware.aip.node.services.overview.ApplicationOverviewServiceImpl - Unable to get snapshot details
com.castsoftware.aip.node.services.snapshots.SnapshotDetailsException: DSS snapshot cannot be found
at com.castsoftware.aip.node.services.snapshots.SnapshotServiceImpl.addSnapshotDetails(SnapshotServiceImpl.java:131) ~[aip-node-services-1.25.2.jar!/:1.25.2]
at com.castsoftware.aip.node.services.overview.ApplicationOverviewServiceImpl.lambda$collectOverviewData$4(ApplicationOverviewServiceImpl.java:172) ~[aip-node-services-1.25.2.jar!/:1.25.2]
at java.util.Optional.ifPresent(Unknown Source) ~[?:1.8.0_202]
at com.castsoftware.aip.node.services.overview.ApplicationOverviewServiceImpl.collectOverviewData(ApplicationOverviewServiceImpl.java:172) [aip-node-services-1.25.2.jar!/:1.25.2]
at com.castsoftware.aip.node.services.applications.ImportApplicationServiceImpl.updateVersionsAndSnapshots(ImportApplicationServiceImpl.java:297) [aip-node-services-1.25.2.jar!/:1.25.2]
at com.castsoftware.aip.node.jobs.steps.ResyncApplicationStep.execute(ResyncApplicationStep.java:67) [aip-node-services-1.25.2.jar!/:1.25.2]
at com.castsoftware.aip.node.jobs.ApplicationJob.doExecute(ApplicationJob.java:182) [aip-node-services-1.25.2.jar!/:1.25.2]
at com.castsoftware.aip.node.jobs.ApplicationJob.execute(ApplicationJob.java:116) [aip-node-services-1.25.2.jar!/:1.25.2]
at com.castsoftware.aip.node.jobs.JobThread.run(JobThread.java:41) [aip-node-services-1.25.2.jar!/:1.25.2]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]

1. Create an application - Add new version - Run analysis and snapshot. 
2. Run 3-4 snapshots more.
3. Click on Version Name from the Versions tab.
4. Error is thrown  

The issue is coming from the capture date column in the AIP Console and Node database not matching with the functional_date column of dss_snapshots table in the central base. 

In the example provided the issue is seen for Baseline_8.3.3 and Rescan-v3 snapshots. 

To solve the issue we need to

1. Clean up the Node h2 Database by deleting the faulty snapshots. The below query will help to clean up the Node h2 database. It is run based on the GUID - 

   delete from SNAPSHOT_INDICATORS where SNAPSHOT_GUID in ('df456347-70ab-45d1-bcb9-dbcb80bbebf3','968ff69d-511a-4a23-8c09-e7036b1bec10') delete from snapshots where guid in ('df456347-70ab-45d1-bcb9-dbcb80bbebf3','968ff69d-511a-4a23-8c09-e7036b1bec10')

    

2. Once the queries are run, restart the Console and Node services and perform a resync of the application. After which the Version Overview will be visible. 
3. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant inputfor CAST Technical Support to carry out further investigation. 

Relevant input

• CAST AIP Console Logs 
• Details of specific steps done
• Any applicable screenshots

Ticket # 34643