Confluence WebDAV: issue listing Confluence directory
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
After upgrading Confluence, WebDav client shows empty directory. Could not list Confluence directories, pages, and subpages
The following appears in the atlassian-confluence.log:
2016-08-12 08:07:15,854 ERROR [http-nio-9443-exec-21] [ContainerBase.[Standalone].[localhost].[/]] log Unhandled exception occurred whilst decorating page
java.lang.NullPointerException
at com.atlassian.confluence.extra.webdav.resource.PageResourceImpl.getCreationtTime(PageResourceImpl.java:109)
at com.atlassian.confluence.extra.webdav.resource.AbstractConfluenceResource.initProperties(AbstractConfluenceResource.java:218)
at com.atlassian.confluence.extra.webdav.resource.AbstractConfluenceResource.getProperties(AbstractConfluenceResource.java:183)
at org.apache.jackrabbit.webdav.MultiStatusResponse.<init>(MultiStatusResponse.java:180)
at org.apache.jackrabbit.webdav.MultiStatus.addResourceProperties(MultiStatus.java:62)
at org.apache.jackrabbit.webdav.MultiStatus.addResourceProperties(MultiStatus.java:66)
at org.apache.jackrabbit.webdav.server.AbstractWebdavServlet.doPropFind(AbstractWebdavServlet.java:434)
at org.apache.jackrabbit.webdav.server.AbstractWebdavServlet.execute(AbstractWebdavServlet.java:231)
at com.atlassian.confluence.extra.webdav.servlet.ConfluenceWebdavServlet.service(ConfluenceWebdavServlet.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:37)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:45)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
....Diagnosis
Environment
- Confluence 5.10.3
- WebDav: Windows Web Folder, Konqueror
Cause
- CREATIONDATE in the CONTENT table has NULL value.
Resolution
Select all pages with NULL CREATIONDATE
select * from CONTENT where CREATIONDATE is nullAfter listing, you can update the value by executing the below query. Note, you can specify the date and time whatever value you may want to enter in the page column field CREATIONDATE:
update CONTENT set CREATIONDATE ='2014-02-04 14:17:21.883' where CREATIONDATE is null
Please ensure to create a database backup prior to executing the above query for backup purposes.- After updating the value from the database, please flush your Confluence cache. To do this, you may navigate to Cog icon >> General configuration >> Cache Management and choose Flush All