CMS Snapshot Analysis - Compute Snapshot - Fatal Error - Error while executing procedure - value too long for type character varying

This page will help you to troubleshoot the Fatal Error message "Error while executing procedure - value too long for type character varying" which you may face while running the Snapshot.

1. In CAST-MS log file, identify the table and the function that are involved in the error message. Under the message "ERROR: value to long...", the SQL query that is failing is written, and starts with "Insert". The name of the function that is involved is defined in the first line where the following appears : function <name of the function> line xxx at SQL statement In the above example the table name is: <MY_TABLE_AS_EXAMPLE> and the function name is: my_tkb_support_example.
2. If the name of the tables is FP_WK_CALIB_ISSUES and the name of the function is DSSAPP_FP_FIX_CALIB_ISSUES:
   1. Download the SQL Script : Fix_Badly_Calibrated_DFs_TFs.sql and run it in your local database
   2. Take the snapshot again by skipping analysis. This issue is fixed in CAST AIP 8.2.4
3. If the above points do not help you, contact Cast Technical Support and provide the following Relevant Input to reproduce the issue.