Skip to main content

Notifications

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) / Upgrade to 9.1 and Sys...
Microsoft Dynamics CRM (Archived)

Upgrade to 9.1 and SystemForm table expansion

(0) ShareShare
ReportReport
Posted on by blackfincloud 566

Last week, when version 9.1 rolled out into our instance of Microsoft Dynamics 365, the SystemForm table (SystemFormBase in the powerplatform app), gained about 900 MB to total just over 1GB. I opened a ticket and was told that this was due to the new relationships required for the Unified Interface. The problem is that this put us over storage for compliance - and none of the data is our user-based CRM-type data. I asked whether this table could be cleared and was told that it could be, but if it was, customizations to forms and views would no longer be possible. Does anyone know whether it would be possible to fractionally delete data from this table safely?  (We would need to use the API, but fine, whatever ...).  Just curious. I wasn't able to get an answer as to whether a partial delete of records from this table would have the same effect.  Also, did anyone else notice this?

*This post is locked for comments

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Upgrade to 9.1 and SystemForm table expansion

    No worries Owen. I do agree with you on "all of this [great] new functionality comes at a price" :)

    If the suggestion helped you then please mark it as answer and close the thread.

  • blackfincloud Profile Picture
    blackfincloud 566 on at
    RE: Upgrade to 9.1 and SystemForm table expansion

    Thanks, Ravi - I think we will use the API to look at the data in this table, but I suspect you are right.  We have cleared out all of the extraneous data we have access to, so we will just have to deal with the overage by purchasing more space.  I do believe, however, that all of this [great] new functionality comes at a price. A 1GB table to contain form and view customizations ... a little bit bloaty, I would say.    Thanks again for replying ..

  • Verified answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Upgrade to 9.1 and SystemForm table expansion

    Hi,

    I don't think you can delete data from this table as it stores the main component of your CRM customizations. Also, I would suggest to not think of deleting data from this table directly, instead you can review your customization and you can delete the unsued forms/ relationships but again that would not make any difference. If this has been grown after the latest version then this must contains some upgraded relationships/ forms etc which is required by system.

    If your storage is over, you can look for other areas of hugh storage like attachments, logs etc.

    Hope this helps.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans