Assigned
Status Update
No update yet.
Comments
pa...@visma.com
Hi. We are also experiencing the same behavior since several days ago.
Our business model requires a higher traffic during this time of month, which is why we have seen the err - maybe the error appeared even before.
If the user re-tries ( using the same credentials ) the same action couple of minutes after , it is working.
Please advice.
Our business model requires a higher traffic during this time of month, which is why we have seen the err - maybe the error appeared even before.
If the user re-tries ( using the same credentials ) the same action couple of minutes after , it is working.
Please advice.
se...@google.com
Hello,
As the example shown in the video is testing the connection multiple times in a row, has it happened by testing the connection once (or until it succeeds), then running the code and queries needed and after a while trying to connect again? Is it still failing?
Regards.
pa...@visma.com
hi. it is happening randomly. the user uses the same credentials and same scenario each time.
We have also noticed that sometimes if we refresh the Google Sheet file, from where the INSERT is fired , using the JDBC connection , we are able to connect and insert the records.
Last year we have had a similar issue due to a rollout of some changes on JDBC class ( related to Issue # 28402227 )
Following the discussions with your developers , they did a rollback which fixed the error and we were able again to use the mechanism.
I guess now there is another rollout related to JDBC ?
Or what is the reason of this issue happening suddenly and randomly?
We have also noticed that sometimes if we refresh the Google Sheet file, from where the INSERT is fired , using the JDBC connection , we are able to connect and insert the records.
Last year we have had a similar issue due to a rollout of some changes on JDBC class ( related to Issue # 28402227 )
Following the discussions with your developers , they did a rollback which fixed the error and we were able again to use the mechanism.
I guess now there is another rollout related to JDBC ?
Or what is the reason of this issue happening suddenly and randomly?
pa...@cecytebc.edu.mx
I have the same problem, since in this last month my script is executed by many users.
It connects intermittently and when it doesn't, it stays 30 seconds connecting until the error is thrown.
I tell my users to try to run the code over and over again, until they finally connect.
It connects intermittently and when it doesn't, it stays 30 seconds connecting until the error is thrown.
I tell my users to try to run the code over and over again, until they finally connect.
se...@google.com
Hello,
Thank you for your comments, this has been forwarded internally.
Regards.
pa...@ame.g4s.com
Hi Team,
I have the same issue, getting this error "Failed to establish a database connection. Check connection string, username and password." around 30% of the time.
We are getting frequently below error.
Error : Failed to establish a database connection. Check connection string, username and password. at __GS_INTERNAL_top_function_call__.gs:1:8
Please fix this issue ASAP
I have the same issue, getting this error "Failed to establish a database connection. Check connection string, username and password." around 30% of the time.
We are getting frequently below error.
Error : Failed to establish a database connection. Check connection string, username and password. at __GS_INTERNAL_top_function_call__.gs:1:8
Please fix this issue ASAP
pa...@supermetrics.com
Hi team,
Our deployment is experiencing the same issues, spiking on August 1 -- by August 4 we realized that our allowlist in Cloud SQL lacked a few critical subnets. That was completely a problem on our end.
After fixing it, the connection error rate dropped to the ambient level of less than 45k/day. On August 12 we tracked only ~3k errors, but after that connection errors have been on the rise again, reaching 125k failed connections just yesterday (Aug 16).
I understand that the issue has already been reported internally. But I hope these additional time references will be helpful.
Thanks
Our deployment is experiencing the same issues, spiking on August 1 -- by August 4 we realized that our allowlist in Cloud SQL lacked a few critical subnets. That was completely a problem on our end.
After fixing it, the connection error rate dropped to the ambient level of less than 45k/day. On August 12 we tracked only ~3k errors, but after that connection errors have been on the rise again, reaching 125k failed connections just yesterday (Aug 16).
I understand that the issue has already been reported internally. But I hope these additional time references will be helpful.
Thanks
se...@google.com
Hello,
In order to move this investigation forward our product engineering team may need sensitive data, therefore Issue Tracker is not the best environment (public) to do so.
This is why I strongly encourage you to reach out to your admin to open a ticket to
If you have any additional questions, please feel free to reach out.
Kind regards.
pa...@eastwestseed.com
Is there any update on this ticket?
We are getting frequently below error and unable to use the application -
Error : Failed to establish a database connection. Check connection string, username and password.
We are getting frequently below error and unable to use the application -
Error : Failed to establish a database connection. Check connection string, username and password.
ca...@centralsanitary.com
Hi there, I'm another Enterprise level user with roughly 50 automated Apps Scripts that need to connect via the JCBC. I was not affected by this issue last yet, but now it's precisely as mentioned above. My scripts fail roughly 50 of the time and it seems to be a completely sporadic error. I'm going to go ahead and take the advice above to open a ticket with our Google Admin.
au...@cernogroup.com
I'm also getting this error increasingly. Many scripts running that normally run without issue but the error rate seems to be increasing by the day
el...@austinpetsalive.org
I'm also having this issue, and the error rate is increasing with time.
pa...@ame.g4s.com
Hi
Can any one help on this, incase found any solutions
Can any one help on this, incase found any solutions
er...@g2g-online.nl
We've also experienced an increasing amount of errors. On aug 26, I found that our IP whitelist was outdated so depending on the IP that was used on Google's side the connection might have been failing because of the firewall that was blocking the connection.
A few days ago I've updated the whitelist based on this document:https://www.gstatic.com/ipranges/goog.txt . This has reduced the number of errors drastically. However, it seems that every now and then we still have the same error. Maybe the list provided by Google is outdated and it's using different IP addresses than the ones listed?
A few days ago I've updated the whitelist based on this document:
ma...@article.com
Hi, I am experiencing a heap of sporadic connection errors. My users are based across the United States, meanwhile I am accessing the app from the UK and it seems that I can always connect without issue. It seems like people on the west coast are more likely to experience it than the east coast. Some people reporting the problem are operating from as far east as Texas.
The DB we are connecting to is an AWS RDS database. So far, no signs of trouble with the database itself.
I don't see what I can do to improve the experience (apart from migrating the app). Any insights?
The DB we are connecting to is an AWS RDS database. So far, no signs of trouble with the database itself.
I don't see what I can do to improve the experience (apart from migrating the app). Any insights?
wc...@gmail.com
We have had this issue as well and has increased recently as previously stated.
One behavior I noticed was when I caught the error in error handling and tried to reconnect in the same code execution it would fail 100% of the time. So my work around ended up writing code that if the execution was from a trigger to create a new trigger to run the code and that seems to work. If the execution was from a menu I would simply alert the user to re-try.
One behavior I noticed was when I caught the error in error handling and tried to reconnect in the same code execution it would fail 100% of the time. So my work around ended up writing code that if the execution was from a trigger to create a new trigger to run the code and that seems to work. If the execution was from a menu I would simply alert the user to re-try.
pa...@ame.g4s.com
Hi All,
Please use enabledTLSProtocols=TLSv1.2 instead of useSSL=false, Hope it will work.
Please use enabledTLSProtocols=TLSv1.2 instead of useSSL=false, Hope it will work.
[Deleted User] <[Deleted User]>
To the above response, thank you but this did not work for me. It's still about 50/50 with enabledTLSProtocols=TLSv1.2, so there's no noticeable change.
pa...@eastwestseed.com
Any update from Google? The issue has been reported a month ago. My organization is not able to use any of the Apps Scripts applications because of this error.
ch...@arnoldgroupweb.com
Any updates to this? Been over a month.
jr...@gmail.com
Comment has been deleted.
[Deleted User] <[Deleted User]>
1.5 Months later and still no real feedback or support. Followed the recommendation from the Google rep to contact their support line and was told that it's outside of the scope of standard Google Support, and was redirected to Google Developer Support instead.
I recommend that everybody file a support ticket here:https://support.google.com/a/contact/wsdev?fl=1
We need to continue escalating this issue and bring more attention to it.
I recommend that everybody file a support ticket here:
We need to continue escalating this issue and bring more attention to it.
de...@madwire.com Restricted
Restricted
Comment has been deleted.
[Deleted User] <[Deleted User]>
An update from my side.
After corresponding with a Google rep I went ahead and followed their advice (and the advice of others on this thread) and whitelisted the full IP address list found here:https://www.gstatic.com/ipranges/goog.txt .
This - in addition to the fact that I'm about 99.9% sure that the Apps Script team made some form of update within ~24 hours of responding to my ticket without actually announcing/admitting the fact that they did so - completely resolved my issues. I now have a 0% error rate on my scripts. I highly recommend that anybody else experiencing this issue starting by whitelisting the full IP address list.
I will say that this is strange considering it was not necessary at all the past ~2.5 years I've been using GAS, but it seems necessary now. Some updated documentation would be very helpful from Google's side, but it is what it is. I'm just very glad to have found this fixing and hoping/praying it's a permanent one.
After corresponding with a Google rep I went ahead and followed their advice (and the advice of others on this thread) and whitelisted the full IP address list found here:
This - in addition to the fact that I'm about 99.9% sure that the Apps Script team made some form of update within ~24 hours of responding to my ticket without actually announcing/admitting the fact that they did so - completely resolved my issues. I now have a 0% error rate on my scripts. I highly recommend that anybody else experiencing this issue starting by whitelisting the full IP address list.
I will say that this is strange considering it was not necessary at all the past ~2.5 years I've been using GAS, but it seems necessary now. Some updated documentation would be very helpful from Google's side, but it is what it is. I'm just very glad to have found this fixing and hoping/praying it's a permanent one.
dy...@hakesbrothers.com
Same issue, I have about 100 scripts that I've made for my company working perfect until a few weeks ago now I am getting countless trigger errors " Failed to establish a database connection. Check connection string, username and password."
Please escalate as this is starting to affect the production of my company.
Please escalate as this is starting to affect the production of my company.
wc...@gmail.com
dy...@hakesbrothers.com
My DB Admin did and still receiving the the error.
wc...@gmail.com
We white listed at the firewall.
wc...@gmail.com
And to be clear updating the white listed IP's did nor resolve 100% of the connection issues, but we went from an average of 150 per day to only 4 yesterday.
aw...@bingologistics.com
I have white listed all google calling IP s.. Still the problem persists, since 20th Oct, suddenly my script connecting to aws rdb is broken. Script log: Failed to establish a database connection. Check connection string, username and password., mysql server registered 'bad handshake';
mi...@gmail.com
Hey, we are facing the same issue, is there any solution? Sometimes it's working sometimes not
mi...@lodgingdynamics.com
We are running into this all over the place. Really irritating.
[Deleted User] <[Deleted User]>
Getting the same error over and over again
jr...@gmail.com
We've had an increase in outages around this issue for the last several months. Thanks to the suggestion of the updated whitelist, we've seen the problem fall off, maybe completely? Since the list is long and the MS Azure SQL Server interface is cumbersome, we added the IP ranges programmatically via MSSMS.
We processed the list at:https://www.gstatic.com/ipranges/goog.txt
through the helper tool:https://suip.biz/?act=cidr-to-range
to get a start-stop, range-based list
from the helpful SQL stored procedures described at:https://databasefaqs.com/azure-sql-database-configure-firewall/
we dumped into a spreadsheet to build a quick formula-based list of
// EXECUTE sp_set_firewall_rule @name = N'Google Whitelist 11 -www.gstatic.com ipranges goog.txt', @start_ip_address = '8.8.4.0', @end_ip_address = '8.8.4.255'
...
Hope that's helpful to someone and this really does resolve this annoying issue.
We processed the list at:
through the helper tool:
to get a start-stop, range-based list
from the helpful SQL stored procedures described at:
we dumped into a spreadsheet to build a quick formula-based list of
// EXECUTE sp_set_firewall_rule @name = N'Google Whitelist 11 -
...
Hope that's helpful to someone and this really does resolve this annoying issue.
yo...@3pxmedia.com
Same issue. Getting worse everyday.
Any chance to resolve???
Any chance to resolve???
pa...@cecytebc.edu.mx
After a long time, we had the opportunity in our school to update the IP list (
It would be a great improvement if you could send us an email informing us of the changes in the IP whitelist when it happens.
Thank you.
cu...@curtismartialarts.com
I was able to resolve this issue by opening my database to every IPv4 on the internet. (i.e., opening *.*.*.* to my host) I have not had any issues in the last 3 months after making this change, whereas before I was having this issue daily.
I understand this is a very insecure, bad idea, but this just confirms the issue is with google and their IP ranges. I have triple checked adding all of the IPv4 addresses in the link mentioned in the last comment, but I still had frequent connection problems. (Note: I did not add any IPv6 addresses because there is no option for that with my host.)
I contacted Google and explained my problem and, like another commenter above, they said it was out of their scope and advised me to contact my database host.
I am lucky that none of my data is very important/sensitive so I am not overly concerned with the insecurity, but I am more than a little irritated that Google has been ignoring this issue.
If your use-case allows the risk of the insecurity, I would open everything up like I did and see if it solves your issue. I am not holding out hope Google will rectify this issue.
Best of luck!
I understand this is a very insecure, bad idea, but this just confirms the issue is with google and their IP ranges. I have triple checked adding all of the IPv4 addresses in the link mentioned in the last comment, but I still had frequent connection problems. (Note: I did not add any IPv6 addresses because there is no option for that with my host.)
I contacted Google and explained my problem and, like another commenter above, they said it was out of their scope and advised me to contact my database host.
I am lucky that none of my data is very important/sensitive so I am not overly concerned with the insecurity, but I am more than a little irritated that Google has been ignoring this issue.
If your use-case allows the risk of the insecurity, I would open everything up like I did and see if it solves your issue. I am not holding out hope Google will rectify this issue.
Best of luck!
is...@google.com
ma...@gmail.com
i did exactly what cu...@curtismartialarts.com! added %.%.%.% in my remote mysql and it worked instantly..
fe...@gmail.com
The same issue is still present despite adding the %.%.%.% to remote MySQL. It does not resolve the sporadic failure problem.
jp...@google.com
ro...@gmail.com
I also have same issue. getting worse.
Sometimes it's working very well, sometimes not
I hope you fix it soon
Sometimes it's working very well, sometimes not
I hope you fix it soon
ge...@newyorkmoney.com.co
Porfavor equipo de google, ayudar, si bien abrir el msqlremote %.%.%.% resuelve la situacion, es un riesgo de seguridad.
si lo anterior lo soluciona, quiere decir que NO esta actualizada la lista de IPS, ahora, mi administrador de la base de datos debe estar en la capacidad de informar la lista de ips que son bloqueadas, alguno de ustedes sabe como hacerlo sin necesidad de pedirle al administrador de la base de datos, o cpanel, o servidor o como se llame? agradezco.
si lo anterior lo soluciona, quiere decir que NO esta actualizada la lista de IPS, ahora, mi administrador de la base de datos debe estar en la capacidad de informar la lista de ips que son bloqueadas, alguno de ustedes sabe como hacerlo sin necesidad de pedirle al administrador de la base de datos, o cpanel, o servidor o como se llame? agradezco.
ju...@cacsantabarbara.co
Tengo el mismo problema, deberían tener un sitio de ips asignadas solo para AppScript. el 85% Falla y no hay conexión.
di...@gmail.com
same error!
ja...@gmail.com
nada que arreglan este erro verdad o alguien ya pudo solucionarlo
za...@ionsolar.com
Same error message only popped up today
as...@mgconsultants.lk
Hello, is there a direct solution or workaround for this?
jo...@gmail.com
aun 2025 y no se puede solucionar este error.
te...@claphamparishchurch.com
Why is this still not fixed? It's been open for over 2 years!
go...@ironmountain.com
Just got this issue today. Why is this still happening?
Description
Basic code sample (with a few variables omitted) is as follows:
var dbUrl = 'jdbc:sqlserver://'+dbhostName+'databaseName='+db;
return Jdbc.getConnection(dbUrl,dbUser,dbUserPass);
This code will succeed 50% of the time and fail the remaining 50% of the time sporadically. I am running a test function that returns the JDBC connection and it's literally like flipping a coin: 50/50 chance that it will fail.
I have attempted the "useSSL=false" workaround - and many other work arounds - to no avail.
Just to provide some additional information that may be helpful, I am connecting to an Azure SQL Server instance via the following Apps Script JDBC getConnection(url, userName, password) method:
This has happened on and off over the past 2 years or so, but turning off the V8 runtime would typically help. That is no longer the case, and this issue now occurs in both the legacy and V8 runtimes. Also, this issue seemed to previously be isolated mostly to time-based trigger functions, but now this occurs across the board with any function, time-based or manual execution.
Lastly, this issue seems to have increased DRAMATICALLY over the past ~2 weeks or so. I noticed a huge spike towards the end of July 2022 and this has persisted as of today, 2022-8-8.
While Apps Script is an extraordinary tool for Google Workspace users and it has transformed my company's ability to spin up quick solutions, these types of long-running issues with JDBC and V8 runtime are simply unacceptable. I am seeking a permanent solution to this issue and will provide any additional information necessary if it will help achieve that goal.
Screen recording of the issue attached.