SMS_STATE_SYSTEM

[boyjaew2]

SCCM 2012 SP1 Beta

SQL 2012

Server 2012

Stand alone primary

 

I am NOT a SQL guy and I am getting a persistent and vague error on my sccm 2012 server.

 

 

"Microsoft SQL Server reported SQL message 8672, severity 16: [42000][8672][Microsoft]

[sql Server]The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the" 

Message ID: 620

Process ID: 2232

Thread ID: 4920

I get an error about every 6 minutes or so.

What I have read so far indicates a possible duplication in a table somewhere. What my SQL people have told me is "looks like there's an error somewhere". Then tell me you have to know the table your looking for and that even if you find it there will be nothing obvious to tell you what needs to be fixed let alone HOW to fix it.

So, I'm super stuck. I know next to nothing about SQL, but if some one has seen this before, if you could help me out that would be great! I have tried simply clearing the counter. I'm sure you can imagine how much that helped.

Thanks,

[GarthMJ]

Since this is clearly an lab setup. Beta version are not support to be installed in product so….

I would re-install CM12 with the released version of CM12 SP1.

[boyjaew2]

Was able to have a DBA dig this up. I don't know if it helps me much, but could it have something to do with my "Delete Aged Endpoint Protection Health Status History Data" Site maintenance task? Keeping in mind the above comment of course.

 

 

 

 

-- Stored procedure throwing the error

spSummaryTaskEPSecurityHealthDashboard

 

-- Gets a list of Collections and
Clients from:

SELECT *

FROM vEPCollections

-- and

SELECT *

FROM CollectionMembers

 

-- Performs MERGE statements against
these 5 tables

SELECT *

FROM EP_EndpointProtectionHealthStatus

 

SELECT *

FROM EP_EndpointProtectionHealthStatus_History

 

SELECT *

FROM EP_TopThreats

 

SELECT *

FROM EP_ThreatPath

 

SELECT *

FROM EP_ThreatCleanActionState

[boyjaew2]

This error has returned. System has not changed. I will try what I did before, but any input would be great. Thanks

[Kevin79]

Sorry to dig up such an old thread but I am having same issue except my environment is different.

 

SCCM 2012 SP1 with CU2

Server 2008 R2 SP1

SQL Server 2008 R2 SP1