Cannot insert duplicate key row in object 'dbo.sqlwatch_meta_procedure' with unique index 'idx_sqlwatch_meta_procedure_1'.

[sozezzo]

Describe the bug We use a Central Repository for many SqlWatch databases.

There is job 'SQLWATCH-[dbaWatch]-INTERNAL-CONFIG' that fail on step 9 'dbo.usp_sqlwatch_internal_add_procedure'

Date		2021-06-11 11:00:27 AM
Log		Job History (SQLWATCH-[dbaWatch]-INTERNAL-CONFIG)

Step ID		9
Server		SQL-DB3
Job Name		SQLWATCH-[dbaWatch]-INTERNAL-CONFIG
Step Name		dbo.usp_sqlwatch_internal_add_procedure
Duration		00:00:00
Sql Severity	14
Sql Message ID	2601
Operator Emailed	
Operator Net sent	
Operator Paged	
Retries Attempted	0

Message
Executed as user: Contoso\UserSqlWatch. Cannot insert duplicate key row in object 'dbo.sqlwatch_meta_procedure' 
with unique index 'idx_sqlwatch_meta_procedure_1'. 
The duplicate key value is (SQL-DB3, 1, Ad-Hoc Query 3FBE6AA6). [SQLSTATE 23000] (Error 2601).  The step failed.`

To Reproduce There are the same databases on many different servers and use a Central Repository. The error only happens in the Central repository.

FIX

WHERE sql_instance = @sql_instance -- fix error : Cannot insert duplicate key row in object 'dbo.sqlwatch_meta_procedure' with unique index 'idx_sqlwatch_meta_procedure_1'.