SOLVED Failed to delete Granular Client Settings Object

[rahlev]

Hi everyone,
I installed HP MIK on my SCCM to manage my Laptops.
At one point I added a client settings for TPM to manage both TPM and Bitlocker. In the end I never did use it.
Recently I upgraded my SCCM to 1910, and I found this client settings. Since it wasn't deployed I decided to delete it.
After a few hours I found this alert repeating itself every 30 minutes: "Failed to delete Granular Client Settings Object - SMS_OBJECT_REPLICATION_MANAGER". Looking closer at the log file I found this: "The DELETE statement conflicted with the REFERENCE constraint "DataItem_ActionID_FK". Digging a little deeper I ran an SQL query and found the deleted client settings and it is tombstoned.
Searching the error I found people saying I need Microsoft's help for this, which I cannot do.
Is there any way someone can help me with this without the need for Microsoft? My environment works fine and after 100 attempts SCCM disregarded the alert...

Thanks.

 

[Garth]

For all SQL related issues you really need to talk to MS support. If this go badly, you can blow you whole configmgr environment up. If this happens with MS support at least they will help fix the problem. Anyone else will just walk away.