FAQ 035: After a couple of hours Dream Report starts to generate reports without values. All values are N/A. However, all the data from the Dream Report logger data and alarm groups continue to be written properly into the MySQL DB. What does this mean?

By default, MySQL connection timeout is limited to 8 hours. After it, while trying to generate a report, you will get an error message in the Dream Report log file: “MySQL server has gone away”. That timeout can be increased in the following way:

open “my.ini” file that is normally located in “C:\Program Files\MySQL\MySQL Server 5.0” and add an additional parameter: wait_timeout=130000, which corresponds to the 48 hours connection timeout. The Dream Report Runtime manager will reinitialize connection with MySQL server every 24 hours.