Hi I have a Queue with 40 transaction items( using same example as lesson 5 in Orchestrator, copying data from excel, adding each row of excel to Queue). i am able to achieve this part successfully. however when i try 2nd part, which is picking each transaction item from the Queue and processing it. I just find only the first transaction item is proceessed and status of queue changing to Successfull. Remaining 39 items, remaining items remain unporcesses. pls advice where am i making mistake.(attaching the screenshots below)
Thanks.
workflow to process the transaction items from the queue
in Queue>> View Transactions -
i see only 1 item in Progress and rest 39 in New Status, its been many a times i tried this and everytime this is the status. i am wondering why all txn items are not getting processed/
Your flow ālooksā quite alright (can you share the xaml?) but the conditions etc need to be checked. Why donāt you put logs for every transaction item that is got and see what actually is happening.
Check with logs and if everything seems correct then share the xaml so that a fresh set of eyes can peruse through
Hi Raghavendra,
So i made changes to my excel sheetā¦
I removed the duplicate records from my Excel sheet and also reduced the no of rows / records to just four.
next when i processed this new Queue having only 4 transaction items, all four records failed, and the log said - Values are not numeric. I do not understand how because i am converting the TransactionItem value to integers using the following statement -
Assign >>
Income = cint(txn_item.SpecificContent(āIncomesā))
(variable - Income is Int32 type)
i even tried - Assign >>
Income = convert.ToInt16(txn_item.SpecificContent(āIncomesā))
But the results remained the sameā¦
below are the screen shots -
excel-data -
great work. let me see, first let us fix the following :
Why donāt you send in the argument to the queue through the type conversion ā.ToStringā for the Income value you are sending in. You can convert it back as soon as it is retrieved.
use a writeline or message box to see what value is coming in (I would have done it if I had access to your queue or platform)
Do this and get back with the results. Share xaml again
If i have understood you correctly, you are asking me to pass these input values āIncomeā and āPaymentsā from Excel to the Queue as arguments with the Type String.
I am already doing soā¦so the first process which is adding the items to the Queue as arguments(Type-string)
first i am opening excel, reading range into a datatable, looping on the datatable using for each row - then adding Queue Item
in my second process i am trying to get the transaction queue and then assigning them to variable which are of type INT32 and using the below statement to convert the income and payments to intergers.
Assign >>
Income = convert.ToInt32(txn_item.SpecificContent(āIncomesā))
i have tried message box to see the assigned values in variables, but then again in message box i use Income.ToString. so message comes out fine. Main.xaml (8.8 KB)
Okay great. Looks good, let me create a queue of my own and I will get back if there are any issues using your code. If there are none that means maybe you might have to reinstallā¦ Wait a bit I will dissect this issue
@Santa_Krish I guess you have āUnique referenceā option toggled on in your orchestrator and if you are trying to send in a duplicate (already existing) values for Queue as your queue item then you might encounter this error.
Beautiful!!! I have been scratching my head over this since daysā¦Thanks a zillionā¦it was a BIG help indeedā¦
Just one last doubt, you said you have attached Dispatcher and Performer in the projectā¦what does that even meanā¦i am not aware of Dispatcher /performerā¦and didnt come across these terms in the trainingā¦is it something i missed out, where can i read about it moreā¦you can answere it at your leisureā¦no rush.
