Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki Spatial version record mismatch or Spatial tables creation Failed
    • Sign In
    • +ProjectWise Design Integration Wiki
    • +ProjectWise Learning
    • +Projectwise Licensing
    • +Projectwise Documentation
    • +ProjectWise Explorer Client
    • -ProjectWise Administrator
      • -DMSConv
        • Troubleshooting Projectwise DMSCONV issues
        • Spatial version record mismatch or Spatial tables creation Failed
        • DMS Convert and Installation Issues [TN]
      • +Environments
      • +ProjectWise Workflow Rules Engine
      • +Miscellaneous - PW Admin
    • +ProjectWise Integration Server
    • +ProjectWise Caching Server
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • +ProjectWise Logging and Tools

     
     Questions about this article, topic, or product? Click here. 

    Spatial version record mismatch or Spatial tables creation Failed

      Product(s): ProjectWise Administrator
      Version(s): NA
      Area:  DMSCONV
      Original Author: Dana Guthrie, Bentley Technical Support Group

    Problem

    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.

    Solution one

    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

    Solution Two

    When installing the ProjectWise Administrator, there is a feature that can be turned on or off call the "Spatial Administrator".  If this feature is installed; When launching ProjectWise Administrator and logging into a datasource, the Spatial feature checks the datasource schema for the tables needed for the Spatial feature.  If not found, then it will prompt you to install these tables or if the tables are found it may fail with Last Error [58199]

    Why would the tables be found if we are not using the Spatial feature?

    • Someone at some time may have accidentally installed the Spatial Administrator and when prompted, installed the tables.
    • Very old versions of ProjectWise may have had these tables installed and it is a carryover from a previous install

    If you are not using the Spatial features, then there is no need to install the Spatial administrator.

    • Go to Control Panel, Programs and Features, Highlight the ProjectWise administrator and choose Modify\Change.
    • On the feature page, expand ProjectWise Administrator and uncheck the Spatial Administrator feature.  
    • Click Modify and complete the installation.

    Also see:

    The ProjectWise Implementation guide under "Upgrade and Planning", step 3.

    • Share
    • History
    • More
    • Cancel
    • Dana Guthrie Created by Bentley Colleague Dana Guthrie
    • When: Tue, Aug 8 2017 10:49 AM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Wed, Nov 2 2022 10:17 AM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies