Did anyone faced this datahub publication error

[Former Member]

2019-07-19 11:00:27,497 [ERROR] [c.h.d.s.i.PublicationActionHandler] Error publishing action: 60 org.springframework.orm.jpa.JpaObjectRetrievalFailureException: Unable to find com.hybris.datahub.runtime.domain.jpa.entities.SubTargetSystemPublicationEntity with id 315; nested exception is javax.persistence.EntityNotFoundException: Unable to find com.hybris.datahub.runtime.domain.jpa.entities.SubTargetSystemPublicationEntity with id 315 at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:389) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:246) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:525) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:209) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy132.save(Unknown Source) at com.hybris.datahub.repository.jpa.impl.AbstractGenericJpaRepository.save(AbstractGenericJpaRepository.java:91) at com.hybris.datahub.repository.jpa.impl.AbstractGenericJpaRepository.save(AbstractGenericJpaRepository.java:56) at com.hybris.datahub.service.impl.DefaultPublicationActionService.updateCompositeTargetSystemPublication(DefaultPublicationActionService.java:114) at com.hybris.datahub.service.impl.AbstractTargetItemService$1.doInTransactionWithoutResult(AbstractTargetItemService.java:102) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133) at com.hybris.datahub.service.impl.AbstractTargetItemService.createTargetItemsForPublication(AbstractTargetItemService.java:97) at com.hybris.datahub.service.impl.PublicationActionHandler.lambda$createTargetItems$0(PublicationActionHandler.java:161) at java.util.ArrayList.forEach(ArrayList.java:1257) at com.hybris.datahub.service.impl.PublicationActionHandler.createTargetItems(PublicationActionHandler.java:158) at com.hybris.datahub.service.impl.PublicationActionHandler.handlePublicationAction(PublicationActionHandler.java:125) at com.hybris.datahub.service.impl.PublicationActionHandler.handleAction(PublicationActionHandler.java:97) at com.hybris.datahub.service.impl.PublicationActionHandler.handleAction(PublicationActionHandler.java:71) at com.hybris.datahub.command.impl.AbstractPerformCommand.lambda$execute$0(AbstractPerformCommand.java:56) at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1626) at com.hybris.datahub.service.ExceptionHandlingAsyncTaskExecutor.lambda$createWrappedRunnable$1(ExceptionHandlingAsyncTaskExecutor.java:72) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:836) Caused by: javax.persistence.EntityNotFoundException: Unable to find com.hybris.datahub.runtime.domain.jpa.entities.SubTargetSystemPublicationEntity with id 315 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$JpaEntityNotFoundDelegate.handleEntityNotFound(EntityManagerFactoryBuilderImpl.java:158) at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227) at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:278) at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:121) at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:89) at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1239) at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1122) at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:646) at org.hibernate.type.EntityType.resolve(EntityType.java:431) at org.hibernate.type.EntityType.replace(EntityType.java:330) at org.hibernate.type.CollectionType.replaceElements(CollectionType.java:543) at org.hibernate.type.CollectionType.replace(CollectionType.java:688) at org.hibernate.type.TypeHelper.replace(TypeHelper.java:180) at org.hibernate.event.internal.DefaultMergeEventListener.copyValues(DefaultMergeEventListener.java:394) at org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:328) at org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:170) at org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:69) at org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:883) at org.hibernate.internal.SessionImpl.merge(SessionImpl.java:869) at sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298) at com.sun.proxy.$Proxy84.merge(Unknown Source) at org.springframework.data.jpa.repository.support.SimpleJpaRepository.save(SimpleJpaRepository.java:509) at sun.reflect.GeneratedMethodAccessor286.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:503) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:488) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:460) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ... 26 common frames omitted 2019-07-19 11:00:27,497 [INFO] [c.h.d.s.i.PublicationActionHandler] Failing publication action: 60 2019-07-19 11:00:27,511 [INFO] [c.h.d.s.i.AsynchronousEventPublicationService] Firing data hub event : TargetSystemPublicationCompletedEvent{publicationId=780, poolId=18, publicationResult=PublicationResult{publicationId=780, completionStatus=FAILURE, successCount=8125, internalErrorCount=0, externalErrorCount=0, ignoredCount=97}} 2019-07-19 11:00:27,512 [DEBUG] [c.h.d.s.p.i.DefaultDataHubPublicationService] setting publication status to FAILURE 2019-07-19 11:00:27,513 [DEBUG] [c.h.d.p.i.DefaultProcessMonitor] Unregistered Publication #60, 16 processes running 2019-07-19 11:00:27,513 [INFO] [c.h.d.s.i.AsynchronousEventPublicationService] Firing data hub event : PublicationCompletedEvent{actionId=60, poolId=18} 2019-07-19 11:00:27,527 [INFO] [c.h.d.a.p.l.DHPurgePublicationListener] ################## Received PublicationCompletedEvent[60] for pool H_SAP_ECC_POOL ##################

[Slava]

I've seen this question on this forum before, so that means "yes" to answer your question.

As to the reason, you're seeing this exception, it's most likely a concurrent deletion of the target system publication entity while the publication is going on. Do you have cleanup extensions enabled? If so, check whether delay is configured correctly for the cleanup. Cleanup extension is the primary suspect of killing the in-flight publication data in the database, but there could be other reasons too (although they do not come to my mind).