Kbase P63030: MSS DataServer does not retrieve data from MSS database when the MSS db has a field longer than 4096
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2008 |
|
Status: Verified
SYMPTOM(s):
MSS DataServer does not retrieve data from MSS database when the MSS db has a field longer than 4096 bytes and a FOR EACH 4GL statement contains the "FIELDS" phrase.
"FIELDS" phrase produces wrong result
"for each fields" never gets executed past the loop
There is a varchar field defined as 8000 long in the field list
Taking off this field from field list does produce correct result
"shrinking" the field to 4000 in SQL server produces the correct result
Database migrated selecting "use width column" option
sql-width defined as 4000 in the dictionary
Migrating did not check "use width column" produces correct result
FACT(s) (Environment):
MS SQL DataServer
CAUSE:
Bug# OE00100027
CAUSE:
Internal buffer for retrieving records in field list defined at 4K, which is exceeded
FIX:
Upgrade to OE 10.0A01 and later. The buffer is expanded to 8K in the fix. But be aware it is not a good practice to place a large field in field list.