KB35488: "Metadata server initialization failed because the 'VERSION' property in table ‘DSSMDSYSPROP' is missing or invalid" error appears when attempting to log into a 2-tier project source or create an Intelligence Server definition in MicroStrategy 9.

SYMPTOM:
In Strategy 9.0.2, user receives the following error when attempting to log into a 2-tier project source or create an Intelligence Server definition against a metadata residing in Informix platform.
 

Sample Code/Error
Metadata server initialization failed because the 'VERSION' property in table ‘DSSMDSYSPROP' is  missing or invalid. You may be trying to connect to a metadata repository version unsupported by this release. Please contact your system administrator.

 
 
Executing the following query against the metadata shows the VERSION property is valid for Strategy 9.0.2.
 

SELECT NAME, PROP_VAL FROM DSSMDSYSPROP WHERE NAME='VERSION';

 
 
CAUSE:
One possible cause of the error is the property name 'VERSION' stored in the metadata has extra blank space inside, i.e., 'V ERSION' instead of 'VERSION' although the query shows no visible difference.
  
ACTION:
Manually execute the following query against the metadata.
NOTE: User must create a valid backup of the metadata before running the query.
 

DELETE FROM DSSMDSYSPROP WHERE PROP_VAL='9010';

INSERT INTO DSSMDSYSPROP (NAME, PROP_VAL) VALUES ('VERSION', '9010');   

 
Metadata Modification:
WARNING:
Manually editing values in the Strategy Metadata incorrectly may cause serious, project-wide problems that may make your project unusable. Since these are user-initiated changes, they are not covered by any Strategy warranty. Users are strongly encouraged to backup Metadata prior to any alteration.