Solved How to start work queue from the point of it's failed.

Vikas

New Member
Greetings,

I have scenario like, I have to execute 10 Marcos on the worksheet. All 10 Macros name, I put into work queue to keep a track of it's status. Sequence of the Marcos are important and dependent of each other. Now, Say if my macro # 3 failed and my process terminated.

I would like to start my work queue execution again using control room from the point of it stop without adding new list of macros in the work queue. How can I achieve this? (Assuming Failed macros # 3 has been executed manually by fixing the issue.)

I was thinking to add and push one more process to control room, just to execute remaining macros and complete rest of the process.

let me know, is this a good approach or we there is a better way to achieve it?
 

VJR

Well-Known Member
Hi Vikas,

For this purpose the Status field of the Work Queue is used.
As you read through the queue and run each macro you can update the Status column depending on what's happening with the macro.

For eg; you have the list of macros along with their statuses-
Macro1.xlsm -> Macro1:Started, Macro1:Completed
Macro2.xlsm -> Macro2:Started, Macro2:Completed,...

The Status field of the Queue can be read through the Get Next Item and can then be checked via a Decision stage where you will be checking what the current status is.

If the Status says Macro2:Started and as you said the process failed and terminated then the status remains as Macro2:Started. So the next time the process runs if the Decision stage finds that there is no Complete for the Macro2 then start running from Macro2 again. If you plan to manually run the Macro2 again then your process should ideally run from Macro3. So in that case you need to update the Status in the Exception Handler accordingly something like Macro2:Failed. So that next time when the Decision stage finds Macro2:Failed it will understand that it was fixed manually and so now start from Macro3.
I am just making up your situation but you need to design your diagram accordingly.

This is well explained with a diagram starting from Page 9 of the Work Queues guide available on the Blue Prism portal.
 

Vikas

New Member
Hi Vikas,

For this purpose the Status field of the Work Queue is used.
As you read through the queue and run each macro you can update the Status column depending on what's happening with the macro.

For eg; you have the list of macros along with their statuses-
Macro1.xlsm -> Macro1:Started, Macro1:Completed
Macro2.xlsm -> Macro2:Started, Macro2:Completed,...

The Status field of the Queue can be read through the Get Next Item and can then be checked via a Decision stage where you will be checking what the current status is.

If the Status says Macro2:Started and as you said the process failed and terminated then the status remains as Macro2:Started. So the next time the process runs if the Decision stage finds that there is no Complete for the Macro2 then start running from Macro2 again. If you plan to manually run the Macro2 again then your process should ideally run from Macro3. So in that case you need to update the Status in the Exception Handler accordingly something like Macro2:Failed. So that next time when the Decision stage finds Macro2:Failed it will understand that it was fixed manually and so now start from Macro3.
I am just making up your situation but you need to design your diagram accordingly.

This is well explained with a diagram starting from Page 9 of the Work Queues guide available on the Blue Prism portal.
Thanks VJR for Direction. I am able to accomplished it..
 
  • Like
Reactions: VJR

curado.asif

New Member
Hi,

I have 1000 items in queue, at 302 item the bot got stopped due to system issues. If i restart the bot should work work from 303 item. How can i achieve this scenario?

Thanks,
Asif
 

Prabha

New Member
Use get pending item's from queue before taking get next item and the item which got exception make it as exception and before that use retry logic for exept and then connect to get next item to pick the pending item from the queue so that you can resolve the issue
 
Top