upgrade from mspcon...
 
Notifications
Clear all

upgrade from mspcontrol to solidcp error's ind the database script

3 Posts
3 Users
0 Likes
586 Views
Posts: 1
Topic starter
(@thekingofchaos)
New Member
Joined: 4 years ago

Hi we will like to migrate from mspcontrol 1.0 to solidcp
but then i run the db script i get thi errors
can you help me with the error and i this is expect

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_HostingPlanQuotas_1'. Cannot insert duplicate key in object 'dbo.HostingPlanQuotas'. The duplicate key value is (49, 701).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_HostingPlanQuotas_1'. Cannot insert duplicate key in object 'dbo.HostingPlanQuotas'. The duplicate key value is (49, 702).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_HostingPlanQuotas_1'. Cannot insert duplicate key in object 'dbo.HostingPlanQuotas'. The duplicate key value is (49, 703).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_HostingPlanQuotas_1'. Cannot insert duplicate key in object 'dbo.HostingPlanQuotas'. The duplicate key value is (49, 704).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_HostingPlanQuotas_1'. Cannot insert duplicate key in object 'dbo.HostingPlanQuotas'. The duplicate key value is (49, 705).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_HostingPlanQuotas_1'. Cannot insert duplicate key in object 'dbo.HostingPlanQuotas'. The duplicate key value is (49, 706).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_HostingPlanQuotas_1'. Cannot insert duplicate key in object 'dbo.HostingPlanQuotas'. The duplicate key value is (49, 707).
The statement has been terminated.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 2
The UPDATE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "FK_Quotas_ServiceItemTypes". The conflict occurred in database "mspcontrol", table "dbo.Quotas", column 'ItemTypeID'.
The statement has been terminated.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 3
The DELETE statement conflicted with the REFERENCE constraint "FK_Quotas_ServiceItemTypes". The conflict occurred in database "mspcontrol", table "dbo.Quotas", column 'ItemTypeID'.
The statement has been terminated.

(0 row(s) affected)
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.

(0 row(s) affected)
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.UsersDetailed', because it does not exist or you do not have permission.
Msg 2714, Level 16, State 3, Procedure SearchServiceItemsPaged, Line 2
There is already an object named 'SearchServiceItemsPaged' in the database.
Msg 547, Level 16, State 0, Line 3
The DELETE statement conflicted with the REFERENCE constraint "FK_HostingPlanQuotas_Quotas". The conflict occurred in database "mspcontrol", table "dbo.HostingPlanQuotas", column 'QuotaID'.
The statement has been terminated.

(3 row(s) affected)
Msg 547, Level 16, State 0, Line 2
The DELETE statement conflicted with the REFERENCE constraint "FK_Providers_ResourceGroups". The conflict occurred in database "mspcontrol", table "dbo.Providers", column 'GroupID'.
The statement has been terminated.

2 Replies
Posts: 1456
Admin
(@trobinson)
Noble Member
Joined: 8 years ago

Hello,

The current upgrade script doesn't cover the newer viewers of MSPControl due to the amount of database changes.

We hear from some users that they opted to to just setup SolidCP fresh and import the resources per user to avoid any issues or unknown conflicts which would be one of the methods (but time it takes varies per environment) .

Regards,

Trevor

Reply
Posts: 14
(@weafarside)
Active Member
Joined: 8 years ago

I have the exact same problem did you ever get this issue fixed ???

Reply
Share: