Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error - No version resource could be located in database
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • -Database Platform Support - Promis.e
        • Backing Up Promis.e Data Automatically
        • Converting to an SQL Parts Database
        • +Creating and Updating the Project Database
        • Desired SQL server Not Listed in the available Servers List
        • Disable Auto Shrink to avoid performance degradation
        • Error - Could not find SQL Server instance named BENTLEYECAD
        • Error - Could not find stored procedure
        • Error - Database version does not match the application
        • Error - Index was outside the bounds of the array (Microsoft.SqlServer.smo)
        • Error - Invalid database name - on Project Database Utility
        • Error - Invalid object name
        • Error - Login failed for Ecaduser: Reason: The Password of the account Expired
        • Error - No version resource could be located in database
        • Error - OraOLEDB.Oracle provider is not registered
        • Error - T-SQL execution command line utility stopped working
        • Error - The database is for product... you cannot use it
        • Error at Startup - Error 0 No connection could be made because the target machine actively refused it.
        • Error at Startup - Error 40 Could Not Open a Connection
        • Error at startup - The Type initializer for ECT.ECAD.API.SystemSetup threw an exception
        • Error at Startup - Unrecognized database format, catalog.mdb
        • Error deleting project - transaction log full
        • Error messages encountered due to case sensitive collation of SQL Server
        • Error on backup - Invalid database object reference
        • Error on Project Database Utility - Cannot find the file specified
        • Error running SQL scripts - Incorrect syntax
        • Exception thrown when creating a project due to SQL permissions
        • Exception thrown when opening a page, transaction log is full
        • Finding the SQL Data folder
        • Installing SQL Server
        • Minimum SQL user permissions
        • Project Database Version - Promis.e
        • Rebuild indexes in the SQL project database
        • Rules for Regular Identifiers
        • SQL Server FAQ
        • Troubleshooting Project Database Connection Problems
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Error - No version resource could be located in database

      Product(s): promis.e, Bentley Substation
      Version(s): through 08.11.12.137
      Environment: N/A
      Area: Database Platform Support
      Subarea: N/A

    Error or Warning Message

    "Configuration not saved: No version resource could be located in database.  Project schema is invalid" appears on the Setup dialog.

    Explanation

    This message indicates that the Version extended property of the Project table in the SQL Server project database being used is missing or cannot be read.

    If using Oracle for the project database, the message indicates that the comment on the "Project" table is missing or cannot be read.

    The Version property/comment may actually be correct on the server but cannot be read by the login being used.

    This message can also occur if no database is specified for the Database or Default Database field on Setup > Project Database.

    How to Avoid

    Ensure a valid database is specified in the Database or Default Database field on Setup > Project Database.

    Verifying Version with SQL Server

    1. Connect to the server using SQL Server Management Studio (SSMS).

    2. In SSMS, drill down in the Object Explorer tree view into Databases > (your database name) > Tables

    3. Right click the dbo.Project table and select "Properties".

    4. On the Extended Properties page there should be properties called "ShortProductName" and "Version". For the software to accept the database, the value of "Version" must match the value expected.  See Project Database Version - promis.e and Project Database Version - Substation.  Note:  While this dialog can also be used to add or modify a property, DO NOT change the version number here in an attempt to "upgrade" or "downgrade" the database schema.

    If the Version property exists and the value is correct, ensure the correct database is being examined and that promis•e/Bentley Substation is pointing to that database on Setup.  If so, check the permissions of the login being used, see Minimum SQL user permissions. In one case, the login had the "public" role assigned but not "db_owner" for the database in question.

    If the Version property does not exist or has an incorrect value, execute the script that updates the database schema.  See the "Update the Database Method 2: Executing a Script" section in Creating and Updating the Project Database.

    Verifying Version with Oracle

    Check for the presence of a comment on the "Project" table of the database.  It should have a value that matches the version number according to  Project Database Version - promis.e or Project Database Version - Substation.  Note: DO NOT change the version number here in an attempt to "upgrade" or "downgrade" the database schema.

    If the comment on the Project table exists and the value is correct, ensure the correct database is being examined and that promis•e/Bentley Substation is pointing to that database on Setup.  If so, check the permissions of the login being used.

    If the comment on the Project table does not exist or has an incorrect value, execute the script that updates the database schema.  See the "Update the Database Method 2: Executing a Script" section in Creating and Updating the Project Database. 

    See Also

    Creating and Updating the Project Database

    Project Database Version - promis.e

    Project Database Version - Substation

      Original Author: Matt_P
    • Oracle
    • Database Platform Support
    • promis.e
    • SQL Server
    • error message
    • Installation/Configuration
    • Bentley Substation
    • en
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Mon, Nov 4 2013 6:07 PM
    • Jesse Dringoli Last revision by Bentley Colleague Communities MVP Jesse Dringoli
    • When: Fri, Mar 27 2020 4:53 PM
    • Revisions: 9
    • 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