SAP CUP - Error Submitting Request

[Former Member]

Hi Experts

At my client , i am trying to implement GRC with CUP and RAR . Idea is to setup CUP where requests should be submitted to RAR for risk analysis automatically and if No risks then there is no need of any approval steps . If there are any violations then it should go through the approval process .

but at the moment , to start with, i have the simple work flow configured with single approval stage . The option for Risk analysis on submitting the request is turned on . with this config when i try to submit the request , i get the below Internal server error.

to go forward , i have switched of the risk analysis on request submission . i am able to create a request but at the approval stage ,when i login as the approver i can see the risk violations tab is green . i run the risk analysis , the flag turns red . when i try to approve i get the same error as below. I have pasted the log at the bottom . Can you please help me go forward at this stage . thanks .

500 Internal Server Error

SAP J2EE Engine/7.01

Application error occurred during request processing.

Details: java.lang.NoClassDefFoundError: com.virsa.cc.rulearchitect.dao.dto.RiskDTO (initialization failure)

Exception id: [002481E5092A006500060973000004CD00049385356E63ED]

CUP LOG:

2010-10-26 14:57:37,825 [SAPEngine_Application_Thread[impl:3]_18] ERROR Exception in retrieving the values from the database

com.virsa.ae.core.BOException: Exception while getting results

at com.virsa.ae.accessrequests.bo.RequestBO.getRequestDetails(RequestBO.java:5125)

at com.virsa.ae.accessrequests.bo.RequestBO.getRequestDetails(RequestBO.java:4503)

at com.virsa.ae.accessrequests.actions.RequestViewAction.loadRequestFromDB(RequestViewAction.java:530)

at com.virsa.ae.accessrequests.actions.RequestViewAction.pageLoad(RequestViewAction.java:424)

at com.virsa.ae.accessrequests.actions.RequestViewAction.execute(RequestViewAction.java:142)

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.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:321)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:377)

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

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(AccessController.java:219)

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.virsa.ae.core.BOException: Exception while getting results

at com.virsa.ae.accessrequests.bo.RequestBaseBO.getRequestBaseDetails(RequestBaseBO.java:633)

at com.virsa.ae.accessrequests.bo.RequestBO.getRequestDetails(RequestBO.java:4557)

... 25 more

Caused by:

com.virsa.ae.workflow.NoTransactionFoundException: Request is closed, no transactions available

at com.virsa.ae.workflow.bo.WorkFlowBOHelper.getWorkFlowInfo(WorkFlowBOHelper.java:1759)

at com.virsa.ae.workflow.bo.WorkFlowBO.getWorkFlowInfo(WorkFlowBO.java:996)

at com.virsa.ae.accessrequests.bo.RequestBaseBO.getRequestBaseDetails(RequestBaseBO.java:204)

... 26 more

[Former Member · Accepted solution]

Hi Prasad

By seeing CUP log i can tell you that link for risk analsyis web service that you have given in upto date .

I would suggest you to go WEB SERVICE Navigator in Netweaver Adminstration and get the correct link in

1.Configuration - Risk Analysis

2.Configuration - Mitigation - risk analysis url serch (2 nd option ).

It should resolve the issue .

Thanks & Regards

Asheesh

[Former Member · Accepted solution]

Hi Asheesh

the url in the risk analysis is as below . i have created a new request with the risk analysis on submit request switched on but i get the below error . log attached at the end . remaining log in the next reply

version: 5.3 web service

http://vidcci.labsrmg.co.uk:55000/VirsaCCRiskAnalysisService/Config1?wsdl&style=document

*Error:*

500 Internal Server Error

SAP J2EE Engine/7.01

Application error occurred during request processing.

Details: java.lang.NoClassDefFoundError: com.virsa.cc.rulearchitect.dao.dto.RiskDTO (initialization failure)

Exception id: [002481E5092A005B00000149000004CD000493994C92FAC1]

LOG:

2010-10-27 13:53:36,403 [SAPEngine_Application_Thread[impl:3]_10] ERROR Requested navigation control not found

com.virsa.ae.commons.utils.framework.ControlNotFoundException: Action not found - requestForApproval

at com.virsa.ae.commons.utils.framework.ScreenDefn.getActionDefn(ScreenDefn.java:141)

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

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(AccessController.java:219)

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

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

2010-10-27 13:55:30,648 [SAPEngine_Application_Thread[impl:3]_14] ERROR com.virsa.ae.core.ObjectNotFoundException: User NULL not found

com.virsa.ae.core.ObjectNotFoundException: User NULL not found

at com.virsa.ae.service.sap.SAPR3UserDAO.findUserByUsername(SAPR3UserDAO.java:1843)

at com.virsa.ae.service.umi.sap.SAPR3SearchUser.getUserById(SAPR3SearchUser.java:218)

at com.virsa.ae.search.bo.SearchUserBO.getUserById(SearchUserBO.java:198)

at com.virsa.ae.ejbutil.submitrequest.RequestSubmissionBean.submitRequest(RequestSubmissionBean.java:549)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJBBean.getSubmitRequest(SubmitRequestEJBBean.java:45)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJBObjectImpl0_0.getSubmitRequest(SubmitRequestEJBObjectImpl0_0.java:119)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJB_Stub.getSubmitRequest(SubmitRequestEJB_Stub.java:57)

at sun.reflect.GeneratedMethodAccessor1278.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:62)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.services.ejb.session.stateless_sp5.ObjectStubProxyImpl.invoke(ObjectStubProxyImpl.java:187)

at $Proxy165.getSubmitRequest(Unknown Source)

at sun.reflect.GeneratedMethodAccessor1277.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:62)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.services.webservices.runtime.EJBImplementationContainer.invokeMethod(EJBImplementationContainer.java:126)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:157)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:79)

at com.sap.engine.services.webservices.runtime.servlet.ServletDispatcherImpl.doPost(ServletDispatcherImpl.java:92)

at SoapServlet.doPost(SoapServlet.java:51)

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

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(AccessController.java:219)

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

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

[Former Member · Accepted solution]

LOG continued :

2010-10-27 13:55:30,830 [SAPEngine_Application_Thread[impl:3]_14] ERROR java.lang.VerifyError: com/virsa/cc/xsys/ejb/RiskAnalysis.execRiskAnalysis(Lcom/virsa/cc/xsys/webservices/dto/WSRAInputParamDTO;)Lcom/virsa/cc/xsys/webservices/dto/RAResultDTO;

java.lang.VerifyError: com/virsa/cc/xsys/ejb/RiskAnalysis.execRiskAnalysis(Lcom/virsa/cc/xsys/webservices/dto/WSRAInputParamDTO;)Lcom/virsa/cc/xsys/webservices/dto/RAResultDTO;

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.execRiskAnalysis(RiskAnalysisEJB53DAO.java:305)

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.getViolations(RiskAnalysisEJB53DAO.java:277)

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.getViolations(RiskAnalysisEJB53DAO.java:419)

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.determineRisks(RiskAnalysisEJB53DAO.java:527)

at com.virsa.ae.service.sap.RiskAnalysis53DAO.determineRisks(RiskAnalysis53DAO.java:103)

at com.virsa.ae.accessrequests.bo.RiskAnalysisBO.findViolations(RiskAnalysisBO.java:182)

at com.virsa.ae.accessrequests.bo.RiskAnalysisBO.findViolations(RiskAnalysisBO.java:80)

at com.virsa.ae.accessrequests.bo.RequestBO.saveRiskAnalysis(RequestBO.java:3999)

at com.virsa.ae.accessrequests.bo.RequestBO.saveNewRequest(RequestBO.java:369)

at com.virsa.ae.ejbutil.submitrequest.RequestSubmissionBean.submitRequest(RequestSubmissionBean.java:692)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJBBean.getSubmitRequest(SubmitRequestEJBBean.java:45)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJBObjectImpl0_0.getSubmitRequest(SubmitRequestEJBObjectImpl0_0.java:119)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJB_Stub.getSubmitRequest(SubmitRequestEJB_Stub.java:57)

at sun.reflect.GeneratedMethodAccessor1278.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:62)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.services.ejb.session.stateless_sp5.ObjectStubProxyImpl.invoke(ObjectStubProxyImpl.java:187)

at $Proxy165.getSubmitRequest(Unknown Source)

at sun.reflect.GeneratedMethodAccessor1277.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:62)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.services.webservices.runtime.EJBImplementationContainer.invokeMethod(EJBImplementationContainer.java:126)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:157)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:79)

at com.sap.engine.services.webservices.runtime.servlet.ServletDispatcherImpl.doPost(ServletDispatcherImpl.java:92)

at SoapServlet.doPost(SoapServlet.java:51)

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

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(AccessController.java:219)

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

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

2010-10-27 13:55:30,831 [SAPEngine_Application_Thread[impl:3]_14] ERROR Exception during EJB call, Ignoring and trying Webservice Call

com.virsa.ae.service.ServiceException: Exception in getting the results from the EJB service : com/virsa/cc/xsys/ejb/RiskAnalysis.execRiskAnalysis(Lcom/virsa/cc/xsys/webservices/dto/WSRAInputParamDTO;)Lcom/virsa/cc/xsys/webservices/dto/RAResultDTO;

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.getViolations(RiskAnalysisEJB53DAO.java:295)

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.getViolations(RiskAnalysisEJB53DAO.java:419)

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.determineRisks(RiskAnalysisEJB53DAO.java:527)

at com.virsa.ae.service.sap.RiskAnalysis53DAO.determineRisks(RiskAnalysis53DAO.java:103)

at com.virsa.ae.accessrequests.bo.RiskAnalysisBO.findViolations(RiskAnalysisBO.java:182)

at com.virsa.ae.accessrequests.bo.RiskAnalysisBO.findViolations(RiskAnalysisBO.java:80)

at com.virsa.ae.accessrequests.bo.RequestBO.saveRiskAnalysis(RequestBO.java:3999)

at com.virsa.ae.accessrequests.bo.RequestBO.saveNewRequest(RequestBO.java:369)

at com.virsa.ae.ejbutil.submitrequest.RequestSubmissionBean.submitRequest(RequestSubmissionBean.java:692)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJBBean.getSubmitRequest(SubmitRequestEJBBean.java:45)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJBObjectImpl0_0.getSubmitRequest(SubmitRequestEJBObjectImpl0_0.java:119)

at com.virsa.ae.ejb.submitrequest.SubmitRequestEJB_Stub.getSubmitRequest(SubmitRequestEJB_Stub.java:57)

at sun.reflect.GeneratedMethodAccessor1278.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:62)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.services.ejb.session.stateless_sp5.ObjectStubProxyImpl.invoke(ObjectStubProxyImpl.java:187)

at $Proxy165.getSubmitRequest(Unknown Source)

at sun.reflect.GeneratedMethodAccessor1277.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:62)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.services.webservices.runtime.EJBImplementationContainer.invokeMethod(EJBImplementationContainer.java:126)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:157)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:79)

at com.sap.engine.services.webservices.runtime.servlet.ServletDispatcherImpl.doPost(ServletDispatcherImpl.java:92)

at SoapServlet.doPost(SoapServlet.java:51)

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

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(AccessController.java:219)

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:

java.lang.VerifyError: com/virsa/cc/xsys/ejb/RiskAnalysis.execRiskAnalysis(Lcom/virsa/cc/xsys/webservices/dto/WSRAInputParamDTO;)Lcom/virsa/cc/xsys/webservices/dto/RAResultDTO;

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.execRiskAnalysis(RiskAnalysisEJB53DAO.java:305)

at com.virsa.ae.service.sap.RiskAnalysisEJB53DAO.getViolations(RiskAnalysisEJB53DAO.java:277)

... 40 more

[Former Member · Accepted solution]

Hi Asheesh

it works when i put the webservice links in the configuration under the mitigation menu . thanks a ton

Regards

Prasad

[Former Member]

For the Risk analysis to be performed from CUP , the Risk analysis and the mitigation menu under the configuration tab should be provided with proper Urls

[Former Member]

Hi Prasad,

Check the connector settings. I infer that the connection settings are not perfect.

Rgds,

Raghu

[Former Member]

Hi,

What is the version of CUP? Did you recently upgrade the version or SP level? Make sure to upload the latest initial data xml file and then try again.

Alpesh

[Former Member]

Hi Raghu

i checked the connectors and the test is successfull . i am able to get the list of the risks when i do the risk analysis from CUP .

Regards

Prasad

[Former Member]

Hi Alpesh

the version of CUP is GRC-SAC-SAE 5.3_11.2 ( Build ID:04032310 ) . this is latest implementation and i recon i have uploaded the latest xml files . below are the names of the files .

AE_init_append_data.xml

AE_init_append_data_ForSODUARReview.xml

AE_init_clean_and_insert_data.xml

Regards

Prasad