No DCM0 item when running update_da_dc_database

Products

Network Observability CA Performance Management

Issue/Introduction

On failover steps. No DCM0 item when running update_da_dc_database_references.sh

Updating Data Aggregator item record to reflect new IP Address...
Updated.
Updating Data Aggregator device record to reflect new IP Address/hostname...
Updated.
WARN - Cannot find item_id for DCM0 item tied to source DC: xxxxxxx
WARN - Cannot find item_id for device item tied to source DC: xxxxxx
WARN - Cannot find item_id for DCM0 item tied to source DC: xxxxxx
WARN - Cannot find item_id for device item tied to source DC: xxxxxx
WARN - Cannot find item_id for DCM0 item tied to source DC: xxxxxx
WARN - Cannot find item_id for device item tied to source DC: xxxxxx

Environment

Dx NetOps Performance Management 22.2,23.3

Cause

Possibly using short name versus FQDN in the script's declare statements

declare -a SOURCE_DC_HOSTNAMES=(xxxx.xx.xx.xx xxxxx.xx.xxx.xxx xxxx.xx.xx.xxx)
declare -a RECOVERY_DC_HOSTNAMES=(xxxx xxxx.xx.xxx.xx xxxxxx)
declare -a RECOVERY_DC_IP_ADDRESSES=("xxx.xxx.xxx.xx" "xxx.xxx.xxx.xx" "xxx.xxx.xxx.xx")

Resolution

Run the following commands in vertica :

drdata=> select * from dauser.v_item where name like '%DCM0%';
item_id | item_type | name | description | tenant_item_id
---------+-----------------------------+-------------------+-------------+----------------
5274 | {http://im.ca.com/core}Item | xxx - DCM0 | | 1
1383294 | {http://im.ca.com/core}Item | xxx - DCM0 | | 1
2141158 | {http://im.ca.com/core}Item | xxx - DCM0 | | 1

Then:

drdata=> select * from dauser.v_item where name like '%DCM0%';
item_id | item_type | name | description | tenant_item_id
---------+-----------------------------+-------------------+-------------+----------------
5274 | {http://im.ca.com/core}Item | xxx - DCM0 | | 1
1383294 | {http://im.ca.com/core}Item | xxx - DCM0 | | 1
2141158 | {http://im.ca.com/core}Item | xxx - DCM0 | | 1

Run select * from v_attribute_instance where item_id IN ($1) order by attr_qname

Where $1 is the item_id value that comes back for the above query

Note the value for http://im.ca.com/dcm%7DDataCollectionMgrInfo.RelatedDeviceItem

Example:
5274 | {http://im.ca.com/dcm}DataCollectionMgrInfo.RelatedDeviceItem | long_value | 5275

Now do:

drdata=> select * from dauser.item where item_id = 5275;

If it comes back empty do the same for the other collectors. If all come back empty the error can be considered benign and you can move on