IBM Support

SecureSync import fails with "Error 8152, String or binary data would be truncated"

Troubleshooting


Problem

Users might find that a SiteProtector SecureSync import fails with a "data would be truncated error.

Symptom

The import job will fail and error messages like the following will be present in the SecureSync logs:

2013-05-12 21:31:53,932 [Job_966] ERROR - Import job failed. Exception executing the import stored procedure iss_Failover_Site_Import. Error 50000, Severity 16, State 1, Procedure iss_error_catch, Line 65, Message: Error 50000, Severity 16, State 1, Procedure iss_error_catch, Line 65, Message: Error 8152, Severity 16, State 13, Procedure iss_UnregisterComponent, Line 178, Message: String or binary data would be truncated.

You can find the SecureSync log at the following location:

C:\Users\Administrator\Desktop\jobxx.zip\Sensor Controller\SecureSync@<IP>\Job_xx\SecureSync.txt

[{"Product":{"code":"SSETBF","label":"IBM Security SiteProtector System"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Secure Sync","Platform":[{"code":"PF033","label":"Windows"}],"Version":"3.0;3.1.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Security SiteProtector System

Software version:
3.0, 3.1.1

Operating system(s):
Windows

Document number:
495307

Modified date:
21 January 2021

UID

swg21639686

Manage My Notification Subscriptions