Error: “Data could not be saved. Cannot insert duplicate key row in object ‘dbo.ADHOCQUERYFOLDERDEFAULTQUERYROLE’ -when moving ad-hoc queries from one environment to another

Error: “Data could not be saved. Cannot insert duplicate key row in object ‘dbo.ADHOCQUERYFOLDERDEFAULTQUERYROLE’ with unique index ‘UIX_ADHOCQUERYFOLDERDEFAULTQUERYROLE_SYSTEMROLEID_ADHOCQYERYFOLDERID_PERMEISSIONTYPECODE’ when moving Ad-Hoc queries from one environment to another using Configuration Manager.

We are currently evaluating this issue and will update this article when we have more information.

Environment

 3.0.516, patch 37

Was this article helpful?