Skip to main content

Notifications

Dynamics 365 Community / Forums / Commerce forum / Offline database needs...
Commerce forum
Answered

Offline database needs cleaning- too many records!

Posted on by 6
Hi experts,
 
I know this question is already present in the forum but I have followed all the suggestions given my Microsoft for this issue .
 
My top tables are :
 
 
I have tried the following : 
 
3. Even tried running few of the procedures present in the standard procedure(on local) , but with no change !
 
did anyone face a similar issue and try writing a clean-up batch job or any stored procedure for the same ?
 
  • Verified answer
    Shafeeque Mohammed Profile Picture
    Shafeeque Mohammed 6,116 Super User on at
    Offline database needs cleaning- too many records!
    Looks like you have performed all documents from the DB administration POV. I would look  at the following.
     
    1. Assortments - Make sure that you only assort items that are currently sold in the store. Items that are currently not in stock or never will be or out of season should be removed. Do you sell all the 231k products ? Unwanted products can be either excluded from assortment or marked as stopped in default order settings>Sales.
     
    2. Configure all housekeeping/ purge options available in FO. 
     
     
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Offline database needs cleaning- too many records!
    Hi,
    I have not encountered this issue before. If you are sure to follow the content of the document and configure it correctly, please wait to see if other developers have encountered this issue or have any suggestions for it.
    Best Regards,
    Hana

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,860 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,398 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans