Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenUtilities
  • Product Communities
  • More
OpenUtilities
OpenUtilities Wiki Error on Project Database Utility - Cannot find the file specified
    • Sign in
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +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 on Project Database Utility - Cannot find the file specified

      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 database, the following error message is displayed on the Project Database Utility dialog: 

    Execution error: The system cannot find the file specified

    Explanation

    The Project Database Utility uses tools included with the SQL Server installation to create the database. It relies on the PATH environment variable to find the necessary tools on the system running the Project Database Utility. The error message is displayed when the software cannot find such a tool. This can be caused by SQL Server not being installed on the machine running Project Database Utility, or a path is missing or incorrect in the PATH environment variable.

    How to Avoid

    Option 1 - make the Project Database Utility work

    Install SQL Server

    If SQL Server is not installed, install SQL Server on the workstation even if attempting to create the database on another machine running SQL Server. SQL Server Express is adequate and bundled with Promis.e and Bentley Substation. To avoid trouble, it may be best to install the same version (2008, 2012, 2014, etc.) of SQL Server. Installing SQL Server should install the necessary tools and add the necessary paths to the PATH environment variable.

    Check the PATH environment variable

    If SQL Server is already installed on the machine running the Project Database Utility, ensure the necessary paths are included in the PATH environment variable. Check this with the following process:

    1. Go to Control Panel > System > Advanced System Settings.
    2. Click the Environment Variables button.
    3. Highlight the PATH variable in the System variables list.
    4. Click the Edit button under the System variables list.

    For SQL Server 2008 R2, the PATH environment variable should include the following paths or similar:

    c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;

    For SQL 2014:

    C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;

    The critical path may be the one containing SQLCMD.EXE (highlighted above).

    Important: Restart the computer after making the changes to the environment variables. 

    Option 2 - Create the database without using Project Database Utility

    The database can be created by running a script using SQL Server Management Studio. See Creating and Updating the Project Database for details.

    See Also

    Creating and Updating the Project Database

    Installing SQL Server

    Install SQL Server Management Studio

      Original Author: Matt_P
    • Setup
    • Database Platform Support
    • promis.e
    • SQL Server
    • error message
    • Bentley Substation
    • en
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Fri, Jan 29 2016 6:20 PM
    • Matt_P Last revision by Communities MVP Matt_P
    • When: Tue, Jul 24 2018 10:02 AM
    • Revisions: 6
    • 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

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