Unregistering IQ Bot 11.x from the Control Room

You have to unregister IQ Bot from the Control Room if the IQ Bot URL changes because of installation or uninstallation of IQ Bot, or when a load balancer is added.

After unregistering IQ Bot from the Automation Anywhere Control Room, restart the Automation Anywhere Cognitive Console service.

Procedure

  1. Using the sysadmin role, run two separate SQL queries in different databases.
  2. Run the first SQL query in the Control Room database to delete the following data: 
    • DELETE FROM [CRDB-NEW].[dbo].[APP_USER] WHERE [type]='IQBOT'
    • DELETE FROM [CRDB-NEW].[dbo].[USERS] WHERE user_type='APP'
    • DELETE from dbo.ACTIVEMQ_ACKS
    • DELETE from [CRDB-NEW].dbo.ACTIVEMQ_ACKS
    • DELETE from dbo.ACTIVEMQ_MSGS
  3. Run the second SQL query in the IQ Bot configuration database to delete the following data: 
    • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='controlRoomVersion'
    • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='appRegistered'
    • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='controlRoomUrl'
    • DELETE FROM [Configurations].[dbo].[Configurations] where [key]='appId'
You have unregistered successfully.