02-01-23 10:13 AM
02-01-23 02:01 PM
03-01-23 01:25 AM
03-01-23 10:15 AM
12-04-23 02:16 PM
Hello,
I have the feeling I cannot confirm that the "Retired Resources" get removed once the Session Logs are cleared. Maybe I am doing something wrong but I have the feeling this is not doning is. I also checked the unofficial DB cleanup scripts but they do not contain anything on the retired Resources.
Did you find a solution to this?
17-04-23 08:19 AM
The resource IDs are present in more tables in the database than just the logs i.e. the aggregated statistics in BPMIUtilizationDaily.
And I don't think there is any built-in mechanism to clean the list of retired schedule (if you know about one please let me know!).
If you are willing to touch the database but don't want to loose the data in other tables the best way to go would be probably like this:
1) pick one of the retire resources (table BPAResource, AttributeID = 1) to be used as a placeholder, save its ID, rename it to something like 'OLD resources"
2) get list of other retired resources
3) either drop or update (using the placeholder) rows in other tables. This will get a bit tricky for the aggregated tables since you will want to update the other values as well.
4) drop the other retired resources.
17-04-23 09:46 AM
I would strongly recommend against running your own unsupported scripts on a production Blue Prism database. Deleting items from one table too early can cause key constraint errors in the Blue Prism product.
I recommend contacting Blue Prism support to ask for a supported cleardown script.