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
Log InLog in to view more of this document
Historical Number
1026727
Was this topic helpful?
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