Source: projects/identity-management/oim-kb-update/sandbox-host/2026-04-27-itshop-productnode-jobcreate-and-dbqueueinsert-file-evidence.md
> Source: projects/identity-management/oim-kb-update/sandbox-host/2026-04-27-itshop-productnode-jobcreate-and-dbqueueinsert-file-evidence.md
Sandbox Host Evidence — Shipped IT Shop SQL references (ProductNode + JobCreate + DBQueueInsert) (2026-04-27)
Source: sandbox host filesystem (WinRM HTTP 5985), OneIM 10 installation media under:
C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL
This is a grep-style evidence capture: file paths + line numbers where key strings appear.
Search hits
Pattern Line Path Text
------- ---- ---- ----
AccProductInBaseTree 7229 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\ModuleContent.xml <V Id="1107DB2B">AccProductInBaseTree</V>
AccProductInBaseTree 53061 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\ModuleContent.xml <V Id="8D9AF1C7">QER-T-AccProductInBaseTree</V>
AccProductInBaseTree 644 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\StartupContent.xml <V Id="1107DB2B">AccProductInBaseTree</V>
AccProductInBaseTree 2328 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\StartupContent.xml <V Id="3DF2675D">exists (select top 1 1 from BaseTree y where y.UID_Org = AccProductInBaseTree.UID_Org and y.UID_OrgRoo…
AccProductInBaseTree 4389 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\StartupContent.xml <V Id="73016E36">exists (select top 1 1 from BaseTree y where y.UID_Org = AccProductInBaseTree.UID_Org and y.UID_OrgRoo…
AccProductInBaseTree 5320 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\StartupContent.xml <V Id="8D9AF1C7">QER-T-AccProductInBaseTree</V>
AccProductInBaseTree 7498 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\StartupContent.xml <V Id="C60CE899">exists (select top 1 1 from BaseTree y where y.UID_Org = AccProductInBaseTree.UID_Org and y.UID_OrgRoo…
AccProductInBaseTree 7987 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\StartupContent.xml <V Id="CE930227">exists (select top 1 1 from BaseTree y where y.UID_Org = AccProductInBaseTree.UID_Org and y.UID_OrgRoo…
AccProductInBaseTree 275 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Generate\00000000QERHandleRelation.sql exec MDK_PRelationshipDefine 'R/1641', 'QER', '', 'BaseTree', 'AccProductInBaseTree', '1', 'DC', 'T', 0, '*', …
AccProductInBaseTree 281 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Generate\00000000QERHandleRelation.sql exec MDK_PRelationshipDefine 'R/1643', 'QER', '', 'AccProduct', 'AccProductInBaseTree', '1', 'DC', 'T', 0, '*'…
AccProductInBaseTree 62 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Generate\00000000QERTableDef.sql Create Table AccProductInBaseTree ( UID_Org varchar(38) NOT NULL, UID_AccProduct varchar(38) NOT NULL, XDateInserted da…
QBM_PDBQueueInsert_Bulk 330 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql into @DBQueueElements_ModifiedHelper(Object, SubObject, GenProcID) select p.UID_PersonWantsOrg, null, p.GenProcID from …
QBM_PDBQueueInsert_Bulk 336 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql where (c.makeEmpty = 0 and (isnull(o.IsToDelete, 0) = 1 or isnull(n.IstoInsert, 0) = 1 ) ) or n.UID_PersonWantsOrg is n…
QBM_PDBQueueInsert_Bulk 381 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql ) begin exec QBM_PDBQueueInsert_Bulk 'CPL-K-ShoppingRackMakeDecisionOC', @DBQueueElements_MakeDecisionOC end if exists …
QBM_PDBQueueInsert_Bulk 382 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql ) begin exec QBM_PDBQueueInsert_Bulk 'CPL-K-ShoppingRackMakeDecisionOH', @DBQueueElements_MakeDecisionOH end …
QBM_PDBQueueInsert_Bulk 397 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql in ( 'OrderProlongate' , 'OrderUnsubscribe') ) exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMakeDecisionEX', @DBQue…
QBM_PDBQueueInsert_Bulk 35 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFillAll.sql @PWOTaskToUse and q.Object = x.uid and q.Generation >= 0 ) exec QBM_PDBQueueInsert_Bulk @PWOTaskToUse, @DBQueueElement…
QBM_PDBQueueInsert_Bulk 35 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheck.sql , @CfgUseGenProcID) as GenProcID from personwantsorg pwo where pwo.OrderState in ( 'OrderProduct') and pwo.validUntil <…
QBM_PDBQueueInsert_Bulk 39 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheck.sql () or h.NextAutomaticDecision < getutcdate() ) and pwo.UID_QERWorkingMethod > ' ' ) as x exec QBM_PDBQueueInsert_Bulk …
QBM_PDBQueueInsert_Bulk 48 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheck.sql ,isnull(MAX(h1.XDateInserted), '1899-12-30')) < GETUTCDATE() ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackCh…
QBM_PDBQueueInsert_Bulk 47 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql > 0 group by x.UID_PersonWantsOrg, x.GenProcID if @@ROWCOUNT > 0 begin exec QBM_PDBQueueInsert_Bulk @Task36443, @DBQueu…
QBM_PDBQueueInsert_Bulk 100 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql ('QER\ITShop\DecisionOnInsert') > ' ' ) ) exec QBM_PDBQueueInsert_Bulk @UID_Task, @DBQueueElements_spezial if @Debug…
QBM_PDBQueueInsert_Bulk 62 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckMethodBO.sql as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackProductNode', @DBQueueElements_01 if @CountItems > 0 begin exec QB…
QBM_PDBQueueInsert_Bulk 34 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckStructure.sql b on b.uid_parentorg = s.uid_org and b.ITShopInfo = 'BO' ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMethod'…
QBM_PDBQueueInsert_Bulk 41 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckStructure.sql b on b.uid_parentorg = s.uid_org and b.ITShopInfo = 'BO' join BaseTree p on p.uid_parentorg = b.uid_org and p.ITShopInf…
QBM_PDBQueueInsert_Bulk 57 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopHelperFill_Recalc.sql -- 33082 hier haben wir uns wohl die Karten gelegt durch das Abschalten des CheckForExisting im QBM_PDBQueueInsert_Bulk
QBM_PDBQueueInsert_Bulk 66 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopHelperFill_Recalc.sql into @DBQueueElements_01 (object, subobject, genprocid) exec sp_executesql @SQLcmd exec QBM_PDBQueueInsert_Bulk @PWOTas…
QBM_PDBQueueInsert_Bulk 72 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopHelperFill_Recalc.sql q with (nolock) where q.UID_Task = @PWOTaskToUse and q.Object = x.uid and q.Generation >= 0 ) exec QBM_PDBQueueInsert_…
QBM_PDBQueueInsert_Bulk 58 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopOrderReset.sql from @DBQueueCurrent p ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackPWOHelperPWO', @DBQueueElements_01 exec…
QBM_PDBQueueInsert_Bulk 46 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_PPersonHasObjectPostProc.sql > ' ' ) as y exec QBM_PDBQueueInsert_Bulk @UID_TaskForMasterIdentity, @DBQueueElements_01 end END TRY BEGIN CATCH exec …
QBM_PDBQueueInsert_Bulk 33 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllChildrenOfOrg.sql bu where bu.ElementIndex = @ElementIndex exec QBM_PDBQueueInsert_Bulk @taskname, @DBQueueElements_01 select @ElementIn…
QBM_PDBQueueInsert_Bulk 44 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql s on s.UID_AERoleFallBack = cu.UID2 join PWOHelperPWO h on h.UID_QERWorkingStep = s.UID_QERWorkingStep if @@ROWCOUNT >…
QBM_PDBQueueInsert_Bulk 49 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql from @EntryAll d join BaseTree b on d.UID2 = b.uid_org where b.uid_orgroot = 'QER-V-AERole' ) as x exec QBM_PDBQueueIn…
QBM_PDBQueueInsert_Bulk 62 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql QBM_PDBQueueInsert_Bulk 'QER-K-AllForOnePerson', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw inse…
QBM_PDBQueueInsert_Bulk 63 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql , subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct d.UID1 as uid, d.UID3 as GenProcID from…
QBM_PDBQueueInsert_Bulk 67 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMemberDel', @DBQueueElements_05 end declare @ElementNacharbe…
QBM_PDBQueueInsert_Bulk 91 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql 1 1 from BaseTree o where o.UID_AERoleManager = pio.UID2 ) ) as x select @UID_TaskFollow = 'QER-K-HelperHeadOrg' exec …
QBM_PDBQueueInsert_Bulk 83 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZDynamicGroupMakeTrigger.sql exec QBM_PDBQueueInsert_Bulk ''QER-K-DynamicGroupSingleBasic'', @DBQueueElements_detail
QBM_PDBQueueInsert_Bulk 103 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZDynamicGroupMakeTrigger.sql exec QBM_PDBQueueInsert_Bulk ''QER-K-DynamicGroupTest'', @DBQueueElements_full
QBM_PDBQueueInsert_Bulk 30 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZDynGroupSingleHardware.sql q.UID_Task = 'QER-K-DynamicGroupTest' and q.Object = dg.UID_DynamicGroup and q.Generation >= 0 ) exec QBM_PDBQueueInse…
QBM_PDBQueueInsert_Bulk 34 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZDynGroupSinglePerson.sql GenProcID) select d.UID_DynamicGroup, null, @GenProcID from DynamicGroup d where d.UID_DialogTableObjectClass = 'QER-T-…
QBM_PDBQueueInsert_Bulk 39 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZDynGroupSinglePerson.sql 0 ) exec QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupSingleBasic', @DBQueueElements_01 end END TRY BEGIN CATCH exec QBM_…
QBM_PDBQueueInsert_Bulk 30 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZDynGroupSingleWorkdesk.sql q.UID_Task = 'QER-K-DynamicGroupTest' and q.Object = dg.UID_DynamicGroup and q.Generation >= 0 ) exec QBM_PDBQueueInse…
QBM_PDBQueueInsert_Bulk 29 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql '___-%' ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-OrgROOT', @DBQueueElements_01 declare @DBQueueElements_02 QBM_Y…
QBM_PDBQueueInsert_Bulk 31 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql 'QBM_PBufferT_Process%' and y.UID_Org like '___-%' and y.XDateUpdated > GETUTCDATE() -1 ) as x exec QBM_PDBQueueInsert…
QBM_PDBQueueInsert_Bulk 32 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql exec QBM_PDBQueueInsert_Bulk 'QER-K-BaseTreeCollectionF', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueue…
QBM_PDBQueueInsert_Bulk 35 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql hm where hm.UID_Org like '___-%' and hm.XUserUpdated like 'QBM_PBufferT_Process%' and hm.XDateUpdated > GETUTCDATE() -1…
QBM_PDBQueueInsert_Bulk 45 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql where a.UID_AccProduct = y.UID_AccProduct and ch.XUserUpdated like 'QBM_PBufferT_Process%' and ch.XDateUpdated > GETUTC…
QBM_PDBQueueInsert_Bulk 50 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql x exec QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg', @DBQueueElements_05 update PWODecisionSubMethod set Revision…
QBM_PDBQueueInsert_Bulk 54 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql and y.XDateUpdated > GETUTCDATE() -1 ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-AccProductGroupCollection', @DBQueueEle…
QBM_PDBQueueInsert_Bulk 64 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql like 'QBM_PBufferT_Process%' and y.UID_Org like '___-%' and y.XDateUpdated > GETUTCDATE() -1 ) as x exec QBM_PDBQueue…
QBM_PDBQueueInsert_Single 30 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill_Recalc.sql m.ObjectKey = p.ObjectKey1 and m.ProcessState = 0 ) if exists (select top 1 1 from @Parameter where Ident1 = 'I') begin…
QBM_PDBQueueInsert_Single 31 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill_Recalc.sql 'QER-K-ShoppingRackPWOHelperPWO-Rec', null, null, @GenProcID end if exists (select top 1 1 from @Parameter where Ident1…
QBM_PDBQueueInsert_Single 27 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_POrderUnreachableClose.sql ('') exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-ShoppingRackCheckDecision', '', @GenProcID END TR…
QBM_PDBQueueInsert_Single 62 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckMethodBO.sql as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackProductNode', @DBQueueElements_01 if @CountItems > 0 begin exec QB…
QBM_PDBQueueInsert_Single 33 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckMethodPR.sql exec QBM_PDBQueueInsert_Single 'QER-K-ShoppingRackPWODecisionMaker', '', '', @GenProcID end END TRY BEGIN CATCH exec QB…
QBM_PDBQueueInsert_Single 47 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopDeleteClosed.sql end exec QBM_PDBQueueInsert_Single 'QER-K-ITShopDeleteClosed', '', '', @GenProcID goto EndLabel end if @ProcessState_P…
QBM_PDBQueueInsert_Single 54 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopDeleteClosed.sql = @MaximumRowcount begin exec QBM_PDBQueueInsert_Single 'QER-K-ITShopDeleteClosed', '', '', @GenProcID if @DebugSwitch …
QBM_PDBQueueInsert_Single 60 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopDeleteClosed.sql >= @MaximumRowcount begin exec QBM_PDBQueueInsert_Single 'QER-K-ITShopDeleteClosed', '', '', @GenProcID if @DebugSwitch…
QBM_PDBQueueInsert_Single 121 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopProductNodeCheck.sql QBM_PDBQueueInsert_Single 'QER-K-OrgAutoChild', @UID_OrgBO, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErr…
QBM_PDBQueueInsert_Single 127 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopProductNodeCheck.sql end exec QER_PITShopProductNodeCheck @UID_OrgBO, @GenProcID NochMalEntscheidung: if @WirMachenDasNochEinmal = 1 begin …
QBM_PDBQueueInsert_Single 42 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql exec QBM_PDBQueueInsert_Single 'QBM-K-Commonrecalculate', 'QER-K-ShoppingRackPWOHelperPWO', '', @GenprocID end declare …
QBM_PDBQueueInsert_Single 88 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql = b.UID_Org join pwodecisionstep s on b.XObjectKey = s.ObjectKeyOfAssignedOrg ) begin exec QBM_PDBQueueInsert_Single '…
QBM_PDBQueueInsert_Single 39 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZDynGroupSingleBasic.sql , @GenProcID exec @erg = @ProcNameRechneDetail @SlotNumber if @erg > 0 begin exec QBM_PDBQueueInsert_Single 'QER-K-Dy…
QBM_PDBQueueInsert_Single 41 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZOrgInherite.sql @RootRechnen = 0 goto einstellen end end einstellen: if @RootRechnen = 1 begin exec QBM_PDBQueueInsert_single 'QER-K-O…
QBM_PDBQueueInsert_Single 55 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql top 1 1 from AccProductGroupCollection ) begin exec QBM_PDBQueueInsert_Single 'QBM-k-CommonRecalculate', 'QER-K-AccProd…
QBM_PDBQueueInsert_Single 65 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql , @DBQueueElements_07 end else begin if dbo.QBM_FGIDBOwner() not in ( @MyModule ) begin exec QBM_PDBQueueInsert_Sing…
QBM_PDBQueueInsert_Single 66 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PAfterMigrationTasks.sql , '', @GenProcID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-PersonHasObject', '', @GenProcID end …
QBM_PDBQueueInsert_Single 164 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TBaseTree.sql ,'') or isnull(b.uid_parentorg,'') <> isnull(d.uid_parentorg,'') ) ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-Commo…
QBM_PDBQueueInsert_Single 165 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TBaseTree.sql , @GenProcID end end exec QBM_PDBQueueInsert_Single 'QER-K-ShoppingRackPWODecisionMaker', '', '', @GenProcID end if u…
QBM_PDBQueueInsert_Single 29 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDialogColumn.sql where c.IsDeactivatedByPreProcessor <> d.IsDeactivatedByPreProcessor ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-Comm…
QBM_PDBQueueInsert_Single 30 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDialogColumn.sql , '', @GenProcID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-QERRiskIndexCalculate', '', @GenProcI…
QBM_PDBQueueInsert_Single 30 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDialogConfigParm.sql = 1 ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-DynamicGroupMakeProc', '', @GenProcID exe…
QBM_PDBQueueInsert_Single 29 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDialogTable.sql where t.IsDeactivatedByPreProcessor <> d.IsDeactivatedByPreProcessor ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-Comm…
QBM_PDBQueueInsert_Single 48 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDynamicGroup.sql exec QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupTest', @DBQueueElements_01 exec QBM_PDBQueueInsert_Single 'QER-K-Dynam…
QBM_PDBQueueInsert_Single 77 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDynamicGroup.sql exec QBM_PExecuteSQLMulti @ElementBufferMulti end if UPDATE(whereclause) or UPDATE(IsCalculateImmediately) begin exec…
QBM_PDBQueueInsert_Single 88 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDynamicGroup.sql QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupMakeProc', @DBQueueElements_01 exec QBM_PDBQueueInsert_Single 'QER-K-Dynam…
QBM_PDBQueueInsert_Single 27 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDynamicGroupHasImmediate.sql varchar(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start:…
QBM_PDBQueueInsert_Single 34 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDynamicGroupHasImmediate.sql ) begin exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID end END TRY BEGIN CATCH exec…
QBM_PDBQueueInsert_Single 38 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDynamicGroupHasImmediate.sql (38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from deleted) goto start return start: exec Q…
QBM_PDBQueueInsert_Single 42 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_THelperHeadOrg.sql ) as y on 1 = 1 exec QER_PITShopHelperFill_Recalc @RecalcParameter_05, @GenprocID exec QBM_PDBQueueInsert_Single 'Q…
QBM_PDBQueueInsert_Single 74 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_THelperHeadOrg.sql QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-ShoppingRackPWODecisionMaker', '', @GenProcID end insert…
QBM_PDBQueueInsert_Single 29 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_THelperHeadPerson.sql x join Person e on x.UID_Person = e.UID_Person exec QER_PITShopHelperFill_Recalc @RecalcParameter, @GenprocID exec QBM_…
QBM_PDBQueueInsert_Single 51 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPerson.sql ) begin if @PWOTaskToUse > ' ' begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', @PWOTaskToUse, '', @Ge…
QBM_PDBQueueInsert_Single 130 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPerson.sql in (select uid_person from deleted ) delete delegation where UID_PersonSender in (select uid_person from deleted ) exe…
QBM_PDBQueueInsert_Single 59 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\ControlFile6Check.xml <Command Type="Sql" Replacement="True">exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-QERRiskIndexMak…
QBM_PDBQueueInsert_Single 61 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\ControlFile6Check.xml <Command Type="Sql" Replacement="True">exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-PWODecisionRule…
QBM_PDBQueueInsert_Single 62 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\ControlFile6Check.xml <Command Type="Sql" Replacement="True">exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-PWOHelperFillMa…
QBM_PDBQueueInsert_Single 64 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\ControlFile6Check.xml <Command Type="Sql" Replacement="True">exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-DynamicGroupMak…
QBM_PDBQueueInsert_Single 66 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\ControlFile6Check.xml <Command Type="Sql" Replacement="True">exec QBM_PDBQueueInsert_Single 'QER-K-EntitlementSourceMakeProc', '', '', '$GenP…
QBM_PDBQueueInsert_Single 67 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\ControlFile6Check.xml <Command Type="Sql" Replacement="True">exec QBM_PDBQueueInsert_Single 'QER-K-PersonFindGenerateFunct', '', '', '$GenPro…
QBM_PJobCreate_HOCallMethod 170 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopOrderMove.sql QBM_PJobCreate_HOCallMethod_L 'PersonWantsOrg', @pwoToAbort,1, 'Abort' , @GenProcIDImZyklus , @AdditionalObjectKeysAffe…
QBM_PJobCreate_HOCallMethod 174 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopOrderMove.sql QBM_PJobCreate_HOCallMethod_L 'PersonWantsOrg', @pwoToAbort,1, 'Abort' , @GenProcIDImZyklus , @AdditionalObjectKeysAffe…
QBM_PJobCreate_HOCallMethod 177 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopOrderMove.sql mo.ExecCallMethodAbort = 3 and mo.GenProcID = @GenProcIDImZyklus if @@ROWCOUNT > 0 begin exec QBM_PJobCreate_HOCallMeth…
QBM_PJobCreate_HOCallMethod 185 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopOrderMove.sql QBM_PJobCreate_HOCallMethod_L 'PersonWantsOrg', @pwoToAbort,1, 'MakeDecision' , @GenProcIDImZyklus , @AdditionalObjectK…
QBM_PJobCreate_HOCallMethod 62 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql + N'''' select @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallM…
QBM_PJobCreate_HOCallMethod 66 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql + STR(@DecisionLevel) exec QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @Methodname = 'ESCALATE' …
QBM_PJobCreate_HOCallMethod 79 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql + N'''' select @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallM…
QBM_PJobCreate_HOCallMethod 83 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql + STR(@DecisionLevel) exec QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @Methodname = 'ESCALATE' …
QBM_PJobCreate_HOCallMethod 116 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMethod 'personwa…
QBM_PJobCreate_HOCallMethod 148 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql ) if @AbortMethod in ('TRUE', 'FALSE') begin exec QBM_PJobCreate_HOCallMethod 'personwantsorg', @SQLcmd, @save = 1 , @…
QBM_PJobCreate_HOCallMethod 152 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql where bu.ElementIndex < @ElementIndex and bu.UID1 = @uid_personwantsorg ) begin exec QBM_PJobCreate_HOCallMethod 'pers…
QBM_PJobCreate_HOCallMethod 157 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql = @uid_personwantsorg and orderstate = 'OrderProduct' ) begin select @AbortMethod = 'AbortOrder' end exec QBM_PJobCreat…
QBM_PJobCreate_HOCallMethod 56 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckValid.sql begin select @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMe…
QBM_PJobCreate_HOCallMethod 60 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckValid.sql QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @WhereClause , @save = 1 , @MethodName = 'W…
QBM_PJobCreate_HOCallMethod 63 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckValid.sql end end else begin exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @WhereClause , @sav…
QBM_PJobCreate_HOCallMethod 83 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckValid.sql if @ExceededValidUntilUnsubscribe = 0 or (@ExceededValidUntilUnsubscribe = 1 and @Orderstate in( 'Waiting', 'Granted') …
QBM_PJobCreate_HOCallMethod 87 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckValid.sql end if @ExceededValidUntilUnsubscribe = 1 and @Orderstate in ('Assigned', 'OrderProlongate') begin exec QBM_PJobCreate…
QBM_PJobCreate_HOCallMethod 91 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckValid.sql else begin exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @WhereClause , @save = 1 , …
QBM_PJobCreate_HOCallMethod 100 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckValid.sql = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , …
QBM_PJobCreate_HOCallMethod 57 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckWaiting.sql + rtrim(@uid_PwoToActivate) + N'''' exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @W…
QBM_PJobCreate_HOCallMethod 59 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopMakeDecisionCD.sql (@uid_personwantsorg) + ''' and DecisionLevel = ' + STR(@DecisionLevel) exec QBM_PJobCreate_HOCallMethod @objecttype =…
QBM_PJobCreate_HOCallMethod 94 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopMakeDecisionRI.sql + rtrim(@uid_personwantsorg) + ''' and DecisionLevel = ' + STR(@DecisionLevel) exec QBM_PJobCreate_HOCallMethod @objec…
QBM_PJobCreate_HOCallMethod 36 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopMakeDecisionSB.sql ) + N''' and DecisionLevel = ' + STR(@DecisionLevel) exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' ,…
QBM_PJobCreate_HOCallMethod 82 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopMakeDecisionWC.sql + STR(@DecisionLevel) exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @cond , @save =…
QBM_PJobCreate_HOCallMethod 36 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopOrderAbort.sql ) exec QBM_PJobCreate_HOCallMethod 'PersonWantsOrg', @cond, @save = 1, @MethodName = @AbortMethod , @GenProcID = @GenPr…
QBM_PJobCreate_HOCallMethod 56 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_GDBQueueTasks\QER_ZAllForPersonInBasetree.sql ) + N'''' select @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCal…
QBM_PJobCreate_HOCallMethod 47 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PPersonDelete_GDPR.sql ' insert into @ElementsToClose(Parameter1) exec sp_executesql @cmd end exec QBM_PJobCreate_HOCallMethod_L
QBM_PJobCreate_HOCallMethod 61 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PPersonDelete_GDPR.sql exec QBM_PJobCreate_HOCallMethod_L @objecttype = 'PersonWantsOrg' , @XObjectKeys = @ElementsToClose , @save = 1 , @Meth…
QBM_PJobCreate_HOCallMethod 66 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\QER_PPersonDelete_GDPR.sql , 'OrderUnsubscribe', 'Waiting') exec QBM_PJobCreate_HOCallMethod_L @objecttype = 'PersonWantsOrg' , @XObjectKeys = @El…
QBM_PJobCreate_HOCallMethod 81 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_THelperHeadOrg.sql (@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMethod @objecttype = 'personwantsorg' , @whereclause = @SQLcmd , @save …
QBM_PJobCreate_HOCallMethod 48 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_THelperHeadPerson.sql select @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMethod @o…
QBM_PJobCreate_HOCallMethod 61 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPerson.sql @@ROWCOUNT > 0 begin exec QBM_PJobCreate_HOCallMethod_L 'PersonWantsOrg', @pwoToAbort, 1, 'Abort' , @GenProcID , @Addi…
QBM_PJobCreate_HOCallMethod 64 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPersonInBaseTree.sql select @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMethod @…
QBM_PJobCreate_HOCallMethod 46 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPersonWantsOrg.sql QBM_PJobCreate_HOCallMethod_L @objecttype = 'PersonWantsOrg' , @XObjectKeys = @PWOsToFire , @save = 1 , @MethodName = …
QBM_PJobCreate_HOCallMethod 141 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPersonWantsOrg.sql in ('OrderProlongate', 'OrderUnsubscribe') and d.OrderState not in ('OrderProlongate', 'OrderUnsubscribe') exec QBM_PJo…
QBM_PJobCreate_HOCallMethod 155 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPersonWantsOrg.sql @UID_PWOStateFinalError = dbo.QER_FGIPWOStateFinalError(@UID_PersonWantsOrg) exec QBM_PJobCreate_HOCallMethod @objectty…
QBM_PJobCreate_HOCallMethod 49829 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Dump\ModuleContent.xml exec QBM_PJobCreate_HOCallMethod_L 'personwantsorg', @wech, @save = 1
QBM_PJobCreate_HOCallMethod 129 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0004.0030.0000.sql create or alter procedure QBM_PJobCreate_HOCallMethod( @objecttype nvarchar(255), @whereclause nvarchar(max) , @save …
QBM_PJobCreate_HOCallMethod 149 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0004.0030.0000.sql declare @GenProcID varchar(38) = newid() declare @whereclause nvarchar(max) = 'UID_AERoleShellOwner is null' exec QBM_P…
QBM_PJobCreate_HOFireEvent 46 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql ) exec QBM_PJobCreate_HOFireEvent_L 'PWOHelperPWO', @ObjectKeysToFire, 'DecisionRequired', @GenProcIDToUse , @priority …
QBM_PJobCreate_HOFireEvent 190 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckDecision.sql )' exec QBM_PJobCreate_HOFireEvent_L
QBM_PJobCreate_HOFireEvent 38 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopMakeDecisionEX.sql + rtrim(@uid_personwantsorg) + N'''' exec QBM_PJobCreate_HOFireEvent_B 'personwantsorg', @cond, @EventName , @GenProcI…
QBM_PJobCreate_HOFireEvent 97 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopProductNodeCheck.sql ('ITShopOrg', 'UID_ITShopOrg', @UID_OrgPR) exec QBM_PJobCreate_HOFireEvent_L 'ITShopOrg', @EntriesToFire ,'DeletePRNode…
QBM_PJobCreate_HOFireEvent 42 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TPerson.sql > ' ' exec QBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkey…
QBM_PJobCreate_HOFireEvent 104 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0008.0022.0000.sql create or alter procedure QBM_PJobCreate_HOFireEvent( @objecttype nvarchar(255), @whereclause nvarchar(max) , @Event…
QBM_PJobCreate_HOFireEvent 154 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0008.0022.0000.sql from @ObjectKeys_Part end exec QBM_PJobCreate_HOFireEvent @objecttype , @Sammler , @EventName , @GenProcID , @ObjectKe…
QBM_PJobCreate_HOFireEvent 161 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0008.0022.0000.sql create or alter procedure QBM_PJobCreate_HOFireEvent_L( @objecttype nvarchar(255), @XObjectKeys QBM_YParameterList rea…
QBM_PJobCreate_HOFireEvent 193 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0008.0022.0000.sql create or alter procedure QBM_PJobCreate_HOFireEvent_B( @objecttype nvarchar(255), @whereclause nvarchar(max), @Event…
QBM_PJobCreate_HOFireEvent 215 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0008.0022.0000.sql into @XObjectKeysToTransfer(Parameter1) exec sp_executeSQL @SQLCmd exec QBM_PJobCreate_HOFireEvent_L @objecttype, @XObj…
QBM_PJobCreate_HOFireEvent 220 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0008.0022.0000.sql @QueueName end else begin exec QBM_PJobCreate_HOFireEvent @objecttype, @whereclause , @EventName, @GenProcID , @Additi…
QBM_PJobCreate_HOFireEvent 240 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V100\2025.0008.0022.0000.sql exec QBM_PJobCreate_HOFireEvent_B 'AERole', @WhereClause, 'Insert' , @GenProcID , @AdditionalObjectKeysAffected = defau…
QBM_PJobCreate_HOUpdate 205 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopProductNodeCreate.sql bu where bu.ElementIndex = @ElementIndex exec QBM_PJobCreate_HOUpdate 'ITShopOrg', @whereclauseOrg, @GenProcID , @Objec…
QBM_PJobCreate_HOUpdate 53 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TQERAssign.sql , N'@ObjectkeyOrdered' , @ObjectkeyOrdered) select @whereclauseOrg = replace(@whereclauseOrg, N'@uid_accproduct' , rtri…
QBM_PJobCreate_HOUpdate 54 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TQERResource.sql , N'@uid_accproduct' , rtrim(@uid_accproduct)) exec QBM_PJobCreate_HOUpdate_B N'ITShopOrg', @whereclauseOrg, @GenPro…
QBM_PJobCreate_HOUpdate 53 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TQERReuse.sql , N'@ObjectkeyOrdered' , @ObjectkeyOrdered) select @whereclauseOrg = replace(@whereclauseOrg, N'@uid_accproduct' , rtri…
QBM_PJobCreate_HOUpdate 54 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TQERReuseUS.sql , N'@uid_accproduct' , rtrim(@uid_accproduct)) exec QBM_PJobCreate_HOUpdate_B N'ITShopOrg', @whereclauseOrg, @GenPro…
QER_PITShopProductNodeCreate_b 31 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShop_PRNodesMove.sql select @ElementIndex = 1 insert into @ObjectKeyElements(Parameter1) select bu.ObjectKey1 from @ElementBuffer bu exec Q…
QER_PITShopProductNodeCreate_b 28 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopProductNodeCreate.sql (Parameter1) select @ObjectKeyElement exec QER_PITShopProductNodeCreate_b @uid_orgBO, @ObjectKeys, @GenProcID, @uid_Org…
QER_PITShopProductNodeCreate_b 32 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopProductNodeCreate.sql create or alter procedure QER_PITShopProductNodeCreate_b( @uid_orgBO varchar(38) , @ObjectKeyElements QBM_YParameterLis…
QER_PITShopProductNodeCreate_b 119 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopProductNodeCheck.sql @NodeCreateBuffer (Parameter1) select top (@RowLimitNodeCheck) m.Parameter1 from @MerkTable3 m select @RowCounterNodeC…
QER-K-ShoppingRack 27 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_FGIPWOTaskToUse.sql ) when 'NoRecalc' then '' when 'CurrentLevel' then 'QER-K-ShoppingRackPWOHelperPWO-Cfg' else 'QER-K-ShoppingRackPWOHelp…
QER-K-ShoppingRack 31 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill_Recalc.sql 'QER-K-ShoppingRackPWOHelperPWO-Rec', null, null, @GenProcID end if exists (select top 1 1 from @Parameter where Ident1…
QER-K-ShoppingRack 331 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql 'QER-K-ShoppingRackPWOHelperPWO' , @DBQueueElements_ModifiedHelper delete @PWOHelperPWO_Old from @PWOHelperPWO_Old o j…
QER-K-ShoppingRack 337 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql 'QER-K-ShoppingRackCheckDecision', @DBQueueElements_CheckDecision if @DebugSwitch > 0 begin print 'Vor publizieren @@PW…
QER-K-ShoppingRack 395 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql and r.UID_Task = 'QER-K-ShoppingRackMakeDecisionEX' where (c.OrderState = 'OrderProduct' and (c.DecisionLevel > 0 o…
QER-K-ShoppingRack 397 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShopHelperFill.sql in ( 'OrderProlongate' , 'OrderUnsubscribe') ) exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMakeDecisionEX', @DBQue…
QER-K-ShoppingRack 27 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_POrderUnreachableClose.sql ('') exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-ShoppingRackCheckDecision', '', @GenProcID END TR…
QER-K-ShoppingRack 36 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheck.sql 'QER-K-ShoppingRackCheckValid', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueue…
QER-K-ShoppingRack 39 C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheck.sql () or h.NextAutomaticDecision < getutcdate() ) and pwo.UID_QERWorkingMethod > ' ' ) as x exec QBM_PDBQueueInsert_Bulk …Notes / Interpretation
- The module content ships
AccProductInBaseTreetable/relationship definitions (even if the sandbox DB currently keeps it empty). - The shipped IT Shop procedure set includes explicit
QBM_PJobCreate_*usage (object-layer calls/events/updates) andQBM_PDBQueueInsert_*usage (enqueue ShoppingRack tasks), matching live-DB observations.
MDK references: ITShopInfo codes BG/BT
The MDK includes MMM procedures that explicitly check b.ITShopInfo in ( 'BO', 'PR', 'BG', 'BT') (so BG/BT are “real” codes in shipped logic, even though they are not present in the current sandbox DB snapshot):
Pattern Line Path Text
------- ---- ---- ----
'BG' 159 C:\Dev\OneIM10.0.0-MDK\MDK\MMM\Database\MSSQL\040Procedures\MMM_ZBaseTreeHasGroup.sql and b.ITShopInfo in ( 'BO', 'PR', 'BG', 'BT')
'BG' 134 C:\Dev\OneIM10.0.0-MDK\MDK\MMM\Database\MSSQL\040Procedures\MMM_ZBaseTreeHasObject.sql and b.ITShopInfo in ( 'BO', 'PR', 'BG', 'BT')
'BT' 159 C:\Dev\OneIM10.0.0-MDK\MDK\MMM\Database\MSSQL\040Procedures\MMM_ZBaseTreeHasGroup.sql and b.ITShopInfo in ( 'BO', 'PR', 'BG', 'BT')
'BT' 134 C:\Dev\OneIM10.0.0-MDK\MDK\MMM\Database\MSSQL\040Procedures\MMM_ZBaseTreeHasObject.sql and b.ITShopInfo in ( 'BO', 'PR', 'BG', 'BT')