SYMPTOM:
In Strategy 9.x, the logs in StatisticFailedSQLs.log are partially overwritten after restarting Intelligence Server.
Before restarting Intelligence Server:
insert into IS_SESSION_STATS (SESSIONID,SERVERID,SERVERNAME,SERVERINSTNAME,SERVERMACHINE,WEBMACHINE,USERID,CLIENTMACHINE,CONNECTTIME,
DISCONNECTTIME,EVENTSOURCE,EVENTNOTES,PROJECTID,SESSIONEVENT,EVENTTIME,DAY_ID,HOUR_ID,MINUTE_ID,RECORDTIME) values ('A7F29F954E21088BB36FFF83D4D87578', 'B683CB5A4F7438557E45C486270CE3F1', 'JPN-xxx', '', 'JPN-xxx:34952', '', '54F3D26011D2896560009A8E67019608', 'JPN-xxx.corp.Strategy.com-23432', {ts'2013-08-22 17:21:22'}, {ts'2013-08-22 17:25:40'}, 1, '', 'NA', -1, {ts'1900-01-01 01:00:00'}, {ts'2013-08-22 17:21:22'}, 2013082217, 2.01308221721E+011,GETDATE());
After restarting Intelligence Server:
insert into IS_SESSION_STATS (SESSIONID,SERVERID,SERVERNAME,SERVERINSTNAME,SERVERMACHINE,WEBMACHINE,USERID,CLIENTMACHINE,CONNECTTIME,
DISCONNECTTIME,EVENTSOURCE,EVENTNOTES,PROJECTID,SESSIONEVENT,EVENTTIME,DAY_ID,HOUR_ID,MINUTE_ID,RECORDTIME) values ('C825219549C1C39BC2E69A8FE1D90DA4', 'B683CB5A4F7438557E45C486270CE3F1', 'JPN-xxx', '', 'JPN-xxx:34952', '', '54F3D26011D2896560009A8E67019608', 'JPN-xxx.corp.Strategy.com-24696', {ts'2013-08-23 10:05:36'}, {ts'2013-08-23 11:07:13'}, 1, '', 'NA', -1, {ts'1900-01-01 01:00:00'}, {ts'2013-08-23 10:05:36'}, 2013082310, 2.01308231005E+011,GETDATE());'}, 1, '', 'NA', -1, {ts'1900-01-01 01:00:00'}, {ts'2013-08-22 17:21:22'}, 2013082217, 2.01308221721E+011,GETDATE());
STEPS TO REPRODUCE:
CAUSE:
This is a known issue with Strategy Intelligence Server 9.x.
ACTION:
Contact Strategy Technical Support for an update on the status of this issue