I've been maintaining an ABF's frame's source code and I get a
"E_US1265 Database reorganization activity has rendered the query plan
invalid. Try again after the db activity is complete. In case of
dynamic
SQL, the statement must be prepared again." error when running the
following query (the query interpolates host variables) :

select max(m.d_kinhshs)
from kinas m
where m.am_asqenh = _am_asqenh
and m.c_eid_kin != 'DNSN'
and (
(m.d_kinhshs < _d_syntagh)
or
(m.d_kinhshs <= :l_d_ews and
m.c_eid_kin != 'EXAG' )
)


the part that gives me a hard time is the part between the
parentheses
(
(m.d_kinhshs < _d_syntagh)
or
(m.d_kinhshs <= :l_d_ews and
m.c_eid_kin != 'EXAG' )
)

If I take the two outer parentheses off, then the query runs to
completion but I really do not want to do that since it will change
the precedence of the operators and will get wrong results back.
It probably has to do something with the nesting depth of the WHERE
clause ??

The query runs successfully AS-IS in II 9.2.0 (int.lnx/118)NPTL but it
gives me that error when run under II 9.2.0 (i64.hpu/143) which has
also patch 13830 applied.
Is there an issue after patch 13830 related to this case?