Primary Key Violation

Question

Primary Key Violation

3ricb4nk opened this issue 3 years ago · 11 comments

Violation of PRIMARY KEY constraint 'pk_sqlwatch_logger_perf_procedure_stats'. I get this error on a brand new installation when the SQLWATCH-LOGGER-PROCS job tries to run. From the very first time.

Answer 1 · 2021-10-21T21:24:58.000Z

what version?

Answer 2 · 2021-10-21T21:25:45.000Z

Are you able to run the code from the procedure in a way that will show you the dataset in the SSMS so we can understand where the violation is coming from?

Answer 3 · 2021-10-21T21:26:53.000Z

Sorry, version is 4.3.0.23725.20210721131116

Answer 4 · 2021-10-21T21:28:32.000Z

I can run the proc so that it returns a result set, yes. What format would you like it saved to?

Answer 5 · 2021-10-21T21:36:06.000Z

CSV, XLS, whatever is easier for you.

Answer 6 · 2021-10-21T21:37:37.000Z

Here's an excel version of the results that usp_sqlwatch_logger_procedure_stats returns. The error from sqlagent is this:

Executed as user: DCSDK12\sqlsvrsvc. Violation of PRIMARY KEY constraint 'pk_sqlwatch_logger_perf_procedure_stats'. Cannot insert duplicate key in object 'dbo.sqlwatch_logger_perf_procedure_stats'. The duplicate key value is (ITS-SQLCLUS\SQLCLUSDEV, 14, 317, 2021-10-21 21:30:31, 27, Oct 19 2021 8:06PM). [SQLSTATE 23000] (Error 2627). The step failed
SQLWatch_Logger_Procedure_Stats.xlsx
.

Answer 7 · 2021-10-21T21:39:47.000Z

Thanks, let me review and I will come back to you

Answer 8 · 2021-10-21T21:44:32.000Z

Many thanks.

Answer 9 · 2021-11-15T13:58:38.000Z

Any ideas, thoughts, comments?

Answer 10 · 2021-11-15T16:46:21.000Z

Hi, apologies, swamped with other priorities. It's still on my to do list.

Answer 11 · 2024-05-06T15:44:19.000Z

Hello @marcingminski. By any chance this error still has no solution?