Kbase P119550: Progress error 6177 and ODBC error 22005 occur when querying a table that was created using Generate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/01/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
MS SQL DataServer
Windows
SYMPTOM(s):
Using the "Generate delta.sql Progress to MSS" utility to update Progress Schema Holder database and foreign MS SQL database
Resulting .DF file is successfully loaded into Schema Holder database
Resulting .SQL file is successfully loaded into foreign MS SQL database
Errors occur when using WHERE clause to find a specific field:
FOR EACH <table> WHERE <field> = 1
SYSTEM ERROR: Assignment error. (6177)
22005: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '<field>' to a column of data type int.
Field referenced in the error shows as data-type INTEGER in the .DF file
Field referenced in the error shows as data-type INTEGER in the .SQL file
CAUSE:
Bug# 20061005-006
FIX:
Option #1
Upgrade to OpenEdge 10.1B
Option #2
Apply the workarounds detailed in solutions P119548 and P119549 to avoid the issue