IT08244: "ANR0102E ERROR 1202 INSERTING ROW IN TABLE REPLICATED.OBJECTS" REPORTED ON REPLICATION SOURCE SERVER

7.1.3.000-TIV-TSMSRV-WIN
7.1.3.000-TIV-TSMSRV-SolarisSPARC
7.1.3.000-TIV-TSMSRV-Linuxx86_64
7.1.3.000-TIV-TSMSRV-Linuxs390x
7.1.3.000-TIV-TSMSRV-Linuxppc64
7.1.3.000-TIV-TSMSRV-HP-UX
7.1.3.000-TIV-TSMSRV-AIX

APAR status

• Closed as program error.

Error description

• During Tivoli Storage Manager node replication, the source
  server might log the following message:
  ANR0102E tbcli.c(2175): Error 1202 inserting row in table
  "Replicated.Objects".
  
  The symptom typically is seen if a node replication process was
  canceled and is not related to IT02221 where a similar symptom
  is reported an a replication target server.
  
    Customer/L2 Diagnostics (If Applicable)
  To verify that you are affected by this APAR collect the
  following SQL command output:
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  db2 "select * from replicated_objects repl left join
  replicating_objects repling on (repl.objid=repling.objid and
  repl.serverid=repling.serverid) where repling.objid is not null"
  
  You hit this APAR if the result sets SOURCE_RC column reports
  1052 (GRC_CANCELED).
  
    Tivoli Storage Manager Versions Affected: V7.1
  
    Initial Impact: Medium
    Additional Keywords: NRRO NRRG TSM
  

Local fix

• until a fix is available you can use the following commands to
  clean up the replicating_objects table:
   db2 connect to tsmdb1
   db2 set schema tsmdb1
   db2 "delete from replicating_objects where source_rc=1052 and
  objid in (select objid from replicated_objects)"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server node replication users.    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 7.1.3. Note that this is      *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R71A PSY

     UP

• R71H PSY

     UP

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP