Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error - Could not find stored procedure
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisHYD Multi Utility
    • +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 - Could not find stored procedure

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

    Error or Warning Message

    One of the following or similar error message is displayed when attempting various operations.

    Internal Error
    Error Message: Could not find stored procedure 'GetProject_P_id'.
    TargetSite: Boolean CheckConn(System.Data.SqlClient.SqlException)
    DeclaringType: ECT.ECAD.DAL.SqlServerProject
    Attributes: private
    MemberType: Method

    Internal Error
    Error Message: Could not find stored procedure 'InitBuildConn_Page'.
    TargetSite: Boolean CheckConn(System.Data.SqlClient.SqlException)
    DeclaringType: ECT.ECAD.DAL.SqlServerProject
    Attributes: private
    MemberType: Method

    Internal Error
    Error Message: Could not find stored procedure 'MoveWirePropertyData'.
    TargetSite: Void OnError(System.Data.SqlClient.SqlException)
    DeclaringType: System.Data.SqlClient.SqlConnection
    Attributes: internal
    MemberType: Method

    Internal Error
    DB_Restore_ConvertWireProperty
    ProjectDB Error Message: Could not find stored procedure 'InsertWirePropertyTable'.
    TargetSite: Boolean _InsertTable(System.Data.DataTable, Bentley.Electrical.Data.Db.TableNames, System.Data.DataTable By Ref)
    DeclaringType: ECT.ECAD.DAL.BulkInsert
    Attributes: private
    MemberType: Method

    Explanation

    The error messages indicate that the project database schema is incomplete, with at least one stored procedure missing.

    The script that updates the schema of the project database after the software is updated drops stored procedures and recreates them.  It is possible some stored procedures did not get recreated after being dropped.

    If the database was just created and not updated, then it was not created completely for some reason.

    Steps to Resolve

    Option 1

    If the database schema was updated and the database needs to be preserved because it contains project data, update the database schema again in order to add the missing stored procedures.  This must be done by running the update script "manually", since the Project Database Utility will likely determine the schema was already updated and not perform the update.  See the "Update the Database Method 2: Executing a Script" section of Creating and Updating the Project Database.

    Option 2

    If the database was recently created and contains no project data that needs to be preserved, create a new database (with a new name).  See Creating and Updating the Project Database.  If one method of creating the database does not work, try the other.

      Original Author: Matt_P

    Keywords: MoveWirePropertyData, GetProject_P_id, ClearSpecifiedParentDevice, restore, Project Manager, runsql

    • 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: Wed, Jul 23 2014 11:14 AM
    • Jesse Dringoli Last revision by Bentley Colleague Communities MVP Jesse Dringoli
    • When: Fri, Mar 27 2020 4:15 PM
    • Revisions: 7
    • 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