1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

tsm report on failed replications

Discussion in 'Scripting' started by sjimenez3300, Oct 3, 2017.

  1. sjimenez3300

    sjimenez3300 Newcomer

    Joined:
    Sep 29, 2017
    Messages:
    2
    Likes Received:
    0
    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)
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,676
    Likes Received:
    374
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    Try this instead:
    Code:
    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.
     
  4. sjimenez3300

    sjimenez3300 Newcomer

    Joined:
    Sep 29, 2017
    Messages:
    2
    Likes Received:
    0
    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?
     
  5. rowl

    rowl ADSM.ORG Senior Member

    Joined:
    May 18, 2006
    Messages:
    229
    Likes Received:
    9
    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
     

Share This Page