My Products
Help
Kjetil Ringstad
PARTNER

SQL Error messages being returned

by Kjetil Ringstad (Updated ‎14-02-2022 10:47 by Kjetil Ringstad PARTNER )

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?

 

 

5 REPLIES 5

by Yıldırım

Hello,

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

Kjetil Ringstad
PARTNER

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.

Hello, 

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

Kjetil Ringstad
PARTNER

by Kjetil Ringstad (Updated ‎14-02-2022 11:18 by Kjetil Ringstad PARTNER )

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

Thank you for the information. This will be investigated.