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

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