Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
I never saw any directions specifically for SP3 to SP5.7... so I followed the directions for updating an exisiting store and got this upon the database upgrade:
<H2>Violation of PRIMARY KEY constraint 'PK_bvc_WebAppSetting'. Cannot insert duplicate key in object 'dbo.bvc_WebAppSetting'. </H2>[color=#ffffcc>
[tr ][td ]<CODE>
Line]Line 8: If Utilities.VersionHelper.SqlPatchNeeded() Then
<FONT color=red>Line 9: Utilities.VersionHelper.RunSqlPatch()
[/color]Line 10:
Line 11: 'Load all items</PRE>[/code][/td][/tr]</TABLE>
[color=#ffffcc>
[tr ][td ]<CODE>
[SqlException] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.RunSingleStatement(String statement, SqlConnection& c) in c:\workspaces\super8x64\BVCommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:545
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& c) in c:\workspaces\super8x64\BVCommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:533
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String script<b>File, String& ErrorMessage) in c:\workspaces\super8x64\BVCommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:510
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in c:\workspaces\super8x64\BVCommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:524
BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\workspaces\super8x64\BVCommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:37
BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\workspaces\super8x64\BVCommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:44
SqlPatch.StartButton_Click(Object sender, EventArgs e) in G:\WEBS\MedSupplier\MedSupplier-Dev\WWW\SqlPatch.aspx.vb:9
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
</PRE>[/code][/td][/tr]</TABLE>[/color]
|
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
ok i tried it 2 more times and this time it worked.
|
|
|
|
|
|
Rank: Member
Joined: 4/10/2009(UTC)
Posts: 120
Location: Mechanicsville, VA
Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
|
Third times the charm... :) |
Tim
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.