MySQL dropped connections
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 will fail. 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.