Hi,
We have a working Oracle MA (out of the box MA), but are unable to delete it (as we wish to perform further tests).
It processes the records (when we click to delete the CS and MA), and when the bar shows full progress is complete, it just sits there for hours. The MA does not delete. Btw. we have disabled provisioning, and made sure all the Imports and Syncs are complete and healthy.
When we ran the following SQL query, it showed a few hundred rows with "anchor = NULL"
SELECTTOP 1000 [object_id]
,[ma_id]
,[pobject_id]
,[rdn]
,[ancestors]
,[anchor]
FROM [FIMSynchronizationService].[dbo].[mms_connectorspace]
where anchoris
NULL
Since this is a test system, we then ran the SQL query below, but it said there is nothing to delete.
Can anyone suggest other approaches to deleting an MA?
-- Get your MA GUIDs first to set @maid
-- select ma_id, ma_name from mms_management_agent
declare @maid as uniqueidentifier
set @maid =
'6F513A91-99F0-40D9-9392-89C69AAEDFC2'
-- Clean mms_csmv_link first ...
delete mms_csmv_link from
mms_csmv_link csmv
inner join
mms_connectorspace cs
on cs.object_id = csmv.cs_object_id
where cs.ma_id =
@maid AND
anchor is NULL AND
not (cs.partition_id
IS NULL)
-- placeholders have null anchor, so we exclude them
-- Then clean mms_connectorspace ...
delete mms_connectorspace where ma_id
= @maid AND
anchor is NULL AND
not (mms_connectorspace.partition_id
IS NULL)
-- placeholders have null anchor, so we exclude them
Thank you.
Other recent topics
