Issue Reinstalling Plugin After Manual Deletion

[angelborrego (Ángel Borrego)]

Which IIQ version are you inquiring about?

IdentityIQ 8.3p3

Hi all,

A few days ago, I installed the following plugin: Application Health Plugin. It was working perfectly, but I wanted to make some modifications and reinstall it with the new changes.

I tried uninstalling the plugin via the SailPoint UI, under Installed Plugins, by clicking the “X,” but I kept getting an error. As a workaround, I manually removed the plugin XML from debug mode, along with the associated XML files for rules, custom objects, and ServiceDefinitions created during the plugin installation.

However, when I attempted to install the plugin again, I encountered the following error:

2025-02-25T08:56:26,789 ERROR ajp-nio-0.0.0.0-9020-exec-10 sailpoint.plugin.PluginInstaller:276 - An error occurred during plugin installation
sailpoint.tools.GeneralException: There is already an object named 'app_health_data' in the database.
...
..
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'app_health_data' in the database.

I connected to ./iiq console and ran the query:

SELECT * FROM INFORMATION_SCHEMA.TABLES;

But I couldn’t find any table named app_health_data. The only relevant table I found was spt_plugins, which contains just two rows (corresponding to other installed plugins), but none related to the Application Health Plugin.

I’m a bit lost on how to completely uninstall the plugin so I can reinstall it properly. Any guidance would be greatly appreciated!

Thanks in advance!

[phodgdon (Paul Hodgdon)]

When you install a plugin with a db folder there is an install, upgrade and uninstall directory. The sql scripts get run according to your action, I.e installing, deleting, etc. It sounds like you have an install DDL, uninstalled the plugin and are trying to install but the table already exists. You’ll want to connect to the plugin database and drop the table and reinstall. Some databases let you run a create table if not exits, others won’t.

See https://community.sailpoint.com/mpomh84452/attachments/mpomh84452/IIQ_docs/658/1/8.4_IdentityIQ_Plugins.pdf for more help.