Identity Manager 9.1 - Anwenderhandbuch für den One Identity Manager Konnektor

-- transfer customized configuration DialogTable.IsModuleGUIDAllowed from your central database 

-- => manual process required

select UID_DialogTable, 'Update DialogTable set IsModuleGUIDAllowed = 1 

    where IsModuleGUIDAllowed = 0 and UID_DialogTable = '''+UID_DialogTable+''' ' as ChangeStatement 

    from DialogTable where IsModuleGUIDAllowed = 1

--if you got an result, copy the commands and execute them in your work database

-- deactivate all predefined provisioning processes

update JobChain set NoGenerate = 1, XDateUpdated = GETUTCDATE(), XUserUpdated = 'SysSyncInitialConfig' from JobChain JC 

    join JobEventGen JEG on JEG.UID_JobChain = JC.UID_JobChain 

    join QBMEvent JE on JE.UID_QBMEvent = JEG.UID_QBMEvent where 

        (

        JE.EventName in ('Insert', 'Update', 'Delete', 'Assign', 'Remove') 

        or JC.UID_DialogTable in ('TSB-T-PersonHasTSBAccountDef', 'QER-T-PersonHasQERResource') 

        or UID_JobChain in ('TSB-F9E8F1B2DA86E847A254E70A572A3832','TSB-EB76885961C6404FB7BB73FC1AC83153')

        ) 

        and dbo.QBM_FCVGUIDToModuleOwner(JC.UID_JobChain) <> 'CCC' 

        and NoGenerate = 0

-- deactivate merge for provisioning (DPRMemberShipAction) for all synchronized tables

update DPRNameSpaceHasDialogTable set IsAdHocSingleMemberShip = 0, WhereClause = Null

-- deactivate XDateSubItem behavior for all synchronized tables

update QBMRelation set IsForUpdateXDateSubItem = 0 where UID_QBMRelation in 

    (

    select UID_QBMRelation from QBM_VQBMRelation r 

        join DialogTable t on r.UID_DialogTableChild=t.UID_DialogTable or r.UID_DialogTableParent=t.UID_DialogTable 

            where t.SystemSyncMode > 0 and r.IsForUpdateXDateSubItem = 1

    )

-- deactivate all not required schedules

-- allow only system and custom schedules as well as such ones belonging to reports and attestation

-- but disable all synchronization schedules except the system synchronization

update DialogSchedule 

    set Enabled = 0, XDateUpdated = GETUTCDATE(), XUserUpdated = 'SysSyncInitialConfig' 

        where Enabled = 1 and 

            (

            dbo.QBM_FCVGUIDToModuleOwner(UID_DialogSchedule) not in ('CCC','QBM','QER','RPS','ATT') 

            or (Name like '%execution of Initial Synchronization%' and Name not like 'System Synchronization%')

            )

-- disable SAP/SBW DBQueueTask for generation SAPUserMandant and SAPBWUser

update QBMDBQueueTask 

    set ProcedureName = 'QBM_ZDBQueueVoidTask', CountParameter = 0, MaxInstance = 1, IsBulkEnabled = 0, QueryForRecalculate = Null 

        where UID_Task in ('SAP-K-SAPUserMandant', 'SBW-K-SAPBWUser')