Failed to execute the SQL Server command on 'CSM_Reports'. String or binary data would be truncated.

Products

• Control Compliance Suite Windows

Issue/Introduction

When runing a Report Job the error "Failed to execute the SQL Server command on 'CSM_Reports'. String or binary data would be truncated." is thrown.

Failed to execute the SQL Server command on 'CSM_Reports'. String or binary data would be truncated.

Cause

"Exception Description" field is only 255 characters in the database...in this case the users description was over 255 characters.

Environment

CCS 11.5.1

Resolution

A fix has been created that will be merged into the next release of CCS that increases the character length to 1024.