IBM Support

Unable to execute the statement.String or binary data would be truncated.

Troubleshooting


Problem

The following error can occur when: 1. Attempting to zero out data for all cubes in model using the Import data and click on Prepare. The prepare import job is queued and run. It completes and then you run a GTP. The reconcile job completes but the data is not zeroed out. OR 2. Unable to run a macro with several administration links.

Symptom

Unable to execute the statement.String or binary data would be truncated
For Oracle it will display:
ORA-01401: inserted value too large for column

For SQL:
Unable to write the new data, the call to SetImportQueueBlob failed.

Unable to execute the statement.String or binary data would be truncated., Error number -2147217833 was raised by Microsoft OLE DB Provider for SQL
Server. Native RDBMS error 8152The statement has been terminated., Error number -2147217833 was raised by Microsoft OLE DB Provider for SQL
Server. Native RDBMS error 3621

[{"Product":{"code":"SSEH6Q","label":"Cognos Planning for Series 7"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Planning - Contributor 7.3;Planning - Contributor 8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"","label":""}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

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.

Historical Number

1026727

Document Information

More support for:
Cognos Planning for Series 7

Software version:
Planning - Contributor 7.3, Planning - Contributor 8.1

Operating system(s):
Windows

Document number:
373767

Modified date:
09 May 2025

UID

swg21346392