tsm report on failed replications

[sjimenez3300]

Hello all,
I would like to get a report on failed replication using the OC.(ver 7.1.7)...so that I can get emails with the failures..I found the following select statement but it doesn't tell which node failed :0( ..any suggestions?..or maybe someone knows the ANR that tsm gives out with the failed replication node name?
SELECT date_time,severity,message from actlog WHERE message LIKE"ANR1893E'' -
and date_time>current_timestamp-24 hours

thank you in advance for your help :0)

 

[marclant]

Try this instead:

SELECT START_TIME,END_TIME,NODE_NAME,STATE,PHASE,COMP_STATE,COMP_REASON,COMP_CODE FROM REPLICATIONVIEW WHERE COMP_CODE!=0 AND START_TIME>current_timestamp-24 hours

You may need to look at SELECT * FROM REPLICATIONVIEW to see all the fields and possible values in case you need additional filtering. On my test box, they were all successful, so hard to test.

 

[sjimenez3300]

Marclant thank you!! it took me a while to tweak the select statement but I think I got it..however, I'm trying to double check in the actlogs but not seeing it..here is my select; SELECT START_TIME,END_TIME,NODE_NAME,STATE,PHASE,COMP_STATE,COMP_REASON,COMP_CODE FROM REPLICATIONVIEW WHERE COMP_STATE='COMPLETE' AND START_TIME>current_timestamp-24 hours
I got;

START_TIME END_TIME NODE_NAME STATE PHASE COMP_STATE COMP_REASON COMP_CODE
2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 ENDED NONE COMPLETE NONE 0
2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE 0
2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE 0
I ALSO TRIED;
tsm: >SELECT START_TIME,END_TIME,NODE_NAME,STATE,PHASE,COMP_STATE,COMP_REASON,COMP_CODE FROM REPLICATIONVIEW WHERE STATE='FAILED' AND START_TIME>current_timestamp-24 hours

START_TIME END_TIME NODE_NAME STATE PHASE COMP_STATE COMP_REASON COMP_CODE
--------------------------- --------------------------- ------------------------------------------------------------------ -------- ------------ ----------- ------------ ------------
2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE 0
2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 TNGKPAP01 FAILED REPLICATING COMPLETE NONE 0
2017-10-11 13:00:01.000000 1900-01-01 00:00:00.000000 BFSKPAP01 FAILED REPLICATING COMPLETE NONE 0
BUT when I search in actlogs to get more info..nothing related to the replication failure :0( ..where else should I look for this..any idea?

 

[rowl]

Did this issue get resolved? I have a similar question. I have a node replication job that works for 399 out of 400 nodes. I isolated the problem to the D: drive on one Windows client from the replicationview table. The activity log on the source/destination servers only shows "Status of FAILED". When I look at the q noder nodename
Node Name Type Filespace Name FSID Files on Replication Files on
Server Server (1) Server (1)
--------------- ---- --------------- ---- ---------- --------------- ----------
nodename Bkup \\nodename\c$ 2 119,116 TARGETSERVER 120,559
nodename Bkup \\nodename\d$ 1 5,730,399 TARGETSERVER 5,730,398

I tried to replicate these individually by FSID and FSID 2 returns SUCCESSFUL but 1 is FAILED.

Is there any way to query why this is reporting failed?

This is from Spectrum Protect 8.1.0 on both source and target.

Thanks,
-Rowl