IT27941: RECLAIM CONTAINER OPERATION ON CLOUD-CONTAINER STORAGE POOLS FAILS WITH ANR0162W AND CLI0109E

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

APAR status

• Closed as program error.

Error description

• A reclaim container operation on cloud-container storage pools
  may fail with the following error in activity log:
  ANR0162W Supplemental database diagnostic information:
  -1:22001:-99999 ([IBM][CLI Driver] CLI0109E String data right
  truncation. SQLSTATE=22001)
  ANR0157W Database operation UPDATE for table SD.Containers
  failed with result code 2332 and tracking ID: 1284007b0.
  
  Customer/L2 Diagnostics:
  The problem can occur if the Object Storage provider uses eTags
  longer than 38 characters.
  A server trace (flags SC SCRECLAIM SD DB SQL) will show:
  
  [TraceSetInputParameters]:col=7, name=FILESIZE, type=INT64,
  value=222349
  [TraceSetInputParameters]:col=8, name=LASTWR, type=DATETIMEN,
  value=2019-01-08 09:26:40.322138
  [TraceSetInputParameters]:col=12, name=CHUNK_CNT, type=INT64,
  value=181
   [TraceSetInputParameters]:col=13, name=ETAG, type=STRING,
  >>>>
  value=dfcbed6bd001274d96af9f8d6a54afb26839cf64mtmail/633-2e2da0e
  4db4f1MBLO%dz......... /* Purp..................<<<<
  [TraceSetInputParameters]:col=14, name=CLOUDSIZE, type=INT64,
  value=222413
  [TraceSetInputParameters]:col=15, name=LASTREAD, type=DATETIMEN,
  value=2019-01-08 05:03:03.000000
  [RdbSetInputParameters]:Entry with inMap 1246f66a8, numInCols 1,
  specificCol -99, and thisOp OpUpdateWhere.
  [RdbSetInputParameters]:Setting param 0 needed based on
  inMapArg.
  [RdbSetInputParameters]:EXITING with rc=0.
  ....
  ....
  [SdUpdateXferedContainer]:Exit: rc=2332
  09][SdMoveContainer]:SdUpdateXferedContainer failed with rc=2332
  
  where the value reported in "value" field (between >>>> <<<<) is
  more than 38 chars.
  
  IBM Spectrum Protect Server version Affected: IBM Spectrum
  Protect Server versions 8.1.x on all platforms
  
  Initial Impact: Medium
  
  Additional Keywords: tsm cloud etag 38 ANR0162W CLI0109E 2332
  TS001690631
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users with cloud object      *
  * storage that uses SHA256 eTags.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 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