SAP Knowledge Base Article - Preview

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

Symptom

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

WARNING: Foreground : Failed to run Risk Analysis
com.sap.sql.log.OpenSQLException: 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


Read more...

Product

SAP GRC Access Control 5.3

Keywords

ARA, RAR, Org level analysis, risk analysis, org user mapping, VIRCC, syntax error, com.sap.sql.log.OpenSQLException, 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 for Me (Login required).

Search for additional results

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