SAP Knowledge Base Article - Preview

1642418 - GRC 5.3 - Org level reports are not running successfully


The org rule risk analysis failed with the below error messages.

WARNING: Foreground : Failed to run Risk Analysis The SQL statement "SELECT o.orgruleid, o.prmrisk, o.orglevel, o.fromval, o.toval, o.searchtype, ot.descn, m.porgruleid, m.porglevel FROM virsa_cc_orgrule o INNER JOIN virsa_cc_orgrulem m ON m.orgruleid = o.orgruleid LEFT OUTER JOIN virsa_cc_orgrulet ot ON ot.orgruleid = o.orgruleid AND ot.lang = 'EN'WHERE  ( o.orgruleid LIKE '%'  ) AND o.orglevel IN() AND  o.status = 0  ORDER BY porglevel , porgruleid,orgruleid,prmrisk,orglevel" contains the syntax error[s]: - 1:334 - SQL syntax error: the token ")" was not expected here



SAP GRC Access Control 5.3


ARA, RAR, Org level analysis, risk analysis, org user mapping, VIRCC, syntax error,, VIRSA_CC_ORGUSERS , KBA , troubleshooting , GRC-SAC-ARA , Access Risk Analysis , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.