Error getting while Retrying the process

Hello everyone,
I have a excel sheet and it’s having multiple data in it i want to retry the process which i got error details. I’m able to retry the process but not able to exit the loop after retrying the process. Can anyone help me how to solve this.

Main.xaml (11.7 KB) new excel.xlsx (8.3 KB)

hi @ranaprathap928

if you are trying based on the condition, you must use break activity to exist the loop

Thanks

Hi @shaikmdrafi can i use break activity in then section.

Hi @shaikmdrafi if you can please edit my Xaml file and send me.

@ranaprathap928

If you want to retry for certain times the same activities you can use Do While activity and place all activities inside and specify the number how many times it required

Same you can do with RetryScope activity also

Hope this helps you

Thanks

Hi @ksrinu070184 I’m using this flow in middle of my project and I can’t use do while in this I think I will check with do while activity , if you can please edit my Xaml file and share it will be a great help.

@ranaprathap928

Do you have any fixed number of times to retry your workflow?

Thanks

Hi @ksrinu070184 max retry count 3 Times and I don’t know the exact count of excel sheet some times it will be 50 rows some times it is more also.

@ranaprathap928

See if you are concern about the rows to finish then For Each row will handle that, no need of retrying the entire process again

ForEachRow activity will loop into your excel sheet let’s say you have 50 rows then it will loop through 50 rows

Hope this helps you

Thanks

@ksrinu070184 I don’t have any issues with rows count , I want to end my process after satisfying the retry count , in my current process it’s not ending after retrying also , something I need to change but I don’t know how to do that

@ranaprathap928

Instead for RetryCount as a variable, Use Index of ForEach Row, Declare a variable for Index property and you will get the exact count, but the count starts with 0

For knowing the Index of ForEach check below
https://forum.uipath.com/t/rpa-datatable-get-previous-row-column-value-set-to-current-row-column-value/256199/3

Hope this helps you

Thanks

@ksrinu070184 I tried with index also it’s not working , but which shared Xaml it’s retrying but it’s not not able to exist the loop after retrying.

@ranaprathap928

That is because you self looping the same file

Can you tell me what is your automation use case

so that can try to solve

Thanks

@ksrinu070184 actually I’m getting some data in Excel and I’m creating user id with that data , if any data is missing or any error occurs means I created one separate cell in excel it will write there it is failed and retry count is 1 and I want to retry the failed date another 2 times

@ranaprathap928

Do you have orchestrator? Then it would be very easy to deal this

OR

You can use Re-Framework make changes to QueueItem-> Datarow

Thanks

@ksrinu070184 we don’t use orchestrator

@ranaprathap928

Use Re-Framework and in_TransactionItem->QueueItem change to DataRow

This will be helpful for you and best practice also

Try that way

Thanks

@ksrinu070184 we are not using orchestrator and reframework we are doing this in normal studio.

Check my Xaml once it’s retrying but the thing is after retrying it’s not able to come out of that loop.