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 12 days ago
    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

    TOP CONTRIBUTOR
    Posted 11 days ago
    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