<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Hello Palusek,
Queue will… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81840#M33371</link>
    <description>Hello Palusek,
Queue will hold only unique items in it as per given key while creating queue. For your scenario, either you may concatinate two column based on which it will return only one value/record and use that column as a key in queue or you can check the item existance in queue before adding and if it is already present then mark item as duplicate.
&amp;nbsp;
Thank you.
Regards,
Vijay Dodamani</description>
    <pubDate>Tue, 13 Nov 2018 11:43:00 GMT</pubDate>
    <dc:creator>VijayDodamani</dc:creator>
    <dc:date>2018-11-13T11:43:00Z</dc:date>
    <item>
      <title>Add Item to Queue doesnt work</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81839#M33370</link>
      <description>Dear all,

Did some of you encounter following issue?

I am trying&amp;nbsp;to add an item to queue and BP returns internal error:

Cannot insert duplicate key row in object 'dbo.bpaTag' with unique index "UNQ_BPATag_Tag". The duplicate key value is (12.11.2018 15:00:04). The statement has been terminated.

It happens randomly on random runtimes. The duplicate key value looks like the the datetime, when the item is written in Queue.

Could you please help?

Thank you</description>
      <pubDate>Mon, 12 Nov 2018 20:43:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81839#M33370</guid>
      <dc:creator>JurajPalusek</dc:creator>
      <dc:date>2018-11-12T20:43:00Z</dc:date>
    </item>
    <item>
      <title>Hello Palusek,
Queue will…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81840#M33371</link>
      <description>Hello Palusek,
Queue will hold only unique items in it as per given key while creating queue. For your scenario, either you may concatinate two column based on which it will return only one value/record and use that column as a key in queue or you can check the item existance in queue before adding and if it is already present then mark item as duplicate.
&amp;nbsp;
Thank you.
Regards,
Vijay Dodamani</description>
      <pubDate>Tue, 13 Nov 2018 11:43:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81840#M33371</guid>
      <dc:creator>VijayDodamani</dc:creator>
      <dc:date>2018-11-13T11:43:00Z</dc:date>
    </item>
    <item>
      <title>Dear Vijay,
Thank you for…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81841#M33372</link>
      <description>Dear Vijay,
Thank you for your answer. However I don't think the issue is the actual key of the item, which is added to queue.
For key I use completely different string, different column of the input collection. And I can have multiple items added to the queue with the same key without any problem.
The value, which is problematic for blueprism is the datetime value, which defines when the item was added to queue. And this is created automatically by Blueprism</description>
      <pubDate>Tue, 13 Nov 2018 14:20:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81841#M33372</guid>
      <dc:creator>JurajPalusek</dc:creator>
      <dc:date>2018-11-13T14:20:00Z</dc:date>
    </item>
    <item>
      <title>palusek - I'd suggest…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81842#M33373</link>
      <description>palusek - I'd suggest contacting Support</description>
      <pubDate>Wed, 14 Nov 2018 20:21:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81842#M33373</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2018-11-14T20:21:00Z</dc:date>
    </item>
    <item>
      <title>Hello Palusek,
I had the…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81843#M33374</link>
      <description>Hello Palusek,
I had the same issue, while inserting row in a queue.
If you are adding queue row by row then you must be created a named collection with datatype. So if, you are using some where datetime as datatype, please try with text format and then add the single row to collection.
Hope it will work! :)
&amp;nbsp;</description>
      <pubDate>Thu, 15 Nov 2018 14:54:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Add-Item-to-Queue-doesnt-work/m-p/81843#M33374</guid>
      <dc:creator>VijayDodamani</dc:creator>
      <dc:date>2018-11-15T14:54:00Z</dc:date>
    </item>
  </channel>
</rss>

