Task Report Macro not working on some spaces
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
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
1
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
1select * from SPACES where SPACEKEY = 'test';Take a note of the spaceid from the previous query and use it to update spacestatus to 'CURRENT' status
1update spaces set spacestatus = 'CURRENT' where spaceid = '98306' ;Start Confluence
Validate that the task report macro is working properly now
Was this helpful?