Kbase P129683: Tables property not set when running across appserver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/27/2009 |
|
Status: Verified
SYMPTOM(s):
Tables property not set when running across AppServer
Getting errors when running addQueryWhere in an SDO split across an AppServer boundary with no database connection on the client after the upgrade
Unknown or ambiguous buffer reference 'table'. Could not add expression to query.
setQueryWhere in SDO running on AppServer returns errors
Foreign Field mapping lost across appserver boundary
Errors coming from newQueryValidate(query.p):
Entry <entry#> is outside the range of list <list-string>. (560)
Entry 0 is outside the range of list . (560)
Unknown or ambiguous buffer reference '<buffername>'. Could not add expression to query.
The error that is returned depends on whether or not you pass the buffer name to addQueryWhere.
FACT(s) (Environment):
Windows 32 Intel
OpenEdge 10.1C
CHANGE:
Upgraded to OpenEdge 10.1C
CAUSE:
Bug# OE00166465
FIX:
Upgrade to OpenEdge 10.1C01 or later.
Alternatively use the following work around:
Add the missing call to setTables in src/adm2/custom/querycustom.i
As follows:
------------
/* use a unique variable name that does not crash with code in SDO */ define variable adm-tables as char no-undo.
adm-tables = REPLACE("{&TABLES-IN-QUERY-{&QUERY-NAME}}":U," ":U,",":U).
{set Tables adm-tables}.
-------------