21
SubscriptionTrackingDeletedObject and ActivityPartyBase tables in D365 instances of Sandbox are having huge number of records and they occupy around 15 GB of our the total instance size.
Does anyone know why these tables are used and why they have huge data and how they can be deleted, without raising a ticket with Microsoft? Also, what will happen if we delete the records in these tables?
Thanks
*This post is locked for comments
If this is affecting your production instance, having high business impact - you can ask MS support to increase the ticket priority to High & get the resolution fast.
Thanks. This CRM DB Copy is a good suggestion to move forward, as usually a microsoft ticket will take ages to close. So will try that. Will update this thread once I get results.
From what I recall the DeletionService does not touch the ActivityParty. Normally the data should be deleted once the activity is deleted.
What you can do is ask MS Support for a CRM DB Copy and run some queries and see exactly how the ActivityParties are tied to the ActivityPointerBase afterwards you can build some bulk deletion jobs in CRM or via the SDK and clean up the data
Thanks Radu for the quick reply. Since our D365 is online, we won't be able to restart the service. So we will raise a ticket with Microsoft to delete them.
For ActivityParty, we have already deleted the parent records, but still the activityparty table is high. Is the same deletion service issue involved here as well?
Hi Michael,
The subscription tracking deleted object stores references towards objects in CRM that have been deleted, so that this can be used the CRM for Outlook Clients that were offline can synchronize their local databases with the main CRM Server One.
After the synchronization has happened then the deletion service should clean up this table. So I would check 2 potential issues:
- Deletion service times our due to the high number of records (see event logs if OnPremise or CRM Platform traces of the Async-Maintenance Service). For this scenario, some SQL Performance tuning can fix the issue
- You have a high number of registered Outlook Clients that didn't sync. In this case you'd need to check if those clients are still active or not. If they aren't active then probably it would make sense to clean up the table with assistance from MS Support, as I am unaware of any supported way to clean it up.
Here is a community post that talks about this table: community.dynamics.com/.../164958
The ActivityPartyBase stores information about the activity parties involved in a CRM Activity. For example To, Cc, Bcc recipients of emails, etc. Check the participationtypemask attribute from this link to get more details: docs.microsoft.com/.../activityparty
To clean up this table, you'd need to delete the parent CRM Activity.
Deleting data directly from SQL from these tables can have negative consequences leading to orphaned records or unsynchronized data so it's best to understand exactly what data you have there (business wise) and see if it is possible to clean up / archive the parent records.
Hope this helps,
Radu
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
