RE: RE: Error on import - Portlet has owner ID of 0 and PLID of 0

thumbnail
Yannis Sinadinos, modified 3 Years ago. Junior Member Posts: 39 Join Date: 3/20/17 Recent Posts

I am trying to import the latest version of a site from production to staging and on import I get the following error:

An unexpected error occurred with the publish process. Please check your portal and publishing configuration.

The following error occurred within com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl: Portlet com_liferay_portal_search_web_portlet_SearchPortlet has owner ID of 0 and PLID of 0 because of wrong properties or wrong data handler settings.

I have deleted the site and re-created with same name and I have selected different options on import with "Mirror" and "Mirror with overwriting" but the error is always the same. 

Any ideas how to fix this?

thumbnail
Zsigmond Rab, modified 3 Years ago. Liferay Master Posts: 764 Join Date: 1/5/10 Recent Posts

Hi Yannis,

Which version of the portal do you use?

Could you please share related errors from the server log if there is any?

Is it possible, your case connects to data deletion option like it has been described here: https://issues.liferay.com/browse/LPS-144797

Regards,

Zsigmond

thumbnail
Yannis Sinadinos, modified 3 Years ago. Junior Member Posts: 39 Join Date: 3/20/17 Recent Posts

Hello Zsigmond, 

I use the latest version "LIFERAY 7.4.3.4" as mentioned in tags bellow the article.

Thank you for the link, I will try and update this post.

You can find the related logs below

2022-02-23 13:44:48.112 ERROR [liferay/background_task-2][BackgroundTaskMessageListener:182] Unable to execute background task
com.liferay.exportimport.kernel.exception.ExportImportRuntimeException: Portlet com_liferay_portal_search_web_portlet_SearchPortlet has owner ID of 0 and PLID of 0 because of wrong properties or wrong data handler settings
        at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayoutsDataDeletions(ExportImportLocalServiceImpl.java:280) ~[portal-impl.jar:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_312]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_312]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_312]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
        at com.sun.proxy.$Proxy94.importLayoutsDataDeletions(Unknown Source) ~[?:?]
        at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.importLayoutsDataDeletions(ExportImportLocalServiceUtil.java:125) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor$LayoutImportCallable.call(LayoutImportBackgroundTaskExecutor.java:130) ~[?:?]
        at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor$LayoutImportCallable.call(LayoutImportBackgroundTaskExecutor.java:119) ~[?:?]
        at com.liferay.portal.spring.transaction.BaseTransactionExecutor.execute(BaseTransactionExecutor.java:37) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:39) ~[portal-impl.jar:?]
        at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor.execute(LayoutImportBackgroundTaskExecutor.java:85) ~[?:?]
        at com.liferay.portal.background.task.internal.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:63) ~[?:?]
        at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41) ~[portal-kernel.jar:?]
        at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72) ~[bundleFile:?]
        at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:136) [bundleFile:?]
        at com.liferay.portal.kernel.messaging.BaseMessageListener.doReceive(BaseMessageListener.java:48) [portal-kernel.jar:?]
        at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:34) [portal-kernel.jar:?]
        at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74) [portal-kernel.jar:?]
        at com.liferay.portal.messaging.internal.ParallelDestination$1.run(ParallelDestination.java:56) [bundleFile:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_312]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_312]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: java.lang.IllegalArgumentException: Portlet com_liferay_portal_search_web_portlet_SearchPortlet has owner ID of 0 and PLID of 0 because of wrong properties or wrong data handler settings
        at com.liferay.portlet.PortletPreferencesFactoryImpl.getPortletPreferencesIds(PortletPreferencesFactoryImpl.java:528) ~[portal-impl.jar:?]
        at com.liferay.exportimport.internal.controller.PortletImportControllerImpl.deletePortletData(PortletImportControllerImpl.java:157) ~[?:?]
        at com.liferay.exportimport.internal.controller.LayoutImportController.deletePortletData(LayoutImportController.java:353) ~[?:?]
        at com.liferay.exportimport.internal.controller.LayoutImportController.importDataDeletions(LayoutImportController.java:178) ~[?:?]
        at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayoutsDataDeletions(ExportImportLocalServiceImpl.java:262) ~[portal-impl.jar:?]
        ... 29 more
 

thumbnail
Yannis Sinadinos, modified 3 Years ago. Junior Member Posts: 39 Join Date: 3/20/17 Recent Posts

I tried to export permissions and import with permissions and there is a new issue coming up with constraint violation:

2022-02-28 13:29:04.668 ERROR [liferay/background_task-6][BackgroundTaskMessageListener:182] Unable to execute background task
com.liferay.portal.kernel.log.LogSanitizerException: com.liferay.exportimport.kernel.lar.PortletDataException: Could not execute JDBC batch update
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:408) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:381) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:367) ~[portal-kernel.jar:?]
        at com.liferay.layout.admin.web.internal.exportimport.data.handler.LayoutStagedModelDataHandler.importLayoutClassedModelUsages(LayoutStagedModelDataHandler.java:1642) ~[?:?]
        at com.liferay.layout.admin.web.internal.exportimport.data.handler.LayoutStagedModelDataHandler.doImportStagedModel(LayoutStagedModelDataHandler.java:1024) ~[?:?]
        at com.liferay.layout.admin.web.internal.exportimport.data.handler.LayoutStagedModelDataHandler.doImportStagedModel(LayoutStagedModelDataHandler.java:159) ~[?:?]
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:367) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:381) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:367) ~[portal-kernel.jar:?]
        at com.liferay.layout.admin.web.internal.exportimport.data.handler.LayoutStagedModelDataHandler.doImportStagedModel(LayoutStagedModelDataHandler.java:754) ~[?:?]
        at com.liferay.layout.admin.web.internal.exportimport.data.handler.LayoutStagedModelDataHandler.doImportStagedModel(LayoutStagedModelDataHandler.java:159) ~[?:?]
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:367) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:381) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:367) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.doImportReferenceStagedModel(StagedModelDataHandlerUtil.java:438) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importReferenceStagedModel(StagedModelDataHandlerUtil.java:296) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importReferenceStagedModel(StagedModelDataHandlerUtil.java:268) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importReferenceStagedModels(StagedModelDataHandlerUtil.java:355) ~[portal-kernel.jar:?]
        at com.liferay.journal.internal.exportimport.data.handler.JournalArticleStagedModelDataHandler.doImportStagedModel(JournalArticleStagedModelDataHandler.java:1008) ~[?:?]
        at com.liferay.journal.internal.exportimport.data.handler.JournalArticleStagedModelDataHandler.doImportStagedModel(JournalArticleStagedModelDataHandler.java:126) ~[?:?]
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:367) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:381) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:367) ~[portal-kernel.jar:?]
        at com.liferay.journal.internal.exportimport.data.handler.JournalPortletDataHandler.doImportData(JournalPortletDataHandler.java:438) ~[?:?]
        at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:392) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.internal.controller.PortletImportControllerImpl.importPortletData(PortletImportControllerImpl.java:422) ~[?:?]
        at com.liferay.exportimport.internal.controller.PortletImportControllerImpl.importPortletData(PortletImportControllerImpl.java:353) ~[?:?]
        at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.importSitePortlets(StagedGroupStagedModelDataHandler.java:599) ~[?:?]
        at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doImportStagedModel(StagedGroupStagedModelDataHandler.java:327) ~[?:?]
        at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doImportStagedModel(StagedGroupStagedModelDataHandler.java:78) ~[?:?]
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:367) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:381) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:367) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.internal.controller.LayoutImportController.doImportFile(LayoutImportController.java:592) ~[?:?]
        at com.liferay.exportimport.internal.controller.LayoutImportController.importFile(LayoutImportController.java:221) ~[?:?]
        at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayouts(ExportImportLocalServiceImpl.java:189) ~[portal-impl.jar:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_312]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_312]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_312]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
        at com.sun.proxy.$Proxy94.importLayouts(Unknown Source) ~[?:?]
        at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.importLayouts(ExportImportLocalServiceUtil.java:107) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor$LayoutImportCallable.call(LayoutImportBackgroundTaskExecutor.java:133) ~[?:?]
        at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor$LayoutImportCallable.call(LayoutImportBackgroundTaskExecutor.java:119) ~[?:?]
        at com.liferay.portal.spring.transaction.BaseTransactionExecutor.execute(BaseTransactionExecutor.java:37) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:39) ~[portal-impl.jar:?]
        at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28) ~[portal-kernel.jar:?]
        at com.liferay.exportimport.internal.background.task.LayoutImportBackgroundTaskExecutor.execute(LayoutImportBackgroundTaskExecutor.java:85) ~[?:?]
        at com.liferay.portal.background.task.internal.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:63) ~[?:?]
        at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41) ~[portal-kernel.jar:?]
        at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72) ~[bundleFile:?]
        at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:136) [bundleFile:?]
        at com.liferay.portal.kernel.messaging.BaseMessageListener.doReceive(BaseMessageListener.java:48) [portal-kernel.jar:?]
        at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:34) [portal-kernel.jar:?]
        at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74) [portal-kernel.jar:?]
        at com.liferay.portal.messaging.internal.ParallelDestination$1.run(ParallelDestination.java:56) [bundleFile:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_312]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_312]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: com.liferay.portal.kernel.log.LogSanitizerException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core.jar:3.6.10.Final]
        at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.hibernate.PortletTransactionManager.commit(PortletTransactionManager.java:63) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:41) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:60) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
        at com.sun.proxy.$Proxy1104.addLayoutClassedModelUsage(Unknown Source) ~[?:?]
        at com.liferay.layout.internal.exportimport.staged.model.repository.LayoutClassedModelUsageStagedModelRepository.addStagedModel(LayoutClassedModelUsageStagedModelRepository.java:54) ~[?:?]
        at com.liferay.layout.internal.exportimport.staged.model.repository.LayoutClassedModelUsageStagedModelRepository.addStagedModel(LayoutClassedModelUsageStagedModelRepository.java:33) ~[?:?]
        at com.liferay.layout.internal.exportimport.data.handler.LayoutClassedModelUsageStagedModelDataHandler.doImportStagedModel(LayoutClassedModelUsageStagedModelDataHandler.java:251) ~[?:?]
        at com.liferay.layout.internal.exportimport.data.handler.LayoutClassedModelUsageStagedModelDataHandler.doImportStagedModel(LayoutClassedModelUsageStagedModelDataHandler.java:51) ~[?:?]
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:367) ~[portal-kernel.jar:?]
        ... 64 more
Caused by: com.liferay.portal.kernel.log.LogSanitizerException: java.sql.BatchUpdateException: ORA-00001: unique constraint (LPORTALFO.IX_63EAFC82) violated_ [Sanitized]
        at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
        at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
        at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234) ~[ojdbc8-12.2.0.1.jar:12.2.0.1.0]
        at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125) ~[hikaricp.jar:?]
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core.jar:3.6.10.Final]
        at com.liferay.portal.spring.hibernate.PortletTransactionManager$TransactionStatusWrapper.reset(PortletTransactionManager.java:260) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.hibernate.PortletTransactionManager.commit(PortletTransactionManager.java:63) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.commit(DefaultTransactionExecutor.java:41) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:77) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:60) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
        at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
        at com.sun.proxy.$Proxy1104.addLayoutClassedModelUsage(Unknown Source) ~[?:?]
        at com.liferay.layout.internal.exportimport.staged.model.repository.LayoutClassedModelUsageStagedModelRepository.addStagedModel(LayoutClassedModelUsageStagedModelRepository.java:54) ~[?:?]
        at com.liferay.layout.internal.exportimport.staged.model.repository.LayoutClassedModelUsageStagedModelRepository.addStagedModel(LayoutClassedModelUsageStagedModelRepository.java:33) ~[?:?]
        at com.liferay.layout.internal.exportimport.data.handler.LayoutClassedModelUsageStagedModelDataHandler.doImportStagedModel(LayoutClassedModelUsageStagedModelDataHandler.java:251) ~[?:?]
        at com.liferay.layout.internal.exportimport.data.handler.LayoutClassedModelUsageStagedModelDataHandler.doImportStagedModel(LayoutClassedModelUsageStagedModelDataHandler.java:51) ~[?:?]
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:367) ~[portal-kernel.jar:?]
        ... 64 more
 

thumbnail
Yannis Sinadinos, modified 3 Years ago. Junior Member Posts: 39 Join Date: 3/20/17 Recent Posts

Just found that if I choose to change the author I get the error I posted at the beginning, otherwise I get the constraint violation

thumbnail
Zsigmond Rab, modified 3 Years ago. Liferay Master Posts: 764 Join Date: 1/5/10 Recent Posts

Hi Yannis,

I think the first error is about the bug I linked above. I don't know immediately for ssure if that has been eliminated in later versions. That should be investigated more.

As for the latter exception, unfortunately that's also something that should be investigated. I've seen similar issues in the past but they had different reasons for happening. These are mostly about some data inconsistence that we needed to find. A bug ticket could be created with the appropriate input data.

However, there are some questions that could be asnwered and may help to find a solution faster.

  1. Have you tested this without the data deletion before import option?
  2. Have you tried these on a vanilla Liferay? I mean, is it some database with historical data or you started testing the export after a site deletion and the import after the site recreation steps on a clean database?
  3. Have you tried to debug more to find what entity may cause any of the issues?

Regards,

Zsigmond

thumbnail
Yannis Sinadinos, modified 3 Years ago. Junior Member Posts: 39 Join Date: 3/20/17 Recent Posts

Hi Zsigmond,

I tried many scenarios but didn't work. The only thing that worked was to start a vanilla liferay and import. 

Thank you, 
Yannis

thumbnail
Zsigmond Rab, modified 3 Years ago. Liferay Master Posts: 764 Join Date: 1/5/10 Recent Posts

Ok, understood. Then it could be tried with the latest version to check if the problems still exist there. Beyond that, I can see only one way which means further debugging of the problem. Without that it's hard to say more.