who is active job failing
2017-03-01 19:56:38
Hi Experts ,
last 2 days my sp_whoisactive job failing .
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Violation of PRIMARY KEY constraint 'PK_WhoIsActive'. Cannot insert duplicate key in object 'monitoring.WhoIsActive'. The duplicate key value is (Mar 1 2017 1:55PM, 103). [SQLSTATE 23000] (Error 2627) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.
how do resolve that problem ?
Aaron Bertrand 2017-03-01 20:06:36
I don't really know that we can troubleshoot your job here – you have a primary key constraint on the table and sp_whoisactive is trying to violate that. This site is meant for getting help with optimizing queries through execution plan analysis.