Saturday, September 14, 2013

MS Dynamics CRM Report Error "Report Does not exist"

Today i came across and error that saying "Report Does not exist. The error came when i try to delete the report from the Dynamics CRM reports section.

We had moved the current CRM instance to a new domain, with new organization name. There comes the issue!! We imported the organization database CRMORG_MSCRM, but after the testing we came across this error for all the scheduled reports.

During the investigation we found that the Reporting server is almost empty with no scheduled reports available. but the OOB and SSRS reports are working fine. i tried to delete the report from CRM Reports section, but couldn't do so only Error came up!!

Now comes the resolution part,  The issue is because the Scheduled reports are stored in the ReportServer Database, which was not imported. So we need to somehow delete the reports and reschedule the reports, In the report server the Reports are stored in the Report-server->Organization Name->4.0 folder with the GUID of the report schedule as name in the Report server, we need to trick CRM by uploading a dummy report file (.rdl) and rename the Report to the GUID of the Scheduled report. The Report GUID can be found by clicking f11 button and copying the GUID from the URL. Use the Guid with "{GUID}" in the name of the uploaded RDL, now we can delete the Report form CRM Report section. Viola!!!! Reports are deleted!

I have tested the above scenario and it is working fine!! for further queries u drop a mail Contact me

No comments:

Post a Comment