cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete 9 hundred thousand entries from SWW_WI2OBJ

Former Member
0 Kudos

Hi All,

When I execute transacation SXI_MONITOR, Process Overview shows a hit being made to the database table SWW_WI2OBJ. This table contains 9 hundred thousand entries all the related work flow items.

This causes a very slow performance while displaying messages in SXMB_MONI.

Please note that I have set all the retention periods, scheduled archiving and deleting jobs in SXMB_ADM.

Any suggestions/help would be really appreciated.

Thank you.

Regards,

Pritish

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Note 868207 - Too many entries in SWW_WI2OBJ

https://service.sap.com/sap/support/notes/868207

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks for your suggestion Moorthy.

As you know the XI messages are stored in a hierarchy. The messages are stored at multiple levels at different dependent tables. So deleting the records from table SWW_WI2OBJ will not be a feasible solution.

You are right, SWWL is used to delete workflow items. But even this transaction takes ample amount of time to delete a work flow item.

I am looking for a report that can delete all my messages in dependent tables. I tried with report SWWIDE_DEP which deletes inconsistent entries from dependent tables.

Any suggestions are welcome.

Thank you very much.

Regards,

Pritish

Former Member
0 Kudos

Thanks Barry.

We are already at Level 6.

I have gone through these notes as well 836092 & 872388.

Any suggestions?

Thanks,

Pritish

moorthy
Active Contributor
0 Kudos

Hi,

Did u try with SE16 with giving the table name as SWW_WI2OBJ

and try to delete.. I am not sure table maintenance exists for this.

Also you can try out with SWWL, but it is mainly for Workflow errors. Still you can try out.

Rgds,

Moorthy