IBM Support

IT20671: ANR0102E MONSTATS.C(5715): ERROR 1202 INSERTING ROW IN TABLE GUIL2.REPLSRV.GRID

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A hub server can report in the activity log:
    
    05/09/2017 05:07:37      ANR0102E monstats.c(5715): Error 1202
    inserting row in table "GUIL2.Replsrv.Grid".
    
    A trace with flags "dbconn dbitxn monitor monitor_detail sql"
    shows:
    
    13:38:23.885 [295][dbieval.c][690][DbiEvalSQLOutcomeX]:SQLSTATE
    23505,
    SQLCODE -803, SQLMsg=[IBM][CLI Driver][DB2/AIX64] SQL0803N  One
    or more
    values in the INSERT statement, UPDATE statement, or foreign key
    update
    caused by a DELETE statement are not valid because the primary
    key,
    unique constraint or unique index identified by "1" constrains
    table
    "TSMDB1.GUIL2_REPLSRV_GRID" from having duplicate values for the
    index
    key.  SQLSTATE=23505
    .
    
    
    The message will be reported in the activity log however it does
     not impact any operation.
    
    IBM Spectrum Protect Versions Affected:
    Server 7.1.7.x and higher and 8.1.x and higher on all supported
    platforms
    
    Initial Impact:
    Medium
    
    Additional Keywords:
    TSM; IBM Spectrum Protect; OC; hub; monitor; monstats.c;
    GUIL2.Replsrv.Grid
    
    | MDVREGR 7.1.7.0-TIV_5698MSV |
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server and Spectrum Protect       *
    * server users.                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in levels 7.1.8 and 8.1.2.  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 number

    IT20671

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-05-24

  • Closed date

    2017-06-19

  • Last modified date

    2018-03-30

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT20671

Modified date: 30 March 2018