Skip to Content
avatar image
Former Member

RAR Mitigating Control Deletion

Hello,

I am having an issue where I've deleted all mitigating controls and now it will not let me delete the associated approvers and business units. When I search for mitigating controls the search comes up empty. The weird thing though is that the main page is still showing one inactive mitigating control. I've also checked users and roles to make sure none are assigned a mitigating control.

Error when deleting the business unit

com.virsa.cc.rulearchitect.dao.DAOException: Business unit: AAID is already assigned to Mitigation Control; it cannot be deleted

Error when deleting the administrator:

administrator ID is already assigned as approver to a business unit : Can't be deleted

I've also checked that Send e-mail notification to the monitor of the updated mitigated object is set to NO and all workflow integration with CUP is set to NO

Any suggestions where this thing might be hiding?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 02, 2010 at 01:34 AM

    Kyle,

    Did you delete mitigating control via front-end? If you did then it should allow you to delete business unit etc. If you deleted them via file then there is an issue. You can load an empty mitigation import file which will wipe out any exisitng mitigating controls. I have seen this issue when I tried to manipulate controls via file.

    Regards,

    Alpesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2010 at 06:28 AM

    Kyle,

    Other solution will be to delete data at DB level.

    All RAR mitigation table names contain MIT string VIRSA_CC_... MIT...

    regards,

    Surpreet

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2010 at 07:12 AM

    Do you still have an export file of your mitigations? (if not, create one...)

    There are "M" rows with the table header, and "D" rows with data for those tables.

    Go and delete all the "D" rows so that jiust the "M" rows are in the file, and import this via mitigation upload.

    That should make sure all tables are empty.

    Frank.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Frank Koehntopp

      Sorry, Frank. You must have the first line empty for the mitigation upload to work. Mitigation is not tied to any connector.

      Regards,

      Alpesh