OpenUtilities Wiki Error - Could not find stored procedure

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.