SQL Connection stopped working - The provided certificate is not within its specified validity window.

Question

We have setup the data gateway and the LogicApp was working fine, connecting to onprem sql using the SQL connector to execute SP.

All of a sudden, it stopped working and I am seeing below errors at the SQL Connection.

"error": {
"code": 502,
"source": "logic-apis-eastus.azure-apim.net",
"clientRequestId": "2d8c8916-d229-407f-af6d-5a774f081f7a",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Unexpected Exception : Microsoft.IdentityModel.Clients.ActiveDirectory.AdalException: {\"error\":\"invalid_client\",\"error_description\":\"AADSTS1000502: The provided certificate is not within its specified validity window.

I chceked with the network team and confirmed that nothing has changed in the network config.

Any help appreciated.
Mayur

Answer 1

We still don't know the reason, but updating the data gateway to latest version helped resolve the issue.

thanks.