Kbase P82873: Referencing 'bigint' column data type with Progress MS SQL DataServer causes error 6194
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/21/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SQL Server DataServer
SYMPTOM(s):
Referencing column of 'bigint' data type in 4GL causes error:
SYSTEM ERROR: SQL number has an unexpected format. (6194)
CAUSE:
This is expected behavior because the 'bigint' MS SQL Server data type is not supported by Progress DataServer for Microsoft SQL Server.
The BIGINT data type is supported in OpenEdge 10.1B or later.
FIX:
Upgrade to 10.1B or later.
If upgrading is not an option, remove references in the 4GL code for the field in the schema holder defined for the column having the 'bigint' data type.