SQL upgrade error 1.6.329 -> 1.6.339

Topics: General, Installing BugNET
Nov 30, 2014 at 7:21 PM
I've got this out of upgrading from 1.6.329 to 1.6.339. Do I need to take corrective actions?

Thank you.

Upgrading BugNET

Upgrade Status Report

Current Assembly Version: 1.6.339.0

Current Database Version: 1.6.329.0
00:00:00.0060003 - Upgrading To Version: 1.6.339.0
00:00:00.0300017 - Executing Script: 1.6.339.0.SqlDataProvider.sql Error!

Error Details

File 1.6.339.0.SqlDataProvider.sql
Error 'DF__BugNet_Us__Recei__56D3D912' is not a constraint. Could not drop constraint. See previous errors.

Upgrade Complete

Click Here To Access Your BugNET Installation____
Coordinator
Nov 30, 2014 at 10:23 PM
I've taken the release down. The autogenerated constraints will be different for each instance so I will have to revise the upgrade script. :(
Coordinator
Nov 30, 2014 at 11:06 PM
Dec 2, 2014 at 10:04 PM
I just manually run the updated sql script against my database and it completed with no errors. :)

(1 row(s) affected)
(1 row(s) affected)
Altering [dbo].[BugNet_DefaultValuesVisibility]...
Altering [dbo].[BugNet_DefaultValView]...
Refreshing [dbo].[BugNet_GetIssuesByProjectIdAndCustomFieldView]...
Refreshing [dbo].[BugNet_IssuesView]...
Refreshing [dbo].[BugNet_ProjectsView]...
Refreshing [dbo].[BugNet_UserView]...
Refreshing [dbo].[BugNet_IssueAssignedToCountView]...
Refreshing [dbo].[BugNet_IssueCommentsView]...
Altering [dbo].[BugNet_DefaultValues_Set]...
Altering [dbo].[BugNet_User_GetUsersByProjectId]...
Altering [dbo].[BugNet_ProjectCategories_CreateNewCategory]...
Altering [dbo].[BugNet_ProjectIssueTypes_CanDeleteIssueType]...
Altering [dbo].[BugNet_ProjectPriorities_CanDeletePriority]...
Altering [dbo].[BugNet_ProjectResolutions_CanDeleteResolution]...
Altering [dbo].[BugNet_ProjectStatus_CanDeleteStatus]...
Refreshing [dbo].[BugNet_DefaultValues_GetByProjectId]...
Refreshing [dbo].[BugNet_IssueAttachment_GetIssueAttachmentById]...
Refreshing [dbo].[BugNet_IssueAttachment_GetIssueAttachmentsByIssueId]...
Refreshing [dbo].[BugNet_IssueComment_GetIssueCommentById]...
Refreshing [dbo].[BugNet_IssueComment_GetIssueCommentsByIssueId]...
Refreshing [dbo].[BugNet_IssueHistory_GetIssueHistoryByIssueId]...
Refreshing [dbo].[BugNet_IssueNotification_GetIssueNotificationsByIssueId]...
Refreshing [dbo].[BugNet_IssueWorkReport_GetIssueWorkReportsByIssueId]...
Refreshing [dbo].[BugNet_Project_GetMemberRolesByProjectId]...
Refreshing [dbo].[BugNet_ProjectMailbox_GetMailboxById]...
Refreshing [dbo].[BugNet_ProjectMailbox_GetMailboxByProjectId]...
Refreshing [dbo].[BugNet_ProjectMailbox_GetProjectByMailbox]...
Refreshing [dbo].[BugNet_ProjectNotification_GetProjectNotificationsByProjectId]...
Refreshing [dbo].[BugNet_ProjectNotification_GetProjectNotificationsByUserName]...
Refreshing [dbo].[BugNet_Query_GetQueriesByUserName]...
Refreshing [dbo].[BugNet_User_GetUserNameByPasswordResetToken]...
Refreshing [dbo].[BugNet_Issue_GetIssueById]...
Refreshing [dbo].[BugNet_Issue_GetIssueCategoryCountByProject]...
Refreshing [dbo].[BugNet_Issue_GetIssueMilestoneCountByProject]...
Refreshing [dbo].[BugNet_Issue_GetIssuePriorityCountByProject]...
Refreshing [dbo].[BugNet_Issue_GetIssuesByAssignedUserName]...
Refreshing [dbo].[BugNet_Issue_GetIssuesByCreatorUserName]...
Refreshing [dbo].[BugNet_Issue_GetIssuesByOwnerUserName]...
Refreshing [dbo].[BugNet_Issue_GetIssuesByProjectId]...
Refreshing [dbo].[BugNet_Issue_GetIssuesByRelevancy]...
Refreshing [dbo].[BugNet_Issue_GetIssueStatusCountByProject]...
Refreshing [dbo].[BugNet_Issue_GetIssueTypeCountByProject]...
Refreshing [dbo].[BugNet_Issue_GetMonitoredIssuesByUserName]...
Refreshing [dbo].[BugNet_Issue_GetOpenIssues]...
Refreshing [dbo].[BugNet_IssueAttachment_ValidateDownload]...
Refreshing [dbo].[BugNet_Project_GetRoadMapProgress]...
Refreshing [dbo].[BugNet_ProjectCategories_GetCategoriesByProjectId]...
Refreshing [dbo].[BugNet_ProjectCategories_GetCategoryById]...
Refreshing [dbo].[BugNet_ProjectCategories_GetChildCategoriesByCategoryId]...
Refreshing [dbo].[BugNet_ProjectCategories_GetRootCategoriesByProjectId]...
Refreshing [dbo].[BugNet_Project_GetAllProjects]...
Refreshing [dbo].[BugNet_Project_GetProjectByCode]...
Refreshing [dbo].[BugNet_Project_GetProjectById]...
Refreshing [dbo].[BugNet_Project_GetProjectsByMemberUserName]...
Refreshing [dbo].[BugNet_Project_GetPublicProjects]...
Refreshing [dbo].[BugNet_Issue_GetIssueUserCountByProject]...
Update complete.