Troubleshooting
Problem
SQL Server 2008 gives a 22026 database error while loading sample Data on table OPTIM_CUSTOMERS
Symptom
While trying to Load Optim Sample data to a target database (Optim Configuration->Task->Load/Drop Sample Tables), a database error is returned:
Data Base Error Detected in xxxx.xxx.OPTIM_CUSTOMERS: Message: ODBC SQL State: 22026 String data,length mismatch
This is returned after the 110th record in the OPTIM_CUSTOMERS table.
[{"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM InfoSphere Optim Test Data Management Solution
Software version:
7.2
Operating system(s):
Windows
Document number:
467879
Modified date:
08 July 2021
UID
swg21585909
Manage My Notification Subscriptions