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

KB236025: Data in Enterprise Manager tables "IS_SESSION_MONITOR" and "RT_IS_JOB_MONITOR" are not saved for more than one day in MicroStrategy Enterprise Manager 9.x


Community Admin

• Strategy


Data in tables "IS_SESSION_MONITOR" and "RT_IS_JOB_MONITOR" are not saved for more than one day in the MicroStrategy Enterprise Manager warehouse.

SYMPTOM
Data in tables "IS_SESSION_MONITOR" and "RT_IS_JOB_MONITOR" are not saved for more than one day in the Strategy Enterprise Manager warehouse. For example, on 03/27/2015 will only see the data of 03/26/2015 & 03/27/2015, while all the data before 03/26/2015 is missing.
 
CAUSE
"IS_SESSION_MONITOR" and "RT_IS_JOB_MONITOR" are "Real-time" views, which only record the recent, near up-to-the-minute information about the server activity. In other words, these views only show data which has not been moved into the Strategy Enterprise Manager Warehouse fact tables. 
For example, if the data load schedule is set as 12:00 PM every day, then if looking into these views before this time point on 03/27/2015, probably the data before 12:00 PM on 03/27/2015 and the date after 12:00PM on 03/26/2015 will display.
 
ACTION
This is working as designed and there is no action to take.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

June 7, 2017