AppSheet API SSL Cert Expired?

[Stefan_QREW]

All AppSheet API Calls to one of our apps are failing with a 500 error

{ "type": "https://tools.ietf.org/html/rfc7231#section-6.6.1", "title": "An error occurred while processing your request.", "status": 500, "detail": "Error: Data table 'client' is not accessible due to: SSL Authentication Error.", "traceId": "00-23b5575fa5978c4880de15166e21d555-f737bd45d32d33db-00" }

Anybody else noticing this?  

[Koichi_Tsuji]

Sniffing this is another newly introduced Bug.....as far as the error message indicates (while im not seeing such on my apps luckily).

[Stefan_QREW]

Perhaps it's isolated to AppSheet customers in US Central Region at the moment? I know of another AppSheet team in Central that is experiencing the issue. 

[Adam_Stevens]

Hi Stefan,

Thank you for highlighting this.  It turned out to be a change in configuration that went out that we have now rolled back.  Additionally, we've added an alert to detect this proactively in the future.  Please follow up here if you are still seeing issues!

[Stefan_QREW]

Thanks @Adam_Stevens. I am no longer seeing the 500 error on my side and appreciate the quick fix 👍 

[Stefan_QREW]

@Adam_Stevens We are experiencing the issue again

{
    "type": "https://tools.ietf.org/html/rfc7231#section-6.6.1",
    "title": "An error occurred while processing your request.",
    "status": 500,
    "detail": "Error: Data table 'client' is not accessible due to: SSL Authentication Error.",
    "traceId": "00-36da6d7863ef9ffb9358d70d69a0c083-ab7944526a8f1555-00"
}

[WillowMobileSys]

Was this resolved?

[Alyssa_QREW]

@Adam_Stevens  This issue is occurring again. 

{"type":"https://tools.ietf.org/html/rfc7231#section-6.6.1","title":"An error occurred while processing your request.","status":500,"detail":"Error: Data table 'employee' is not accessible due to: SSL Authentication Error.","traceId":"00-71ccd07604b47c1fda2e855eb0ff92dc-87d13b7413557fd5-01"}

[Alyssa_QREW]

@Adam_Stevens  This issue is still occurring. Is there anything we can do to mitigate this issue?

(raw message: {"type":"https://tools.ietf.org/html/rfc7231#section-6.6.1","title":"An error occurred while processing your request.","status":500,"detail":"Error: Data table 'v_dev_timecard_keyless' is not accessible due to: SSL Authentication Error.","traceId":"00-03c1dfb4ccd9995da9ffe4cd949c27e3-b4923f5c227e2f95-01"})

[WillowMobileSys]

@Stefan_QREW  @Alyssa_QREW 

Is your app accessing the tables via a database?  If so, have you confirmed that the certificate at your database provider is still active?

Whenever I have encountered "SSL Authentication Error", in things other than AppSheet, it has always resulted in an expired certificate on my host server.

[Alyssa_QREW]

@WillowMobileSys 

The app is accessing the tables via database, but the certificate is still active. 

[WillowMobileSys]

The only other thing I can offer is that I believe I saw an updated list of IP servers published by AppSheet.  Could the database host be missing whitelisted AppSheet servers?

Bottpom-line is that it seems you are receiving a 500 error from the database server.  Something is not right, or at least the database servers thinks its not right. on that end.

[Alyssa_QREW]

Thank you for the input. Unfortunately, I already checked all the IP addresses, reconnected the database and tried again but no luck.