Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

how to delete some reports in CRM Reporting Services

  • 1.  how to delete some reports in CRM Reporting Services

    TOP CONTRIBUTOR
    Posted May 14, 2019 03:22 AM
    Hello
    I have a requirement I have whereby I need to delete some reports under CRM Reporting Services Reports where I have deleted the reports in question at the SQL Server Reporting Services end (where I created scheduled subscriptions).

    When I try to delete such a report in CRM I get an error. Below is the log file for the error.
    Any help or guidance will be received with many thanks and appreciation.
    Thanks

    <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><s:Fault><faultcode>s:Client</faultcode><faultstring xml:lang="en-GB">Error occurred while deleting an item from the report server.</faultstring><detail><OrganizationServiceFault xmlns="http://schemas.microsoft.com/xrm/2011/Contracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><ActivityId>78f61d34-d707-45b5-9efc-312d2ec261ff</ActivityId><ErrorCode>-2147187945</ErrorCode><ErrorDetails xmlns:a="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/><Message>Error occurred while deleting an item from the report server.</Message><Timestamp>2019-05-14T07:20:05.8131518Z</Timestamp><ExceptionRetriable>false</ExceptionRetriable><ExceptionSource i:nil="true"/><InnerFault><ActivityId>78f61d34-d707-45b5-9efc-312d2ec261ff</ActivityId><ErrorCode>-2147187945</ErrorCode><ErrorDetails xmlns:a="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/><Message>Error occurred while deleting an item from the report server.</Message><Timestamp>2019-05-14T07:20:05.8131518Z</Timestamp><ExceptionRetriable>false</ExceptionRetriable><ExceptionSource i:nil="true"/><InnerFault><ActivityId>78f61d34-d707-45b5-9efc-312d2ec261ff</ActivityId><ErrorCode>-2147220970</ErrorCode><ErrorDetails xmlns:a="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/><Message>System.Web.Services.Protocols.SoapException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #806DD071</Message><Timestamp>2019-05-14T07:20:05.8131518Z</Timestamp><ExceptionRetriable>false</ExceptionRetriable><ExceptionSource i:nil="true"/><InnerFault i:nil="true"/><OriginalException i:nil="true"/><TraceText i:nil="true"/></InnerFault><OriginalException i:nil="true"/><TraceText i:nil="true"/></InnerFault><OriginalException i:nil="true"/><TraceText i:nil="true"/></OrganizationServiceFault></detail></s:Fault></s:Body></s:Envelope>

    ------------------------------
    Nigel Cole

    ------------------------------


  • 2.  RE: how to delete some reports in CRM Reporting Services

    MICROSOFT MVP
    Posted May 15, 2019 06:53 AM
    Hi Nigel!

    I'm not sure which version you're on and the solution might be different depending on the version, however, this is not an uncommon issue.  Have a look at this possible fix:

    https://crmtipoftheday.com/358/how-to-delete-deleted-report/

    It's a bit ugly but seems to work!

    Best regards,
    Andrew.

    ------------------------------
    Andrew Bibby
    Dynamics 365 Consultant & Project Advisor
    Evesham, United Kingdom
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role