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

KB41001: Purge element caches schedule based on one attribute deletes all attribute element caches in MicroStrategy Intelligence Server 9.x and 10.x


Community Admin

• Strategy


Purge element caches schedule based on one attribute deletes all attribute element caches in MicroStrategy Intelligence Server 9.x and 10.x

SYMPTOM:
 
'Purge element caches' schedule based on one attribute deletes all attribute element caches in Strategy 9.x and 10.x.
 
STEPS TO REPRODUCE:
 
Follow the steps below to reproduce the issue in Tutorial project in Strategy Developer 9.x and 10.x:
 

  1. Create a Schedule Administration Task to 'Purge element caches'. Go to Administration> Scheduling >Schedule Administration Tasks, and choose 'Purge element caches' based on attribute 'Year', as shown below:
ka04W000000OcGkQAK_0EM4400000029jb.png

 
 

  • Enable 'Element cache trace'. Go to Diagnostic Configuration, set configuration as 'CastorServer Instance', enable 'Element Server >Element Source Trace', as shown below:
ka04W000000OcGkQAK_0EM4400000029jr.png

 
Sample Code/Error
2012-08-29 01:08:55.359-08:00 Getting elements for Object(Name="Year" Type=Attribute ID=8D679D5111D3E4981000E787EC6DE8A4Proj=B19DEDCC11D4E0EFC000EB9495D0F44F Ver=9EF853E34A96B3700C174DB80B2DC99D ) from ReportInstance(Name="-" ExecFlags=0x8(ElmtBrw ) ExecActn=0x37(Rslv GenSQL ExeSQL XTab EvalVw ) ) (Offset=1 Limit=2)
2012-08-29 01:08:55.359-08:00 Populated elements from ReportInstance(Name="-" ExecFlags=0x8(ElmtBrw ) ExecActn=0x37(Rslv GenSQL ExeSQL XTab EvalVw ) ) (ElSrvOffset=1 ElSrvLimit=8 Total=4)
2012-08-29 01:09:12.234-08:00 Getting elements for Object(Name="Region" Type=Attribute ID=8D679D4B11D3E4981000E787EC6DE8A4Proj=B19DEDCC11D4E0EFC000EB9495D0F44F Ver=5C83D96645A93F5CD026F382C19DA678 ) from ReportInstance(Name="-" ExecFlags=0x8(ElmtBrw ) ExecActn=0x37(Rslv GenSQL ExeSQL XTab EvalVw ) ) (Offset=1 Limit=2)
2012-08-29 01:09:12.234-08:00 Populated elements from ReportInstance(Name="-" ExecFlags=0x8(ElmtBrw ) ExecActn=0x37(Rslv GenSQL ExeSQL XTab EvalVw ) ) (ElSrvOffset=1 ElSrvLimit=8 Total=12)
 
Sample Code/Error
2012-08-29 01:09:38.562-08:00 Removing Object(Type=Attribute ID=8D679D5111D3E4981000E787EC6DE8A4)
2012-08-29 01:09:38.578-08:00 Removed Object(Type=Attribute ID=8D679D5111D3E4981000E787EC6DE8A4)
 
CAUSE:
It is a known issue in Strategy Intelligence Server 9.x and 10.x.
Intelligence Engine delete attribute element caches by attribute ID, however, all attributes share the same object ID but have different version IDs.
 
 
ACTION:
Contact Strategy Technical Support for an update on this issue.
Strategy will continue to investigate and post updates as soon as they are available.

  • Create attribute element caches for attribute 'year' and 'region'. In element cache trace log, entries can be found:
  • Trigger 'Purge element caches', all attribute element caches are purged. In element cache trace log, entries can be found, as shown below:

Comment

0 comments

Details

Knowledge Article

Published:

June 4, 2017

Last Updated:

June 4, 2017