Kbase P129342: Errors 6182, 2651 and 142 during the insert of data on the field with unicode data type nvarchar(max
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/05/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Windows 2003
MS SQL DataServer
OpenEdge 10.1C
MS SQL 2005
OpenEdge 10.1B
SYMPTOM(s):
OpenEdge 10.1B03
Errors 6182, 2651 and 142 during the insert of data on the field with Unicode data type nvarchar(max)
"You tried to compare or to update a character field with a value longer than the maximum length. (6182)
Field num: <field-num>, value: <value>. (2651)
** Unable to update <filename> Field. (142)
No record is inserted after the above errors
The MS SQL Server Native Client driver is used to access the SQL Server database
Use of the SQL Server driver to connect to SQL Server Database resolves the symptoms
CAUSE:
This is a known issue
FIX:
As a workaround use SQL Server driver to connect to the MS SQL Server database