web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SubscriptionTrackingDe...
Microsoft Dynamics CRM (Archived)

SubscriptionTrackingDeletedObject and ActivityPartyBase occupies more storage space in D365 Online. Why is it & how to delete them?

(0) ShareShare
ReportReport
Posted on by mickrich 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

I have the same question (0)
  • Verified answer
    Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at

    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

  • mickrich Profile Picture
    mickrich 21 on at

    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?

  • Radu Chiribelea Profile Picture
    Radu Chiribelea 6,667 on at

    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

  • mickrich Profile Picture
    mickrich 21 on at

    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.

  • Arun Vinoth Profile Picture
    Arun Vinoth 11,615 Moderator on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans