Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / ActivityPointerBase ha...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

ActivityPointerBase has dramatically decreased in size in the past 24-36 hours

(0) ShareShare
ReportReport
Posted on by FM-22040757-0 35

Hello everyone,

In the past 36 hours the size of this table in Dataverse has gone down from 95Gb to 75GB.

We do not have any Bulk Delete jobs or system jobs that are running.

We are now experiencing significant changes in numbers for our most used activity -->Emails

It also does not seem to be any release wave that Microsoft is pushing right now.

Could it be that there were some corrupt indexes on this table and MSFT figured out a way to fix it and is pushing it to all customers?

Anyone else experienced this or has any idea why this might have happened?

Only the database portion was affected - no changes in File or Log.

Thanks

  • Verified answer
    FM-22040757-0 Profile Picture
    FM-22040757-0 35 on at
    RE: ActivityPointerBase has dramatically decreased in size in the past 24-36 hours

    I have found this recent document that MSFT posted about this and it explains what is going on

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/email-activity-entities?branch=main#email-storage

    Thank you all for your help

  • FM-22040757-0 Profile Picture
    FM-22040757-0 35 on at
    RE: ActivityPointerBase has dramatically decreased in size in the past 24-36 hours

    Hi Alex,

    This was the first thing I have checked yesterday. I looked for any In Progress jobs and also I looked at counts and nothing indicated that there are or were Bulk Delete jobs doing this.

    Thanks for looking into your environments.

  • Flydancer Profile Picture
    Flydancer 1,332 on at
    RE: ActivityPointerBase has dramatically decreased in size in the past 24-36 hours

    Hi FXM32,

    have you double checked if there are no activated recurring bulk deletion jobs?

    I've checked 8 of my instances and there was no change in the last days, so I don't think it was some fixed issue by MS.

  • FM-22040757-0 Profile Picture
    FM-22040757-0 35 on at
    RE: ActivityPointerBase has dramatically decreased in size in the past 24-36 hours

    Hi,

    sorry that was a typo.. we are NOT experiencing significant changes in numbers for our most used activity -->Emails

    So it must be something else.

    By the way we lost another 17GB or data in the past 20 hours as well

    Could it be some indexing issue that is been fixed by MSFT?

    Thanks

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: ActivityPointerBase has dramatically decreased in size in the past 24-36 hours

    Hi FXM32,

    We are now experiencing significant changes in numbers for our most used activity -->Emails

    So the ActivityPointerBase size is dropping because of the mass deletion of email records?

    No one in the organisation manually deletes emails? Nor are there any jobs running?

    Have you enabled 'Audit' feature on the email entity? If you enabled, you can check who delete emails in audit summary view；

    Or I would suggest you create a support ticket for professional assistance following the below procedure.

    Get Help + Support - Dynamics | Microsoft Docs

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans