Reporting could not get rendered

 

SYMPTOM

  • The report gets the error message: "Error Executing Reader". 

    Screenshot_2021-02-23_at_12.13.32.png
  • In the NMEA error log, you get the error as:

    ERROR [HY000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.18]Query execution was interrupted, maximum statement execution time exceeded (System.Data.Odbc.OdbcException)

CAUSE

The SQL command times out. The default timeout is 120 seconds.
(Note: the March 2021 release will increase the default timeout to 600 seconds.)

 

SOLUTION

To increase the SQL command timeout manually, please edit the file c:\GpsGateServer\Franson NMEA Service\GpsGate.Service.exe.config

Add the following tag inside the <appSettings> tag.

<add key="CommandTimeout" value="600" />

This increases the SQL command timeout to 10 minutes (600 seconds).