Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
Please help. . .
Installed 5.4 on the remote host (exisating store w/ existing database hosted on AppliedI), the sql patch prompt came up, clicked start and got the following message:
<H1>Server Error in '/' Application.
<HR width="100%" color=silver SIZE=1>
</H1>
<H2>Could not drop object 'dbo.bvc_Product' because it is referenced by a FOREIGN KEY constraint. </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) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +196
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +269
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 script<b>File, 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:29
SqlPatch.StartButton_Click(Object sender, EventArgs e) in D:\Domains\yayaimports.com\wwwroot\SqlPatch.aspx.vb:9
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) +1746
</PRE>[/code][/td][/tr]</TABLE>
<HR width="100%" color=silver][1]<FONT face=Verdana>Version Information:[/color] Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 [/1][/color]
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
We're having the same problem. We believe it is because the SQL scripts in the SP4 folder are empty files.
Aaron |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
Do you know if you guys got this fixed? I was planning on looking to do the upgrade but, now I am hesitant. =) |
|
|
|
|
|
|
Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
Not yet. i also sent an email over to bvsoftware, but no response yet.
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
We're looking into this. Can you tell me what version you're upgrading from? Any hot fixes installed? Any customizations?
|
|
|
|
|
|
Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
Upgrade from 5.3.2, No hotfixes installed, and no database customizations (we do have custom catalog & product pages, as well as custom.master pages.)
|
|
|
|
|
|
Rank: Member
Joined: 3/15/2007(UTC)
Posts: 126
|
I have seen this on 2 separate sites both running SP5.3.2 with all available hot fixes applied. |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
**** ISSUE RESOLVED AND NEW CODE IS IN YOUR ORDER FOR DOWNLOAD **** ** ONLY Use this if you had a failed install of yesterday's 5.4 patcher ** I've identified an issue with the installer and will be posting an updated patch utility tomorrow. If you want to proceed or are in the middle of a 5.3.2 to 5.4 install you can manually run the two attached SQL script s to bring the database up to speed. Run the Schemascript .sql file first, then Datascript .sql File Attachment(s):  DataScript.sql (7kb) downloaded 229 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
That seemed to do the trick for getting us live again. ( I have not gone as far as to check functionality of anything other than the site being up, and the ability to dynamically populate the site with data.)
Thank you for the prompt attention!
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
I just posted revision 4 of BV Commerce 5.4 to your orders. This should resolve the patcher issue that some of you were experiencing.
|
|
|
|
|
|
Rank: Member
Joined: 5/18/2005(UTC)
Posts: 38
|
Hi,
I received the same error when upgrading from BVC 5 SP2.
I tried using the sql scripts and received even more errors after.
Could you update my account with the latest sql patch utility?
Thanks
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
SteveB,
All accounts have been upgraded with the new patcher. It says "BV Commerce 5.4 Full and Upgrade (rev.a)"
|
|
|
|
|
|
Rank: Member
Joined: 5/18/2005(UTC)
Posts: 38
|
Marcus,
I downloaded the new installer (rev. 4) and tried it on the original site (restored from backup, including database) so it was at BVC5 SP2 (we never upgraded to SP3 for stability reasons).
We still get the same error
Could not drop object 'dbo.bvc_Product' because it is referenced by a FOREIGN KEY constraint
Please advise on how to upgrade database from SP2 to SP4
Thanks
|
|
|
|
|
|
Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
SteveB,
I also had problems when trying to use the upgraded 'rev. 4' installer on our second site. I ended up manually running the scripts (in SQL management studio expess, with a connection to our remote database) to update the database. For the files, I simply used an ftp client tool to upload the new files manually. For your situation, running the two scripts should fix the issue. (Be sure to backup your database first, just in case.)
Marcus,
I put my vote in to have future releases be the 'manual method' with just files and scripts, minus the fancy upgrade utility.
Thanks!
|
|
|
|
|
|
Rank: Member
Joined: 5/18/2005(UTC)
Posts: 38
|
Hi,
Mark
Unfortunately, I have tried this before with the manual scripts and had no luck. I received a bunch of errors about invalid column names and can't find objects.
I assume this is caused by the fact that the script assumes I have BVC 5 SP3 installed (I noticed the comment at the top from SQL Compare that said "[2]
(local).bv532 to bv54full")[/2], which I don't due to all the issues that SP had. If Marcus could create a SQL Compare script from bv52 to bv54full, that would probably help me.
I am still at 5 SP2 and want to upgrade to SP4. No luck..
|
|
|
|
|
|
Rank: Member
Joined: 5/18/2005(UTC)
Posts: 38
|
I got it working now, received an email from Marcus. All SP2 users read this:
After you download the latest update code, you must run the SQL files in order from sp3, 3.1, 3.2 and finally sp4 for it to work.
They are in the src/www/bvadmin/bvsql folder.
Thanks
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
Originally Posted by: "Marcus" 
**** ISSUE RESOLVED AND NEW CODE IS IN YOUR ORDER FOR DOWNLOAD ****
** ONLY Use this if you had a failed install of yesterday's 5.4 patcher **
I've identified an issue with the installer and will be posting an updated patch utility tomorrow.
If you want to proceed or are in the middle of a 5.3.2 to 5.4 install you can manually run the two attached SQL scripts to bring the database up to speed.
Run the Schemascript.sql file first, then Datascript.sql
What is the proper way to to run the SQl script s? I'm also working locally on a test site. Thanks |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
If you are having trouble patching from earlier versions of BV Commerce you can run the database patches manually.
There are folders in the 5.4 code under /bvadmin/sql/ Each version has its own folder. Find the version that you are currently running and then run all the patches after your version in sequence.
For example, If you have version SP2 installed you would run the patches in the SP3, SP31, SP32, SP4 folders in that order. Always run the SCHEMA scripts before the data populate scripts.
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
Marcus:
I'm on SP3.2 right now and had the problem. But i don't remember if i downloaded before or after you made an update. My download says Rev.4.
I'm also asking what is the proper way to run the scripts? |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 11/17/2008(UTC)
Posts: 6
|
I received this error, will try the running the scripts manually Code:Server Error in '/' Application.
--------------------------------------------------------------------------------
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near the keyword 'AND'.
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@Queries".
Must declare the scalar variable "@Queries".
Must declare the scalar variable "@Queries".
Must declare the scalar variable "@Queries".
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
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: Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near the keyword 'AND'.
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@SortBy".
Must declare the scalar variable "@Queries".
Must declare the scalar variable "@Queries".
Must declare the scalar variable "@Queries".
Must declare the scalar variable "@Queries".
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Incorrect syntax near '0x0a0d'.
Source Error:
Line 7: Protected Sub StartButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles StartButton.Click
Line 8: If Utilities.VersionHelper.SqlPatchNeeded() Then
Line 9: Utilities.VersionHelper.RunSqlPatch()
Line 10:
Line 11: 'Load all items
Source File: D:\Inetpub\ergonomicsalifestyle\SqlPatch.aspx.vb Line: 9
|
|
|
|
|
|
|
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.