RE: Unable to export in Liferay 7.2. Error: Store is not available

BRODY HIGGS JR, modified 5 Years ago. Junior Member Posts: 61 Join Date: 5/16/14 Recent Posts
I am unable to export anything (site pages, etc).  I receive the following error when attempting to export from Site Settings > Publishing > Export
Error:
An unexpected error occurred with the publication process.  Please check your portal and publishing configuration.  Store is not available.
thumbnail
Christoph Rabel, modified 5 Years ago. Liferay Legend Posts: 1555 Join Date: 9/24/09 Recent Posts
Can you check the logfile? There has to be some exception there that points to the root cause of the issue.
BRODY HIGGS JR, modified 5 Years ago. Junior Member Posts: 61 Join Date: 5/16/14 Recent Posts
Below is the stdout log when attempting to export.
Error: An unexpected error occurred with the publication process. Please check your portal and publishing configuration.
Store is not available


<code>
2020-02-24 15:18:11.410 ERROR [liferay/background_task-1][BackgroundTaskMessageListener:173] Unable to execute background task
java.lang.IllegalStateException: Store is not available
at com.liferay.portlet.documentlibrary.store.StoreFactory.getStore(StoreFactory.java:129)
at com.liferay.portlet.documentlibrary.store.DLStoreImpl.addFile(DLStoreImpl.java:89)
at com.liferay.document.library.kernel.store.DLStoreUtil.addFile(DLStoreUtil.java:114)
at com.liferay.portlet.documentlibrary.service.impl.DLFileEntryLocalServiceImpl.addFileEntry(DLFileEntryLocalServiceImpl.java:272)
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:498)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:64)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:62)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:60)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
at com.sun.proxy.$Proxy157.addFileEntry(Unknown Source)
at com.liferay.portal.repository.liferayrepository.LiferayLocalRepository.addFileEntry(LiferayLocalRepository.java:116)
at com.liferay.portal.repository.util.LocalRepositoryWrapper.addFileEntry(LocalRepositoryWrapper.java:50)
at com.liferay.portal.repository.liferayrepository.LiferayProcessorLocalRepositoryWrapper.addFileEntry(LiferayProcessorLocalRepositoryWrapper.java:51)
at com.liferay.portal.repository.util.LocalRepositoryWrapper.addFileEntry(LocalRepositoryWrapper.java:50)
at com.liferay.portal.repository.liferayrepository.LiferayWorkflowLocalRepositoryWrapper.addFileEntry(LiferayWorkflowLocalRepositoryWrapper.java:50)
at com.liferay.portal.repository.capabilities.CapabilityLocalRepository.addFileEntry(CapabilityLocalRepository.java:61)
at com.liferay.portal.portletfilerepository.PortletFileRepositoryImpl.addPortletFileEntry(PortletFileRepositoryImpl.java:162)
at com.liferay.portal.kernel.portletfilerepository.PortletFileRepositoryUtil.addPortletFileEntry(PortletFileRepositoryUtil.java:70)
at com.liferay.portal.background.task.service.impl.BackgroundTaskLocalServiceImpl.addBackgroundTaskAttachment(BackgroundTaskLocalServiceImpl.java:141)
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:498)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:64)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:62)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
at com.sun.proxy.$Proxy1257.addBackgroundTaskAttachment(Unknown Source)
at com.liferay.portal.background.task.internal.BackgroundTaskManagerImpl.addBackgroundTaskAttachment(BackgroundTaskManagerImpl.java:104)
at com.liferay.portal.kernel.backgroundtask.BackgroundTaskManagerUtil.addBackgroundTaskAttachment(BackgroundTaskManagerUtil.java:61)
at com.liferay.exportimport.internal.background.task.LayoutExportBackgroundTaskExecutor.execute(LayoutExportBackgroundTaskExecutor.java:87)
at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41)
at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72)
at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:132)
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:752)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:664)
at java.lang.Thread.run(Thread.java:748)
</code>
thumbnail
Christoph Rabel, modified 5 Years ago. Liferay Legend Posts: 1555 Join Date: 9/24/09 Recent Posts
It seems to be related to the document library. Do you have any special settings there? Did you set dl.store.impl by chance? Are there any exceptions at startup that might be related to that (e.g. modules that cannot be started)
Which version do you use exactly? CE, EE, patch level?
BRODY HIGGS JR, modified 5 Years ago. Junior Member Posts: 61 Join Date: 5/16/14 Recent Posts
Liferay CE Portal 7.2.0 CE GA1
dl.store.impl=com.liferay.portal.store.file.system.AdvancedFileSystemStore

This is the only startup error I see in log.

<code>
2020-02-21 17:16:53.025 ERROR [main][LPKGDeployerRegistrar:185] Unable to track installed app Liferay CE Collaboration - Liferay CE Upload - Impl with Marketplace
org.hibernate.exception.DataException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
Caused by: java.sql.BatchUpdateException: String or binary data would be truncated.
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1239)
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 254 more
</code>
thumbnail
Christoph Rabel, modified 5 Years ago. Liferay Legend Posts: 1555 Join Date: 9/24/09 Recent Posts
Ok, the startup error looks unrelated, but I might be wrong here.
Did you set the dl.store.impl? It seems, something is wrong with it. Did you per chance change something in System Settings -> File Storage? Did you change something else that might be related?
BRODY HIGGS JR, modified 5 Years ago. Junior Member Posts: 61 Join Date: 5/16/14 Recent Posts
I did not change system settings, but I did set the 'dl.store.impl' property in portal-ext.properties file.  This is a new install of Liferay not an upgrade.
thumbnail
Jorge Díaz, modified 5 Years ago. Liferay Master Posts: 753 Join Date: 1/9/14 Recent Posts
What value did you set to 'dl.store.impl' property in portal-ext.properties?
BRODY HIGGS JR, modified 5 Years ago. Junior Member Posts: 61 Join Date: 5/16/14 Recent Posts
I was able to export after commenting out dl.store.impl=com.liferay.portal.store.file.system.AdvancedFileSystemStore
It is now dl.store.impl=com.liferay.portal.store.file.system.FileSystemStore
thumbnail
Christoph Rabel, modified 5 Years ago. Liferay Legend Posts: 1555 Join Date: 9/24/09 Recent Posts
Did you migrate the old store after setting the AdvancedFileSystemStore?
You need to do that in Server Administration -> Data Migration.
Btw. If you have no real need for some reason, the standard store is just fine. If I remember correctly (please correct me if I am wrong here), the advanced store just places the files in more folders. This was done due to several old filesystem limitations (e.g. FAT32 only supported 65535 files per folder, some filesystems (ext2) had huge performance problems with large numbers of files, ...). If you use ext4 or NTFS, it shouldn't make a difference anymore and I would stay with the default.
BRODY HIGGS JR, modified 5 Years ago. Junior Member Posts: 61 Join Date: 5/16/14 Recent Posts
No, I did not migrate data after setting AdvancedFileSystemStore.
Also, I am having the same issue with a previous 6.2 > 7.2 upgrade (unable to export).  Below is the log file. I will execute the data migration using AdvancedFileSystemStore option to see if that will resolve this new error.

Error: An unexpected error occurred with publication process. Please check your portal and publishing configuration. An unexpected error in Documents and Media while preparing its manifest has stopped the process.

<code>
ERROR [ajp-nio-8109-exec-7][IncludeTag:128] Current URL /group/guest/~/control_panel/manage?p_p_id=com_liferay_exportimport_web_portlet_ExportPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_mode=view&_com_liferay_exportimport_web_portlet_ExportPortlet_mvcPath=%2Fexport%2Fnew_export%2Fexport_layouts.jsp&_com_liferay_exportimport_web_portlet_ExportPortlet_cmd=export&_com_liferay_exportimport_web_portlet_ExportPortlet_groupId=27431&_com_liferay_exportimport_web_portlet_ExportPortlet_liveGroupId=27431&_com_liferay_exportimport_web_portlet_ExportPortlet_privateLayout=false&_com_liferay_exportimport_web_portlet_ExportPortlet_displayStyle=descriptive&p_p_auth=E3A1Xg5x&zx=ct2h9n1k765b generates exception: com.liferay.exportimport.kernel.lar.PortletDataException
java.lang.NullPointerException
at com.liferay.document.library.internal.exportimport.staged.model.repository.FileEntryStagedModelRepository.lambda$getExportActionableDynamicQuery$0(FileEntryStagedModelRepository.java:150)
at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery.addCriteria(DefaultActionableDynamicQuery.java:215)
at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery.performCount(DefaultActionableDynamicQuery.java:115)
at com.liferay.portlet.documentlibrary.service.base.DLFileEntryLocalServiceBaseImpl$1.performCount(DLFileEntryLocalServiceBaseImpl.java:331)
at com.liferay.document.library.web.internal.lar.DLAdminPortletDataHandler.doPrepareManifestSummary(DLAdminPortletDataHandler.java:369)
at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.prepareManifestSummary(BasePortletDataHandler.java:471)
at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.prepareManifestSummary(BasePortletDataHandler.java:461)
at org.apache.jsp.portlet_005flist.page_jsp._jspService(page_jsp.java:445)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at com.liferay.portal.osgi.web.servlet.jsp.compiler.internal.JspServlet.service(JspServlet.java:319)
at com.liferay.portal.osgi.web.servlet.jsp.compiler.internal.JspServlet.service(JspServlet.java:330)
at org.eclipse.equinox.http.servlet.internal.registration.EndpointRegistration.service(EndpointRegistration.java:153)
at org.eclipse.equinox.http.servlet.internal.servlet.ResponseStateHandler.processRequest(ResponseStateHandler.java:62)
at org.eclipse.equinox.http.servlet.internal.context.DispatchTargets.doDispatch(DispatchTargets.java:120)
at org.eclipse.equinox.http.servlet.internal.servlet.RequestDispatcherAdaptor.include(RequestDispatcherAdaptor.java:48)
2020-02-25 14:22:25.461 ERROR [liferay/background_task-1][BackgroundTaskMessageListener:173] Unable to execute background task
com.liferay.exportimport.kernel.lar.PortletDataException
at com.liferay.exportimport.kernel.lar.BasePortletDataHandler._handleException(BasePortletDataHandler.java:865)
at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.prepareManifestSummary(BasePortletDataHandler.java:474)
at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.prepareManifestSummary(BasePortletDataHandler.java:461)
at com.liferay.exportimport.internal.controller.PortletExportControllerImpl.exportPortlet(PortletExportControllerImpl.java:387)
at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.exportPortlet(StagedGroupStagedModelDataHandler.java:375)
at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.exportSitePortlets(StagedGroupStagedModelDataHandler.java:437)
at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doExportStagedModel(StagedGroupStagedModelDataHandler.java:227)
at com.liferay.site.internal.exportimport.data.handler.StagedGroupStagedModelDataHandler.doExportStagedModel(StagedGroupStagedModelDataHandler.java:78)
at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.exportStagedModel(BaseStagedModelDataHandler.java:102)
at com.liferay.exportimport.data.handler.base.BaseStagedModelDataHandler.exportStagedModel(BaseStagedModelDataHandler.java:80)
at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.exportStagedModel(StagedModelDataHandlerUtil.java:183)
at com.liferay.exportimport.internal.controller.LayoutExportController.doExport(LayoutExportController.java:327)
at com.liferay.exportimport.internal.controller.LayoutExportController.export(LayoutExportController.java:119)
at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.exportLayoutsAsFile(ExportImportLocalServiceImpl.java:66)
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:498)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
at com.liferay.portal.spring.transaction.TransactionInterceptor.lambda$invoke$0(TransactionInterceptor.java:64)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:128)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:51)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:62)
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
at com.sun.proxy.$Proxy192.exportLayoutsAsFile(Unknown Source)
at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.exportLayoutsAsFile(ExportImportLocalServiceUtil.java:46)
at com.liferay.exportimport.internal.background.task.LayoutExportBackgroundTaskExecutor.execute(LayoutExportBackgroundTaskExecutor.java:84)
at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41)
at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72)
at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:132)
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:752)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:664)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
at com.liferay.document.library.internal.exportimport.staged.model.repository.FileEntryStagedModelRepository.lambda$getExportActionableDynamicQuery$0(FileEntryStagedModelRepository.java:150)
at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery.addCriteria(DefaultActionableDynamicQuery.java:215)
at com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery.performCount(DefaultActionableDynamicQuery.java:115)
at com.liferay.portlet.documentlibrary.service.base.DLFileEntryLocalServiceBaseImpl$1.performCount(DLFileEntryLocalServiceBaseImpl.java:331)
at com.liferay.document.library.web.internal.lar.DLAdminPortletDataHandler.doPrepareManifestSummary(DLAdminPortletDataHandler.java:369)
at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.prepareManifestSummary(BasePortletDataHandler.java:471)
... 35 more
</code>