Confluence WebDAV: issue listing Confluence directory
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Summary
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:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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.
Solution
Resolution
Select all pages with NULL CREATIONDATE
1select * 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:
1update 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
Was this helpful?