Nightly Deletion Job has started failing - CRM 2015 RRS feed

  • Question

  • Hi,

    we have discovered the Deletion Job on our CRM 2015 instance has started failing. We get an error in relation to the SubscriptionTrackingDeletedObject table:

    Error: Deletion Service encountered an internal error for

    OrganizationId: (I have removed)

    OrgName: (I have removed)

    Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SubscriptionTrackingDeletedObject'.

    We are using a HA SQL cluster with CRM pointing at the Availability Group. The issue seems to have started after a SQL failover. The 'SubscriptionTrackingDeletedObject' table has about 3million records and counting at the minute.

    I saw another post about deleting the records manually but I'm concerned manually deleting the entries from the table will leave lots of things in other tables which should be deleted but aren't.

    Does anyone know how to get the job working again?



    • Edited by Neil Lavery Monday, September 26, 2016 11:11 AM
    Monday, September 26, 2016 11:04 AM