I'm new to SAP and have been tasked with trying to identify the cause of an issue in a non-production environment as a learning exercise
A couple of users complained that they had many thousands of workflow items in their inbox and they needed them all deleted just to clear their inboxes out
Trying to do this via SWWL timed out when trying to do this for all workflow items for any one of the users. I managed to delete them by running SWWL for different date ranges for each user separately, but this only found and deleted about a hundred in total per user
When checking via SWI5 I could see a few thousand items for one user but still could not find most of the items they were complaining about. SWI5 could only find 1/3 or less of the total
A colleague resolved the symptom by deleting the relevant records for the users using SE16 for table SWWUSERWI in another enviroment, however we still don't know what caused the issue.
Also I'm not sure if deleting the workflow items in this way will result in orphan records being left behind in other tables
So I've been trying to find the cause in an environment where they haven't been cleared out yet
Trying to track back the workflow items to find a cause, I found the following post by searching Q and A:
But when I try to search for the RECKEY in table SWFREVTLOG using the TOP_WI_ID I looked up from table SWWIHEAD, it returns nothing
Any ideas on what I should look at next or possible causes of the issue?
Let me know if anything is unclear or if I'm missing something obvious or going about this in the wrong way
Thanks for your help