Skip to content

SMS_STATE_SYSTEM

Featured Replies

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,

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.



  • Author

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

  • 1 month later...
  • Author

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

  • 6 months later...

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.