MicroStrategy8升级到9时遇到的错误ora-00955.doc

Error, Failed to execute: CREATE TABLE DSSMDOBJTRNS... error appears at the summary page of Configuration Wizard when trying to upgrade a MicroStrategy 8.1.x Metadata on a MicroStrategy Intelligence Server 9.0.x SYMPTOM: When trying to upgrade a metadata by following the following Technical Note: ? TN32647 -?How to upgrade MicroStrategy 8.1.x or 9.0.0 metadata repository and project definitions to MicroStrategy 9.0.1 ? ... the following error is received in the last window of the Configuration Wizard: ? ? Sample Code/Error Failed to execute CREATE TABLE DSSMDOBJTRNS(?? PROJECT_ID? ... ? ? CAUSE: The same databsae space where 8.1.x metadata tables have been restored and are being upgraded?was used previously as a testing tablespace?for a 9.0.x metadata and some 9.0.x metadata tables such as DSSMDOBJTRNS?still exist there. For a complete list of 8.1.x and 9.x metadata tables, please see: ? TN30515 -?List of tables for MicroStrategy 8.1.x and 9.x metadata repositories? ? ACTION: Clean up the database space and make sure no table exist prior to restoring 8.1.x metadata tables from the back up file. Run the Configuration Wizard to upgrade metadata.? List of tables for MicroStrategy 8.1.x and 9.x metadata repositories Below is?a list of the 10 tables contained in a MicroStrategy 8.1.x metadata repository: DSSMDLNKITEM DSSMDLNKPROP DSSMDOBJCMNT DSSMDOBJDEFN DSSMDOBJDEPN DSSMDOBJINFO DSSMDOBJPROP DSSMDOBJSECU DSSMDSYSPROP DSSMDUSRACCT Starting with MicroStrategy 9.x,?thirteen additional tables were included: seven for Distribution Services, five for the Change Journal feature, and one for Metadata Internationalization. Below is?a list of the 23 tables contained in a MicroStrategy 9.x metadata repository. ? Tables available since MicroStrategy 8.1.x: DSSMDLNKITEM DSSMDLNKPROP DSSMDOBJCMNT DSSMDOBJDEFN DSSMDOBJDEPN DSSMDOBJINFO DSSMDOBJPROP DSSMDOBJSECU DSSMDSYSPROP DSSMDUSRACCT ? Additional tables for the Distribution Services feature: DSSCSADDRESS DSS