topic Re: MySQL: Fatal error encountered during command execution. in Desktop

MySQL: Fatal error encountered during command execution.

Anonymous — Thu, 13 Feb 2020 13:25:12 GMT

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.

Re: MySQL: Fatal error encountered during command execution.

v-gizhi-msft — Fri, 14 Feb 2020 03:07:06 GMT

Hi,

Hope this helps:

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

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

Re: MySQL: Fatal error encountered during command execution.

Anonymous — Fri, 28 Feb 2020 16:53:06 GMT

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

Re: MySQL: Fatal error encountered during command execution.

albertoderossi — Wed, 11 Mar 2020 03:15:12 GMT

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

Thanks

Alberto

Re: MySQL: Fatal error encountered during command execution.

Anonymous — Thu, 19 Mar 2020 17:36:05 GMT

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?

Re: MySQL: Fatal error encountered during command execution.

Anonymous — Fri, 26 Jun 2020 15:00:42 GMT

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.

Re: MySQL: Fatal error encountered during command execution.

Anonymous — Thu, 27 Jan 2022 02:51:35 GMT

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!!!