Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Unregistering IQ Bot from the Control Room

  • Updated: 7/12/2021

    Unregistering IQ Bot 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 set of SQL statements in the Control Room database to delete the following data:

      Run the following SQL statements for versions A2019.10 to A2019.13:

      DELETE FROM [AAE-Database].[dbo].[ACTIVEMQ_ACKS]
      DELETE FROM [AAE-Database].[dbo].[ACTIVEMQ_MSGS]
      DELETE FROM [AAE-Database].[dbo].[SERVICE_USER]
      DELETE FROM [AAE-Database].[dbo].[USERS] where user_type='APP'
      Run the following SQL statements for version A2019.14 and later:
      1. Run the following query:
        USE [AAE-Database]
        SELECT T.uuid As TenantID,T.name AS TenantName,T.created_by,T.enabled,U.id AS IQBotAppUserId,U.user_type,S.url AS 
        IQBotURL FROM [dbo].[TENANTS] T 
        LEFT JOIN [dbo].[USERS] U ON T.uuid = U.tenant_uuid 
        LEFT JOIN [dbo].[SERVICE_USER] S ON U.id = S.id
        WHERE (U.user_type='APP' AND S.type='IQBOT')
        
      2. The above query will provide you an 'IQBotAppUserId' number. Replace id = 'IQBotAppUserId' with id = 'number' in the next query.
      3. Execute the following delete queries:
        DELETE FROM [AAE-Database].[dbo].[SERVICE_USER] WHERE [type]='IQBOT'
      4. DELETE FROM [AAE-Database].[dbo].[USERS] WHERE id = 'IQBotAppUserId'
    3. Run the second set of SQL statements in the IQ Bot configuration database to delete the following data:
      • DELETE FROM [IQBot].[dbo].[Configurations] where [key]='controlRoomVersion'
      • DELETE FROM [IQBot].[dbo].[Configurations] where [key]='appRegistered'
      • DELETE FROM [IQBot].[dbo].[Configurations] where [key]='controlRoomUrl'
      • DELETE FROM [IQBot].[dbo].[Configurations] where [key]='appId'
      You have unregistered successfully.
    Send Feedback