cancel
Showing results for 
Search instead for 
Did you mean: 

Error trying to approve Role in CUP

Former Member
0 Kudos

Hi Guys!

When I try to approve a request in CUP for Role approval, the system show the next error. ( GRC 5. 3)

Can you help me??? Thanks!!!

2010-03-19 14:18:51,656 [SAPEngine_Application_Thread[impl:3]_32] 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" = ?".

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" = ?".

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

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

at com.virsa.ae.accessrequests.bo.RequestBO.callExitService(RequestBO.java:6761)

at com.virsa.ae.accessrequests.bo.RequestBO.approveRequest(RequestBO.java:6600)

at com.virsa.ae.accessrequests.bo.RequestBO.approveRequest(RequestBO.java:6393)

at com.virsa.ae.accessrequests.actions.RequestViewAction.confirmRequestApproval(RequestViewAction.java:949)

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

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.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(Native Method)

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

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

2010-03-19 14:18:51,656 [SAPEngine_Application_Thread[impl:3]_32] INFO MessagingHelper.java@159:clearMessages() : @@@clearing messages

2010-03-19 14:18:51,671 [SAPEngine_Application_Thread[impl:3]_32] INFO MessagingHelper.java@127:addMessage() : @@@Adding msgValue: Code: 1016; Locale: es

2010-03-19 14:18:51,671 [SAPEngine_Application_Thread[impl:3]_32] INFO MessagingHelper.java@137:addMessage() : @@@Creating new message list

2010-03-19 14:18:51,671 [SAPEngine_Application_Thread[impl:3]_32] INFO MessagingHelper.java@147:addMessage() : Adding msg to msglist

2010-03-19 14:18:51,671 [SAPEngine_Application_Thread[impl:3]_32] DEBUG NavigationEngine.java@296:execute() : Target returned by execute action: failure

2010-03-19 14:18:51,671 [SAPEngine_Application_Thread[impl:3]_32] DEBUG AEFrameworkServlet.java@458:service() : forwarding to:scrRequestDetails.loadRequestDetails.do

2010-03-19 14:18:51,671 [SAPEngine_Application_Thread[impl:3]_32] DEBUG AEFrameworkServlet.java@521:logRequest() :

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I think you already got an answer from the following thread:

Thanks

Himadama

Former Member
0 Kudos

SP11 doesn`t apply in my case, because I`m working with GRC V. 5.3.

Any ideas?? I really need to resolve this!

Thanks!

Former Member
0 Kudos

The current SP level of GRC AC 5.3 version CUP is SP11:

VIRAE11_0-20002300.SCA SP11 for VIRAE 530_700 0 Info 54767 25.02.2010

Thanks

Himadama

Former Member
0 Kudos

Karen,

SP11 is part of GRC AC 5.3. 5.3 is the main version of the product and SP11 means the support pack level of the version. What is the SP level of your CUP 5.3?

Alpesh

Former Member
0 Kudos

Thanks for your reply. My SP is 10.

Former Member
0 Kudos

As mentioned by the expert above, this is fixed in SP11. You will have to upgrade from SP10 to SP11.

Alpesh