Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. An error occurs when deleting a report from the Microsoft Dynamics CRM 2011 application

An error occurs when deleting a report from the Microsoft Dynamics CRM 2011 application

View products that this article applies to.

Symptoms

Reports deleted from the SQL Report Server directly may still appear in the Microsoft Dynamics CRM user interface. While trying to delete it, as user might get the following error:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #49B448CDDetail: 
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ErrorCode>-2147220970</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #49B448CD</Message>
  <Timestamp>2013-05-23T14:19:49.2545823Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147187945</ErrorCode>
    <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
    <Message>Error occurred while deleting an item from the report server.</Message>
    <Timestamp>2013-05-23T14:19:49.2545823Z</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText i:nil="true" />
</OrganizationServiceFault>

↑ Back to the top

Cause

When a report is deleted from Microsoft Dynamics CRM, it will check for its reference in Report Manager. If it cannot find a reference in Report Manager, the deletion fails with the below error.

"Error occurred while deleting an item from the report server"

↑ Back to the top

Resolution

To resolve this problem, follow these steps:

1. On the CRM server, navigate to the CRM installation directory. Default path is C:\Program Files\ Microsoft Dynamics CRM\LangPacks\1033\Reports\MSCRM

2. Open Internet Explorer and navigate to http://srsservername/reports

3. Open the Organization_MSCRM folder and select Details View on the right-hand side of the toolbar

4. Open the Custom Reports folder

5. On the SQL Server, open SQL Server Management Studio and connect to the Server where the CRM databases reside

6. On the toolbar, select new query and change the dropdown to the proper CRM database

7. Execute the query below:

select reportid, name from reportbase where name = 'reportname'

Replace reportname with the name of the report you are trying to delete.

8. Copy the reportid and go back to the Internet Explorer window

9. Select Upload File and browse to the path in Step 1 and select the User Summary.rdl file. Hit Ok.

10. Replace the name with the copied reportid from Step 7 and hit Ok

11. From within Microsoft Dynamics CRM, navigate to Workplace, click Reports, and select the report you wish to delete. Mark the checkbox and click Delete on the toolbar.

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2856604
Revision : 1
Created on : 1/7/2017
Published on : 6/14/2013
Exists online : False
Views : 117