AnsweredAssumed Answered

Two-way task communication error

Question asked by gjaya26 on Nov 7, 2017

Hi,

Can you please let me know what is the cause of the below error when i am trying to close workflows? what am i missing.

 

2017-11-07 01:59:15,919 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] RuntimeService.postTaskForm(): exception:
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

### The error may involve org.activiti.engine.impl.persistence.entity.HistoricDetailEntity.insertHistoricFormProperty-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, ACT_INST_ID_, EXECUTION_ID_, TASK_ID_, TIME_, NAME_, TEXT_) values ( ?, 'FormProperty', ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23) ~[mybatis-3.2.5.jar:3.2.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:150) ~[mybatis-3.2.5.jar:3.2.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:137) ~[mybatis-3.2.5.jar:3.2.5]
at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:757) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:589) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:137) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47) ~[activiti-spring-5.16.3.jar:5.16.3]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) ~[spring-tx-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) ~[activiti-spring-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35) ~[activiti-engine-5.16.3.jar:5.16.3]
at org.activiti.engine.impl.FormServiceImpl.submitTaskFormData(FormServiceImpl.java:70) ~[activiti-engine-5.16.3.jar:5.16.3]
at com.pru.wf.engine.service.RuntimeService.postTaskForm(RuntimeService.java:246) [_wl_cls_gen.jar:?]
at com.pru.wf.engine.service.RuntimeService$$FastClassBySpringCGLIB$$855cc2ab.invoke(<generated>) [spring-core-4.0.6.RELEASE.jar:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:640) [spring-aop-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at com.pru.wf.engine.service.RuntimeService$$EnhancerBySpringCGLIB$$b8ebe476.postTaskForm(<generated>) [spring-core-4.0.6.RELEASE.jar:?]
at com.pru.wf.engine.service.CreateWorkflowService.actionWorkflowsUserTask(CreateWorkflowService.java:253) [_wl_cls_gen.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_40]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_40]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_40]
at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_40]
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) [spring-web-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) [spring-web-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:751) [javax.servlet_2.0.0.0_3-0.jar:3.0]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837) [spring-webmvc-4.0.6.RELEASE.jar:4.0.6.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:844) [javax.servlet_2.0.0.0_3-0.jar:3.0]
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338) [BUG20780188_1211012.jar:12.1.1.0]
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:74) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:74) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3296) [BUG20780188_1211012.jar:12.1.1.0]
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3262) [BUG20780188_1211012.jar:12.1.1.0]
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) [com.bea.core.weblogic.security.identity_2.0.0.0.jar:2.0.0.0]
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) [com.bea.core.weblogic.security.wls_1.1.0.0_6-2-0-0.jar:6.2.0.0]
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57) [weblogic.jar:12.1.1.0]
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2171) [BUG20780188_1211012.jar:12.1.1.0]
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2097) [BUG20780188_1211012.jar:12.1.1.0]
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2075) [BUG20780188_1211012.jar:12.1.1.0]
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513) [BUG20780188_1211012.jar:12.1.1.0]
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254) [weblogic.jar:12.1.1.0]
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) [com.bea.core.weblogic.workmanager_2.0.0.0.jar:2.0.0.0]
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) [com.bea.core.weblogic.workmanager_2.0.0.0.jar:2.0.0.0]
Caused by: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

 

i have attached the bpmn xml for your reference.

Attachments

Outcomes