on 01-24-2011 4:27 PM
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
issue resolved now, we can able to search the roles by t-codes in CUP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.