CCS Icdx stored procedure fails to run

Products

• Control Compliance Suite Standards Server
• Control Compliance Suite

Issue/Introduction

Control Compliance Suite SP for ICDx is failing.

We have an icdx instance running that we use to collect CCS data and push to syslog servers.  The stored procedure that grabs the data from the CCS database is failing with this error.

Msg 8115, Level 16, State 2, Procedure spGenerateCCSEventDataForICDx, Line 465 [Batch Start Line 0]
Arithmetic overflow error converting expression to data type int.
The statement has been terminated. Completion time: <datetime>

 

 

Environment

12.5.1-12.6

Cause

The problem is with seq_num column. The value is going beyond the range of int.

Resolution

If you encounter this issue, please contact support and request the script created to resolve this issue.
Along with instructions on applying the fix.

This fix will not be included with future updates as ICDX has been EOL.