Control Room 注销 IQ Bot

如果 IQ Bot URL 因 IQ Bot 的安装或卸载而更改,或者添加了负载均衡器,则必须从 Control Room 注销 IQ Bot

Automation Anywhere Control Room 注销 IQ Bot 后,重新启动 Automation Anywhere 认知控制台服务。

过程

  1. 使用 sysadmin 角色,在不同的数据库中运行两个单独的 SQL 查询。
  2. 运行 Control Room 数据库中的第一组 SQL 语句以删除以下数据:

    对版本 A2019.10 至 A2019.13 运行以下 SQL 语句:

    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'
    对版本 A2019.14 和更高版本运行以下 SQL 语句:
    1. 运行以下查询:
      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. 上述查询将为您提供一个‘IQBotAppUserId’编号。 替换 id = 'IQBotAppUserId'。
    3. 执行以下删除查询:
      DELETE FROM [AAE-Database].[dbo].[SERVICE_USER] WHERE [type]='IQBOT'
    4. DELETE FROM [AAE-Database].[dbo].[USERS] WHERE id = 'IQBotAppUserId'
  3. IQ Bot 配置数据库中运行第二组 SQL 语句以删除以下数据:
    • 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'
    您已成功注销。