Hello everyone,
I’m trying to create a new instance of an existing database but I get an exception with the following error.
Kindly assist
Violation of PRIMARY KEY constraint 'UPHistory_PK'. Cannot insert duplicate key in object 'dbo.UPHistory'. The duplicate key value is (5).
The statement has been terminated.
--------------------------------------
Inner Exception:
Violation of PRIMARY KEY constraint 'UPHistory_PK'. Cannot insert duplicate key in object 'dbo.UPHistory'. The duplicate key value is (5).
The statement has been terminated.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/87e8e21e-f628-45ca-ace8-ac08e0a7028c.png)
From the database this is how the situation looks like;
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/db337c8d-df51-412d-bceb-e835c6ac16c7.png)
NB:database was moved to a different server.
Any kind of response will be highly appreciated
Best answer by Manikanta Dhulipudi
View original