Source: projects/identity-management/oim-kb-update/sandbox-host/2026-04-27-itshopinfo-and-configparm-file-evidence.md
> Source: projects/identity-management/oim-kb-update/sandbox-host/2026-04-27-itshopinfo-and-configparm-file-evidence.md
Sandbox Host Evidence — ITShopInfo + DialogConfigParm artifacts (2026-04-27)
Method
- Host:
im.sandbox.local - Access: WinRM HTTP
5985(read-only) - Paths inspected:
C:\\Dev\\OneIdentityManager.10.0\\Modules\\QER\\database\\MSSQL
Evidence
C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_PITShop_ShopMove.sql
Matches (first hits, context ±2 lines):
[Pattern] ITShopInfo [Line] 32
(38) declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() declare @FullPathSCTarget nvarchar(400) SET XACT_ABORT
OFF BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext('') select @uid_orgCU_Source = null select top 1 @uid_orgCU_Source = cu.uid_org , @UID_OrgSC_Source
= sc.uid_org from Basetree sh join BaseTree cu on cu.uid_parentorg = sh.UID_Org and cu.itShopInfo = 'CU' left outer join Basetree sc on sh.UID_ParentOrg
= sc.uid_org where sh.uid_org = @UID_OrgSHSource and sh.uid_OrgRoot = 'QER-V-ITShopOrg' and sh.ITShopInfo = 'SH' if @uid_orgCU_Source is null begin raiserror
( '#LDS#The customer node cannot be found in shop (source).|', 18, 2) with nowait end if not exists (select top 1 1 from BaseTree where uid_OrgRoot =
---
[Pattern] ITShopInfo [Line] 33
OFF BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext('') select @uid_orgCU_Source = null select top 1 @uid_orgCU_Source = cu.uid_org , @UID_OrgSC_Source
= sc.uid_org from Basetree sh join BaseTree cu on cu.uid_parentorg = sh.UID_Org and cu.itShopInfo = 'CU' left outer join Basetree sc on sh.UID_ParentOrg
= sc.uid_org where sh.uid_org = @UID_OrgSHSource and sh.uid_OrgRoot = 'QER-V-ITShopOrg' and sh.ITShopInfo = 'SH' if @uid_orgCU_Source is null begin raiserror
( '#LDS#The customer node cannot be found in shop (source).|', 18, 2) with nowait end if not exists (select top 1 1 from BaseTree where uid_OrgRoot =
'QER-V-ITShopOrg' and ITShopInfo = 'SC' and uid_Org = @UID_OrgSCTarget ) begin raiserror( '#LDS#The given target node is not a shopping center.|', 18,
---
[Pattern] shopping center [Line] 35
= sc.uid_org where sh.uid_org = @UID_OrgSHSource and sh.uid_OrgRoot = 'QER-V-ITShopOrg' and sh.ITShopInfo = 'SH' if @uid_orgCU_Source is null begin raiserror
( '#LDS#The customer node cannot be found in shop (source).|', 18, 2) with nowait end if not exists (select top 1 1 from BaseTree where uid_OrgRoot =
'QER-V-ITShopOrg' and ITShopInfo = 'SC' and uid_Org = @UID_OrgSCTarget ) begin raiserror( '#LDS#The given target node is not a shopping center.|', 18,
2) with nowait end if isnull(@UID_OrgSC_Source, '') = @UID_OrgSCTarget begin goto ende end if not exists (select top 1 1 from BaseTree where uid_OrgRoot
= 'QER-V-ITShopOrg' and ITShopInfo = 'SH' and uid_Org = @UID_OrgSHSource and dbo.QBM_FGIGuidIsValid(uid_Org) & 2 = 0 ) begin raiserror( '#LDS#The given shop (source) must not be moved to another shoping center.|'
---
[Pattern] ITShopInfo [Line] 35
= sc.uid_org where sh.uid_org = @UID_OrgSHSource and sh.uid_OrgRoot = 'QER-V-ITShopOrg' and sh.ITShopInfo = 'SH' if @uid_orgCU_Source is null begin raiserror
( '#LDS#The customer node cannot be found in shop (source).|', 18, 2) with nowait end if not exists (select top 1 1 from BaseTree where uid_OrgRoot =
'QER-V-ITShopOrg' and ITShopInfo = 'SC' and uid_Org = @UID_OrgSCTarget ) begin raiserror( '#LDS#The given target node is not a shopping center.|', 18,
2) with nowait end if isnull(@UID_OrgSC_Source, '') = @UID_OrgSCTarget begin goto ende end if not exists (select top 1 1 from BaseTree where uid_OrgRoot
= 'QER-V-ITShopOrg' and ITShopInfo = 'SH' and uid_Org = @UID_OrgSHSource and dbo.QBM_FGIGuidIsValid(uid_Org) & 2 = 0 ) begin raiserror( '#LDS#The given shop (source) must not be moved to another shoping center.|'
---
[Pattern] ITShopInfo [Line] 37
'QER-V-ITShopOrg' and ITShopInfo = 'SC' and uid_Org = @UID_OrgSCTarget ) begin raiserror( '#LDS#The given target node is not a shopping center.|', 18,
2) with nowait end if isnull(@UID_OrgSC_Source, '') = @UID_OrgSCTarget begin goto ende end if not exists (select top 1 1 from BaseTree where uid_OrgRoot
= 'QER-V-ITShopOrg' and ITShopInfo = 'SH' and uid_Org = @UID_OrgSHSource and dbo.QBM_FGIGuidIsValid(uid_Org) & 2 = 0 ) begin raiserror( '#LDS#The given shop (source) must not be moved to another shoping center.|'
, 18, 2) with nowait end if exists (select top 1 1 from BaseTree targetSH where targetSH.uid_OrgRoot = 'QER-V-ITShopOrg' and targetSH.ITShopInfo = 'SH'
and targetSH.uid_ParentOrg = @UID_OrgSCTarget and targetSH.Ident_Org in (select Ident_Org from Basetree where uid_org = @UID_OrgSHSource) ) begin raiserror
---
[Pattern] ITShopInfo [Line] 38
2) with nowait end if isnull(@UID_OrgSC_Source, '') = @UID_OrgSCTarget begin goto ende end if not exists (select top 1 1 from BaseTree where uid_OrgRoot
= 'QER-V-ITShopOrg' and ITShopInfo = 'SH' and uid_Org = @UID_OrgSHSource and dbo.QBM_FGIGuidIsValid(uid_Org) & 2 = 0 ) begin raiserror( '#LDS#The given shop (source) must not be moved to another shoping center.|'
, 18, 2) with nowait end if exists (select top 1 1 from BaseTree targetSH where targetSH.uid_OrgRoot = 'QER-V-ITShopOrg' and targetSH.ITShopInfo = 'SH'
and targetSH.uid_ParentOrg = @UID_OrgSCTarget and targetSH.Ident_Org in (select Ident_Org from Basetree where uid_org = @UID_OrgSHSource) ) begin raiserror
( '#LDS#The target shopping center already contains a shop with the same ident.|', 18, 2) with nowait end select top 1 @FullPathSCTarget = fullpath from
---
[Pattern] shopping center [Line] 40
, 18, 2) with nowait end if exists (select top 1 1 from BaseTree targetSH where targetSH.uid_OrgRoot = 'QER-V-ITShopOrg' and targetSH.ITShopInfo = 'SH'
and targetSH.uid_ParentOrg = @UID_OrgSCTarget and targetSH.Ident_Org in (select Ident_Org from Basetree where uid_org = @UID_OrgSHSource) ) begin raiserror
( '#LDS#The target shopping center already contains a shop with the same ident.|', 18, 2) with nowait end select top 1 @FullPathSCTarget = fullpath from
Basetree where UID_Org = @UID_OrgSCTarget select @UID_OrgSH_Target = newid() insert into BaseTree( UID_Org, UID_ParentOrg, Ident_Org , IsCutNode, Description
, uid_OrgRoot , UID_PersonHead, UID_PersonHeadSecond, UID_OrgDepartment, UID_OrgLocality, UID_OrgProfitCenter, UID_OrgAttestator , XDateInserted , XDateUpdated
---
[Pattern] ITShopInfo [Line] 43
Basetree where UID_Org = @UID_OrgSCTarget select @UID_OrgSH_Target = newid() insert into BaseTree( UID_Org, UID_ParentOrg, Ident_Org , IsCutNode, Description
, uid_OrgRoot , UID_PersonHead, UID_PersonHeadSecond, UID_OrgDepartment, UID_OrgLocality, UID_OrgProfitCenter, UID_OrgAttestator , XDateInserted , XDateUpdated
, XUserInserted , XUserUpdated, InternalName , FullPath ,Commentary , ITShopInfo , XObjectKey , IsInvalidForDynamicGroup , UID_PWODecisionMethod ) select
@UID_OrgSH_Target, @UID_OrgSCTarget, b.Ident_Org, 0, b.Description, b.UID_OrgRoot , b.UID_PersonHead, b.UID_PersonHeadSecond, b.UID_OrgDepartment, b.UID_OrgLocality
, b.UID_OrgProfitCenter, b.UID_OrgAttestator , GetUTCDate(), GetUTCDate(), 'QER_PITShopShopMove', 'QER_PITShopShopMove', b.InternalName, concat(@FullPathSCTarget
---C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\040Procedures\ITShop\QER_ZITShopCheckStructure.sql
Matches (first hits, context ±2 lines):
[Pattern] ITShopInfo [Line] 30
cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end declare @DBQueueElements_01 QBM_YDBQueueRaw insert into
@DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select o.uid_org as uid , x.GenProcID from @DBQueueCurrent x
join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'BO' union select x.uid_parameter , x.GenProcID from @DBQueueCurrent x where not exists
(select top 1 1 from BaseTree where uid_org = x.uid_parameter ) union select b.uid_org, x.GenProcID from @DBQueueCurrent x join BaseTree o on x.uid_parameter
= o.uid_org and o.ITShopInfo = 'SH' join BaseTree b on b.uid_parentorg = o.uid_org and b.ITShopInfo = 'BO' union select b.uid_org, x.GenProcID from @DBQueueCurrent
---
[Pattern] ITShopInfo [Line] 32
join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'BO' union select x.uid_parameter , x.GenProcID from @DBQueueCurrent x where not exists
(select top 1 1 from BaseTree where uid_org = x.uid_parameter ) union select b.uid_org, x.GenProcID from @DBQueueCurrent x join BaseTree o on x.uid_parameter
= o.uid_org and o.ITShopInfo = 'SH' join BaseTree b on b.uid_parentorg = o.uid_org and b.ITShopInfo = 'BO' union select b.uid_org, x.GenProcID from @DBQueueCurrent
x join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'SC' join BaseTree s on s.uid_parentorg = o.uid_org and s.ITShopInfo = 'SH' join BaseTree
b on b.uid_parentorg = s.uid_org and b.ITShopInfo = 'BO' ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMethod', @DBQueueElements_01 declare @DBQueueElements_02
---
[Pattern] ITShopInfo [Line] 33
(select top 1 1 from BaseTree where uid_org = x.uid_parameter ) union select b.uid_org, x.GenProcID from @DBQueueCurrent x join BaseTree o on x.uid_parameter
= o.uid_org and o.ITShopInfo = 'SH' join BaseTree b on b.uid_parentorg = o.uid_org and b.ITShopInfo = 'BO' union select b.uid_org, x.GenProcID from @DBQueueCurrent
x join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'SC' join BaseTree s on s.uid_parentorg = o.uid_org and s.ITShopInfo = 'SH' join BaseTree
b on b.uid_parentorg = s.uid_org and b.ITShopInfo = 'BO' ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMethod', @DBQueueElements_01 declare @DBQueueElements_02
QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_org as uid , x.GenProcID
---
[Pattern] ITShopInfo [Line] 34
= o.uid_org and o.ITShopInfo = 'SH' join BaseTree b on b.uid_parentorg = o.uid_org and b.ITShopInfo = 'BO' union select b.uid_org, x.GenProcID from @DBQueueCurrent
x join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'SC' join BaseTree s on s.uid_parentorg = o.uid_org and s.ITShopInfo = 'SH' join BaseTree
b on b.uid_parentorg = s.uid_org and b.ITShopInfo = 'BO' ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMethod', @DBQueueElements_01 declare @DBQueueElements_02
QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_org as uid , x.GenProcID
from @DBQueueCurrent x join BaseTree p on x.uid_parameter = p.uid_org and p.ITShopInfo = 'PR' union select p.uid_org as uid , x.GenProcID from @DBQueueCurrent
---
[Pattern] ITShopInfo [Line] 36
b on b.uid_parentorg = s.uid_org and b.ITShopInfo = 'BO' ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackMethod', @DBQueueElements_01 declare @DBQueueElements_02
QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_org as uid , x.GenProcID
from @DBQueueCurrent x join BaseTree p on x.uid_parameter = p.uid_org and p.ITShopInfo = 'PR' union select p.uid_org as uid , x.GenProcID from @DBQueueCurrent
x join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'BO' join BaseTree p on p.uid_parentorg = o.uid_org and p.ITShopInfo = 'PR' union
select p.uid_org, x.GenProcID from @DBQueueCurrent x join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'SH' join BaseTree b on b.uid_parentorg
---
[Pattern] ITShopInfo [Line] 37
QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_org as uid , x.GenProcID
from @DBQueueCurrent x join BaseTree p on x.uid_parameter = p.uid_org and p.ITShopInfo = 'PR' union select p.uid_org as uid , x.GenProcID from @DBQueueCurrent
x join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'BO' join BaseTree p on p.uid_parentorg = o.uid_org and p.ITShopInfo = 'PR' union
select p.uid_org, x.GenProcID from @DBQueueCurrent x join BaseTree o on x.uid_parameter = o.uid_org and o.ITShopInfo = 'SH' join BaseTree b on b.uid_parentorg
= o.uid_org and b.ITShopInfo = 'BO' join BaseTree p on p.uid_parentorg = b.uid_org and p.ITShopInfo = 'PR' union select p.uid_org, x.GenProcID from @DBQueueCurrent
---C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TBaseTree.sql
Matches (first hits, context ±2 lines):
[Pattern] ITShopInfo [Line] 42
) select x.uid, null, @GenProcID from ( select d.uid_org as uid from deleted d ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-OrgInherite', @DBQueueElements_02
declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select
d.uid_org as uid from deleted d where d.uid_OrgRoot = 'QER-V-ITShopOrg' and d.itshopinfo in ('SC', 'SH', 'BO', 'PR') ) as x exec QBM_PDBQueueInsert_Bulk
'QER-K-ShoppingRack-All', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid
) select x.uid, null, @GenProcID from ( select d.uid_parentorg as uid from deleted d where d.uid_parentorg > ' ' union select o.uid_org as uid from deleted
---
[Pattern] ITShopInfo [Line] 70
) select x.uid, null, @GenProcID from ( select i.uid_org as uid from inserted i ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-BaseTreeCollectionF',
@DBQueueElements_03 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID
from ( select i.uid_org as uid from inserted i where i.uid_orgroot = 'QER-V-ITShopOrg' and i.itshopinfo in ('SC', 'SH', 'BO', 'PR') ) as x exec QBM_PDBQueueInsert_Bulk
'QER-K-ShoppingRack-All', @DBQueueElements_05 if exists (select top 1 1 from inserted i where i.ITShopInfo > ' ' and i.UID_OrgRoot not in ('QER-V-ITShopOrg'
, 'QER-V-ITShopSrc') ) begin raiserror('#LDS#Cannot set IT Shop information, because role class is not suitable for IT Shop.|', 18, 2) with nowait end
---
[Pattern] ITShopInfo [Line] 71
@DBQueueElements_03 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID
from ( select i.uid_org as uid from inserted i where i.uid_orgroot = 'QER-V-ITShopOrg' and i.itshopinfo in ('SC', 'SH', 'BO', 'PR') ) as x exec QBM_PDBQueueInsert_Bulk
'QER-K-ShoppingRack-All', @DBQueueElements_05 if exists (select top 1 1 from inserted i where i.ITShopInfo > ' ' and i.UID_OrgRoot not in ('QER-V-ITShopOrg'
, 'QER-V-ITShopSrc') ) begin raiserror('#LDS#Cannot set IT Shop information, because role class is not suitable for IT Shop.|', 18, 2) with nowait end
if exists (select top 1 1 from inserted i left outer join BaseTree p on i.UID_ParentOrg = p.UID_Org and i.UID_OrgRoot = p.UID_OrgRoot where i.UID_ParentOrg
---
[Pattern] Cannot set IT Shop information [Line] 72
from ( select i.uid_org as uid from inserted i where i.uid_orgroot = 'QER-V-ITShopOrg' and i.itshopinfo in ('SC', 'SH', 'BO', 'PR') ) as x exec QBM_PDBQueueInsert_Bulk
'QER-K-ShoppingRack-All', @DBQueueElements_05 if exists (select top 1 1 from inserted i where i.ITShopInfo > ' ' and i.UID_OrgRoot not in ('QER-V-ITShopOrg'
, 'QER-V-ITShopSrc') ) begin raiserror('#LDS#Cannot set IT Shop information, because role class is not suitable for IT Shop.|', 18, 2) with nowait end
if exists (select top 1 1 from inserted i left outer join BaseTree p on i.UID_ParentOrg = p.UID_Org and i.UID_OrgRoot = p.UID_OrgRoot where i.UID_ParentOrg
> ' ' and p.UID_Org is null ) begin raiserror( '#LDS#Cannot insert node, because predecessor does not exist in the same role class.|', 18, 2) with nowait
---
[Pattern] Cannot insert node [Line] 74
, 'QER-V-ITShopSrc') ) begin raiserror('#LDS#Cannot set IT Shop information, because role class is not suitable for IT Shop.|', 18, 2) with nowait end
if exists (select top 1 1 from inserted i left outer join BaseTree p on i.UID_ParentOrg = p.UID_Org and i.UID_OrgRoot = p.UID_OrgRoot where i.UID_ParentOrg
> ' ' and p.UID_Org is null ) begin raiserror( '#LDS#Cannot insert node, because predecessor does not exist in the same role class.|', 18, 2) with nowait
end insert into BaseTreecollection (uid_org, uid_parentorg) select x.uid_org, x.uid_parentorg from ( select i.UID_Org as UID_Org, i.UID_Org as UID_ParentOrg
from inserted i join OrgRoot r on i.UID_OrgRoot = r.UID_OrgRoot union select i.UID_Org, c.UID_ParentOrg from BaseTreeCollection c join inserted i on c.UID_Org
---
[Pattern] ITShopInfo [Line] 93
(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @alt_uid_Org varchar(38) declare @alt_uid_Orgroot varchar(38) declare @neu_uid_Orgroot
varchar(38) declare @alt_uid_Parentorg varchar(38) declare @neu_uid_Parentorg varchar(38) declare @Ordernumber int declare @OL_only_Upper bit declare
@alt_isCutNode bit declare @neu_isCutNode bit declare @alt_ITShopInfo nvarchar(2) declare @neu_ITShopInfo nvarchar(2) declare @alt_ident_orgtype nvarchar
(64) declare @neu_ident_orgtype nvarchar(64) declare @IsTopDown bit declare @QER_ITShop_OnWorkflowAssign varchar(16) if update(UID_PWODecisionMethod) begin
select @QER_ITShop_OnWorkflowAssign = dbo.QBM_FGIConfigparmValue('QER\ITShop\OnWorkflowAssign') if @QER_ITShop_OnWorkflowAssign in ('RESET', 'ABORT')
---
[Pattern] QER\\ITShop [Line] 95
@alt_isCutNode bit declare @neu_isCutNode bit declare @alt_ITShopInfo nvarchar(2) declare @neu_ITShopInfo nvarchar(2) declare @alt_ident_orgtype nvarchar
(64) declare @neu_ident_orgtype nvarchar(64) declare @IsTopDown bit declare @QER_ITShop_OnWorkflowAssign varchar(16) if update(UID_PWODecisionMethod) begin
select @QER_ITShop_OnWorkflowAssign = dbo.QBM_FGIConfigparmValue('QER\ITShop\OnWorkflowAssign') if @QER_ITShop_OnWorkflowAssign in ('RESET', 'ABORT')
begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from ( select
pwo.UID_PersonWantsOrg as uid from BaseTree b join deleted d on b.UID_Org = d.UID_Org and isnull(b.UID_PWODecisionMethod, '') <> isnull(d.UID_PWODecisionMethod
---
[Pattern] ITShopInfo [Line] 117
join BaseTree p on b.UID_ParentOrg = p.UID_Org and b.UID_OrgRoot = p.UID_OrgRoot where b.UID_ParentOrg > ' ' and p.UID_Org is null ) begin raiserror(
'#LDS#Cannot change node, because predecessor does not exist in same role class.|', 18, 1) with nowait end if exists (select top 1 1 from deleted d join
BaseTree b on d.UID_Org = b.UID_Org left outer join BaseTree sh on b.UID_ParentOrg = sh.UID_Org and sh.ITShopInfo = 'SH' where b.UID_OrgRoot = 'QER-V-ITShopOrg'
and d.ITShopInfo = 'BO' and isnull(d.UID_ParentOrg, '') <> isnull(b.UID_ParentOrg, '') and sh.UID_Org is null ) begin raiserror( '#LDS#Cannot change shelf properties, because predecessor is not a Shop.|'
, 18, 2) with nowait end end if update(ITShopInfo) begin if exists (select top 1 1 from deleted d join BaseTree b on d.UID_Org = b.UID_Org where b.ITShopInfo
---
[Pattern] ITShopInfo [Line] 118
'#LDS#Cannot change node, because predecessor does not exist in same role class.|', 18, 1) with nowait end if exists (select top 1 1 from deleted d join
BaseTree b on d.UID_Org = b.UID_Org left outer join BaseTree sh on b.UID_ParentOrg = sh.UID_Org and sh.ITShopInfo = 'SH' where b.UID_OrgRoot = 'QER-V-ITShopOrg'
and d.ITShopInfo = 'BO' and isnull(d.UID_ParentOrg, '') <> isnull(b.UID_ParentOrg, '') and sh.UID_Org is null ) begin raiserror( '#LDS#Cannot change shelf properties, because predecessor is not a Shop.|'
, 18, 2) with nowait end end if update(ITShopInfo) begin if exists (select top 1 1 from deleted d join BaseTree b on d.UID_Org = b.UID_Org where b.ITShopInfo
> ' ' and b.UID_OrgRoot not in ('QER-V-ITShopOrg', 'QER-V-ITShopSrc') ) begin raiserror( '#LDS#Cannot set IT Shop information, because role class is not suitable for IT Shop.|'
---
[Pattern] Cannot set IT Shop information [Line] 120
and d.ITShopInfo = 'BO' and isnull(d.UID_ParentOrg, '') <> isnull(b.UID_ParentOrg, '') and sh.UID_Org is null ) begin raiserror( '#LDS#Cannot change shelf properties, because predecessor is not a Shop.|'
, 18, 2) with nowait end end if update(ITShopInfo) begin if exists (select top 1 1 from deleted d join BaseTree b on d.UID_Org = b.UID_Org where b.ITShopInfo
> ' ' and b.UID_OrgRoot not in ('QER-V-ITShopOrg', 'QER-V-ITShopSrc') ) begin raiserror( '#LDS#Cannot set IT Shop information, because role class is not suitable for IT Shop.|'
, 18, 2) with nowait end if exists (select top 1 1 from deleted d join BaseTree b on d.UID_Org = b.UID_Org join BaseTree pr on pr.UID_ParentOrg = d.UID_Org
where d.ITShopInfo = 'BO' and isnull( b.ITShopInfo , '') <> 'BO' ) begin raiserror( '#LDS#Cannot change shelf in IT Shop, because product nodes still exist.|'
---C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\050Triggers\QER_TDialogConfigParm.sql
Matches (first hits, context ±2 lines):
[Pattern] DialogConfigParm [Line] 26
--
create or alter trigger QER_TUDialogConfigParm on DialogConfigParm for Update not for Replication as begin BEGIN TRY if exists (select top 1 1 from
inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext
('') if update(value) or update(IsEnabledResulting) begin if exists ( select top 1 1 from dialogconfigparm p join deleted d on p.uid_configparm = d.uid_configparm
---
[Pattern] DialogConfigParm [Line] 28
create or alter trigger QER_TUDialogConfigParm on DialogConfigParm for Update not for Replication as begin BEGIN TRY if exists (select top 1 1 from
inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext
('') if update(value) or update(IsEnabledResulting) begin if exists ( select top 1 1 from dialogconfigparm p join deleted d on p.uid_configparm = d.uid_configparm
and ( isnull(d.value,N'') <> isnull(p.value,N'') or isnull(d.IsEnabledResulting,0)<> isnull(p.IsEnabledResulting,0) ) where p.IsPreprocessorCondition
= 1 ) begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-DynamicGroupMakeProc', '', @GenProcID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate'
---C:\Dev\OneIdentityManager.10.0\Modules\QER\database\MSSQL\Migration\V82\2021.0006.0017.0000.sql
Matches (first hits, context ±2 lines):
[Pattern] DialogConfigParm [Line] 26
--
if not exists (select top 1 1 from DialogConfigparm where UID_ConfigParm = 'QER-50F919687701574E9C828808EF5608D8') begin insert into DialogConfigParm
(UID_ConfigParm, UID_ParentConfigparm, ConfigParm , Fullpath, IsPreprocessorCondition, IsCrypted , Description, DisplayName, SortOrder, Enabled, Value
, XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey) select 'QER-50F919687701574E9C828808EF5608D8', 'QER-C505B582954011D5B2C70008C7B391A8'
---
[Pattern] QER\\ITShop [Line] 29
(UID_ConfigParm, UID_ParentConfigparm, ConfigParm , Fullpath, IsPreprocessorCondition, IsCrypted , Description, DisplayName, SortOrder, Enabled, Value
, XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey) select 'QER-50F919687701574E9C828808EF5608D8', 'QER-C505B582954011D5B2C70008C7B391A8'
, 'AutoPublish' , 'QER\ITShop\AutoPublish', 0, 0 , 'General configuration parameter defining automatically assignments of system entitlements to IT shop.'
, null, 0, 1, 1 , getutcdate(), getutcdate(), 'dbmig', 'dbmig' , '<Key><T>DialogConfigParm</T><P>QER-50F919687701574E9C828808EF5608D8</P></Key>' end
go
---
[Pattern] AutoPublish [Line] 29
(UID_ConfigParm, UID_ParentConfigparm, ConfigParm , Fullpath, IsPreprocessorCondition, IsCrypted , Description, DisplayName, SortOrder, Enabled, Value
, XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey) select 'QER-50F919687701574E9C828808EF5608D8', 'QER-C505B582954011D5B2C70008C7B391A8'
, 'AutoPublish' , 'QER\ITShop\AutoPublish', 0, 0 , 'General configuration parameter defining automatically assignments of system entitlements to IT shop.'
, null, 0, 1, 1 , getutcdate(), getutcdate(), 'dbmig', 'dbmig' , '<Key><T>DialogConfigParm</T><P>QER-50F919687701574E9C828808EF5608D8</P></Key>' end
go
---
[Pattern] DialogConfigParm [Line] 30
, XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey) select 'QER-50F919687701574E9C828808EF5608D8', 'QER-C505B582954011D5B2C70008C7B391A8'
, 'AutoPublish' , 'QER\ITShop\AutoPublish', 0, 0 , 'General configuration parameter defining automatically assignments of system entitlements to IT shop.'
, null, 0, 1, 1 , getutcdate(), getutcdate(), 'dbmig', 'dbmig' , '<Key><T>DialogConfigParm</T><P>QER-50F919687701574E9C828808EF5608D8</P></Key>' end
go
---