We are intermittently seeing the error below regarding the request processor permission queires...
Strange thing is
a) the query does return a row when checked in psql
b) it's 0or1row anyway and the syntax is fine
Anyone hit this or have thoughts?
"switch -glob -- [ad_conn extra_url] {
admin/* {
permission::require_permission -object_id [ad_conn object_id] -privilege adm..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
switch -glob -- [ad_conn extra_url] {
admin/* {
permission::require_permission -object_id [ad_conn object_i..."
(procedure "rp_filter" line 173)
invoked from within
"rp_filter preauth"
[05/Feb/2007:11:28:21][25973.7][-conn:edemocracy-dev::3] Error: Database operation "0or1row" failed (exception \
NSDB, "Query was not a statement returning rows.")
SQL:
select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '384' and ppm.party_id = '0' and ppm.privilege = 'admin' )