No DCM0 item when running update_da_dc_database_references.sh

book

Article ID: 238536

calendar_today

Updated On:

Products

DX NetOps CA Performance Management - Usage and Administration

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

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")

Environment

Dx NetOps Performance Management 21.2.x

 

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