Skip to Content
0
Former Member
Apr 27, 2009 at 08:32 AM

GP Fault due to duplicated key on internal DB table named CAF_GP_PFWRPR

26 Views

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