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

KB275224: Attempting to delete a cube cache which no longer exists from MicroStrategy Command Manager deletes all other cubes caches from the same project


Community Admin

• Strategy


The issue described in this document has been classified as a defect by MicroStrategy. The issue occurs in MicroStrategy Command Manager when users run a script to delete a cube cache which no longer exists. A solution/code fix for this issue is not available in current releases, but is being reviewed for a future MicroStrategy release.

SYMPTOM:
In Strategy Command Manager 10.0 - 10.4 Hotfix 3 and 10.5, when users run the following script to delete a cube cache, they may notice that all other cube caches from the project have been deleted.
 


DELETE INTELLIGENT CUBE CACHE NAME “Cube_Cache_Name” FOR PROJECT “Project_Name”;

 
If users check the Intelligent Cube cache monitor in Developer, they will notice all other cube caches for the project are gone. If users try to execute a report based on an Intelligent Cube in the project, they will get an error saying that the cube needs to be published.
STEPS TO REPRODUCE:

  • Create and publish two Intelligent Cubes. You should see these cubes in the Intelligent Cube cache monitor in Developer.
ka04W000000Ofk6QAC_0EM440000002SZu.jpeg
  • Delete one of these two cube caches from the cache monitor in Developer.
ka04W000000Ofk6QAC_0EM440000002SZt.jpeg
  • Run a Command Manager script to delete the cube cache previously deleted in step 2.
ka04W000000Ofk6QAC_0EM440000002SZs.jpeg
  • In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project are now deleted.
ka04W000000Ofk6QAC_0EM440000002SZv.jpeg

 
CAUSE:
This is an identified defect in Strategy Command Manager when running a script to delete an Intelligent Cube cache which no longer exists.
 
ACTION:
This issue has been addressed in Strategy Command Manager 10.4 Hotfix 4 and 10.6. Upgrade to any of those or newer versions to take advantage of this fix.
 
WORKAROUND:
Ensure the DELETE INTELLIGENT CUBE CACHE command is run only for cache which are still present at the time of execution.
 


Comment

0 comments

Details

Knowledge Article

Published:

June 29, 2017

Last Updated:

February 28, 2018