[jboss-user] [jBPM] - ConstraintViolationException in JBPM4_HIST_ACTINST table

Abdul Rahman Kunhi Ahamed [http://community.jboss.org/people/abdulrahman] created the discussion "ConstraintViolationException in JBPM4_HIST_ACTINST table" To view the discussion, visit: http://community.jboss.org/message/562050#562050 -------------------------------------------------------------- Hi, I am running into a ConstraintViolationException when executing a job in the jbpm. The constraint being violated is the primary key for the table JBPM4_HIST_ACTINST. There is no particular scenario when this issue happens, however the state transition involed is always a timed transition with a due time(escalation). And we are trying to trigger it manually. The only possible solution is that to disable the primary key in the history table. However we are not sure of its impact on jbpm's working. Please find below the exception trace. Please advise. org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update                 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)                 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)                 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)                 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)                 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)                 at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)                 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)                 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)                 at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)                 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)                 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)                 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)                 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)                 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)                 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)                 at org.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:56)                 at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)                 at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)                 at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)                 at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)                 at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)                 at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)                 at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)                 at org.jbpm.pvm.internal.svc.ManagementServiceImpl.executeJob(ManagementServiceImpl.java:37)                 ......                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)                 at java.lang.reflect.Method.invoke(Method.java:597)                 at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:335)                 at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:348)                 at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)                 at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)                 at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)                 at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)                 at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)                 at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:95)                 at javax.faces.component.UICommand.broadcast(UICommand.java:387)                 at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321)                 at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296)                 at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253)                 at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466)                 at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)                 at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:248)                 at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)                 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)                 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)                 at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:341)                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)                 at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)                 at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)                 at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:86)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)                 at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)                 at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)                 at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)                 at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)                 at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368)                 at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495)                 at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)                 at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)                 at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)                 at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)                 at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)                 at com.dhl.ost.filter.AccessFilter.doFilter(Unknown Source)                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)                 at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)                 at weblogic.security.service.SecurityManager.runAs(Unknown Source)                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:173) Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (OSTUSER1.BIN$j7sVs2OuC+bgQEilfksI4A==$0) violated                 at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:566)                 at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9365)                 at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)                 at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:191)                 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)                 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)                 ... 105 more -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/562050#562050] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]