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

KB37022: "Upgrade is not supported for the selected database and version..." error message appears when trying to Upgrade History List tables in MicroStrategy 9.x


Community Admin

• Strategy


SYMPTOM:
 
Users upgrading their History List DB based environment in Strategy can potentially face the error shown below:
 
Sample Code/Error
Upgrade is not supported for the selected database and version. Back up your data to a file, then import the files into a new repository.
 
 
This error appears when users open Strategy Configuration Wizard and try to upgrade their History List tables as shown below:
 
 

ka04W000000Oh7YQAS_0EM440000002JGj.png

 
 

ka04W000000Oh7YQAS_0EM440000002JGm.png

 
 
CAUSE:
 
This error message is related to an issue with the History List tables’ version (not with the Database version by itself). This version is stored in the column PROP_VAL from DSSCSSYSPROP table.
 
 
ACTION:
 
Users can execute SQL statement below, to modify the version store in DSSCSSYSPROP table. After this update upgrade process should run successfully.
 
Sql
UPDATE DSSCSSYSPROP SET PROP_VAL = '0' WHERE PROP_NAME = 'VERSION';
 
 
 
 
 
 
 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 1, 2017

Last Updated:

June 1, 2017