Publication fails for pages with page comments after upgrading from 6.1/6.2 to 7.0

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.1 CE GA2
• Fix Version/s: 7.0.0 DXP FP3, 7.0.0 DXP SP1, Master
• Component/s: Collaboration, Collaboration > Comments, Staging
• Labels:
  • KNOWNISSUES_DE70
  • LR7UPGRADE
  • QA-F
  • liferay-digital-enterprise-70-sp1
  • liferay-fixpack-de-3-7010
  • post-upgrade-fix
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Sprint: Hydroxylclinohumite, Ilmenorutile, Olivinoid
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/41666

Steps to reproduce

1. Start Liferay Portal 6.2 (or execute upgrade using attached MySQL dump file and data folder and skip to 5)
2. Add new site with staging enabled
3. Add page comment portlet to page
4. Add page comment
5. Shut down portal
6. Execute upgrade to 7.0
7. Start 7.0
8. Navigate to staging site > page with comments
9. Publish to live
10. Assert process fails
11. Click "See More Details"

Staging dump created from MySQL 5.5 is attached.

Expected result: Publication is successful.
Actual result: Publication fails. Portlet displays "An unexpected error occurred with the publication process. Please check your portal and publishing configuration. java.lang.UnsupportedOperationException"

Console errors are thrown:

22:28:58,273 ERROR [liferay/background_task-4][BackgroundTaskMessageListener:164] Unable to execute background task
com.liferay.exportimport.kernel.lar.PortletDataException: java.lang.UnsupportedOperationException
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importMissingReference(BaseStagedModelDataHandler.java:323)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.doImportMissingReference(BaseStagedModelDataHandler.java:485)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importMissingReference(BaseStagedModelDataHandler.java:297)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.doImportReferenceStagedModel(StagedModelDataHandlerUtil.java:394)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importReferenceStagedModel(StagedModelDataHandlerUtil.java:279)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importReferenceStagedModels(BaseStagedModelDataHandler.java:805)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:362)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:367)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:353)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.doImportReferenceStagedModel(StagedModelDataHandlerUtil.java:400)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importReferenceStagedModel(StagedModelDataHandlerUtil.java:279)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importReferenceStagedModel(StagedModelDataHandlerUtil.java:251)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importReferenceStagedModels(StagedModelDataHandlerUtil.java:341)
        at com.liferay.message.boards.comment.MBDiscussionStagingHandler.importReferenceDiscussions(MBDiscussionStagingHandler.java:173)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importComments(BaseStagedModelDataHandler.java:732)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:366)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:367)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:353)
        at com.liferay.exportimport.controller.LayoutImportController.importLayout(LayoutImportController.java:998)
        at com.liferay.exportimport.controller.LayoutImportController.doImportFile(LayoutImportController.java:693)
        at com.liferay.exportimport.controller.LayoutImportController.importFile(LayoutImportController.java:220)
        at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayouts(ExportImportLocalServiceImpl.java:185)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:85)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:173)
        at com.sun.proxy.$Proxy165.importLayouts(Unknown Source)
        at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.importLayouts(ExportImportLocalServiceUtil.java:202)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:267)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:240)
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl$CallableMethodInvocation.proceed(TransactionInvokerImpl.java:93)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:85)
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:39)
        at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor.execute(LayoutStagingBackgroundTaskExecutor.java:137)
        at com.liferay.portal.kernel.backgroundtask.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:54)
        at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:43)
        at com.liferay.portal.kernel.backgroundtask.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:56)
        at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:124)
        at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
        at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
        at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
        at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
        at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.UnsupportedOperationException
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.doImportMissingReference(BaseStagedModelDataHandler.java:493)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importMissingReference(BaseStagedModelDataHandler.java:316)
        ... 51 more

Reproduced on:
Tomcat 8.0.32 + MySQL 5.6
ee-6.2.10 > ee-7.0.x GIT ID: c6f5ae666b0dd3293079a59604371bf99ae87549

Tomcat 8.0.32 + Oracle 11gR2
ee-6.2.10 > master GIT ID: 63f46013f9a16e2f5aa8bc01b2974c6bc9a3c806