Cannot insert duplicate key row in object 'dbo.SYSTEMROLEPERM_SMARTQUERY' with unique index 'UIX_SYSTEMROLEPERM_SMARTQUERY_SYSTEMROLEID_SMARTQUERYCATALOGID' when saving a smart query using a non-admin user

When editing user defined smart queries the following error occurs when logged in as a user who is not a system admin:

Cannot insert duplicate key row in object 'dbo.SYSTEMROLEPERM_SMARTQUERY' with unique index 'UIX_SYSTEMROLEPERM_SMARTQUERY_SYSTEMROLEID_SMARTQUERYCATALOGID'. The duplicate key value is (c71a4dd7-8285-45bb-a2f2-1cb1f816537b, 4e131026-8a7a-426d-bddd-ef86335f77ec).
The statement has been terminated.

The query itself will update accordingly but the error message is always thrown unless you have admin rights.
 We are currently evaluating this issue and will update this article when we have more information.

Environment

 3.0.516 Service Pack 8

Was this article helpful?