Sync error from SQL database

[KON_TROLL]

All our apps have suddenly sync issues today. Among all users. 10 different apps. We use SQL (microsoft running on Google Cloud). We have no issues accessing MS SQL server on other software. The sync issu on appsheet is unstable, somtimes it works. But mostly sync error. Her is the error message. We are totally lost here....

[KON_TROLL]

@Adam_Stevens is this related to issues from last week? We have a customer storm of complains now....

[GNF]

Same, from last week!

[takuya_miyai]

@KON_TROLL 

Maybe all the AppSheet server IP addresses are not registered in the SQL Server Firewall.

https://support.google.com/appsheet/answer/10104492?hl=en

When you can use it normally, you are accessing from the registered AppSheet server IP.
When not available, that AppSheet server IP may be blocked by the Firewall.

[KON_TROLL]

Thanks @takuya_miyai . I did now. Approx 10 IPs were missing in my list. I somehow do not think this caused it, as the problem occured suddenly for all apps and users. Let's see.

[takuya_miyai · Accepted solution]

Hi @KON_TROLL 

The IP address of the AppSheet Server will be added from time to time.
(They are announced in advance with a grace period).

I am also using Cloud SQL and one day Sync started succeeding and failing.
It forgot to add the new IP.

[Steve]

Please contact AppSheet Support for help with this.

[Aurelien]

Down here in France with all apps using SQL.

(IP addresses have been checked)

@lizlynch 

[bills984]

This is happening to me too! Hyperlinks in Looker Studio aren't opening in new tabs, even with the setting enabled. It's really disrupting user flow in our dashboards. Hope for a quick fix!

[appsheetfelloff]

Gotta love issues constantly popping up and not being resolved. Definitely regretting not having migrated away over the last couple years.