Kbase P15311: Word index query with a string causes the webspeed agents to hang.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
word index query with a string in the format "f1 f2 (f3 | f4 | f5) f6 f7" causes the WebSpeed agents to hang.
CAUSE:
Bug #: 20021024-029
FIX:
Apply the latest patch for 9.1C or upgrade to 9.1D, depending on platform (see Solution xxx for the patch list of this bug)
OR apply the workaround below.
WORKAROUND:
----------
Add a FOR LAST statement (for the table used by the OPEN QUERY), right before the open query statement, the problem should disappear.
EXAMPLE:
-------
do with frame {&frame-name}:
assign lv_all = if fn_cando("default","all dealerships")
then -1 else 0.
/* temp mod to prevent slow queries */
/**********************************************/
/* added to workaround problem */
FOR LAST cvrvehic NO-LOCK.
END.
/**********************************************/
if input fi_search = ""
then do:
Notice it is only added to the beginning of the function because the problem happens with queries that use the CONTAINS clause, and because they have 3 of them, it would probably be safer to do it before the OPEN QUERY's...