IT30767: IBM STORWIZE STORAGE DEVICE PROBE COMPLETED WITH 'SQLDATAEXCEPTION' ERRORS

APAR status

• Closed as program error.

Error description

• After probing IBM Storwize Storage Devices, the following
  error may be seen in Probe Job logs:
  
  Encountered an SQL exception while persisting data:
  DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001,
  SQLERRMC=null, DRIVER=4.19.49
  java.sql.SQLDataException: DB2 SQL Error:
  SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.19.49
   at
  com.ibm.tpc.infrastructure.mapping.AbstractDBAttributeMapper.att
  emptInsert(AbstractDBAttributeMapper.java:2535)
  

Local fix

• Engage Support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control & Storage Insights users monitoring     *
  * Storwize storage devices                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In Spectrum Control & Storage Insights, there is             *
  * potential of experiencing a failed probe of Storwize         *
  * Storage devices.                                             *
  *                                                              *
  * If you encounter this problem you would see failed           *
  * probes of Storwize devices and the following error           *
  * may be seen in Probe Job logs:                               *
  *                                                              *
  * Encountered an SQL exception while persisting data:          *
  * DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001,                 *
  * SQLERRMC=null, DRIVER=4.19.49                                *
  * java.sql.SQLDataException: DB2 SQL Error:                    *
  * SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null,                 *
  * DRIVER=4.19.49                                               *
  *  at                                                          *
  * com.ibm.tpc.infrastructure.mapping.AbstractDBAttributeMapper *
  * .att                                                         *
  * emptInsert(AbstractDBAttributeMapper.java:2535)              *
  *                                                              *
  * The Spectrum Control database had a column size              *
  * which was too small, which has been resolved.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is targeted for the following release:
  
  IBM Spectrum Control 5.3.6   [ 5.3.6-IBM-SC ]
  IBM Storage Insights 1Q20   [ 5.3.6-IBM-SC ]
  
  ( release target February 2020 )
  
  http://www.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future releases do not represent a formal
  commitment by IBM. The dates are subject to change without
  notice.
  

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

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels