Need tool to completely remove StrongAuth plugin from DB and console

Products

• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Strong Authentication
• CA Advanced Authentication

Issue/Introduction

In our dev env, we have 10+ strongauth plugins configured and we are trying to install 2138 plugin, however we are running into issues because there is so much old config hanging around that we cannot delete.

We fee this old config is preventing the new plugin to be installed.  Please provide some instructions on how to remove the old plugin's from defaultorg/ga-user admin console and masteradmin console.  Ideally this should be done through the database to completely remove these items.

Environment

Release : 9.1

Component : AuthMinder(Arcot WebFort)

Resolution

Pre-requisites: Make sure to take the backup of the tables ARWFCONFIG , ARWFORGCONFIG , ARWFMODULEREGISTRY, before executing the queries. 

Execute below sql queries to remove plugin entries from DB:

delete from ARWFCONFIG where CONFIGTYPE=1002 and CONFIGID IN (select distinct configid from ARWFORGCONFIG where CONFIGTYPE=1002 and CONFIGIDSTR IN ('TESTPLUGIN1', 'TESTPLUGIN3', 'TESTPLUGIN4'));

delete from ARWFORGCONFIG where CONFIGTYPE=1002 and CONFIGIDSTR IN ('TESTPLUGIN1', 'TESTPLUGIN3', 'TESTPLUGIN4'); 

delete from ARWFMODULEREGISTRY where MODULETYPE=100 and MODULENAME IN ('TESTPLUGIN1', 'TESTPLUGIN3', 'TESTPLUGIN4');

commit;

Note: Replace the plugin names ('TESTPLUGIN1', 'TESTPLUGIN3', 'TESTPLUGIN4') with the plugin names that you want to remove from the database.