Framework/GetTransactionData.xaml: BC30311: Value of type 'QueueItem' cannot be converted to 'DataRow'

Help Agent Builder
1

Hi everyone :waving_hand:

I’m currently working on a project using the REFramework template, and I’m trying to process data from an Excel file (not using Orchestrator Queue).

While running my workflow, I got the following error:

:round_pushpin: Error Message:
Framework/GetTransactionData.xaml: BC30311: Value of type ‘QueueItem’ cannot be converted to ‘DataRow’. The selected value is incompatible with the property type.

:round_pushpin: What I’m trying to do:

  • I read Excel data into a DataTable in InitAllSettings.xaml.
  • In GetTransactionData.xaml, I want each transaction to be one DataRow.
  • In ProcessTransaction.xaml, I’m using the current DataRow to fill form fields.

:round_pushpin: What I think is happening:
The default REFramework uses QueueItem as the transaction type, but I changed it to DataRow. I might have missed updating the data type somewhere.

:round_pushpin: What I’ve tried so far:

  • Changed the TransactionItem argument types.
  • Checked in_Main.xaml argument connections.
  • Still, the type mismatch appears.

Any help to fix this type conversion issue (QueueItem → DataRow) would be appreciated :folded_hands:

Screenshot (47)
Screenshot (47)1920×1080 240 KB

2

Hi,

In this case, I think GetTransactionItem activity is unnecessary.

Can you check “Practical Example 2: Using Tabular Data” in ReFramework document?
(It’s under documentation folder in Refremework)
It describes regarding sample for using DataTable.

image
image879×680 59.4 KB

Regards,

3

hi, @S_Yuvaraj you can Comment out or remive Get Transaction Activity if you are not working with queues.

4

@S_Yuvaraj

I will advise to learn the Reframe work customisation from this training.

5

Hi @S_Yuvaraj
Please find attached zip project which already uses Reframework with tabular data
You just need to pass your excel file path in get transaction.xaml
For your reference attached zip File
I hope this will work for you!

UiDemo_TabularData_WithoutQueue.zip (3.0 MB)

6

Hi @S_Yuvaraj

Please refer below post, it talks about all the changes you need to do for your use case. It also has a video tutorial on same.

Hope this helps.

7

@S_Yuvaraj

ideally when you change the transactionitem ..get transactionitem from queue must be removed as no queue is involved

cheers