While try to add unique values caught exception “Message: Error creating Transaction. Duplicate Reference. Error code: 1016”. since enabled the unique reference in orch while creating queues. Once we get the exception. It just stop to add the further unique items. How to check the value is unique and need to adding the values further on queue. Is there any condition avail to check the values reference.
Excel values which tried to add in queue
Id Types
111 Gift Cards
222 Pet Supplies
111 Buy Again
567 Gift Cards
1- disable unique feature and handle it in your excel tracker separately.
2 - Use Get Queue Item activity that will give you a collection of queue items so before adding any new item to queue just check in the collection first, if it’s present escape it.
tried the bulk insert with commit type. but caught exception as “,Error creating Transaction. Reference is required for Unique Reference Queues.”
so added Reference by update row item on data table and achieved the partial solution.
since created the unique column(Reference) it just consider it as new values so unable to compare with old one and duplicate values created on queue.
Please correct me if i am wrong on usecase.
As per @ermanoj3101,
case1: disabled an unique reference and handled by excel activity.
case2: On get queue item activity. while get the queue items on queue it make the status new to inprogress. hence unable to perform queue items on future robot use.
Yes get queue item wont change status, but to get specific value(“Id”) in the queue used get transaction item so it makes queue inprogress.
Not sure on how to check\ compare the queueitem values and excel column value(read range).
Case 1: using addqueueitem activity, added the unique values to the queue.
At the duplication value, the activity will throw error as duplicate and stop the execution, hence used the continue on catch block. it just eliminate the duplicate(comparing queue and excel) and continue by adding the unique values in to the queue.
Case 2: On bulkadditem activity thrown error if reference is not added and property window we dont have option, hence made the Id column as reference. and commit type is ProcessAllIndependently.
