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

Notification

Icon
Error

smartdom
#1 Posted : Tuesday, March 23, 2010 12:10:26 PM(UTC)
smartdom

Rank: Member

Joined: 11/15/2006(UTC)
Posts: 52

Have an upgrade tool, SitePatchInstaller.exe, which takes a BVC 5 SP 2 site and upgrades it to SP 3.1


Got an error near the end of the upgrade, "Database scripts failed to run. Patch has been rolled back. Error Message: Violation of PRIMARY KEY constraint 'PK_bvc_WebAppSetting', cannot insert duplicate key in object 'dbo.bvc_WebAppSetting'"



I used this tool as prescribed. Anyone know the cause of this and a solution?
Marcus
#2 Posted : Tuesday, March 23, 2010 12:23:09 PM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Did you run any other upgrades/patches before this?
smartdom
#3 Posted : Tuesday, March 23, 2010 2:11:17 PM(UTC)
smartdom

Rank: Member

Joined: 11/15/2006(UTC)
Posts: 52

I understand the site was upgraded from BVC 5 SP 1 and this worked fine.
Marcus
#4 Posted : Wednesday, March 24, 2010 10:20:45 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

You can run the SQL scripts for the SP2 to SP3 patch in SQL Managment studio. This will tell you the exact error that is causing the problem. If you need assistance with the upgrade our Consulting Service would be happy to provide a quote OR you can contact one of the developer partners at www.bvsoftware.com/partners for a quote.
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