CUP 5.3 - Error creating request

Dear expert,

We have installed GRC Access control 5.3 (support package 8.0) and are facing a problem when trying to create a request in CUP:

When creating a new request, we always get the error message "Error creating request" after trying to submit. There seems to be no apparent problem with the workflow and we have filled out all mandatory fields.

Thanks for your help in advance!

Regards,

Felix Poeschl

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (4)

Did you solve the problem?

i have the same problem, can't create request in CUP..it takes long time and then error.."error in creating request"

i tried to change the Risk Analysis On Request Submission to NO, and then it works but we need it to do risk analysis...

any idea?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I setup the GRC CUP test system and have been able to create user requests on my test workflow all morning. However I am not unable to create the requests, with the above error.

I looked at the logs, and have the following message. I had made some changes to my role attributes and to my custom approver definitions, but nothing to the systems. I'm not sure why this error has come up.

Any assistance is appreciated.

Thanks,

Santosh

2009-11-19 16:52:35,439 [SAPEngine_Application_Thread[impl:3]_34] ERROR BO Exception in Save request

com.virsa.ae.core.BOException: Exception from the service : Invalid System

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

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

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

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

at com.virsa.ae.accessrequests.actions.CreateRequestAction.createRequest(CreateRequestAction.java:262)

at com.virsa.ae.accessrequests.actions.EUCreateRequestAction.createRequestHandler(EUCreateRequestAction.java:106)

at com.virsa.ae.accessrequests.actions.EUCreateRequestAction.execute(EUCreateRequestAction.java:63)

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

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

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

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doWork(RequestDispatcherImpl

You have probably resolved this by now. But I encountered this error as well and the Risk Analysis was my issue too. The password for the ID set up in the Risk Analysis configuration for CUP had expired. So I had to set a new password for the ID and enter it into the config area. After this CUP requests began to flow again.

Hi Mosi,

Even I was facing the same problem "Error creating request". Actually I changed the password and it stopped working. As suggested by you, I set the original password and now I am able to submit request successfully.

Regards,

Rohini Joshi.

i have the same problem..where do i see the log?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

you can check the logs at following location.

Configuration -- Monitoring --> System log.

Please make sure you have made the log to debug level. you can change this at following location.

Configuration --> Misc -- Log Level. Make this to Debug.

Thanks,

Hi Felix,

Just try to recreate this error again and copy the logs from CUP during that time duration so that we can check the cause of the error from the logs.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Alpesh, hello Shweta,

We're pretty sure that the initiator is set correctly. (The only condition for it to be actived is that a certain employee type is selected, which we select accordingly during request creation.)

Below are the sections of the log durch creation of the request, where an error message appears.

Thanks for your help!

Regards,

Felix

2009-07-13 09:32:31,015 [SAPEngine_Application_Thread[impl:3]_8] ERROR com.virsa.ae.dao.sqlj.RequestDataHeaderDAO : insertUsers(IAETransaction txn,String reqNo,List listRequestDataUserDTOs) : : SqlException occured, reqNo= 44 exception=[SAP_NWmss][SQLServer JDBC Driver][SQLServer]The INSERT statement conflicted with the FOREIGN KEY constraint "VF_AE_RQD_USERS_1". The conflict occurred in database "ERP", table "SAPERPDB.VIRSA_AE_REQD_HDR", column 'REQNO'.

com.sap.sql.DuplicateKeyException: [SAP_NWmss][SQLServer JDBC Driver][SQLServer]The INSERT statement conflicted with the FOREIGN KEY constraint "VF_AE_RQD_USERS_1". The conflict occurred in database "ERP", table "SAPERPDB.VIRSA_AE_REQD_HDR", column 'REQNO'.

at com.sap.sql.jdbc.common.CommonPreparedStatement.executeUpdate(CommonPreparedStatement.java:259)

at com.sap.sql.sqlj.runtime.profile.ref.RTStatementJDBCPrepared.executeUpdate(RTStatementJDBCPrepared.java:267)

at sqlj.runtime.ExecutionContext$StatementFrame.executeUpdate(ExecutionContext.java:1124)

at sqlj.runtime.ExecutionContext.executeUpdate(ExecutionContext.java:718)

at com.virsa.ae.dao.sqlj.RequestDataHeaderDAO.insertUsers(RequestDataHeaderDAO.sqlj:578)

at com.virsa.ae.accessrequests.bo.RequestBO.saveUsers(RequestBO.java:1505)

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

at com.virsa.ae.accessrequests.actions.CreateRequestAction.createRequest(CreateRequestAction.java:268)

at com.virsa.ae.accessrequests.actions.CreateRequestAction.execute(CreateRequestAction.java:89)

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:387)

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

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

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

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:100)

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

2009-07-13 09:32:31,015 [SAPEngine_Application_Thread[impl:3]_8] ERROR Exception in saving the request

com.virsa.ae.dao.DAOException: [SAP_NWmss][SQLServer JDBC Driver][SQLServer]The INSERT statement conflicted with the FOREIGN KEY constraint "VF_AE_RQD_USERS_1". The conflict occurred in database "ERP", table "SAPERPDB.VIRSA_AE_REQD_HDR", column 'REQNO'.

at com.virsa.ae.dao.sqlj.RequestDataHeaderDAO.insertUsers(RequestDataHeaderDAO.sqlj:605)