Sync error from SQL database

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…

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

Same, from last week!

1 Like

@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.

1 Like

Please contact AppSheet Support for help with this.

1 Like

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.

2 Likes

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.

3 Likes

Down here in France with all apps using SQL.

(IP addresses have been checked)

@lizlynch

1 Like

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

1 Like