KB39887: "Invalid object name 'DSSMDSYSPROP'" error message appears when connecting to a 2-tier project source in MicroStrategy Desktop 9.x or Developer 10.x

Salesforce Solutions Architect • Strategy

This technical note describes a potential solution for resolving the error "Invalid object name 'DSSMDSYSPROP'" when connect to a 2-tier project source in MicroStrategy Desktop 9.x or Developer 10.x. This may be caused by missing metadata table prefix at the project source level. Add the table prefix at the project source level to potentially resolve the issue.

SYMPTOM:
When connecting to a 2-tier project source in Strategy Desktop 9.x or Developer 10.x, following error message appears:


Metadata Server cannot connect to metadata repository. Database error: Execute Query failed.Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Invalid object name 'DSSMDSYSPROP'..

CAUSE:
This may be caused by missing metadata table prefix at the project source level.

ACTION:
Add the table prefix at the project source level:

Comment

0 comments

Details

Knowledge Article

Published:

June 6, 2017

Last Updated:

June 6, 2017