The price link for minimum quantity '0' is not unique.'

Questions
1

What does this mean and how can one aviod it?
We get this exception using the DataService CreateBatch trying to update a pricelist.

private void BatchUpdatePriceLists(PriceList netPriceList, PriceList grossPriceList)
{
Stopwatch stopwatch = Stopwatch.StartNew();

        using (var db = _dataService.CreateBatch())
        {
            db.Update(netPriceList);
            db.Update(grossPriceList);

            db.Commit();
        }
        stopwatch.Stop();
        _logger.LogTrace($"Batch update execution time: {stopwatch.ElapsedMilliseconds}ms");

    }

Litium.Validations.ValidationException: Validation error for PriceList(SystemId: da26e398-4087-481f-89ad-d4a89ed99004, Id: 100060-net), Items: ‘The price link ‘9b75c81d-d0ce-4907-b32d-30c7933d70b0’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘0a90a008-6e31-4db1-83f1-5d1b17925057’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘13424874-2bdb-45ce-a99f-da973af4da6e’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘a251877a-210a-468a-8fde-db02f06281ae’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘e0a5bda5-fb19-4ac5-a763-ce1b7ecb3bbb’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘2f111d6a-b1ee-4924-b338-aa2d57e75b08’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘7d0c0613-0e1c-45d5-9b25-d9420f09ddb9’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘2c33d7da-37d7-4cc5-aa12-4b0e05b5f903’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘b861a7e1-613f-4e1d-b956-0fae596433fe’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘89b0982f-00d6-485c-be63-d8421113f075’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘49a1097b-bb12-4094-85d8-c3eb923e4503’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘f7491f10-f766-4a6f-9811-fd474f203fcd’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘e4ba7752-64f3-4b3d-9ab5-e64c47f0b07f’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘8affcb3c-9302-4da1-91ad-a50863499bb4’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘d1c0ea37-ddcd-45bc-a40f-62e3fa00945c’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘b1fbca90-d485-4f5a-b65c-053853219d92’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘d1621cb2-7dd5-4a30-bf68-1c84badcd716’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘30b2dd17-d2a5-4750-9c7a-26f76778f808’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘fffe061a-1237-41ae-839b-0f0aa08bbde6’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘2736cd40-566c-4b98-9e25-0f2123993e94’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘8c2ef122-5c14-459c-9f97-52c3759aff3e’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘935461bf-abc9-4607-975b-65b4ee41c459’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘d0350495-6bbc-4142-8cb7-46956fa96135’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘26a7432c-f10e-4107-a8a5-f5ca6b45c069’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘58a9b06f-548a-41de-8447-fe30717de931’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘2d89c809-0151-459a-8af2-acaa728d32dc’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘e2a0a933-2f69-4f53-8c09-92c9891f50bd’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘453e81de-bfd6-4413-9de2-1b798574a353’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘b88eb6bd-fe85-4a2f-b24f-168730ed572e’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘2f2c5672-b0b3-4fc6-a1c7-b8f48b473654’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘624b170f-6f66-4d9f-bfac-9936693a2321’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘e3f0495a-fab1-41ce-9b9a-953bc7f0c08d’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘9817dc2c-2e6c-4ae1-9012-67eddbcc3d41’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘9aebc077-feb2-479d-97e3-03bc24188035’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘add7dd9f-b26f-437a-a5e7-9b318525d22c’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘6774e0c2-13e1-426b-82df-a03950a1e43e’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘3bf3e186-7a4a-4753-8908-f9eee09e412f’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘4b3fa598-d92a-4076-a014-6db2c350077f’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘9a7b8ba7-0129-4149-9288-7cd246117674’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘9e5bfb4d-6dbb-4acc-a2f1-7b0e208e08ea’ for minimum quantity ‘0’ is not unique.’ - ‘The price link ‘b668d8f8-4977-4f4c-8328-33faf03e06eb’ for minimum quantity ‘0’ is not unique.’ - 'The price link

Litium version: 7.3

2

I think that you processing multiple integrations on the same time that may cause deadlocks in the database and errors as above when multiple threads trying to insert the same items.

The validation message says that your price list already have a price for the product with the minimum quantity 0 so you can’t insert that multiple times in the same price list.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.