Server Error in '/' Application.

---

Could not drop object 'dbo.bvc_Product' because it is referenced by a FOREIGN KEY constraint.


Stack Trace:


[SqlException (0x80131904): Could not drop object 'dbo.bvc_Product' because it is referenced by a FOREIGN KEY constraint.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +380
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& c) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:534
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile, String& ErrorMessage) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:510
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:524
BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:21
BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:34
SqlPatch.StartButton_Click(Object sender, EventArgs e) +17
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

The store has Structured Solutions Shipping Calculator and Shipping Service installed, in case that matters.

Any idea what's going on here? I was hoping to update tonight (this was a test run), but I guess not.

Thanks for the info, but I think you wanted to say that your products do NOT have a role in this error :-)

I did not think they would, but thought I should mention I was using them, just in case.

I didn't see any info on your site on Shipper 1 to Shipper 3 upgrades. I have already bought Shipper twice - once for BVC 2004 and once for BVC 5 - I hope I don't have to pay full price a third time for the same web site. (Both products are great, btw - we had huge problems with incorrect shipping charges until we started using the Rule Providers, and Shipper saves so much time every day)

I'll try the manual db migration tomorrow.