CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Errors
Purpose (problem description)
This page will help you to handle SQL Errors during the analysis. SQL errors could occur before the Saving step, and after the Saving step. See in the screenshot how to identify the Saving step. When the statement : “Comparin objects on server” and “Merging objects on server” appear, the process is at the saving step.
When the issue occurs before the Saving step, the analyzer is populating the IN Tables, that are working tables for saving items in the local database.
When the issue occurs after the Saving step, the working tables are used to populate the technical tables in the local databases.
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| Oracle Server | ✅ |
| Microsoft SQL Server | ✅ |
| CSS3 | ✅ |
| CSS2 | ✅ |
Action Plan
Perform the following steps:
- When the issue occurs before the Saving Step, we will need to modify the definition of the IN table involved in the SQL Error:
- If the SQL error is NULL Value in column of an IN Table, go to the page CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Error - Null value in column xxxx violates not null constraint - In Table involved
- When the issue occurs during the Saving step:
- Activate the IN Tables
- Run the Analysis.
- Provide the Sherlock output (option to activate are : Export logs, Export database dumps), to support technical support.
- Deactivate the IN Tables
- If the above step does not help, navigate to the below error messages :
- If the above section does not help contact CAST Technical Support and provide Relevant Input to help CAST Technical Support team reproduce and solve your problem.