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
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.