Error upgrading 315 to 327 Procedure BugNet_Project_GetAllProjects

Topics: Installing BugNET
Sep 1, 2014 at 8:55 AM
I've kept the version 315 database, extracted all files from the .ZIP and replaced the connectionstring. After running /install/install.aspx and returning to Default.aspx I get:

"Procedure BugNet_Project_GetAllProjects has no parameters and arguments were supplied.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure BugNet_Project_GetAllProjects has no parameters and arguments were supplied.

Source Error:


An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Procedure BugNet_Project_GetAllProjects has no parameters and arguments were supplied.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +392
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61
System.Data.SqlClient.SqlDataReader.get_MetaData() +138
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6738869
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6741487
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288
System.Data.SqlClient.SqlCommand.ExecuteReader() +302
BugNET.Providers.DataProviders.SqlDataProvider.ExecuteReaderCmd(SqlCommand sqlCmd, GenerateListFromReader1 gcfr, List1& list) +162
BugNET.Providers.DataProviders.SqlDataProvider.GetAllProjects(Nullable`1 activeOnly) +325
BugNET._Default.Page_Load(Object sender, EventArgs e) +471
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178"

Any suggestions what I might be doing wrong?
Sep 1, 2014 at 1:17 PM
Did the upgrade script run without errors? There was an update to the GetAllProjects stored procedure that should have been executed during the install.
Sep 1, 2014 at 1:32 PM
After replacing the database with the 315 version the Install page is convinced I'm running code 327 and database 327, so no script is executed. On a previous attempt the script did run, but with an error:

"Msg 3728, Level 16, State 1, Line 2
'PK_BugNet_RelatedIssues' is not a constraint.
Msg 3727, Level 16, State 0, Line 2
Could not drop constraint. See previous errors."

I located the update script and ran it manually, which resulted in the same error, but it's working now.

Thanks for your support!