SYMPTOM:
The following error message appears when running a report in Strategy 10.x:
Sample Code/Error
QueryEngine encountered error: Execute Query Failed. Error Type: Odbc Error. MySQL Server has gone away
CAUSE:
The most common reason for the "MySQL server has gone away" error is that the server timed out and closed the connection.
For a full list of reasons to why this error can occur, please see http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
ACTION:
Check the timeout settings on the database and set them accordingly.