REST API - empty response

[priya110]

Hello Experts,

wondering if I could get some help with Integration issue that we have currently.

we have integration to create request item via service catalog API, recently we notice that some payloads dont get transformed into tickets , and emply repsonse object is sent back. However after a bit of analysis on the logs, the following error found in the logs

FAILED TRYING TO EXECUTE ON CONNECTION glide.20 (connpid=5178629): INSERT INTO sc_cart_item  e

so based on this the variable values sent form the payload is added to the cart items. however the request or request item is not created. repushing these paylods creates the ticket.  not sure what is happening there.

any ideas or further suggestion will be much helpful

Thanks

[Amit Gujarathi]

HI @priya110 ,
I trust you are doing great.

It seems that some payloads are not being transformed into tickets, and an empty response object is being returned. Upon analyzing the logs, you have identified the following error:

"FAILED TRYING TO EXECUTE ON CONNECTION glide.20 (connpid=5178629): INSERT INTO sc_cart_item e"

This error indicates that the variable values from the payload are being added to the cart items, but the request or request item is not being created. However, when you resubmit these payloads, the ticket is created successfully. It's unclear what might be causing this issue.

[priya110]

Thanks Amit,

multiple temporary cart items are created for the same user  , although tow step check out property is set to false. as per my understanding this temporary carts  will be deleted once the request is created. However i see many of these getting created. I tried to simulate this in our lower production environment couldn't replicate ths.

the payload is sent via azure integration.