How to write remarks for system exception

Help Studio
, ,
1

Hello guys,

I want to add remarks for system exception and move to next transaction.

how could i get index of the excel to add comments in the remark column.

2

@Gokul_Murali

Are using it in reframework

If so

In the catch block of process state under exception block

Use assign activity or write cell activity

3

@Gokul_Murali

You can perform a loop up with unique column and get the row index from excel and write it

Or same can be done from datatable lookup as well

Cheers

4

Hi @Gokul_Murali,

Can you please elaborate your question, I mean you have number of excel file as a transaction item or you have list of items in a single excel file.

If you have one excel file and iterating through each line item as transaction items and you are looking for index of current line item, then you can use the following LINQ to get the index of current line item.

LINQ : dt.AsEnumerable.tolist().findindex(Function (row) row(“Transaction”).ToString.Equals(“7654”))

Replace the column name “Transaction” with desired column name and do the same with value “7654” too.

I hope it will work.

5

I want to add remarks for system exception.

I have added a lookup table to get the index of the blank column to add remarks.

image

ISSUE :-1

it is logging into the app but not processing the next transaction.

image

@Anil_G
@MFK
@Shiva_Nikhil

6

@Gokul_Murali

can you share where you are using this whether in reframework or any other?

7

image
image844Ă—546 29 KB

Iam using this in REFRAMEWORK

I made changes in Config file also

image
image1350Ă—134 5.59 KB

8

@Gokul_Murali

why use lookup datatable

just use assign activity inside the exception block

dt.rows(inTransactionNumber).item(“ColumnName”)=“Exception”

is this you are expecting or any other?

9

No the remarks is adding properly for system exception.

But after that exception RPA is closing the app and login again to the application and it got stopped not going to the next transaction.

10

@Gokul_Murali

can you share the condition which you given in the get transaction state

11

image
image898Ă—542 35.2 KB

I haven’t changed any condition in get transaction state.

I only changed the config file value from 0 to 10

image
image1343Ă—134 5.76 KB

12

Hi @Gokul_Murali

If you are using the RE Frameworks, In the Set Transaction status xaml open the System exception block in that there is a set transaction activity below of that you can use the Write cell workbook or write cell activity to write the remarks for the system exception in excel.

When go through the flow, If system exception occurred in the code it went to System exception block in Set Transaction status xaml, after updating to excel it will go for the next Transaction item in the queue.

Hope it helps!!

13

@mkankatala

There only i added the write cell, it is adding the Remark in status column, closing the application and loging again to the application but not processing the Next transaction data.

image
image761Ă—547 26.3 KB

image

14

Yes @Gokul_Murali

If you see the structure of the RE Frameworks, If the System exception occurs it will go from Process Transaction Status to the Initialization Status and execute the login process again and it went to process transaction state but it will take the next transaction Item for sure.

Hope you understand!!

15

@Gokul_Murali

Lookup should be on the unique column like id invoice number etc and not on blank

Cheers

16

Hello guys issue got solved i solved it in another way

thanks for the support

1 Like