正在从注销 IQ Bot Control Room
IQ Bot Control Room 如果 IQ Bot URL 因安装或卸载而更改 IQ Bot,或者添加了负载平衡器,则必须从注销。
过程
- 使用 sysadmin 角色,在不同的数据库中运行两个单独的 SQL 查询。
-
运行 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 语句 以后:- 运行以下查询:
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')
- 上述查询将为您提供一个“ IQBotAppUserId ”编号。 将 id = 'IQBotAppUserId' 替换为 id = 'number' 查询。
- 执行以下删除查询:
DELETE FROM [AAE-Database].[dbo].[SERVICE_USER] WHERE [type]='IQBOT'
-
DELETE FROM [AAE-Database].[dbo].[USERS] WHERE id = 'IQBotAppUserId'
- 运行以下查询:
-
运行 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'
您已成功注销。 -