Thankyou......but im getting another error.....ive a collection of 50 rows after passing the Get Next Item Stage the collection showing as row 1 of 1.What it means....i have to put them in the loop but showing as aboveHi @vinay
That means you're attempting to mark an item as complete/exception but you don't have the item locked anymore.
I suspect you marked your first item as complete but didn't go and get another item from the queue before trying to mark as complete again. You need to link back to Get Next Item.
Rob
I need work with one after other which means after completing first row in WQ it has to be marked as Mark Completed and should get the 2nd row in the WQ, Im attaching my Work Flow solve it if possibleGet Next Item gets an item from the queue one at a time.. If you need to access all 50 records at once, consider whether a queue is required. Or do you really need to access all 50, would 1 at a time be suitable?
It is best to always use work queues where possible.
Hi Vimal I have added a decision stage with same logic ... u can see that in the attachmentDear Vinay,
You are using work queue feature in your robot program and work queue feature work one by one item at a time .
Second after get next item action, you would need to check [Item ID]<>"" and use decision stage at this point . When all items are processed by blueprism so that [Item ID] & [Data] would be blank so on basis of that you can apply and error will not come . Suppose In any chance error would come then mark as Exception and reprocess those item .
Please let me know in case you would need more clarification so that I would share robot (VBO) also.
Regards
Vimal
Everything fine with the WQ but the problem is only 1st row of the My Collection data taking into the application it is not moving to 2nd row u can see there in the pic Data 1 of 1, But actually it contains 50rowsHi @vinay,
Few things about the diagram-
1. Connect the Create quote to wherever you require it. May be you took the screenshot just before connecting it .
2. Remove the Loop. WQs will not require a loop. The Get Next Item will start the loop.
3. As soon after Get Next Item, check if the item id exists as suggested by @Vimal25. When the Item Id is blank then this is the stop for the loop.
See the flow is as said but the Item in the Q is picking up the Next Item but the the thing is Items in the DATA Collection (In Pic) not picking up the 2nd item u can see in the data collection i have 50 rows but is taking only the 1st rowHi vinay,
The diagram doesn't appear to be the way it should be. Would you like to try the 3 steps given above and share what happens?
The flow should be similar to this -
Get Next Item -> If Item Id <> "" -> Create Quote -> Mark Completed -> Then back to Get Next Item
If there is some kind of Failure in Create Quote then you need to send it to Mark Exception
If Item Id is "" then you can End
When the get next item running the 2nd time it is taking the next item from ID's collection,but the problem is it isnot taking data from the DATA Collection only 1st row of my DATA collection is entering the details into the my web applicationHi vinay,
Can you show the input output properties of Add to Queue and Get Next Item? Check if you have tag filters set in the Get next item?
Also can you tell what happens when the Get next item is encountered the 2nd time?
Create Quote is an action which contains the my original process which is submitting the Details of customer in the web page. there is no error in that. But if i put hte loop in my object it loops through the collection but it doesn't moves to the Mark Completed Action in the Process until it completes the 50 rows in the collectionThere looks to be an error generated on the Create Quote. Have you taken a look at that?
I stopped the process externallyFor more understanding what was the error marked in red in the screenshot and what was done to resolve it?
Yes it is uniqueWhat is 'Key Name' you have given in the System tab? Is it unique in the Excel file?