Reports no longer exist in Management Reporter

(0) Share

Report

Posted on by Community Member

"The operation could not be completed because the item no longer exists."

I am receiving this error message on a number of my report definitions, row definitions and now even one of my report groups. Our AX implementation partner have been unable to assist and are waiting for Microsoft to come up with a fix in the future. Is anyone else having this problem and maybe has other information to share on a potential fix please? Or at least, is there anything I can do to prevent further items from ceasing to exist.

I am having to manually rebuild my critical items and now in the middle of year end, my most critical report group "no longer exists" as well as the original report definition.

I am using Dynamics AX 2012 and Management Reporter 2012.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Frank Hamelly | MVP... 46,617 Super User 2025 Season 2 on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter AX 2012

Shirley, I would not go through the effort of rebuilding those reports. I would push your technical staff to identify the most recent backup where all your report definitions existed and restore that backup (of the MR tables only).

Was this reply helpful? Yes No
DAX_ajsqd2 269 on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter AX 2012

Did you ever resolve this? We are having the same issue with our Management Reporter reports. I found it is due to old checkouts that are holding onto the reports but haven't been able to resolve.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter AX 2012

Hi DAX.

We recently completed an update to MR cumulative update 14 and the reports have returned but as you've said, they now come up as checked out by a user but we are unable to uncheck them. I have a ticket raised with our support partner and am awaiting their response. I will let you know if we have any success.

I take comfort that we can at least open the reports as read-only now which means that we can "Save As" under a new name if we do need to make changes.

Was this reply helpful? Yes No
DAX_ajsqd2 269 on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter AX 2012

We escalated this to Microsoft and they acknowledged this as a bug. They said it is fixed in CU15 but they provided two hotfixes and a SQL job to clean up the old checkouts. Will let you know when it is fully tested and provide the details.

Was this reply helpful? Yes No
Verified answer

DAX_ajsqd2 269 on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter

Hi Shirley,

Microsoft provided us with the following script to run against the MR database and it cleared out the invalid checkouts for the reports:

UPDATE [Reporting].[ControlReport]

SET CheckedOutTo = NULL, CheckedOutDate = NULL

WHERE not CheckedOutTo is null or not CheckedOutDate is null

Make sure to test in a test DB first and backup before making your change in your production instance.

They also provided hotfixes 3757498 and 3780433 that were deployed in Management Reporter CU15.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter

Thanks for sharing DAX. I am passing this over to our IT team.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter

Hi DAX,

Can you please send me the path to download these two hotfixes? KB3757498 & KB3780433 .

I searched on hotfix site but didn't found.

Thank you

Was this reply helpful? Yes No
DAX_ajsqd2 269 on at

Like (2)

Report

RE: Reports no longer exist in Management Reporter

Hi nglehang,

They were provided to us by Microsoft, I would recommend logging a ticket with them to get the hotfixes. Sometimes they retire or combine KBs and the original is no longer valid.

Was this reply helpful? Yes No
MC08 170 on at

Like (1)

Report

RE: Reports no longer exist in Management Reporter

I am facing same item no longer exists issue today. After using the script provided by DAX_ajsqd2, i can open related row definition without the error.

I think SSID changing will cause this error as i remember i have removed my user account from security admin group and re-add to the group again during open the report that i got this error.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Reports no longer exist in Management Reporter

Hi Dax,

I am also getting the same error. If you don't mind could you please send me these hotfixes. Thanks Arvinder

Was this reply helpful? Yes No