A fix is available
APAR status
Closed as program error.
Error description
The storage probe fails during a post-processing step for all storage devices every time. This can be seen in specific situations where the auto identifiers have previously been exhausted and a workaround with GapFileAuto is being used. The probe log starts with successful data collection and ends with unspecified errors: ... HWNEP0001I Successfully persisted 5 mdiskgroup instances. HWN021503E The action cannot be completed HWN021503E The action cannot be completed HWN021709I Collection for storage system <storage_device> completed. BTADS0102E The probe with the run ID 76029 completed with errors. The trace logs shows the database errors trying to get an identifier. IBM/TPC/device/log/<storage_device>/Probe_ x/traceProbe_y_z_errors_0.log [NAPIPostProcess-<IP>_<storage_dev ice>] [NAPIProbePostProcess.process] [ERROR] Encountered error while parsing output file. com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003, SQLERRMC=null, DRIV ER=4.19.49 com.ibm.tpc.discovery.interfaces.DiscoveryException: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.19.49 at c om.ibm.tpc.disk.collection.DiskCIMProcessor.persist(DiskCIMProce ssor.java:1926) at com.ibm.tpc.discovery.parser.NAPI_DS_SVC_Pars er.persistEntity(NAPI_DS_SVC_Parser.java:339) at com.ibm.tpc.dis covery.parser.NAPI_DS_SVC_Parser.processOutputFile(NAPI_DS_SVC_P arser.java:275) at com.ibm.tpc.disk.discovery.SVC_CLI_PostProces s.parse(SVC_CLI_PostProcess.java:86) at com.ibm.tpc.disk.discove ry.NAPIProbePostProcess.process(NAPIProbePostProcess.java:379) a t com.ibm.tpc.Router.perform(Router.java:724) at com.ibm.tpc.Router.perform(Router.java:452) at com.ibm.tpc.disco very.ProcessProcessor.process(ProcessProcessor.java:78) at com.i bm.tpc.infrastructure.threads.TPCThread.run(TPCThread.java:253) Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-802, SQLSTATE=22003, SQLERRMC=null, DRIVER=4.19.49 ... at com.ibm.tpc.infrastructure.database.DBPrep aredStatement.executeUpdate(DBPreparedStatement.java:114) at com .ibm.tpc.infrastructure.database.ComplexQuery.sqlUpdate(ComplexQ uery.java:49) at com.ibm.tpc.infrastructure.database.AutoIdentif ier.getIdentifierFromDB(AutoIdentifier.java:485) at com.ibm.tpc. infrastructure.database.AutoIdentifier.getIdentifier(AutoIdentif ier.java:342) This issue is a continuation of the following APARs and requires an additional fix. - IT24025 PROBES FAIL WITH BTADS0102E DUE TO MAX VALUE REACHED WITH AUTOIDS - IT25718 RECOVERY FOR IT24025 PROBES FAIL WITH BTADS0102E DUE TO MAX VALUE REACHED WITH AUTOIDS
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Control users monitoring storage devices * **************************************************************** * PROBLEM DESCRIPTION: * * The storage probe fail during a post-processing step for all * * storage devices, every time. * * * * This can be seen in specific situations where the auto * * identifiers have previously been exhausted, and a workaround * * * * with GapFileAuto is being used. * * * * This issue is a continuation of the following APARs which * * requires * * an additional fix: * * * * - IT24025 PROBES FAIL WITH BTADS0102E DUE TO MAX * * VALUE REACHED WITH AUTOIDS * * * * - IT25718 RECOVERY FOR IT24025 PROBES FAIL WITH * * BTADS0102E DUE TO MAX VALUE REACHED WITH AUTOIDS * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following release: IBM Spectrum Control 5.3.7 [ 5.3.7-IBM-SC ] ( release target 2Q 2020 / May ) 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
IT31775
Reported component name
TPC ADVANCED
Reported component ID
5608TPCA0
Reported release
532
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-02-05
Closed date
2020-03-03
Last modified date
2020-03-03
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":"532"}]
Document Information
Modified date:
25 June 2022