• How to Migrate from Old SQL Server to New SQL Server for OpenUtilities Substation CONNECT

    Satish Saptasagar
    Satish Saptasagar
    Product(s): OpenUtilities Substation CONNECT Edition Version(s): 10.00.XX.XX to 10.14.XX.XX Environment: NA Area: Database Platform Support Subarea: NA Background: Organizations usually have…
    • 6 months ago
    • OpenUtilities
    • OpenUtilities Wiki
  • How to Migrate from Old SQL Server to New SQL Server for Promis.e CONNECT

    Satish Saptasagar
    Satish Saptasagar
    Product(s): Promis.e CONNECT Edition Version(s): 10.00.XX.XX to 10.12.XX.XX Environment: NA Area: Database Platform Support Subarea: NA Background: Organizations usually have IT Policy in…
    • 6 months ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error "In order to create the database you must have the 'sysadmin' role permission" - OpenUtilities Substation CONNECT

    Satish Saptasagar
    Satish Saptasagar
    Product(s): OpenUtilities Substation CONNECT Edition Version(s): 10.00.XX.XX to 10.13.XX.XX Environment: NA Area: Database Platform Support Subarea: SQL Permission Background: When the user…
    • 8 months ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error "In order to create the database you must have the 'sysadmin' role permission" - Promis.e CONNECT

    Satish Saptasagar
    Satish Saptasagar
    Product(s): Promis.e CONNECT Edition Version(s): 10.00.XX.XX to 10.10.XX.XX Environment: NA Area: Database Platform Support Subarea: SQL Permission Background: When the user is trying to…
    • 8 months ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Recommendation for OpenUtilities Designer SQL Server database environment:

    Mike Carlisle
    Mike Carlisle
    Set the Transaction Isolation Level to Read Committed (default value) SQL Syntax: SET TRANSACTION ISOLATION LEVEL READ COMMITTED; Set the READ_COMMITTED_SNAPSHOT database option to ON: SQL Syntax: ALTER DATABASE OUDesignerWFM SET READ_COMMITTED_SNAPSHOT…
    • over 2 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Installing SQL Server Express locally for OpenUtilities Substation CONNECT

    Satish Saptasagar
    Satish Saptasagar
    Product(s): OpenUtilities Substation CONNECT Edition Version(s): 10.00.XX.XX to 10.10.XX.XX Environment: NA Area: Database Platform Support Subarea: NA Background: OPenUtilities (OU) Substation…
    • over 2 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Updating Database for OpenUtilities Substation CONNECT Update 10 and through

    Satish Saptasagar
    Satish Saptasagar
    Product(s): OpenUtilities Substation CONNECT Version(s): 10.10.XX.XX to 10.11.XX.XX Environment: NA Area: Database Platform Support Subarea: NA Background: Substation uses a database to store…
    • over 2 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Creating and Updating Project Database - Promise CE

    Satish Saptasagar
    Satish Saptasagar
    Product(s): Promise CONNECT Version(s): 10.00.XX.XX to 10.03.XX.xx Environment: N/A Area: Installation_Configuration Subarea: N/A Background Promis.e uses database to store project related…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Creating and Updating the Project Database - Substation CE

    Satish Saptasagar
    Satish Saptasagar
    Product(s): Substation CONNECT Version(s): 10.00.XX.XX to 10.05.XX.XX Environment: N/A Area: Installation_Configuration Subarea: N/A Background Substation uses database to store project related…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Plant Exchange

    Matt_P
    Matt_P
    Product(s): Promis.e Version(s): V8i Environment: N/A Area: Interoperability Subarea: Plant Exchange Background AutoPlant P&ID and other Plant products store information that is related to…
    • over 5 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error - Index was outside the bounds of the array (Microsoft.SqlServer.smo)

    Jesse Dringoli
    Jesse Dringoli
    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 Index was outside the bounds…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error at Startup - Error 40 Could Not Open a Connection

    Jesse Dringoli
    Jesse Dringoli
    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 The following error appears…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error at Startup - Error 0 No connection could be made because the target machine actively refused it.

    Jesse Dringoli
    Jesse Dringoli
    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 The following error appears…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Finding the SQL Data folder

    Michael Kelley
    Michael Kelley
    Product(s): Promis.e, Bentley Substation Version(s): through 08.11.13.140 Environment: N/A Area: Database Platform Support Subarea: N/A Background When creating SQL Server databases using a…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Desired SQL server Not Listed in the available Servers List

    Jesse Dringoli
    Jesse Dringoli
    Product(s): Promis.e, Bentley Substation Version(s): through 08.11.13.96 Environment: N/A Area: Database Platform Support Subarea: N/A Problem Description After installing the " SQL Server…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • The GUID in the project database doesn’t correspond to GUID for this project in the ect.fid

    Siddharaj Talawar
    Siddharaj Talawar
    Product(s): Promis.e, Bentley Substation Version(s): V8i through 08.11.13.140 Environment: SQL Server Area: Project Management Subarea: Project Manager Problem Description “ The GUID in the…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error on Project Database Utility - Cannot find the file specified

    Matt_P
    Matt_P
    Product(s): Promis.e, Bentley Substation Version(s): through 08.11.13.140 Environment: N\A Area: Database Platform Support Subarea: N\A Error or Warning Message When trying to create a project…
    • over 5 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Exception thrown when creating a project due to SQL permissions

    Jesse Dringoli
    Jesse Dringoli
    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 When trying to create a new…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Minimum SQL user permissions

    Satish Saptasagar
    Satish Saptasagar
    Product(s): Promis.e, Bentley Substation Version(s): through 08.11.13.73 Environment: N\A Area: Database Platform Support Subarea: N/A What are the minimum permissions required for a user to…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error messages encountered due to case sensitive collation of SQL Server

    Matt_P
    Matt_P
    Product(s): Promis.e, Bentley Substation Version(s): 08.11.07.82 Environment: N/A Area: Database Platform Support Subarea: N/A Error or Warning Message Various error messages are encountered…
    • over 5 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error running SQL scripts - Incorrect syntax

    Jesse Dringoli
    Jesse Dringoli
    Product(s): Promis.e, Bentley Substation Version(s): through 08.11.13.73 Environment: N\A Area: Database Platform Support Subarea: N/A Error or Warning Message When executing the SqlServerProject…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Exception thrown when opening a page, transaction log is full

    Jesse Dringoli
    Jesse Dringoli
    Product(s): Promis.e, Bentley Substation Version(s): 08.11.11.18 Environment: N/A Area: Database Platform Support Subarea: N/A Error or Warning Message One or more of the error messages below…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Error - T-SQL execution command line utility stopped working

    Jesse Dringoli
    Jesse Dringoli
    Product(s): Promis.e, Bentley Substation Version(s): 08.11.12.137 Environment: N/A Area: Database Platform Support Subarea: N/A Error or Warning Message When attempting to create a new project…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Install SQL Server Management Studio

    Siddharaj Talawar
    Siddharaj Talawar
    Product(s): Promis.e, Bentley Substation Version(s): 08.11.12.137 - 08.11.13.140 Environment: N/A Area: Database Platform Support Subarea: N/A Problem Description What happened to SQL Server…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • Disable Auto Shrink to avoid performance degradation

    Jesse Dringoli
    Jesse Dringoli
    Product(s): Promis.e, Bentley Substation Version(s): through 08.11.13.140 Environment: N/A Area: Database Platform Support Subarea: N/A Background Manual and automatic shrinking of SQL database…
    • over 3 years ago
    • OpenUtilities
    • OpenUtilities Wiki
  • View related content throughout OpenUtilities
  • More
  • Cancel
>