T
Tom Oosterwijk
Guest
I have a process that is working perfectly fine for quite some time now (OEBPM 11.4), but last week the following issue happened twice for some process instances: A subprocess gets suspended in the End step. I cannot reactivate it, because the process is completed according to the BIZLOGIC_PROCESSINSTANCE table (STATUS = 11), but it is not according to the PROCESSINSTANCE table (STATUS = PI_ACTIVATED). Is there any place where I can see what the status in BIZLOGIC_PROCESSINSTANCE means anyway? I solved my problem by executing the following query: UPDATE BIZLOGIC_PROCESSINSTANCE SET STATUS = 7 WHERE BIZLOGIC_PROCESSINSTANCE.STATUS IN (6, 11) AND BIZLOGIC_PROCESSINSTANCE.PROCESS_TEMPLATE_ID = 4 AND BIZLOGIC_PROCESSINSTANCE.PROCESS_INSTANCE_ID IN ( SELECT bpi.PROCESS_INSTANCE_ID FROM BIZLOGIC_PROCESSINSTANCE bpi LEFT JOIN PROCESSINSTANCE pi ON bpi.PROCESS_INSTANCE_ID = pi.PROCESS_INSTANCE_ID WHERE bpi.STATUS IN (6, 11) AND bpi.PROCESS_TEMPLATE_ID = 4 AND pi.STATUS = 'PI_ACTIVATED' ) ; After this, I can activate my End steps. My customer wants to know what caused this (frankly, so do I), and I found the following in the bpserver.log: [#| 17 Aug 2018 14:44:57,270 | BPServer | ERROR | ejbServer | BPServer | (1621) SQL Exception occurs in database transaction.; context(BLDAOService.handle(SQLEx))[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -100007 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmLobUpdate called from proLob::updateData on for . Save log for Progress technical support. | WorkerThread#3[127.0.0.1:50922] |#] java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -100007 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmLobUpdate called from proLob::updateData on for . Save log for Progress technical support. at com.ddtek.jdbc.openedge.client.dde.ap(Unknown Source) at com.ddtek.jdbc.openedge.client.dde.h(Unknown Source) at com.ddtek.jdbc.openedge.client.dde.g(Unknown Source) at com.ddtek.jdbc.openedge.ddf.b(Unknown Source) at com.ddtek.jdbc.openedgebase.ddej.u(Unknown Source) at com.ddtek.jdbc.openedgebase.ddej.w(Unknown Source) at com.ddtek.jdbc.openedgebase.ddde.executeUpdate(Unknown Source) at com.ddtek.jdbcx.openedgebase.ddn.executeUpdate(Unknown Source) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at com.savvion.sbm.bizlogic.server.dao.DataSlotDAO.update(DataSlotDAO.java:1252) at com.savvion.sbm.bizlogic.server.dao.DataSlotDAO.store(DataSlotDAO.java:165) at com.savvion.sbm.bizlogic.server.WFDataSlotInstance.updateSlotValue(WFDataSlotInstance.java:643) at com.savvion.sbm.bizlogic.server.WFProcessContext.updateSlotValue(WFProcessContext.java:710) at com.savvion.sbm.bizlogic.server.WFProcessInstance.completeCaller(WFProcessInstance.java:1575) at com.savvion.sbm.bizlogic.server.WFProcessInstance.complete(WFProcessInstance.java:1424) at com.savvion.sbm.bizlogic.server.WFProcessContext.completeProcessInstance(WFProcessContext.java:953) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.complete(WFAtomicInstance.java:289) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.complete(WFAtomicInstance.java:195) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.execute(WFAtomicInstance.java:183) at com.savvion.sbm.bizlogic.server.WFWorkstepInstance.runIt(WFWorkstepInstance.java:2109) at com.savvion.sbm.bizlogic.server.WFWorkstepInstance.activate(WFWorkstepInstance.java:1191) at com.savvion.sbm.bizlogic.server.WFProcessContext.activateWorkstep(WFProcessContext.java:991) at com.savvion.sbm.bizlogic.server.WFWorkstepInstance.activateNextWorksteps(WFWorkstepInstance.java:982) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.complete(WFAtomicInstance.java:291) at com.savvion.sbm.bizlogic.server.WFWorkItem.checkWorkStepCompletion(WFWorkItem.java:440) at com.savvion.sbm.bizlogic.server.WFWorkItem.complete(WFWorkItem.java:336) at com.savvion.sbm.bizlogic.server.WFWorkItem.complete(WFWorkItem.java:242) at com.savvion.sbm.bizlogic.server.WFProcessContext.completeWorkItem(WFProcessContext.java:1160) at com.savvion.sbm.bizlogic.server.ejb.WorkItemSBBean.complete(WorkItemSBBean.java:320) at sun.reflect.GeneratedMethodAccessor759.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.jboss.invocation.Invocation.performCall(Invocation.java:386) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:228) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211) at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:97) at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:81) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650) at org.jboss.ejb.Container.invoke(Container.java:1029) at sun.reflect.GeneratedMethodAccessor364.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668) at org.jboss.invocation.unified.server.UnifiedInvoker.invoke(UnifiedInvoker.java:232) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891) at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:744) at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:697) at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:551) at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:232) [#| 17 Aug 2018 14:44:57,270 | BPServer | ERROR | ejbServer | BPServer | (931) Exception occurs during workstep execution for PI , Workstep at | WorkerThread#3[127.0.0.1:50922] |#] com.savvion.sbm.bizlogic.util.BizLogicException: (1621) SQL Exception occurs in database transaction.; context(BLDAOService.handle(SQLEx))[DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -100007 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmLobUpdate called from proLob::updateData on for . Save log for Progress technical support. at com.savvion.sbm.bizlogic.util.BLDAOService.handle(BLDAOService.java:143) at com.savvion.sbm.bizlogic.server.dao.DataSlotDAO.update(DataSlotDAO.java:1254) at com.savvion.sbm.bizlogic.server.dao.DataSlotDAO.store(DataSlotDAO.java:165) at com.savvion.sbm.bizlogic.server.WFDataSlotInstance.updateSlotValue(WFDataSlotInstance.java:643) at com.savvion.sbm.bizlogic.server.WFProcessContext.updateSlotValue(WFProcessContext.java:710) at com.savvion.sbm.bizlogic.server.WFProcessInstance.completeCaller(WFProcessInstance.java:1575) at com.savvion.sbm.bizlogic.server.WFProcessInstance.complete(WFProcessInstance.java:1424) at com.savvion.sbm.bizlogic.server.WFProcessContext.completeProcessInstance(WFProcessContext.java:953) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.complete(WFAtomicInstance.java:289) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.complete(WFAtomicInstance.java:195) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.execute(WFAtomicInstance.java:183) at com.savvion.sbm.bizlogic.server.WFWorkstepInstance.runIt(WFWorkstepInstance.java:2109) at com.savvion.sbm.bizlogic.server.WFWorkstepInstance.activate(WFWorkstepInstance.java:1191) at com.savvion.sbm.bizlogic.server.WFProcessContext.activateWorkstep(WFProcessContext.java:991) at com.savvion.sbm.bizlogic.server.WFWorkstepInstance.activateNextWorksteps(WFWorkstepInstance.java:982) at com.savvion.sbm.bizlogic.server.WFAtomicInstance.complete(WFAtomicInstance.java:291) at com.savvion.sbm.bizlogic.server.WFWorkItem.checkWorkStepCompletion(WFWorkItem.java:440) at com.savvion.sbm.bizlogic.server.WFWorkItem.complete(WFWorkItem.java:336) at com.savvion.sbm.bizlogic.server.WFWorkItem.complete(WFWorkItem.java:242) at com.savvion.sbm.bizlogic.server.WFProcessContext.completeWorkItem(WFProcessContext.java:1160) at com.savvion.sbm.bizlogic.server.ejb.WorkItemSBBean.complete(WorkItemSBBean.java:320) at sun.reflect.GeneratedMethodAccessor759.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.jboss.invocation.Invocation.performCall(Invocation.java:386) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:228) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211) at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:97) at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:81) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650) at org.jboss.ejb.Container.invoke(Container.java:1029) at sun.reflect.GeneratedMethodAccessor364.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668) at org.jboss.invocation.unified.server.UnifiedInvoker.invoke(UnifiedInvoker.java:232) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891) at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:744) at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:697) at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:551) at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:232) Caused by: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -100007 (see dsmret.h) in SQL from subsystem DSM SERVICES function dsmLobUpdate called from proLob::updateData on for . Save log for Progress technical support. at com.ddtek.jdbc.openedge.client.dde.ap(Unknown Source) at com.ddtek.jdbc.openedge.client.dde.h(Unknown Source) at com.ddtek.jdbc.openedge.client.dde.g(Unknown Source) at com.ddtek.jdbc.openedge.ddf.b(Unknown Source) at com.ddtek.jdbc.openedgebase.ddej.u(Unknown Source) at com.ddtek.jdbc.openedgebase.ddej.w(Unknown Source) at com.ddtek.jdbc.openedgebase.ddde.executeUpdate(Unknown Source) at com.ddtek.jdbcx.openedgebase.ddn.executeUpdate(Unknown Source) at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) at com.savvion.sbm.bizlogic.server.dao.DataSlotDAO.update(DataSlotDAO.java:1252) ... 52 more Can I prevent this issue? How can this happen?
Continue reading...
Continue reading...