APAR status
Closed as program error.
Error description
Spectrum Scale device probes fail, logging the following errors within the post process tasks: [SQLUtil.getGeneralSQLException] [ERROR] DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=3;TPC.T_STAT_FSET_HIST, D RIVER=4.19.49 com.ibm.db2.jcc.am.SqlIntegrityConstraintViolation Exception: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=3;TPC.T_STAT_FSET_HIST, DRIVER=4.19.49 at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.kd.a(Unknown Source) at com.ibm.db2.jcc.am.fp.b(Unknown Source) at com.ibm.db2.jcc.am.fp.c(Unknown Source) at com.ibm.db2.jcc.t4.bb.l(Unknown Source) at com.ibm.db2.jcc.t4.bb.a(Unknown Source) at com.ibm.db2.jcc.t4.p.a(Unknown Source) at com.ibm.db2.jcc.t4.wb.b(Unknown Source) at com.ibm.db2.jcc.am.gp.tc(Unknown Source) at com.ibm.db2.jcc.am.gp.b(Unknown Source) at com.ibm.db2.jcc.am.gp.lc(Unknown Source) at com.ibm.db2.jcc.am.gp.executeUpdate(Unknown Source) at com.ibm.t pc.infrastructure.database.DBPreparedStatement.executeUpdate(DBP reparedStatement.java:114) at com.tivoli.itsrm.repository.Reposi toryAccessor.executeUpdate(RepositoryAccessor.java:249) at com.t ivoli.itsrm.TStorm.repository.TStatSpaceHist.insertHist(TStatSpa ceHist.java:352) at com.tivoli.itsrm.TStorm.repository.TStatSpac eHist.saveHist(TStatSpaceHist.java:275) at com.ibm.tpc.disk.coll ection.ELASTIC_ShareUpdatePostProcess.persistFsetHist(ELASTIC_Sh areUpdatePostProcess.java:601) at com.ibm.tpc.disk.collection.EL ASTIC_ShareUpdatePostProcess.process(ELASTIC_ShareUpdatePostProc ess.java:221) at com.ibm.tpc.disk.discovery.ELASTIC_CLI_PostProc ess.dbPostProcess(ELASTIC_CLI_PostProcess.java:105) at com.ibm.t pc.disk.discovery.NAPIProbePostProcess.finishProbe(NAPIProbePost Process.java:767) at com.ibm.tpc.disk.discovery.NAPIProbePostPro cess.process(NAPIProbePostProcess.java:547) at com.ibm.tpc.Router.perform(Router.java:728) at com.ibm.tpc.Router.perform(Router.java:457) at com.ibm.tpc.disco very.ProcessProcessor.process(ProcessProcessor.java:78) at com.i bm.tpc.infrastructure.threads.TPCThread.run(TPCThread.java:253) ____________________________________________________ The defect is against component: 5608TPCSI Device Server Server/Manager build/release: 5.4.0 Problem as described by customer: Spectrum Scale probe failures Initial customer impact (low/med/high): med
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Control & Storage Insights users monitoring * * Spectrum Scale device * **************************************************************** * PROBLEM DESCRIPTION: * * Spectrum Scale device probes fail, logging the following * * errors * * within the post process tasks: * * * * [SQLUtil.getGeneralSQLException] [ERROR] DB2 SQL Error: * * SQLCODE=-803, SQLSTATE=23505, * * SQLERRMC=3;TPC.T_STAT_FSET_HIST, D * * RIVER=4.19.49 * * com.ibm.db2.jcc.am.SqlIntegrityConstraintViolation * * Exception: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, * * SQLERRMC=3;TPC.T_STAT_FSET_HIST, DRIVER=4.19.49 * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following release: IBM Spectrum Control 5.4.2 [ 5.4.2-IBM-SC ] ( release target 1Q 2021 / February ) IBM Storage Insights 1Q21 [ 5.4.2-IBM-SI-Patch ] 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
IT34942
Reported component name
STORAGE INSIGHT
Reported component ID
5608TPCSI
Reported release
540
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-11-16
Closed date
2021-01-15
Last modified date
2021-02-15
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
STORAGE INSIGHT
Fixed component ID
5608TPCSI
Applicable component levels
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSQRB8","label":"IBM Storage Insights"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"540"}]
Document Information
Modified date:
08 February 2022