+1-888-365-2779
Try Now
More in this section

Forums / Sitefinity SDK / Sitefinity 6.3, delete approval tracking records

Sitefinity 6.3, delete approval tracking records

2 posts, 0 answered
  1. Jan
    Jan avatar
    39 posts
    Registered:
    22 Jan 2010
    04 Sep 2015
    Link to this post

    I have a sitefinity 6.3 db with eCom. The eCom is populated with products from a backend db. The problem showed when the import function got a hick-up and looped same products over and over again.
    What's happend is that the table sf_pprvl_trckng_rcrd_sf_pprvl_ now got over 80 millions rows and take up over 8 gb of data.
    The db consists of about 60k products, and since it's a master/live versions I guess it grows rater quickly. Another thing is that the product changes quite alot because of an internal item structure.
    What I now need to do is to disable the approval log for products (if possible) and clear the sf_pprvl_trckng_rcrd_sf_pprvl_ table. Also table sf_pprvl_trckng_rcrd_mp_sf_ppr seems to be involved. IS there any way to do this?

    Found that the reason is that product.ApprovalTrackingRecordMap.ApprovalRecordshave ALOT of versions.

    I also see that I can get the current by calling product.GetCurrentApprovalTrackingRecord

    Is it safe to just delete all records but the current?Just remove them and call save or do I need to do this another way?

  2. Sabrie Nedzhip
    Sabrie Nedzhip avatar
    534 posts
    Registered:
    30 Sep 2016
    08 Sep 2015
    Link to this post
    Hi Jan,

    This forum thread seems to be a duplicate of the following one: 

    http://www.sitefinity.com/developer-network/forums/bugs-issues-/approval-db-table-grows-out-of-control

    I have just posted a reply in the above thread. I would kindly ask you to keep the communication in one thread only in order the communication to be more straightforward and structured. 

    Regards,
    Sabrie Nedzhip
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
2 posts, 0 answered