After running Dmsconv, then logging into datasource for the first time, it prompts me to create tables. I click yes, but get a message “Spatial version record mismatch” and it fails to update\create spatial tables.
After running Dmsconv, then logging into datasource for the first time, it prompts me to create tables. I click yes, but get a message “Spatial tables creation Failed” and it fails to update\create spatial tables.
Followed by Last Error [58199] Cannot Login to the Datasource. Database Version Mismatch. One or more custom tables need conversion. The ProjectWise DMSCONV conversion application and the ProjectWise Administrator must be used before logging into the Datasource.
The issue is not the DMSCONV process, it is more related to the mounting of a datasource to a new ProjectWise environment and it not having access to the ProjectWise storage area that holds the dmsSystem folder to create the necessary files and tables for Spatial.
If you are in a test environment, Create a test storage area.
Before running DMSconv, log into ProjectWise explorer and determine which storage area holds the dmsSystem folders. Click on the dmsSystem folder and view the folder properties.
Log into ProjectWise administrator and change the storage area for this storage to your test storage area in your test environment.
Now Run the Dmsconv.
When completed and if successful, log into the ProjectWise administrator, create the Datasource and log in.
You will be prompted to create Spatial tables. Check the box to convert tables, then click Convert
Also see:
The ProjectWise Implementation guide under "Upgrade and Planning", step 3.