Skip to Content
author's profile photo Former Member
Former Member

How to delete/archive entries from SOFFCONT1 table

Hello everyone,

Our SOFFCONT1 table is getting very big approx 53 GB. I have already checked SAP Note 966854 - Reorganization - New report.

The report RSBCS_REORG deleted only 10% of data.

Is there any other way to reduce the space being used by this table like archiving etc. ?

We are on ECC 6.0, Basis 700 SP15.

I appreciate your help.

Thanks

TSB

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Mar 24, 2010 at 11:49 AM

    Hi TSB,

    Some background to the issue that you are experiencing:-

    The records in table SOFFCONT1 (where attachment data is stored) will be deleted when you have deleted the reference to these attachments and run the port RSBCS_REORG. So to speak, the normal clean-up report, where all information in SAPoffice tables will be reorganized, will also delete the records from table SOFFCONT1.

    So, if the attachments in SOFFCONT1 still remains after execution of report RSBCS_REORG (please execute twice and run with DB change) there is only one explanation:

    A reference to this attachment still exists !!!

    So, before an attachment is deleted you have to delete the main document, where the attachment is connected to, from every recipients inbox, also, the document have to be deleted from the outbox folder of the sender and all trash folders. When using the report RSSODLIN the document is not placed into the trash, but if a user has deleted the document by hand, it has been placed into the trash by default.

    In addition, if the document has been send by a batch or system user maybe a reference has been placed in the dark folder and this reference prevents the attachment from being deleted.

    So this is the reason why report RSBCS_REORG only reduces table SOFFCONT1 by 10%.

    So the "real" solution to your problem would be to refer to SAP Note "904711 - SAPoffice: Where are documents physically stored?" -> "The document is stored using the knowledge provider".

    In TA OAC0, there is a Content Repository, SOFFDB, which is Database storage for SAPOffice documents. Since it is not recommended to change the customizing of shipped repositories, because documents stored in that repository before will be unaccessable after your change.

    Therefore you may consider to create a new category (TA OACT) along with a new Repository (TA OAC0). In TA SKPR08 you can register the new category to be used by class SOFFPHIO.

    Hope this helps

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Michael,

      Thank you for your detailed reply. I appreciate it.

      I created a new content repository ZSOFFDB_NEW (OAC0) with Contents Table SOFFCONT1 and also a new Category ZSOFFDB (OACT).

      Now I have two Content repositories which point to the same contents Table SOFFCONT1.

      How do I delete the contents of original repository SOFFDB ? Use Delete button in OAC0 ? Would it delete just the contents or whole repository ?

      Thanks again for your valuable reply.

      TSB

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2010 at 08:36 PM

    Michael,

    Very informative regarding SOFFCONT1, thanks. So, based on this if I had many "attachments" created via the "create attachment" feature directed to SOFFDB, I would need to "MOVE" those attachments via SAP's RSIRPIRL program, then

    run RSSO_DELETE_PRIVATE for the user inboxes and then RSSODFRE for the "dark" folder....then run RSBCS_REORG, correct? Our attachments were out of control, now we've stopped the bleeding, but we have to keep attachments linked

    to business documents, and get rid of everything else up to 90 days.

    Any other input would be appreciated!

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.