Kbase P147776: Error 6176 and 22001: [Microsoft][SQL Native Client] String data, right truncation When Inserting da
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 6176 and 22001 When Inserting data in SQL server table
An overflow of a character value. (6176)
22001: [Microsoft][SQL Native Client] String data, right truncation
FACT(s) (Environment):
Windows
OpenEdge 10.x
CAUSE:
The data server builds a template record from schema holder definition of the field length, if say, schema holder tells us there is enough room to insert but in fact SQL server does not allow that length of data to be inserted, you will get the above errors.
The "DSRVR-LENGTH" in schema holder defines foreign length for DataServer to build template records, if this length is larger than actual SQL server field length, the above error will be received.
In this case, there is indeed mismatch between DSRVR-LENGTH in schema holder and the actual field length in SQL server
FIX:
Update the schema holder by deleting and recreating the table so the DSRVR-LENGTH matches the field length definition