Prior to the release of Strategy 10 Secure Enterprise Platform, a connection to the Statistics database would be attempted a maximum of only 5 times in case of a failure, as described in the following Strategy Knowledge Base document:
KB45534: In Strategy Intelligence Server 9.3.1, Statistics logging does not re-initiate automatically once the Statistics database connection is lost and later restored
With the release of Strategy 10 Secure Enterprise Platform, this behavior has been changed. As in versions 9.3.1 and 9.4.1, there will be 5 attempts to establish a connection to the database and each time we try to write Statistics if there is no established database connection and we cannot open a new connection, it is instead written to a buffer in memory. Whenever the buffer exceeds the maximum size (1000 SQL insert lines) it will be flushed to the StatisticsFailedSQL log file.
The change in Strategy Intelligence Server 10.0 occurs after there have been 5 failed attempts to establish a connection. In Strategy Intelligence Server 10.0, after there has been 5 failures, we won't attempt to connect again for 5 minutes, however we will reset the counter for failed attempts. After 5 minutes have passed, we will attempt to connect to the database 5 additional times. This process will continue forever whenever we cannot establish a connection to the database.
The Strategy internal reference number for the issue described in this document is 667551.
