Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Error During Deployment: An error occurred while saving a project to the database. Cannot insert duplicate key in object.


Symptoms

When attempting to deploy a project within the Jet Data Manager you encounter the following error message:


Error during deployment: An error occurred while saving a project to the database. An error occurred while updating.  DataWarehouses Violation of PRIMARY KEY constraint 'PK_DataWarehouses'.  Cannot insert duplicate key in object 'dbo.DataWarehouses'.

Resolution

This error will only occur when you have multiple projects in the same project repository database.  It is caused by having more than one data warehouse with the same name in the Jet Data Manager.

To resolve, right-click on your data warehouse instance within the Jet Data Manager and select 'Edit Data Warehouse'


In the window that opens up, change the value for the 'Name' of your data warehouse.


Once changed, click 'OK' to continue.  You should now be able to deploy the project without issue.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments