who is active job failing

Kabir 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.