SQL Error messages being returned

[Kjetil Ringstad]

Hi

At a few occasions SQL error messages are being returned in the response from the API with a statuscode 400:

{"message":"Transaction (Process ID 1579) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."}

Are you rerunning these transactions or should we resend them?

[Yıldırım]

Hello,

what is the operation sent ? Failed requests should be retried on the client side. 

[Kjetil Ringstad]

This is a shipment update, POST
/controller/api/v1/shipment/{shipmentNumber}/action/confirmShipment
Confirm shipment operation

When retrying we are informed the shipment has already been confirmed. But that's not the issue itself here.

Should SQL Deadlock messages really be returned through the API? We have no control over which operations you have completed or not on your side.

[Yıldırım]

Hello, 

Do you have ipp-request-id returned, so that the transaction can be inspected in detail ? 

[Kjetil Ringstad]

It looks like it wasn't logged on our side. But the timestamp is  2022-02-14T10:40:41 , companyid 2693113

[Yıldırım]

Thank you for the information. This will be investigated.