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.
SAP Knowledge Base Article - Preview