on 07-10-2007 4:45 PM
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
Note 868207 - Too many entries in SWW_WI2OBJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Barry.
We are already at Level 6.
I have gone through these notes as well 836092 & 872388.
Any suggestions?
Thanks,
Pritish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.