HP MIK - Client Settings cannot be removed

[KalinTashev]

Hello,

We've started using the HP MIK mostly to update drivers and patch password protected BIOS on workstations. This works as expected - it's integrated with CfgMgr, the HP MIK Client is pushed to the workstations (~5000 laptops and desktops) and the HP drivers and BIOS is getting updated on the workstations.

Apart of allowing us to update HP drivers, software and BIOS via HP Patch Assistant, HP MIK allows us to manage various BIOS settings and BIOS authentication. Once such BIOS policies are configured, this creates configuration items in CfgMgr, which are included in configuration baselines, and they get deployed to the target device collections together with the CfgMgr client setting that HP MIK creates.

We 've created two policies - one for BIOS settings and one for BIOS authentication. We've then decided to focus purely on HP Patch Assistant and deleted the HP BIOS configuration and authentication policies.This introduced the following issue on the CfgMgr SQL backend:

Microsoft SQL Server reported SQL message 547, severity 16:

[23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]

The DELETE statement conflicted with the REFERENCE constraint "DataItem_ActionID_FK". The conflict occurred in database "CM_XXX", table "dbo.DataItem", column 'ActionID'. : ClientAgentProp

Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

We have traced it back to the two client settings created for the two policies - they are deleted from the CfgMgr console but cannot be deleted from the SQL backend. This is evident in the priority ID of the CfgMgr Client settings:

Notice the gap between 6 and 9 - if I create a new client setting, it will get priority 10, as 7 and 8 are locked.

No information anywhere on internet on how to resolve such issues, I've been on the phone with HP Consumer support - after more than a month, they referred me to HP Enterprise, as the product is installed on a server.

I've tried to reach out to HP Enterprise Support and after 10 attempts, I finally got through to be told that I need to reach out to HP Consumer Support, as the CfgMgr primary site server is not an HP server, it's a VM.

HP Support is not helpful at all on this occasion, I will hold off to pour out all my thoughts on the subject.

Anyone has any ideas or perhaps if HP sees this, reach out to me and provide support for their own product which introduced the issue?

Screenshot of the data table.

Screenshot from dbo.ClientSettings that shows the entries in question:

Manually deleting in SQL Management Studio results in the same error:

objreplmgr.log

***** Processing Granular Client Settings Object {33A75842-0DFE-46BB-A319-08C1804F5533} ***** SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Successfully processed Granular Client Settings Object {33A75842-0DFE-46BB-A319-08C1804F5533} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777258 and UniqueID='{33A75842-0DFE-46BB-A319-08C1804F5533}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "DataItem_ActionID_FK". The conflict occurred in database "CM_***", table "dbo.DataItem", column 'ActionID'. : ClientAgentProperty_Value_del SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777258 and UniqueID='{33A75842-0DFE-46BB-A319-08C1804F5533}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [HY007][0][Microsoft][SQL Server Native Client 11.0]Associated statement is not prepared SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Failed to delete Granular Client Settings Object {33A75842-0DFE-46BB-A319-08C1804F5533} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Found notification file Program Files\Microsoft Configuration Manager\inboxes\objmgr.box\16777259.GCS SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Using local site's SCF for default client component settings SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

***** Processing Granular Client Settings Object {CFACBB7D-92D9-4889-B3D7-6C47FD9FA406} ***** SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Successfully processed Granular Client Settings Object {CFACBB7D-92D9-4889-B3D7-6C47FD9FA406} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777259 and UniqueID='{CFACBB7D-92D9-4889-B3D7-6C47FD9FA406}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "DataItem_ActionID_FK". The conflict occurred in database "CM_***", table "dbo.DataItem", column 'ActionID'. : ClientAgentProperty_Value_del SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777259 and UniqueID='{CFACBB7D-92D9-4889-B3D7-6C47FD9FA406}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [HY007][0][Microsoft][SQL Server Native Client 11.0]Associated statement is not prepared SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Failed to delete Granular Client Settings Object {CFACBB7D-92D9-4889-B3D7-6C47FD9FA406} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Found notification file Program Files\Microsoft Configuration Manager\inboxes\objmgr.box\16777260.GCS SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Using local site's SCF for default client component settings SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

***** Processing Granular Client Settings Object {1D19B6D5-F4EC-490D-96D8-CE56B2CA940D} ***** SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Successfully processed Granular Client Settings Object {1D19B6D5-F4EC-490D-96D8-CE56B2CA940D} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777260 and UniqueID='{1D19B6D5-F4EC-490D-96D8-CE56B2CA940D}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "DataItem_ActionID_FK". The conflict occurred in database "CM_***", table "dbo.DataItem", column 'ActionID'. : ClientAgentProperty_Value_del SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777260 and UniqueID='{1D19B6D5-F4EC-490D-96D8-CE56B2CA940D}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [HY007][0][Microsoft][SQL Server Native Client 11.0]Associated statement is not prepared SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Failed to delete Granular Client Settings Object {1D19B6D5-F4EC-490D-96D8-CE56B2CA940D} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Found notification file Program Files\Microsoft Configuration Manager\inboxes\objmgr.box\16777261.GCS SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Using local site's SCF for default client component settings SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

***** Processing Granular Client Settings Object {75A97171-8ACF-43F0-A525-2583762BD9C5} ***** SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Successfully processed Granular Client Settings Object {75A97171-8ACF-43F0-A525-2583762BD9C5} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777261 and UniqueID='{75A97171-8ACF-43F0-A525-2583762BD9C5}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "DataItem_ActionID_FK". The conflict occurred in database "CM_***", table "dbo.DataItem", column 'ActionID'. : ClientAgentProperty_Value_del SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** delete ClientSettings where ID=16777261 and UniqueID='{75A97171-8ACF-43F0-A525-2583762BD9C5}' SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

*** [HY007][0][Microsoft][SQL Server Native Client 11.0]Associated statement is not prepared SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)

Failed to delete Granular Client Settings Object {75A97171-8ACF-43F0-A525-2583762BD9C5} SMS_OBJECT_REPLICATION_MANAGER 12/05/2023 12:08:23 3884 (0x0F2C)