Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Project Database Version - Promis.e
    • 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. 

    Project Database Version - Promis.e

      Product(s): Promis.e
      Version(s): through 08.11.13.96
      Environment: N/A
      Area: Database Platform Support
      Subarea: N/A

    Background

    Each version of Promis.e has its own corresponding project database schema, identified by a version number. The version number of the database is stored as an extended property of the Project table in SQL Server databases and as a comment on the Project table for Oracle databases.

    When connecting to the project database, if the "Version" property/comment of the database does not match what Promis.e expects or cannot be retrieved for some reason, a Database version does not match the application message will appear.  Generally, this means that either the Promis.e application or the database schema needs to be updated, whichever is older.

    Database version numbers can also be revealed in a prompt when restoring a project from a different version of Promis.e.  In this case, when the current project database version is newer than the database version for the backup listed in the message, the message is purely informational and no action is necessary.  If the database version of the backup is newer than the application, the backup cannot be restored and the message typically indicates this (Unable to restore project because the project's database version is newer than your current database version).

    The purpose of this document is to help determine the proper course of action, if any is necessary.

    Versions Chart

    This chart applies to SELECT releases of Promis.e.

    Application Application Version Database Version
    Promis.e V8i SS8 REFRESH 08.11.13.96 8.1.42
    Promis.e V8i SS8 08.11.13.57 8.1.33
    Promis.e V8i SS7 REFRESH Q1 2015 08.11.12.137 8.1.14
    promis.e V8i SS7 REFRESH Q3 2014 08.11.12.120 8.1.12
    promis.e V8i SS7 REFRESH Q2 2014 08.11.12.101 8.1.10
    promis.e V8i SS7 REFRESH 08.11.12.88 8.1.10
    promis.e V8i SS7 08.11.12.18 8.1.06
    promis.e V8i SS6 REFRESH 08.11.11.85 8.0.75
    promis.e V8i SS6 08.11.11.18 8.0.72
    promis.e V8i SS5 REFRESH 08.11.10.66 - .68 8.0.71
    promis.e V8i SS5 08.11.10.60 - .62 8.0.69
    promis.e V8i SS3 REFRESH 08.11.08.22 8.0.55
    promis.e V8i SS3 08.11.08.14 8.0.55
    promis.e V8i SS2 08.11.07.1xx 8.0.49
    promis.e V8i SR1 08.11.07.82 8.0.15
    promis.e V8i (base) 08.11.05.9x 8.0.06
    promis.e 2007 3.0.3 3.0.36
    promis.e 2007 3.0.2 3.0.28
    promis.e 2007 3.0.1 3.0.18
    promis.e 2007 3.0.0 3.0.16
    promis.e 2007 2.0.3 2.0.07

    Determining the application version

    The installed version of Promis.e ("Application Version" in the chart) can be found on the About promis-e dialog.

    Determining the database version (SQL Server)

    The current database version can be determined by connecting to the SQL Server using SQL Server Management Studio (SSMS) and checking the extended properties of the Project table in the database used by Promis.e.  In SSMS, expand Object Explorer > Databases > promise > Tables, right click dbo.Project, and select Properties > Extended Properties.

    Alternatively, executing the following query will also return the database version.

    use promise
    SELECT * FROM fn_listextendedproperty ('Version', 'user', 'dbo', 'table', 'project', default, default)

    Replace "promise" in the above query with the name of the database if different.

    Additional Notes

    • "SS" in the above chart stands for SELECTseries.
    • The version of the database that will be created by a script file can typically be found as a comment near the beginning of the script.  For example: --$DBVersion:8.1.42$-- 
      Similarly, an update script will list the version to which the script will update the database.
    • The SQL Server and database used by Promis.e can be determined by looking in the Project Database area of the Promis.e Setup dialog.

    See Also

    Updating and Upgrading Promis.e

    How to download the Promis.e software

    Creating and Updating the Project Database

    Error - Unable to restore project, project's database version is newer

    Error - Database version does not match the application

    Project Database Version - Substation

      Original Author: Matt_P
    • Database Platform Support
    • promis.e
    • Administration
    • en
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Mon, Mar 26 2012 5:02 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Thu, Feb 18 2021 12:36 PM
    • Revisions: 31
    • 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