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
4.1K members online now
4.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I have created few basic reports, but none of them are displaying any reports, they are all giving following errors:

 

System error 

Error Details

There`s a query error.

Error ID: 7d8ad845

 

 

No matter how simple report is, it will still not generate it. 

 

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I also have this problem, even trying to show a simple table, adding some columns is fine, but adding others causes it to go throw an error like:

Error Details

There`s a query error.

Error ID: 22041248

 

The columns it most appears to have issue with is Currency Fields (GBP) but again it seems intermittent 

 

Re: MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
If I remove the currency fields, would that fix it?

What is the solution?

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

In regards to my previous post, I have found that I get errors in columns that contain NULL's when they are aggregated.

Changing the dataset to have a default value of '0' solved my issues, hope that helps someone

 

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

That's what i found as well, however a fix still seems necessary, null values should definitely be possible!

 

MySQL basic reports are giving errors

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

I had the same problem. Removing spaces in column names did the trick for me.