EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB46094: The logs in StatisticFailedSQLs.log are partially overwritten after restarting Intelligence Server in MicroStrategy 9.x


Community Admin

• Strategy


In MicroStrategy 9.x, the logs in StatisticFailedSQLs.log are partially overwritten after restarting Intelligence Server.

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:

  1. Login to Intelligence Server as Administrator.
  2. Restart Intelligence Server while the user session is kept.
  3. Note that the logs in StatisticFailedSQLs.log are partially overwritten.

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
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017