Source: projects/identity-management/oim-kb-update/runs/2026-04-27-20.md

> Source: projects/identity-management/oim-kb-update/runs/2026-04-27-20.md

OIM KB Update — Run 2026-04-27 (20)

Focus: tighten the “product node creation + job/DBQueue mechanics” story with fresh live sandbox DB evidence (SELECT-only).

What I did

• Queried QBMDBQueueTask for QER-K-ShoppingRack% task configuration.
• Inspected QER_PITShopProductNodeCreate_b for:
• whether it references QBM_PJobCreate*
• where BaseTreeHasObject placement is performed
• Inspected trigger bodies for how QBM_PDBQueueInsert_Bulk vs ..._Single are chosen.

Key findings (live DB)

• ShoppingRack tasks are mostly bulk-enabled (QBMDBQueueTask.IsBulkEnabled = 1) and point at QER_ZITShop* procedures.
• QER_PITShopProductNodeCreate_b does call QBM_PJobCreate_HOUpdate (and also issues direct SQL updates).
• Triggers can decide at runtime between QBM_PDBQueueInsert_Single and ..._Bulk (e.g., ADS_TUAdsGroup uses a load threshold).

Evidence

• Sandbox DB evidence note:
• ../sandbox-db/2026-04-27-itshop-productnode-jobcreate-and-dbqueueinsert-db-evidence.md

Changes / safety

• Sandbox: SELECT-only SQL via scripts/sandbox/Invoke-SandboxSql.ps1 (no DML).