CMS Snapshot Analysis - Synchronize Assessment Model - Fatal Error
*Purpose
This page will help you solve fatal error that may occur during the Synchronize Assessment Model.
*Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
| 7.2.x | ✅ |
| 7.0.x | ❌ |
*Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ✅ |
| Microsoft SQL Server | ✅ |
| CSS3 | ✅ |
| CSS2 | ✅ |
| CSS1 | ❌ |
Action Plan
- In the CAST-MS log file file check if the issue is due to an SQL Error:
- Identify the SQL error as below screenshot:

- Identify the type of error.
In the above example, the error is duplicate key value violates unique constraint “” - Identify the tables that are involved.
In the above example, the table involved in.DSS_METRIC_VALUE_TYPES
- Identify the type of error.
- Navigate in the below pages:
- Identify the SQL error as below screenshot:
- 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
Notes/comments
Related Pages