Hi guys,
We got customer reports about errors during checkout and found this on Log/eCom/CartV2/Errors:
2018-11-19 12:28:38.2645|ERROR|eCom/CartV2/Errors|Order <No order>: Unexpected exception GetContent() with the message: Cannot insert duplicate key row in object 'dbo.EcomOrderLines' with unique index 'DW_IX_OrderLines_OrderLineID'. The duplicate key value is (OL14115502).
The statement has been terminated.
2018-11-19 12:32:45.3943|ERROR|eCom/CartV2/Errors|Order <No order>: Unexpected exception GetContent() with the message: Cannot insert duplicate key row in object 'dbo.EcomOrderLines' with unique
index 'DW_IX_OrderLines_OrderLineID'. The duplicate key value is (OL14116732).
The statement has been terminated.
2018-11-19 12:34:27.8494|ERROR|eCom/CartV2/Errors|Order <No order>: Unexpected exception GetContent() with the message: Cannot insert duplicate key row in object 'dbo.EcomOrderLines' with unique index 'DW_IX_OrderLines_OrderLineID'. The duplicate key value is (OL14117462).
The statement has been terminated.
2018-11-19 15:51:09.1989|ERROR|eCom/CartV2/Errors|Order <No order>: Unexpected exception GetContent() with the message: Object reference not set to an instance of an object.
There are no records on EcomOrderLines for the three orderlines mentioned above.
This is pretty scary as we have a concurrency issue somehow. Could this be related to the load balancer that we're using? Or should DW be guaranteed to generate unique order line IDs and is the problem elsewhere?
Thanks!
