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

8.1.8.000-IBM-SPOC-Linuxs390x
8.1.8.000-IBM-SPSRV-Linuxppc64le
8.1.8.000-IBM-SPCMS-WindowsX64
8.1.8.000-IBM-SPCMS-WindowsI32
8.1.8.000-IBM-SPCMS-Linuxx86_64
8.1.8.000-IBM-SPOC-WindowsX64
8.1.8.000-IBM-SPOC-Linuxx86_64
8.1.8.000-IBM-SPOC-LinuxPPC64le
8.1.8.000-IBM-SPOC-AIX
8.1.8.000-IBM-SPSRV-WindowsX64
8.1.8.000-IBM-SPSRV-Linuxx86_64
8.1.8.000-IBM-SPSRV-Linuxs390x
8.1.8.000-IBM-SPSRV-AIX
8.1.6.200-IBM-SPSRV-WindowsX64
8.1.6.200-IBM-SPSRV-Linuxx86_64
8.1.6.200-IBM-SPSRV-Linuxs390x
8.1.6.200-IBM-SPSRV-Linuxppc64le
8.1.6.200-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1.6.X interim fix downloads
IBM Spectrum Protect Server V8.1 Fix Pack 8 (V8.1.8) Downloads

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 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

• R81A PSY

     UP

• R81L PSY

     UP

• R81W PSY

     UP