CMS Snapshot Analysis - Synchronize Assessment Model - Fatal Error

This page will help you solve fatal error that may occur during the Synchronize Assessment Model.

1. In the CAST-MS log file file check if the issue is due to an SQL Error:
   1. Identify the SQL error as below screenshot:
      
      1. Identify the type of error.
         In the above example, the error is duplicate key value violates unique constraint "<UNIQUE CONSTRAINTE NAME>"
      2. Identify the tables that are involved.
         In the above example, the table involved in <CENTRAL DB>.DSS_METRIC_VALUE_TYPES
   2. Navigate in the below pages:
      
      • CMS Snapshot Analysis - Synchronize Assessment Model - Fatal Error - duplicate key value violates unique contraint dss_me_val_typ_pk
2. If the above points do not help you, contact CAST Technical Support and provide the below relevant input in order to reproduce the issue
   

Relevant Input

• Activate the SQL Traces for CAST MS as described in : CAST Management Studio - Information - How to launch CAST-MS in SHOW SQL mode in order to get the SQL traces, and run the Snapshot by skipping analysis
• CAST Support Tool (CST) - alias Sherlock. Option to select : Export CAST Databases, Export log, Export configuration file.
• Screenshot describing the error/warning