Search the Roles By T-codes in GRC CUP

[Former Member]

Hi Experts,

Present i am involving GRC implimentation, i have created the once CUP workflow (Change User Account) and tried to create the CUP reauest for the User Change Access.

i have given the details of the User and manager and tried to find out the roles by t-codes(for example-- find out list of roles which are having the MM03-t-code), but it shows an error..

*Note: List Role are already imported in GRC CUP.

2011-01-24 10:58:05,291 [SAPEngine_Application_Thread[impl:3]_27] ERROR com.virsa.ae.dao.sqlj.RoleDAO : findRoleDetailsByName : Unable to retrieve record : An Exception in finding role by name

com.virsa.ae.dao.DAOException: An Exception in finding role by name

at com.virsa.ae.dao.sqlj.RoleDAO.loadRoleDetailsByRoleProfName(RoleDAO.sqlj:2922)

at com.virsa.ae.dao.sqlj.RoleDAO.findRoleDetailsByName(RoleDAO.sqlj:2451)

at com.virsa.ae.search.bo.SearchRolesBO.searchOnTransactionCode(SearchRolesBO.java:857)

at com.virsa.ae.search.bo.SearchRolesBO.searchRoles(SearchRolesBO.java:249)

at com.virsa.ae.search.bo.SearchRolesBO.searchRoles(SearchRolesBO.java:188)

at com.virsa.ae.search.actions.SearchRolesAction.execute(SearchRolesAction.java:962)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:295)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:431)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

Caused by: com.sap.sql.log.OpenSQLException: Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "A"."ROLEPROFNAME","A"."ROLEPROFDISPNAME","B"."ROLEPROFDESC","BUSSPROC","SUBPROC","COMMENTS_MANDATORY","PARENTROLE_OWNER","REAFFIRM_PERIOD","LST_REAFF_DT","B"."DETAIL_DESC","ROLEPROFTYPE","ROLEPROFINDICATOR","CRITICAL_LEVEL","CONTYPE","PROF_GEN_URL","PROF_GEN_BAPI","RSPB_ID","LOCALE" FROM "VIRSA_AE_ROLDTLS" "A" LEFT OUTER JOIN "VT_AE_ROLDTLS_LOC" "B" ON "A"."ROLEPROFNAME" = "B"."ROLEPROFNAME" WHERE "A"."ROLEPROFNAME" = ? AND ("B"."LOCALE" IS NULL OR "B"."LOCALE" = ? OR "B"."LOCALE" = ?) UNION SELECT "ROLEPROFNAME","ROLEPROFDISPNAME","ROLEPROFDESC","BUSSPROC","SUBPROC","COMMENTS_MANDATORY","PARENTROLE_OWNER","REAFFIRM_PERIOD","LST_REAFF_DT","DETAIL_DESC","ROLEPROFTYPE","ROLEPROFINDICATOR","CRITICAL_LEVEL","CONTYPE","PROF_GEN_URL","PROF_GEN_BAPI","RSPB_ID", - 1 "LOCALE" FROM "VIRSA_AE_ROLDTLS" WHERE "ROLEPROFNAME" = ?".

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:85)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:124)

at com.sap.sql.jdbc.common.CommonPreparedStatement.setNull(CommonPreparedStatement.java:303)

at com.sap.sql.jdbc.common.CommonPreparedStatement.setString(CommonPreparedStatement.java:509)

at com.sap.sql.sqlj.runtime.profile.ref.RTStatementJDBCPrepared.setString(RTStatementJDBCPrepared.java:359)

at com.virsa.ae.dao.sqlj.RoleDAO.loadRoleDetailsByRoleProfName(RoleDAO.sqlj:2848)

... 22 more

Please help me out in this case.

Regards,

Arjuna.

Edited by: Arjunab on Jan 24, 2011 5:28 PM

Edited by: Arjunab on Jan 24, 2011 5:30 PM

[Former Member]

issue resolved now, we can able to search the roles by t-codes in CUP.