Error during access to the Exit method from RAR to ERM

[Former Member]

Hi Experts,

<br>

<br>i configured the ERM with the Role Designer, I can create a Role and perform all Steps until the confirmation by the RAR.

<br>The role request are visible by the RAR but if I would confirm the request I got the error:

<br>

<br>Error processing your request, Request no: 2010000007 in stage : RE_STAGE_1.

<br>

<br>The RE_STAGE_1 is the stage configuration of the ERM access. I checked the Exit URL, the migitation url ...User, Passwords.

<br>

<br>Please see the detailed log (logsAE/logger.log)

<br>2010-03-18 16:58:52,775 [SAPEngine_Application_Thread[impl:3]_20] ERROR com.virsa.ae.accessrequests.bo.RequestExitServiceHelper : callExitService() : : Exception in calling the exit service, error code : -2, error message : Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "WFTASKID","OBJTYPE","ACTIONTYPE","OBJKEYS","WKSTATUS","REQUESTER","LASTUPDATE" FROM "VIRSA_CC_WFOBJ" WHERE "WFTASKID" = ?".

<br>2010-03-18 16:58:52,775 [SAPEngine_Application_Thread[impl:3]_20] ERROR Exception in calling the exit service, error code : -2, error message : Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "WFTASKID","OBJTYPE","ACTIONTYPE","OBJKEYS","WKSTATUS","REQUESTER","LASTUPDATE" FROM "VIRSA_CC_WFOBJ" WHERE "WFTASKID" = ?".

<br>com.virsa.ae.service.ServiceException: Exception in calling the exit service, error code : -2, error message : Cannot assign NULL to host variable 1. setNull() can only be used in INSERT and UPDATE statements. The statement is "SELECT "WFTASKID","OBJTYPE","ACTIONTYPE","OBJKEYS","WKSTATUS","REQUESTER","LASTUPDATE" FROM "VIRSA_CC_WFOBJ" WHERE "WFTASKID" = ?".

<br> at com.virsa.ae.accessrequests.bo.RequestExitServiceHelper.callExitService(RequestExitServiceHelper.java:171)

<br> at com.virsa.ae.accessrequests.bo.RequestExitServiceHelper.callExitServiceForApprovedRequest(RequestExitServiceHelper.java:56)

<br> at com.virsa.ae.accessrequests.bo.RequestBO.callExitService(RequestBO.java:5335)

<br> at com.virsa.ae.accessrequests.bo.RequestBO.approveRequest(RequestBO.java:5174)

<br> at com.virsa.ae.accessrequests.bo.RequestBO.approveRequest(RequestBO.java:4967)

<br> at com.virsa.ae.accessrequests.actions.RequestViewAction.confirmRequestApproval(RequestViewAction.java:928)

<br> at com.virsa.ae.accessrequests.actions.RequestViewAction.execute(RequestViewAction.java:103)

<br> at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:271)

<br> at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:425)

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

<br> at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:321)

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

<br> at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:455)

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

<br> at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:321)

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

<br> at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:455)

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

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

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

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

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

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

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

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

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

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

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

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

<br> at java.security.AccessController.doPrivileged(Native Method)

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

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

<br>2010-03-18 16:58:52,807 [SAPEngine_Application_Thread[impl:3]_20] INFO com.virsa.ae.accessrequests.actions.RequestViewAction : pageLoad() : : INTO the method

<br>2010-03-18 16:58:52,807 [SAPEngine_Application_Thread[impl:3]_20] INFO com.virsa.ae.accessrequests.actions.RequestViewAction : pageLoad() : : request number : 2010000007

<br>2010-03-18 17:00:53,491 [SAPEngine_Application_Thread[impl:3]_39] INFO com.virsa.ae.dao.sqlj.RequestTypeDAO : findAll : : going to return no of records= 21

<br>

<br>

<br>The Default Trace file (server0.log) show me the following errors:

<br>

<br>#1.5 #0013724BD69000780000005D00001EC4000482156385B47C#1268928282501#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#sap.com/grc~aeear#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#OSTNER#20232##grc_TGJ_17283950#OSTNER#f3833f1532a711df800e0013724bd690#SAPEngine_Application_Thread[impl:3]_4##0#0#Error#1#/System/Server/WebRequests#Plain###application [AE] Processing HTTP request to servlet [AEController] finished with error.

<br>The error is: com.sap.engine.services.servlets_jsp.server.exceptions.ServletNotFoundException: Requested resource [/getchart.chart] not found.

<br>Exception id: [0013724BD69000780000005B00001EC4000482156385B209]#

<br>#1.5 #0013724BD69000780000005E00001EC4000482156385D286#1268928282517#com.sap.engine.services.servlets_jsp.client.RequestInfoServer#sap.com/grc~aeear#com.sap.engine.services.servlets_jsp.client.RequestInfoServer#OSTNER#20232##grc_TGJ_17283950#OSTNER#f3833f1532a711df800e0013724bd690#SAPEngine_Application_Thread[impl:3]_4##0#0#Error##Plain###application [AE] Cannot send an HTTP error response [404 The request cannot be processed. (details: com.sap.engine.services.servlets_jsp.server.exceptions.ServletNotFoundException: Requested resource [/getchart.chart] not found.)]. The error is: com.sap.engine.services.servlets_jsp.server.exceptions.WebIOException: Error while invoking the error page.

<br> at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.sendError(HttpServletResponseFacade.java:958)

<br> at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.sendError(HttpServletResponseFacade.java:872)

<br> at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.sendError(HttpHandlerImpl.java:970)

<br> at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.processError(HttpHandlerImpl.java:845)

<br> at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:412)

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

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

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

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

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

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

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

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

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

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

<br> at java.security.AccessController.doPrivileged(Native Method)

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

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

<br>Caused by: com.sap.engine.services.servlets_jsp.server.exceptions.WebServletException: Error in dispatching request to servlet [/error.jsp].

<br> at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:328)

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

<br> at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.doError(HttpServletResponseFacade.java:1889)

<br> at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.sendError(HttpServletResponseFacade.java:912)

<br> ... 17 more

<br>Caused by: com.sap.engine.services.servlets_jsp.server.exceptions.WebIllegalStateException: The stream has already been taken by method [getOutputStream()].

<br> at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.getWriter(HttpServletResponseFacade.java:639)

<br> at com.sap.engine.services.servlets_jsp.server.jsp.JspWriterImpl.flushBuffer(JspWriterImpl.java:139)

<br> at com.sap.engine.services.servlets_jsp.server.jsp.JspWriterImpl.flush(JspWriterImpl.java:189)

<br> at com.sap.engine.services.servlets_jsp.server.jsp.PageContextImpl.release(PageContextImpl.java:306)

<br> at com.sap.engine.services.servlets_jsp.server.jsp.JspFactoryImpl.releasePageContext(JspFactoryImpl.java:83)

<br> at jsp_error1268321107982._jspService(jsp_error1268321107982.java:65535)

<br> at com.sap.engine.services.servlets_jsp.server.jsp.JspBase.service(JspBase.java:112)

<br> at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:566)

<br> at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:190)

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

<br> at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl.java:321)

<br> ... 20 more

<br>

<br>#

<br>#1.5 #0013724BD69000780000006000001EC4000482156385D678#1268928282517#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#sap.com/grc~aeear#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#OSTNER#20232##grc_TGJ_17283950#OSTNER#f3833f1532a711df800e0013724bd690#SAPEngine_Application_Thread[impl:3]_4##0#0#Error#1#/System/Server/WebRequests#Plain###application [AE] Cannot send an HTTP error response [404 The request cannot be processed. (details: com.sap.engine.services.servlets_jsp.server.exceptions.ServletNotFoundException: Requested resource [/getchart.chart] not found.)].

<br>The error is: com.sap.engine.services.servlets_jsp.server.exceptions.WebIOException: Error while invoking the error page.

<br>Exception id: [0013724BD69000780000005E00001EC4000482156385D286]#

Edited by: Daniel Ostner on Mar 18, 2010 5:36 PM

[Former Member]

Daniel,

There seems to be some SQL error. You should open a message with SAP so they can look at your system.

Alpesh

[Former Member]

Daniel, I`m having the same error... Do you have any advice ?

Thanks a lot !

[Former Member]

Hi Karem,

its fixed by the SP11

kind regards,

Daniel