The physical_table_name column in the ca_resource_family table has its data swapped for the "Cluster.Resource" and "Cluster.Resource Group" records.

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Run the below SQL Query:

select id, name, physical_table_name, table_extension_name, description
from ca_resource_family
where name like'Cluster.Resource%'
order by 2

The output will be:

As seen for ci_network_resource the name is mentioned as "Cluster.Resource Group' and whereas for ci_network_resource_group the same is Cluster.Resource.

Environment

USRD 17.3

Resolution

SE has reviewed it via defect DE581776 and updated that this can be editted manually in GUI and there will be no impact