AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

AWS Aurora: Data Studio randomly shows connection errors

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Issue: data studio randomly shows connection errors for some of widgets on the page.

It is not a consistent behavior, other widgets are failing upon page refresh. Sometimes all widgets are working, sometimes all are failing

The data source is a really small static table with like 7 columns. No data changing there.

 

random-errors.jpg

 

 

Aurora has the following IP ranges white-listed (via security group):

 

MYSQL/Aurora
TCP
3306
64.18.0.0/20
MYSQL/Aurora
TCP
3306
64.233.160.0/19
MYSQL/Aurora
TCP
3306
66.102.0.0/20
MYSQL/Aurora
TCP
3306
66.249.80.0/20
MYSQL/Aurora
TCP
3306
72.14.192.0/18
MYSQL/Aurora
TCP
3306
74.125.0.0/16
MYSQL/Aurora
TCP
3306
108.177.8.0/21
MYSQL/Aurora
TCP
3306
173.194.0.0/16
MYSQL/Aurora
TCP
3306
207.126.144.0/20
MYSQL/Aurora
TCP
3306
209.85.128.0/17
MYSQL/Aurora
TCP
3306
216.58.192.0/19
MYSQL/Aurora
TCP
3306
216.239.32.0/19

 

Does that mean that IP list above is not complete?

Looks to be inline with: https://support.google.com/datastudio/answer/7088031?hl=en&ref_topic=6370347

AWS Aurora: Data Studio randomly shows connection errors

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I can't even get mine to connect with the security group added. 

The server encountered an internal error and was unable to complete your request.

 

Error ID: 925997d4