• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

renej
#1 Posted : Sunday, September 12, 2010 10:03:19 AM(UTC)
renej

Rank: Member

Joined: 9/4/2010(UTC)
Posts: 1

I have created a testing website to perform an upgrade from SP2 to 5.7.3. I had my host copy the database, I copied the files from my live site to the test site, and everything was working fine so I proceeded with performing the upgrade to 5.7.3. When I pulled the site up in my browser I received the issue with the PasswordLastSet, but after changing my user dates in the database, that issue went away. Now when I pull up the site in my browser it begins to execute the database update script and I now receive the following. Any suggestions would be appreciated.
thanks

Rene'




<H1>Server Error in '/' Application.
<HR color=silver SIZE=1 width="100%">
</H1>
<H2>There is already an object named 'bvc_ProductXChoice' in the database. </H2>[color=#ffffcc>

[tr ][td ]<CODE>
Line]Line 8: If Utilities.VersionHelper.SqlPatchNeeded() Then
[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) +1949258
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4845243
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&amp; c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:545
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection&amp; c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:533
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String script<b>
File, String&amp; ErrorMessage) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:510
BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:524
BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:21
BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:38
SqlPatch.StartButton_Click(Object sender, EventArgs e) in c:\domains\examreviewstore.com\wwwroot\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>

<HR color=silver][1]<FONT face=Verdana>Version Information:[/color] Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3614 [/1][/color]&lt;!--
[SqlException]: There is already an object named 'bvc_ProductXChoice' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.RunSingleStatement(String statement, SqlConnection& c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 545
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ParseSQLLines(String lines, SqlConnection& c) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 533
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile, String& ErrorMessage) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 510
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteSQL(SqlConnection conn, String scriptFile) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 524
at BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:line 21
at BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:line 38
at SqlPatch.StartButton_Click(Object sender, EventArgs e) in c:\domains\examreviewstore.com\wwwroot\SqlPatch.aspx.vb:line 9
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
[HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown.
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.sqlpatch_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--&gt;&lt;!--
This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using &lt;customErrors mode="Off"/&gt;. Consider using &lt;customErrors mode="On"/&gt; or &lt;customErrors mode="RemoteOnly"/&gt; in production environments.--&gt;
ttillman
#2 Posted : Tuesday, September 14, 2010 9:12:54 PM(UTC)
ttillman

Rank: Member

Joined: 4/10/2009(UTC)
Posts: 120
Location: Mechanicsville, VA

Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
Have you tried running the update scripts manually?


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.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012