EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0] when using store entity

cancel
Showing results for 
Search instead for 
Did you mean: 
yadavlpsir
Member II

EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0] when using store entity

When i am inserting data in mysql database using Store Entity Task, row gets inserted successfully but i get the error :

19-Oct-2019 19:31:36.919 SEVERE [http-nio-8080-exec-17] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [appDispatcher] in context with path [/activiti-app] threw exception [Request processing failed; ne
sted exception is org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0] with root cause
org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:69)

and process gets stuck at that point, does not proceed further for next tasks.

please help me get out of this

 

Full log :

19-Oct-2019 21:19:27.287 SEVERE [http-nio-8080-exec-13] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [appDispatcher] in context with path [/activiti-app] threw exception [Request processing failed; nested exception is org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0] with root cause
org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:69)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:801)
at com.activiti.service.datamodel.DataModelEntityDao.findOneBy(DataModelEntityDao.java:47)
at com.activiti.service.datamodel.DataModelEntityDao$$FastClassBySpringCGLIB$$b6012afa.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
at com.activiti.service.datamodel.DataModelEntityDao$$EnhancerBySpringCGLIB$$ef3d9da5.findOneBy(<generated>)
at com.activiti.service.runtime.AlfrescoRuntimeDataModelService.handleStoreEntityDefinitionForVariable(AlfrescoRuntimeDataModelService.java:205)
at com.activiti.variable.VariableDataEntityType.getValue(VariableDataEntityType.java:137)
at org.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.getValue(HistoricVariableInstanceEntity.java:129)
at org.activiti.engine.impl.HistoricVariableInstanceQueryImpl.executeList(HistoricVariableInstanceQueryImpl.java:233)
at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:164)
at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
at com.activiti.addon.cluster.interceptor.GatherMetricsCommandInterceptor.execute(GatherMetricsCommandInterceptor.java:57)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
at org.activiti.engine.impl.AbstractQuery.list(AbstractQuery.java:138)
at com.activiti.service.runtime.AlfrescoProcessInstanceService.getProcessInstance(AlfrescoProcessInstanceService.java:201)
at com.activiti.rest.runtime.ProcessInstanceResource.getProcessInstance(ProcessInstanceResource.java:45)
at com.activiti.rest.runtime.ProcessInstanceResource$$FastClassBySpringCGLIB$$c82699e4.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:48)
at com.ryantenney.metrics.spring.TimedMethodInterceptor.invoke(TimedMethodInterceptor.java:34)
at com.ryantenney.metrics.spring.AbstractMetricMethodInterceptor.invoke(AbstractMetricMethodInterceptor.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
at com.activiti.rest.runtime.ProcessInstanceResource$$EnhancerBySpringCGLIB$$a24c5f81.getProcessInstance(<generated>)
at sun.reflect.GeneratedMethodAccessor3211.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInt

2 Replies
james_miller
Customer

Re: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0] when using store en

Any  answer to this? Im experincing it.

mathewsmotta
Customer

Re: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0] when using store en

Hello,

 

is there any answer to this? I'm also getting the same issue