Kbase P55842: Running the SDO OpenQuery function the current record disappears
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/01/2011 |
|
Status: Unverified
SYMPTOM(s):
Running the SDO OpenQuery function the current record disappears
The SDO is on a remote AppServer partition
AppServer is in stateless mode
This happens only when a bind to the AppServer is done before an update record and OpenQuery combination is attempted, and the correspondent unbind is executed after these two calls.
Example:
DO:
DEFINE VARIABLE hds AS HANDLE NO-UNDO.
hds = DYNAMIC-FUNCTION('getASHandle':U IN h_dcust).
RUN updateRecord IN h_bcust.
DYNAMIC-FUNCTION('openQuery':U IN h_dcust).
RUN unbindServer IN h_dcust (INPUT ?).
END.
CAUSE:
Bug# OE00098493
FIX:
As a workaround - execute the OpenQuery outside of bind / unbind block.
Example:
DO:
DEFINE VARIABLE hds AS HANDLE NO-UNDO.
hds = DYNAMIC-FUNCTION('getASHandle':U IN h_dcust).
RUN updateRecord IN h_bcust.
/*DYNAMIC-FUNCTION('openQuery':U IN h_dcust).*/
RUN unbindServer IN h_dcust (INPUT ?).
DYNAMIC-FUNCTION('openQuery':U IN h_dcust).
END.