Kbase P79129: Inserting or updating data into a field causes error 6182
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/09/2008 |
|
Status: Verified
SYMPTOM(s):
Inserting or updating data into a field causes error 6182
You tried to compare or to update a character field with a value longer than the maximum length. (6182)
FACT(s) (Environment):
Inserting or assigning the data from one table to another table with the similar datatype fields
The schema holder was created by pulling the MS SQL Server database schema
The field in question had a length of VARCHAR(20) originally, in the SQL Server database
Changing the field length mentioned above to VARCHAR(26) in the SQL Server database schema and to x(26) to the Progress schema holder did not work
The "Update/Add Table Definitions..." is performed after the above changes but still got the same error.
OpenEdge 10.x
Progress 9.1x
MS SQL DataServer
Windows
CAUSE:
The .df of the table from the schema holder showed that the "FORMAT" of the field was changed to x(26) but all the others, such as "LENGTH", "DSRVR-PRECISION" and "DSRVR-LENGTH" value were unchanged, i.e., to 20. The "LENGTH", "DSRVR-PRECISION" and "DSRVR-LENGTH" attributes in the meta schema did not get changed to 26 even after performing the update/Add utility of the SQL Server DataServer.
FIX:
In order to fix the issue, follow the steps below:
1. Change the format of the field to VARCHAR(26) in the SQL Server Database Schema (This step is already done according to the sixth symptom)
2. Delete the tables in questions from the schema holder using the Progress Data Dictionary.
3. Re-pull those deleted tables back to the schema holder using the Progress Data Administration > DataServer > MS SQL Server Utilities > Update/Add Table Definitions...