Purging Completed WorkFlows in MDM
Weu2019re running SAP MDM 5.5 SP 6.
We implemented the SAP Note Number: 1240587 about 1 ½ years ago. Here is the linku2026
It really seemed to help initially. We went from 3 hours to load the repository down to 1 hour. Yahoo!
Unfortunately, we are seeing it slow down again (2 ½ hours). After some research, we discovered that the Java Utility will ONLY delete the Workflows that are assigned to the ID that is running the Java Utility. Example: Admin ID will only delete the Workflows that were launched by the Admin ID, such as Syndication and Import Managers Workflows.
We have several hundred people that can initiate a workflow to request a part change or add a new part. So, running this job under their IDs is not an option.
1) Is there some way to create a Supper User ID that will delete all the Completed Workflows and not just the ones for the ID that is running the job? If so, how do you create this ID, since we currently donu2019t have an id like that?
2) Is there some way we can change this job to loop through individual IDs to delete the completed Workflows?
3) Or did someone get the Database Trigger to work that I read in a few discussions?
4) Any other suggestions?
Your help is greatly appreciated!!!