Content Report Table macro NPE's when page creator doesn't exist

XMLWordPrintable

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      If the Content Report Table macro cannot determine which user is the creator of a page, rendering will fail with the message

      Error rendering macro 'content-report-table' : null value”.
      

      Caused by not providing a non-null value for the creatorName map parameter in the pages marked with the target label in ContentReportTableMacro#createSearchResult.

      Workaround

      1. Identify the problematic label
      2. In the database run the following SQL query to identify where labels have been applied to pages without a creator:

      select c.contentid, c.creator, c.title from content c, content_label cl, label l 
      where c.contentid = cl.contentid 
      and cl.labelid = l.labelid 
      and l.name = 'insert label name here' 
      and creator is null;
      

      3. Identify which user you'd like to be the creator by searching for:

      select * from user_mapping where username = 'insert username here';
      

      4. Update the content table with the user_key of that user

      update content set creator = 'user_key from step 3' where content.id = contentid from step 2
      

      5. Flush all Confluence caches from https://instanceurl/admin/cachestatistics.action

            Assignee:
            Kenny MacLeod
            Reporter:
            Hugh Giddens (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: