Hi all,
we are facing a very odd problem working with GP. This problem seems to be caused by a duplication of the key contained in table CAF_GP_PFWRPR. Each of its rows are composed by five fields:
TEMPLATEID, PROCESSID, PROCROLETECHNAME, USERCXTID, READORDER. The right condition is that each row has to be different at least in one field from another one. Reading our logs we found that GP runtime manager crashed by automatically creating the same row each time (expecially by using the same PROCESSID). This problem is totally blocking our system so any suggestion or help to solve it would be much appreciated. We tested the same application on an internal development server before going to production without any problem.
Thank in advance for your support.
Luca
This is the stack trace error:
com.sap.caf.eu.gp.exception.api.GPEngineException: ORA-00001: unique constraint (SAPSR3DB.SYS_C005164) violated at com.sap.caf.eu.gp.exception.impl.ExceptionUtil.convertTo(ExceptionUtil.java:38) at com.sap.caf.eu.gp.process.rt.impl.GPRuntimeManager.startProcess(GPRuntimeManager.java:150) at com.akhela.abilaut.root.abil.richiesta.gp.crea.GPCreaRichiestaCO.startProcess(GPCreaRichiestaCO.java:437) at com.akhela.abilaut.root.abil.richiesta.gp.crea.GPCreaRichiestaCO.handleSalvato(GPCreaRichiestaCO.java:386) at com.akhela.abilaut.root.abil.richiesta.gp.crea.wdp.InternalGPCreaRichiestaCO.wdInvokeEventHandler(InternalGPCreaRichiestaCO.java:213) at com.sap.tc.webdynpro.progmodel.generation.DelegatingComponent.invokeEventHandler(DelegatingComponent.java:161) at com.sap.tc.webdynpro.progmodel.controller.Component.fireEvent(Component.java:284) at com.akhela.abilaut.root.abil.richiesta.wdp.InternalRootAbilRichiestaInterface.wdFireEventSalvato(InternalRootAbilRichiestaInterface.java:218) at com.akhela.abilaut.root.abil.richiesta.RootAbilRichiestaInterface.doFireSalvato(RootAbilRichiestaInterface.java:176) at com.akhela.abilaut.root.abil.richiesta.wdp.InternalRootAbilRichiestaInterface.wdInvokeEventHandler(InternalRootAbilRichiestaInterface.java:179) at com.sap.tc.webdynpro.progmodel.generation.DelegatingCustomController.invokeEventHandler(DelegatingCustomController.java:89) at com.sap.tc.webdynpro.progmodel.controller.Component.fireEvent(Component.java:284) at com.akhela.abilaut.root.abil.richiesta.wdp.InternalRootAbilRichiesta.wdFireEventSalvato(InternalRootAbilRichiesta.java:786) at com.akhela.abilaut.root.abil.richiesta.RootAbilRichiesta.salvaRichiestaInterno(RootAbilRichiesta.java:907) at com.akhela.abilaut.root.abil.richiesta.RootAbilRichiesta.salvaRichiesta(RootAbilRichiesta.java:413) at com.akhela.abilaut.root.abil.richiesta.wdp.InternalRootAbilRichiesta.salvaRichiesta(InternalRootAbilRichiesta.java:457) at com.akhela.abilaut.root.abil.richiesta.CreazioneRichiestaView.onActionSalvaBozza(CreazioneRichiestaView.java:186) at com.akhela.abilaut.root.abil.richiesta.wdp.InternalCreazioneRichiestaView.wdInvokeEventHandler(InternalCreazioneRichiestaView.java:254) at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.invokeEventHandler(DelegatingView.java:87) at com.sap.tc.webdynpro.progmodel.controller.Action.fire(Action.java:67) at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doHandleActionEvent(WindowPhaseModel.java:420) at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:132) at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335) at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143) at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:319) at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingPortal(ClientSession.java:733) at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:668) at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:250) at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149) at com.sap.tc.webdynpro.clientserver.session.core.ApplicationHandle.doProcessing(ApplicationHandle.java:73) at com.sap.tc.webdynpro.portal.pb.impl.AbstractApplicationProxy.sendDataAndProcessActionInternal(AbstractApplicationProxy.java:860) at com.sap.tc.webdynpro.portal.pb.impl.localwd.LocalApplicationProxy.sendDataAndProcessAction(LocalApplicationProxy.java:77) at com.sap.portal.pb.PageBuilder.updateApplications(PageBuilder.java:1299) at com.sap.portal.pb.PageBuilder.SendDataAndProcessAction(PageBuilder.java:326) at com.sap.portal.pb.PageBuilder$1.doPhase(PageBuilder.java:868) at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processPhaseListener(WindowPhaseModel.java:755) at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.doPortalDispatch(WindowPhaseModel.java:717) at com.sap.tc.webdynpro.clientserver.window.WindowPhaseModel.processRequest(WindowPhaseModel.java:136) at com.sap.tc.webdynpro.clientserver.window.WebDynproWindow.processRequest(WebDynproWindow.java:335) at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:143) at com.sap.tc.webdynpro.clientserver.session.ApplicationSession.doProcessing(ApplicationSession.java:319) at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessingStandalone(ClientSession.java:713) at com.sap.tc.webdynpro.clientserver.session.ClientSession.doApplicationProcessing(ClientSession.java:666) at com.sap.tc.webdynpro.clientserver.session.ClientSession.doProcessing(ClientSession.java:250) at com.sap.tc.webdynpro.clientserver.session.RequestManager.doProcessing(RequestManager.java:149) at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:62) at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doPost(DispatcherServlet.java:53) 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(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) Caused by: com.sap.sql.DuplicateKeyException: ORA-00001: unique constraint (SAPSR3DB.SYS_C005164) violated at com.sap.sql.jdbc.common.CommonPreparedStatement.executeUpdate(CommonPreparedStatement.java:259) at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:254) at com.sap.caf.eu.gp.model.pfw.wfc.local.db.impl.LocalProcessRolePersistence.insertUser(LocalProcessRolePersistence.java:142) at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.createProcessRoles(StatusWriter.java:668) at com.sap.caf.eu.gp.model.pfw.wfc.local.status.StatusWriter.startWorkflow(StatusWriter.java:164) at com.sap.caf.eu.gp.model.pfw.wfc.local.impl.LocalWorkflowConnector.startWorkflow(LocalWorkflowConnector.java:2