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 number
IT30767
Reported component name
TPC ADVANCED
Reported component ID
5608TPCA0
Reported release
534
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-10-30
Closed date
2020-01-24
Last modified date
2020-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
TPC ADVANCED
Fixed component ID
5608TPCA0
Applicable component levels
[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSNECY","label":"Tivoli Storage Productivity Center Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"534"}]
Document Information
Modified date:
24 June 2022