none
Unable to delete Oracle MA RRS feed

  • Question

  • 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.

    Monday, February 23, 2015 10:44 PM

Answers

All replies