Unable to delete a tag in the Deployment Tags group, even though no fixed deployment project is present

Technical Articles ID: KB92103
Last Modified: 10/1/2020

Environment

McAfee ePolicy Orchestrator (ePO) 5.10.0, 5.10 Update 1–6
McAfee MVISION ePO

Problem

When you create a fixed deployment, a tag is created in the Deployment Tags group of the ePO Tag Catalog and it can't be deleted.

You observe the following if you create a fixed deployment, but later edit that deployment to make it a continuous deployment:

The tag can remain in the tag catalog.
The tag can't be deleted, even if you completely delete the deployment.

You see this issue with the following products:

ePO 5.10.0 and Update 1–6
MVISION ePO

Solution 1

ePO on-premises

This issue is resolved in ePolicy Orchestrator 5.10.0 Update 7, which is available from the Product Downloads site.

NOTE: You need a valid Grant Number to access the update.

To view other known and resolved issues, see KB90382 - ePolicy Orchestrator 5.10.x Known Issues.

Solution 2

MVISION ePO
This article will be updated when a solution for MVISION ePO is available.

Workaround

ePO on-premises customers only
Step 1 - Run the following query. Confirm that it identifies the tags you want to delete, and no others:

Click Start, Programs, Microsoft SQL Server, Query Analyzer.
Connect to the SQL Server.
Open a query window, and select the ePO database. For instructions, see KB67591.
Paste the following into the query window:

select T.TagID, T.[Name] from EPOTag T
join EPOTagGroupMT G on T.TagGroupID = G.TagGroupID
left join EPODeploymentTagMT D on T.TagID = D.TagID
where D.TagID IS NULL
AND G.GroupName = 'Deployment Tags'
Click Execute Query.

Step 2 - If the above query identifies the tags you want to remove, run the following query to delete them:

Open a query window, and select the ePO database.
Paste the following query into the query window:

delete from EPOTag where TagID in
(select T.TagID from EPOTag T
join EPOTagGroupMT G on T.TagGroupID = G.TagGroupID
left join EPODeploymentTagMT D on T.TagID = D.TagID
where D.TagID IS NULL
AND G.GroupName = 'Deployment Tags')
Click Execute Query.

Related Information

See the ePO 5.10 Product Guide for more information about Deployment tags.

Affected Products

ePolicy Orchestrator 5.10.x
Known Issue/Product Defect
MVISION ePO

Languages:

This article is available in the following languages:

English United States
Spanish Spain
French
Italian
Japanese
Portuguese Brasileiro
Chinese Simplified

Knowledge Center

Unable to delete a tag in the Deployment Tags group, even though no fixed deployment project is present

Environment

Problem

Solution 1

Solution 2

Workaround

Related Information

Affected Products

Languages:

Title

Title

Knowledge Center

Unable to delete a tag in the Deployment Tags group, even though no fixed deployment project is present

Environment

Problem

Solution 1

Solution 2

Workaround

Related Information

Affected Products

Languages:

Choose your region

Title

Title