cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting the [BPAWorkqueueitem] affect the any items in blueprism data

vipularora007
Level 2
Hi 
Can anyone guide any how to delete the BPAWorkqueueitem  from database.
If we delete the BPAWorkqueueitem table from database what data is impacting on blueprism 
  • It will affect the schedules or any schedules previously created  can be change .?
2 REPLIES 2

PvD_SE
Level 12
Hi Vipul,

Just wondering: Why would you want to remove it from the database, if you can easily remove it directly in Control Room?

Happy coding!
---------------
Paul
Sweden
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)

steven.boggs
Staff
Staff
We would strongly recommend against deleting any tables in a Blue Prism database.

Our recommendations for removing Work Queue Items can be found here: "How do I remove completed Work Queue items from the Work Queue?"

As suggested in the article, we have a database script called "trim-queues.sql" that can be provided on request from Support, which will trim data in the BPAWorkQueueItem table and truncate the BPAWorkQueueLog table. The BPAtag table is also trimmed, removing any tags no longer being used by work queue items.

More information on these scripts can be found here.