topic Re: Deleting the [BPAWorkqueueitem] affect the any items in blueprism data in Product Forum

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

vipularora007 — Tue, 07 Feb 2023 11:16:35 GMT

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 .?

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

PvD_SE — Tue, 07 Feb 2023 13:34:31 GMT

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

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

steven.boggs — Tue, 07 Feb 2023 16:58:15 GMT

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.