IBM Support

IT27833: DSMSERV INSERTDB MIGHT COMPLETE WITH ERROR "ANR1338E ONE OR MORECONSTRAINT VIOLATIONS WERE DETECTED"

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • The DSMSERV INSERTDB utility will report the following messages
    in the insert.out log file:
    ....
    ANR1527I INSERTDB: Checked 200 of 200 database objects in
    45:40:18.
    ANR1338E One or more constraint violations were detected.
    Examine log file
    constrnt.log for details.
    ANR1396E INSERTDB: Process 1, database insert, has completed
    with errors.
    
    Reviewing the constrnt.log file it will show the following
    exception:
    ....
    </constraint_error>
    <constraint_error timestamp="20190108095308"
    tablename="TSMDB1"."REPLICATING_OBJECTS" numcols="20">
    <violation type="OUT_OF_RANGE" colnum="18">
    <rowdata>
    .....
    
    The problem only occurs when column 18 has a negative value. For
    example:
    
    <constraint_error timestamp="20190108095308"
    tablename="TSMDB1"."REPLICATING_OBJECTS" numcols="20">
    <violation type="OUT_OF_RANGE" colnum="18">
    ...
    <col colnum="18" colname="GROUPMAP" coltype="INTEGER">
    -2147450880
    </col>
    ...
    </rowdata>
    </constraint_error>
    
    
    
    IBM Spectrum Protect versions affected:
    Server 7.1.x and 8.1.x on supported platforms
    
    
    
    Initial impact: Medium
    
    
    
    Additional Keyword: TS001779674 TSM "spectrum protect" "DSMSERV
    INSERTDB" ANR1338E ANR1396E "REPLICATING_OBJECTS"
    

Local fix

  • Contact the IBM Spectrum Protect support team for assistance in
    adding the skipped rows to the database.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All IBM 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 8.1.6.200 and 8.1.8. Note    *
    * that this is subject to change at the discretion of IBM.     *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms for reported release:  AIX, Linux, and
    Windows.
    Platforms fixed:  AIX, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27833

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    81A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-22

  • Closed date

    2019-01-24

  • Last modified date

    2019-01-24

  • 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: 81A

Reference #: IT27833

Modified date: 24 January 2019