MySQL: Fatal error encountered during command execution.

[Anonymous]

Hello,

Can someone point me to the right direction on how I can troubleshoot this? I have a a data model that consists of a few queries. One query in particular won't execute and thus the entire refresh fails. This dashboard used to refresh just fine for at least 6 months. A few days ago it stopped refreshing in power bi services so I tried to refresh it in the app and I'm getting the fatal error. It's one query that executes in mysql client within 3 mins everytime I run it. My IT folks say the issue is on MS side. My understanding is that if I run the refresh on the app on my local machine = mysql client query. 

[v-gizhi-msft]

Hi,

Hope this helps:

https://stackoverflow.com/questions/2467603/fatal-error-encountered-during-command-execution-with-a-... 

And please try to check your formula such as Comparison functions and Operators' using:

https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html 

Best Regards,

Giotto Zhi

[Anonymous · Accepted solution]

It's been fixed. It was an issue on our server. Thank you.

[Anonymous]

Hi guy,

Can you tell me exactly the problems on your server you had met? Because I have met the problems the same with you but IT help desk always ask me to cut down the query/rows/columns selected from database! Hope to hear from you soon!
Thanks in advance!!!

[albertoderossi]

Hi Luck. Do you have any details about the problem in your server? We have the same problem

Thanks

Alberto

[Anonymous]

@albertoderossi Hey Alberto,

From my past experience, the issue may be on the server. Does the query run directly in sql client? Any performance issue there?

[Anonymous]

@Anonymous,

I too am facing the same error messgae for past two days. In my case, the query was refreshing fine for last 6 months. I modified the query to bring in some changes as requested & query failed miserably in Power BI Desktop. Now when I try to run same query in MySQL workbench, it gets queried in 2 mins. In Power BI service the report is refreshing fine, but when I attempt to refresh the query without making any changes, it fails again with same error. Please help confirm, what did you find at your server, which once fixed, resolved your issue. Appreciate your support here.