Hi all,
Does anyone have experience with deleting old comments from the BPC Comments table?
We have reached 3.8 million records in our comments table, and need to delete all the old comments (for a given characteristic combination), and only keep the latest comments.
I'm aware that there is a standard class available (CL_UJC_CMTMANAGER) which allows us to archive and delete comments, but was hoping to hear from someone who has actually written a program to effectively "compress" the comments table, to see if there are any tips or tricks or anything to watch out for.
You may ask why we have so many comments in our table in the first place... well let's just say that I've found a bug in the standard Copy Comments package that causes duplicates in the comments table when we copy data and comments from one version of forecast to another. And our business users have been using this standard copy comments for many years now, and the result is that comments have grown exponentially.
Thanks in advance,
Carlton.