ERROR: Failed to offer the client upgrade package program. Error: 3.

Question

*** [23000][547][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "ProgramOffers_L_PkgID_FK". The conflict occurred in database "CM_SMC", table "dbo.SMSPackages_L", column 'PkgID'. : tr_ProgramOffers_ins SMS_HIERARCHY_MANAGER 07/02/2025 9:09:23 AM 7984 (0x1F30)

ERROR: Failed to offer the client upgrade package program. Error: 3. SMS_HIERARCHY_MANAGER 07/02/2025 9:09:23 AM 7984 (0x1F30)

Error: Failed to advertise the client upgrade program. SMS_HIERARCHY_MANAGER 07/02/2025 9:09:23 AM 7984 (0x1F30)

Waiting for Configuration Manager Client Upgrade changes for maximum 3382 seconds... SMS_HIERARCHY_MANAGER 07/02/2025 9:09:23 AM 7984 (0x1F30)

CheckPinResetCertificate() - start the pin reset certificate check task SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

Pin reset cert scan threshold is not met yet. SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

HandleRBACPermissions : Check if there is request. SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

End sync rbac permissions. SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

Update site server active directory information into DB SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

Skipping feature exposure validation as it was recently run SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

returned public key [0602000000A400005253413100080000010001005134DB1F78EEBF24827F8D48...] SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

Wait for site control changes for maximum 3600 seconds... SMS_HIERARCHY_MANAGER 07/02/2025 9:09:26 AM 8120 (0x1FB8)

Loaded client upgrade settings from DB successfully. FullClientPackageID=SMC00003, StagingClientPackageID=SMC00007, ClientUpgradePackageID=SMC00169, PilotingUpgradePackageID=SMC00008, ClientUpgradeAdvertisementID=SMC20115, ClientPilotingAdvertisementID=(null) SMS_HIERARCHY_MANAGER 07/02/2025 9:09:28 AM 7984 (0x1F30)

No pending client binaries update needed for the current update package. SMS_HIERARCHY_MANAGER 07/02/2025 9:09:28 AM 7984 (0x1F30)

Answer 1

Hi, @Ahmed Shahzad Ashraf, Consultant

Thank you for posting in Microsoft Q&A forum.

Could you give a short description of the problem you're experiencing? Are you upgrading your SCCM version? Or just see the error messages in the log?

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".