Task Report Macro not working on some spaces
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
Task report macro not rendering tasks list, on some spaces although you have task list of incomplete tasks .
Diagnostic Steps
First check the problematic space by running below query, make sure that returning SPACESTATUS column value is NULL
select * from SPACES where SPACEKEY = 'test';
Cause
Task report macro renders task list embeded on the mentioned page/space id as resource on the macro paramters.
Since the space status is null so task report macro doesn't have resource to pull from task lists.
Resolution
Please test changes first on a test environment before applying to Production.
Always take a backup of your database, confluence home and install directories.
- Stop Confluence
Check the problematic space by running below query, make sure that returning SPACESTATUS column value is NULL
select * from SPACES where SPACEKEY = 'test';Take a note of the spaceid from the previous query and use it to update spacestatus to 'CURRENT' status
update spaces set spacestatus = 'CURRENT' where spaceid = '98306' ;- Start Confluence
- Validate that the task report macro is working properly now