This known issue is a characteristic of MySQL when it is left idle for a given period of time.

If you use MySQL as the job database you may experience dropped connections if Spotfire Statistics Services is idle for more than eight hours. As a result, the first request after the time-out occurs fails. However, the failed request automatically re-establishes the connection and subsequent requests succeed.

To work around this issue, we recommend that you change the MySQL server wait_timeout environment variable. As an alternative, you can edit the spserver.properties file to modify the database.url value by appending ?autoReconnect=true to the server URL. For more information on the wait_timeout or autoReconnect properties, see your MySQL Reference Manual.