Identity Manager 8.2.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')