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"}}]
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.
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg21585909