ePO 5.10 Cumulative Update 15 fails with the RequestError: ALTER TABLE DROP COLUMN failed because column 'Tags' does not exist in table 'EPOLeafNodeMT'

Technical Articles ID: KB96290
Last Modified: 2023-02-10 10:44:04 Etc/GMT

Environment

ePolicy Orchestrator (ePO) 5.10 Update 15

Problem

An upgrade from ePO 5.10 Update 9 to ePO 5.10 Update 15 fails.

The errors below are recorded in the ePOUpdater.yyyy.mm.dd.hr.min.logs file (C:\Programdata\McAfee\ePolicy Orchestrator\ePOUpdaterLogs):

NOTE: You can search the EPOUpdater log with the keyword Total files processed to find the failure count. This helps you to identify one by one failure entries to find the problem.

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.

Cause

The tags column from the ePOLeafNode table is missing, which leads to errors in the epoUpdater log.

When you run the SQL script named 4_ePO_Function.sql through the CU15 process, the script doesn't run completely.

The 4_ePO_Function.sql file is located in C:/PROGRA~2/McAfee/EPOLIC~1/updates/CU-15/down/CU-13/EPOCore/4_ePO_Function.sql

Solution

Perform the steps below to find the missing column, view, or function:

Open SQL Management Studio.
Expand Databases and select your ePO database.
Right-click on the ePO database and click New Query.
Type the following commands in the blank area:

Query 1 - The query below helps find the tags column from the ePOLeafNodeMT table:

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

Output
A sample of the results that the query generates is shown below:

TABLE_NAME	COLUMN_NAME
EPOLeafNodeMT	Tags

Query 2 - The query below helps check whether the ePoLeafNode view is listed in the ePO database:

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

Output
A sample of the results that the query generates is shown below:

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

Query 3 - The query below helps to check whether the function name is available in the ePO core database:

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

Output
A sample of the results that the query generates is shown below:

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

Perform either of the following options to resolve the issue:

Option 1:

If the Query 1 results show that the tags column is missing, run the following script to find the tags column from the ePoLeafNodeMT table:

Alter table EPOLeafNodeMT add ExcludedTags AS ([dbo].[epofn_tagCreateList]([AutoID],(1)));
After the successful completion of the above query, run the script below:

EXEC sp_refreshView N'EPOLeafNode';

Option 2:

If the Query 1 results show the tags column, run only the following script to refresh the EPOLeafNode-view:

EXEC sp_refreshView N'EPOLeafNode';

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

ePO 5.10 Cumulative Update 15 fails with the RequestError: ALTER TABLE DROP COLUMN failed because column 'Tags' does not exist in table 'EPOLeafNodeMT'

Environment

Problem

Cause

Solution

Affected Products

Languages:

Title

Title

Knowledge Center

ePO 5.10 Cumulative Update 15 fails with the RequestError: ALTER TABLE DROP COLUMN failed because column 'Tags' does not exist in table 'EPOLeafNodeMT'

Environment

Problem

Cause

Solution

Affected Products

Languages:

Choose your region

Title

Title