Unanswered

Data Gateway SQL Connector Connectivity Issue

(0) Share

Report

Posted on by gsr51

I have a flow that at some point updates an on-premise database using the SQL Connector. The flow has been in production for 3 days now. Today I noticed that one of the runs had failed. Upon inspecting the run error, it says -

The gateway is either offline or could not be reached. Inner exception: Gateway on endpoint sb://wabi-south-central-us-relay22.servicebus.windows.net/... is unreachable. The Microsoft.ServiceBus.Channels.ClientFramingDuplexSessionChannel, cannot be used for communication because it is in the Faulted state.

This errored on the SQL connector at the moment it's supposed to update the on-premise SQL database through the on-premise Microsoft Data Gateway.

Is there a way I could check to see if the SQL connector succeeded or not? And if not, perhaps put a 1 or 2 minute delay and try it again? I'm looking for a way to solve it for when there is a failure.

Thanks

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

gsr51 76 on at

Like (0)

Report
Just wanted to add, the output response when the SQL connector update fails is below.

Could I use a Compose somehow to check for status 404 and insert a delay before trying it again?

{ "status": 404, "message": "The gateway is either offline or could not be reached.\r\n inner exception: Gateway on endpoint '<ii>sb://wabi-south-central-us-relay22.servicebus.windows.net/d0f40bee-8e70-4a18-9981-0c2d9ae131b5/</ii>' is unreachable.\r\n inner exception: The communication object, Microsoft.ServiceBus.Channels.ClientFramingDuplexSessionChannel, cannot be used for communication because it is in the Faulted state.\r\nclientRequestId: 16c3e290-7d31-4712-9258-d9160fed2fb3", "error": { "message": "The gateway is either offline or could not be reached.\r\n inner exception: Gateway on endpoint '<ii>sb://wabi-south-central-us-relay22.servicebus.windows.net/d0f40bee-8e70-4a18-9981-0c2d9ae131b5/</ii>' is unreachable.\r\n inner exception: The communication object, Microsoft.ServiceBus.Channels.ClientFramingDuplexSessionChannel, cannot be used for communication because it is in the Faulted state." }, "source": "sql-cus.azconn-cus.p.azurewebsites.net" }

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report
Hi @gsr51 ,

Try the below:

Upgrade the data gateway to the latest version
Try to restart the gateway service or reboot
Try to uninstall the gateway then restart

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No