Duplicate Task Server communication profiles show Existing profile '' contains the same FQDN and web application path

Products

• IT Management Suite

Issue/Introduction

When viewing Site Server Communication Profiles in the Symantec Management Console, some of them are duplicated:

Settings > Agents / Plug-ins > Symantec Management Agent > Site Server Communication profiles

Users are unable to delete (right-click > delete) duplicate communication profiles on their SMP.

May see the following under the duplicate communication profile settings: 

Existing profile 'name of the server' contains the same FQDN and web application path. Existence of non-unique profiles can lead to connection problems if some outdated profile will be used by the NS agent.

Environment

Symantec Management Platform 8.X 

ITMS 8.x

Cause

During the disaster recovery process or an off-box upgrade, another "built-in" SMA profile may be created.

Upgrading sometimes causes another profile to be created as well.

Resolution

Browse to Settings > Agents / Plug-ins > Symantec Management Agent Communication Profiles > Site Server Communication profiles

1. Identify the correct duplicate profile (be sure that this profile is not currently in use by agents/site servers)
2. Right-click on the communication profile and select "Properties"
3. Copy the GUID of the communication profile
4. Paste the following query into SQL and run, replacing the capitalized section with the appropriate GUID:
   Update Item
   set Attributes = 0
   where Guid = 'GUID OF PROFILE TO DELETE'
5. Go back to the communication profile page, refresh, and you can then right-click and delete the profile

IF the Communication Profile is not visible in the Console, your error message may say: Existing profile '' contains the same FQDN and web application path.  This indicates that the Communication Profile does not have a name in the database and so it is not visible in the Console. 

To find these Duplicate Profiles run this SQL Query (exactly as shown):

select Name, GUID, State, *
from item
where State like '%<Name of the server or profile having issue>%'
order by 1

Once you find the GUID, set it's attribute to 0 and add it to the ItemToDelete table (deletes happen every 15 minutes on the NS.Quarter Hour Task schedule)

Update Item
set Attributes = 0
where Guid = 'GUID OF PROFILE TO DELETE'

Then:

insert into ItemToDelete 
select  guid, GETDATE() 
from item where guid = 'GUID OF PROFILE TO DELETE'

After the NS.Quarter Hour schedule runs the item will be removed from the database.

Additional Information

171409 "Unable to delete duplicate or conflicting Symantec Management Agent communication profiles"