Workflow exploding SOFFCONT1 - what to do?

[Former Member]

Hi all -

We have just recently implemented workflow for purchase requisitions at our company. Along with workflow, we have implemented workflow email notifications via RSWUFWFML2. Correspondingly, our database table SOFFCONT1 has grown extremely large in a very short time.

We are trying to minimize the size of this database. Originally we thought we could do it by deleting all emails over 30 days old via RSSO_PRIVATE_DELETE and then removing them from the database via RSSORE00. The first step works just fine in deleting the emails from users' inboxes, outboxes, etc. However, the table isn't getting any smaller!

Does anyone know what we can do to get this table's size down?

Thanks very much!

Abby

[Former Member]

Try reports RSSODLWF or RSSODFRE. They deal with "dark folder" cleanup about items coming from WF-BATCH. That was what solved the issue for us.

hth,

Abby

[Former Member]

We're still struggling with both SOFFCONT1 and SOC3.

I'm trying to figure out what is populating these tables.

I sent myself an SAP office mail with an attachment and it populated both SOC3 and SOFFCONT1 - the number of recs created on SOFFCONT1 depends on the size of the attachment.

I noticed many SO* tables are populated.

SOOS (field SNDREQ) and SOOD (IF_DOC_BCS) contain a reference but I cannot figure out a link from these or any of the SO* tables to SOFFLOIO. SOFFLOIO has reference to SOFFPHIO which in turn has a link to SOFFCONT1.

Does anyone know how to navigate from the SO* tables to SOFFLOIO / SOFFPHIO / SOFFCONT1.

Also, I deleted the inbox mail, deleted it from the outbox and emptied the trash but it did NOT delete the records from SOC3 and SOFFCONT1. I have run a number of other reports from the numerous oss notes but to no avail.

Any ideas please?

I'll really apprecuiate any help.

Thanks.

Soyab

[former_member185167]

What version are you on?

[bpawanchand]

Hi Rick,

Nice Timing....

Regards

Pavan

[Former Member]

Hi,

I am also facing similar problem(deleting data from table SOFFCONT1). Have you got any solution for this?

If so, please let me know.

From SAP notes, I found that report RSSOAPUT is used for mass archiving of SAP office tables. But in the code of this report , I couldn't find table SOFFCONT1.

Please help in this.

Thanks and regards,

Lakshmi Reghuvaran

[Former Member]

hello ,

please try this SAP note ,

536414

regards

vagesan