Scenario:
System show error message as below during upgrade database.
Solution
1. Launch SSMS and connect to your database
https://support.qne.com.my/a/solutions/articles/81000385373
2. Click “New Query” button
3. Copy and paste below query
-- creditors
alter table creditors add PriceGroupId int null
-- debtors
alter table debtors add PriceGroupId int null
ALTER TABLE [dbo].[Debtors] WITH NOCHECK ADD CONSTRAINT [FK_Debtors_PriceGroupId] FOREIGN KEY([PriceGroupId])
REFERENCES [dbo].[PriceGroups] ([Id])
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[Debtors] CHECK CONSTRAINT [FK_Debtors_PriceGroupId]
GO
5. Re-launch QNE Optimum
6. Continue to upgrade database
** Learn more about Azure Cloud
** Learn more about QNE Hybrid Cloud Software
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article