Upgrade from 0.7.854

Topics: Installing BugNET
Sep 19, 2012 at 8:53 AM

This is the problem:

Upgrading BugNET

Upgrade Status Report

Current Assembly Version: 1.0.187.0

Current Database Version: 0.7.854.0

00:00:00.0090009 - Upgrading To Version: 1.0.187.0
00:00:00.0400040 - Creating Custom Field Views
00:00:00.2240224 - There was an issue creating the custom fields views for your project, please view the application log for more details
00:00:00.2250225 - You can manually re-generate the custom field views by going to the Project List page and using the generate feature along the top menu
00:00:00.2300230 - Executing Script: 0.7.880.0.SqlDataProvider.sql Success
00:00:01.1371137 - Executing Script: 0.8.140.0.SqlDataProvider.sql Error!

Error Details

File 0.8.140.0.SqlDataProvider.sql
Error The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BugNet_Issues_BugNet_ProjectMilestones". The conflict occurred in database "BugNet_Xlayers", table "dbo.BugNet_ProjectMilestones", column 'MilestoneId'.



00:00:22.0952093 - Executing Script: 0.8.167.0.SqlDataProvider.sql Error!

Error Details

File 0.8.167.0.SqlDataProvider.sql
Error Invalid object name 'dbo.BugNet_StringResources'.



00:00:22.1022100 - Executing Script: 0.8.185.0.SqlDataProvider.sql Error!

Error Details

File 0.8.185.0.SqlDataProvider.sql
Error Cannot find the object "BugNet_ProjectMilestones" because it does not exist or you do not have permissions.



00:00:22.1122110 - Executing Script: 0.8.188.0.SqlDataProvider.sql Error!

Error Details

File 0.8.188.0.SqlDataProvider.sql
Error Cannot find the object "BugNet_ProjectMilestones" because it does not exist or you do not have permissions.



00:00:22.1182116 - Executing Script: 0.8.193.0.SqlDataProvider.sql Error!

Error Details

File 0.8.193.0.SqlDataProvider.sql
Error Cannot find the object "BugNet_RequiredFieldList" because it does not exist or you do not have permissions.



00:00:22.1232121 - Executing Script: 0.8.221.0.SqlDataProvider.sql Error!

Error Details

File 0.8.221.0.SqlDataProvider.sql
Error Cannot find the object "dbo.BugNet_Projects" because it does not exist or you do not have permissions.



00:00:22.1332131 - Executing Script: 0.8.250.0.SqlDataProvider.sql Error!

Error Details

File 0.8.250.0.SqlDataProvider.sql
Error Invalid object name 'BugNet_UserProfiles'.



00:00:22.1382136 - Executing Script: 0.8.270.0.SqlDataProvider.sql Error!

Error Details

File 0.8.270.0.SqlDataProvider.sql
Error Invalid object name 'dbo.BugNet_Issue_GetIssueUserCountByProject'.



00:00:22.1472145 - Executing Script: 0.8.273.0.SqlDataProvider.sql Error!

Error Details

File 0.8.273.0.SqlDataProvider.sql
Error Cannot find the object "BugNet_UserProfiles" because it does not exist or you do not have permissions.



00:00:22.1522150 - Executing Script: 0.8.276.0.SqlDataProvider.sql Error!

Error Details

File 0.8.276.0.SqlDataProvider.sql
Error Invalid object name 'dbo.BugNet_ProjectCustomFields'.



00:00:22.1592157 - Executing Script: 0.8.284.0.SqlDataProvider.sql Error!

Error Details

File 0.8.284.0.SqlDataProvider.sql
Error Invalid object name 'dbo.BugNet_ProjectCustomFields'.



00:00:22.1682166 - Executing Script: 0.8.295.0.SqlDataProvider.sql Error!

Error Details

File 0.8.295.0.SqlDataProvider.sql
Error Invalid object name 'BugNet_StringResources'.



00:00:22.1772175 - Executing Script: 0.8.300.0.SqlDataProvider.sql Error!

Error Details

File 0.8.300.0.SqlDataProvider.sql
Error Invalid object name 'dbo.BugNet_UserProfiles'.



00:00:22.1862184 - Executing Script: 0.9.126.0.SqlDataProvider.sql Error!

Error Details

File 0.9.126.0.SqlDataProvider.sql
Error Cannot find the object "dbo.BugNet_ProjectCategories" because it does not exist or you do not have permissions.



00:00:22.1942192 - Executing Script: 0.9.142.0.SqlDataProvider.sql Error!

Error Details

File 0.9.142.0.SqlDataProvider.sql
Error Cannot find the object "dbo.BugNet_UserProjects" because it does not exist or you do not have permissions.



00:00:22.1982196 - Executing Script: 0.9.152.0.SqlDataProvider.sql Error!

Error Details

File 0.9.152.0.SqlDataProvider.sql
Error Invalid object name 'dbo.BugNet_IssueNotification_GetIssueNotificationsByIssueId'.



00:00:22.2042202 - Executing Script: 1.0.187.0.SqlDataProvider.sql Error!

Error Details

File 1.0.187.0.SqlDataProvider.sql
Error Invalid object name 'dbo.BugNet_UserProfiles'.





Error: Database Error

Upgrade Failed!

Thank you in advanced..

Developer
Sep 19, 2012 at 12:32 PM

It looks like you have some custom tables in your database (BugNet_Xlayers).

The issue is you probably have FK relations from your custom tables to bugnet tables, not sure what the script does but you may have to remove the relations from your custom tables to the bugnet tables run the update and then restore your relations after the update is done.  You can usee the Diagrams in the Management Studio to see what the relations are and delete/add them from there.

Hope that helps
- William