ePO 5.10 累积更新15发生故障，RequestError： ALTER TABLE DROP COLUMN 失败，因为表 "EPOLeafNodeMT" 中不存在列 "标记"

技术文章 ID: KB96290
上次修改时间: 2023-03-09 13:50:00 Etc/GMT

环境

ePolicy Orchestrator （ePO） 5.10 更新15

问题

从 ePO 5.10 更新9到 ePO 5.10 更新15的升级失败。

以下错误记录在文件中 ePOUpdater.yyyy.mm.dd.hr.min.logs （ C:\Programdata\McAfee\ePolicy Orchestrator\ePOUpdaterLogs ）：

注意: 您可以在 EPOUpdater 日志中搜索已处理的关键字 总文件 ，以查找失败计数。这可帮助您识别一个失败条目以查找问题。

2023-01-30T18:52:26.226Z - info: Sucessfully executed SQL -- END: EPO-9610
--------------------------------------------------------------------------------
EXEC dbo.EPOCore_DropFunction N'EPOGetPolicyAssignmentForApproval';

2023-01-30T18:52:26.232Z - error: Failed to execute SQL CREATE FUNCTION [dbo].[EPOGetPolicyAssignmentForApproval]
LEFT JOIN EPOPolicyLocaleXlate D2 ON C.ProductCode = D2.ProductCode AND PT.FeatureTextID = D2.Token AND D2.LanguageID = @LanguageID
WHERE B.Status = @WorkflowStatus
execution failed with error : RequestError: View or function 'EPOLeafNode' has more column names specified than columns defined.
2023-01-30T18:52:26.232Z - error: Error executing script file 4_ePO_Function.sql
2023-01-30T18:52:26.232Z - info: SQL script execution failed
2023-01-30T18:52:26.232Z - info: Add update with id CU-15 to failed update list
2023-01-30T18:52:26.232Z - info: Total files processed : 633 success : 44 failure : 1
2023-01-30T18:52:26.232Z - info: Waiting for apply updates to completed
2023-01-30T18:52:26.260Z - info: Total files processed : 633 success : 44 failure : 1
2023-01-30T18:52:26.260Z - info: Waiting for apply updates to completed
2023-01-30T18:52:26.260Z - info: going to execute sql 5_ePO_Proc.sql
2023-01-30T18:52:26.261Z - info: Sql file5_ePO_Proc.sql has 20 chunks
2023-01-30T18:52:26.261Z - info: Copying file from C:\Users\secadmin\Downloads\ePO_5.10.0_Update_15\resources\app\release\webapps\EPOCore\sql\down\5.10.0cu-5.10.0\CU-11\5_ePO_Proc.sql to C:/PROGRA~2/McAfee/EPOLIC~1/updates/CU-15/down/CU-11/EPOCore/5_ePO_Proc.sql
2023-01-30T18:52:26.288Z - info: Successfully got connection

execution failed with error : RequestError: View or function 'dbo.EPOLeafNode' has more column names specified than columns defined.
2023-01-30T18:52:26.331Z - error: Error executing script file 5_ePO_Proc.sql
2023-01-30T18:52:26.331Z - info: SQL script execution failed
2023-01-30T18:52:26.331Z - info: Add update with id CU-15 to failed update list
2023-01-30T18:52:26.331Z - info: Total files processed : 633 success : 44 failure : 2

2023-01-30T18:52:46.359Z - error: Failed to execute SQL -- end EPO-9724
--------------------------------------------------------------------------------
/**** START: EPO-9646 Adding the drop column as we are modifying the function which is being used in these
columns hence they are being dropped here before altering the function ***/
Alter table EPOLeafNodeMT drop column [Tags];
execution failed with error : RequestError: ALTER TABLE DROP COLUMN failed because column 'Tags' does not exist in table 'EPOLeafNodeMT'.
2023-01-30T18:52:46.359Z - error: Error executing script file 4_ePO_Function.sql
2023-01-30T18:52:46.359Z - info: SQL script execution failed
2023-01-30T18:52:46.359Z - info: Add update with id CU-15 to failed update list
2023-01-30T18:52:46.360Z - info: Total files processed : 633 success : 49 failure : 3

2023-01-30T18:52:46.359Z - error: Failed to execute SQL -- end EPO-9724
--------------------------------------------------------------------------------
/**** START: EPO-9646 Adding the drop column as we are modifying the function which is being used in these
columns hence they are being dropped here before altering the function ***/
Alter table EPOLeafNodeMT drop column [Tags];
execution failed with error : RequestError: ALTER TABLE DROP COLUMN failed because column 'Tags' does not exist in table 'EPOLeafNodeMT'.
2023-01-30T18:52:46.359Z - error: Error executing script file 4_ePO_Function.sql
2023-01-30T18:52:46.359Z - info: SQL script execution failed

execution failed with error : RequestError: Could not use view or function 'EPOPolicyAssignment' because of binding errors.
2023-01-30T18:52:46.448Z - error: Error executing script file 5_ePO_Proc.sql
2023-01-30T18:52:46.448Z - info: SQL script execution failed
2023-01-30T18:52:46.448Z - info: Add update with id CU-15 to failed update list
2023-01-30T18:52:46.450Z - info: Total files processed : 633 success : 49 failure : 4
2023-01-30T18:52:46.450Z - info: Waiting for apply updates to completed

execution failed with error : RequestError: Could not use view or function 'EPOPolicyAssignment' because of binding errors.
2023-01-30T18:52:49.569Z - error: Error executing script file 5_ePO_Proc.sql
2023-01-30T18:52:49.569Z - info: SQL script execution failed
2023-01-30T18:52:49.569Z - info: Add update with id CU-15 to failed update list
2023-01-30T18:52:49.569Z - info: Total files processed : 633 success : 53 failure : 5
2023-01-30T18:52:49.569Z - info: Waiting for apply updates to completed

2023-01-30T18:53:14.808Z - info: Going to execute rollback script..C:/PROGRA~2/McAfee/EPOLIC~1/updates/CU-15/down/CU-13/EPOCore/4_ePO_Function.sql
2023-01-30T18:53:14.808Z - info: going to execute sql 4_ePO_Function.sql
2023-01-30T18:53:14.808Z - info: Sql file4_ePO_Function.sql has 9 chunks
2023-01-30T18:53:14.872Z - info: Successfully got connection
2023-01-30T18:53:14.944Z - info: Sucessfully executed SQL -- Copyright (C) McAfee, LLC. All Rights Reserved.
PRINT '<<< EXECUTING CU-111-CU-10/4_ePO_Function.sql : ' + CONVERT(VARCHAR(100), GETDATE()) + ' >>>'

2023-01-30T18:53:14.949Z - info: Sucessfully executed SQL EXEC EPOCore_DropFunction N'EPOFN_CompareVersions_2';

2023-01-30T18:53:14.954Z - error: Failed to execute SQL --START : EPO-9646 Downgrade/Rollback.
/*** Since the function is being used in computed column so dropping and re-creating them before rollback. ***/
Alter table EPOLeafNodeMT drop column [Tags];
execution failed with error : RequestError: ALTER TABLE DROP COLUMN failed because column 'Tags' does not exist in table 'EPOLeafNodeMT'.
2023-01-30T18:53:14.954Z - error: Error executing script file 4_ePO_Function.sql
2023-01-30T18:53:14.954Z - info: Rollback SQL script execution failed

ePOUpdater log screen showing the error entry details.

ePOUpdater log screen showing the error entry details.

原因

缺少表中的 " 标记" 列ePOLeafNode ，这会导致日志中 epoUpdater 出现错误。

当您运行通过 CU15 进程命名 4_ePO_Function.sql 的 SQL 脚本时，脚本不会完全运行。

该 4_ePO_Function.sql 文件位于 C:/PROGRA~2/McAfee/EPOLIC~1/updates/CU-15/down/CU-13/EPOCore/4_ePO_Function.sql

解决方案

执行以下步骤以查找缺少的列、视图或函数：

打开 SQL Management Studio。
展开数据库，然后选择 ePO 数据库。
右键单击 ePO 数据库，然后单击新建查询。
在空白区域中键入以下命令：

查询 1 - 下面的查询可帮助您从表中 ePOLeafNodeMT 找到标记列：

SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'EPOLEAFNODEMT' and COLUMN_NAME = 'tags'

输出
查询生成的结果示例如下所示：

TABLE_NAME	COLUMN_NAME
EPOLeafNodeMT	Tags

查询 2- 下面的查询可帮助您检查视图是否 ePoLeafNode 列在 ePO 数据库中：

Select * from sys.views where name = 'EPOLeafNode'

输出
查询生成的结果示例如下所示：

Name	Object_id	Principal_id	Schema_id	Parent_object_id	Type	Type_desc	Create_date	Modify_date	Is_ms_shipped	Is_published
EPOLeafNode	1898489842	NULL	1	0	V	VIEW	5/10/22 9:58 AM	2/4/23 9:41 AM	0	0

查询 3- 下面的查询有助于检查函数名称在 ePO 核心数据库中是否可用：

Select * from sys.objects where name like 'epofn_tagcreatelist'

输出
查询生成的结果示例如下所示：

Name	Object_id	Principal_id	Schema_id	Parent_object_id	Type	Type_desc	Create_date	Modify_date	Is_ms_shipped	Is_published
epofn_tagCreateList	1542348609	NULL	1	0	FN	SQL_SCALAR_FUNCTION	11/22/22 10:59 AM	11/22/22 10:59 AM	0	0

执行以下任一选项来解决该问题：

选项1：

如果查询1结果显示 "标记" 列丢失，请运行以下脚本以从表中 ePoLeafNodeMT 查找 "标记" 列：

Alter table EPOLeafNodeMT add ExcludedTags AS ([dbo].[epofn_tagCreateList]([AutoID],(1)));
成功完成上述查询后，运行下面的脚本：

EXEC sp_refreshView N'EPOLeafNode';

选项 2：

如果查询1结果显示标记列，请仅运行以下脚本以刷新 EPOLeafNode-查看：

EXEC sp_refreshView N'EPOLeafNode';

免责声明

本文内容源于英文。如果英文内容与其翻译内容之间存在差异，应始终以英文内容为准。本文部分内容是使用 Microsoft 的机器翻译技术进行翻译的。

受影响的产品

语言:

此文章有以下语言版本：

Knowledge Center

ePO 5.10 累积更新15发生故障，RequestError： ALTER TABLE DROP COLUMN 失败，因为表 "EPOLeafNodeMT" 中不存在列 "标记"

环境

问题

原因

解决方案

免责声明

受影响的产品

语言:

Title

Title

Knowledge Center

ePO 5.10 累积更新15发生故障，RequestError： ALTER TABLE DROP COLUMN 失败，因为表 "EPOLeafNodeMT" 中不存在列 "标记"

环境

问题

原因

解决方案

免责声明

受影响的产品

语言:

选择您的区域

Title

Title