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

yadavlpsir — Sat, 19 Oct 2019 21:44:19 GMT

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

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

james_miller — Thu, 06 Feb 2020 01:49:32 GMT

Any answer to this? Im experincing it.

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

mathewsmotta — Tue, 21 Jul 2020 14:14:55 GMT

Hello,

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

topic EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0] when using store entity in Alfresco Forum

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

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

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