Task Report macro shows duplicate tasks that cannot be completed

Question

Reopening the question posted here:

https://community.atlassian.com/t5/Confluence-questions/Task-Report-macro-shows-duplicate-tasks-that-cannot-be-completed/qaq-p/1534866

I have a page with a Task Report macro showing all open tasks for a project.

Recently, some tasks listed are duplicates and have an incorrect page under the "Task appears on" column. I've tried deleting and creating a new macro on the page, but it still shows the duplicate tasks. I also get an error that the "task change couldn't be saved" when I try to mark it as completed from the macro. Since the page listed under "Task appears on" is incorrect, then there's no way to find the task otherwise. Is there a fix for this?

The suggested solutions in the answer marked as "solution" do not work, especially on a Atlasian Cloud instance with no access to the DB...

Please help us !

Tamimi · Answer

I meant the deleting the page where the actual tasks resides in and not the page where the macro is configured in (just incase there was confusion in what I suggested..) The way that I cam across this is by using the Confluence cloud REST API to query all the tasks in a space `https://wiki/rest/api/inlinetasks/search?spaceKey=&limit=500&assignee=` and I realized that the same tasks content has two occurrences with different IDs. I followed the steps of create new blank page, copy content, delete affected page, rename new page and that fixed my issue

Xavier Krantz · Answer

Hi @Tamimi

I have just try your suggestion and I have the same issue

Tamimi · Answer

@Xavier Krantz can you attempt to do the following steps and see if it resolves your issue

* Create a new, blank page.
* Copy the content of the affected page that is causing the duplicated tasks, and paste into the new page.
* Delete the affected page.
* Rename the new page, so it uses the name of the deleted one.