A fix is available
APAR status
Closed as program error.
Error description
Storage Insights Probes fail to run against Spectrum Scale devices. The only visible messaging in the Storage Insights UI is as follows: Error <date_and_time_removed> HWN021503E The action cannot be completed Tracing behind this, visible only internal to Storage Insights, is as follows: <date_and_time_removed> [NAPIPostProcess-10.113.115.141_stage2.D1PRPSTG2NSD3] [NAPIProbePostProcess.process] [ERROR] Encountered error while parsing output file. com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;TPC.T_RES_NSD2REDUNDANCY, DRIVER=4.19.49 com.ibm.tpc. discovery.interfaces.DiscoveryException: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;TPC.T_RES_NSD2REDUNDANCY, DRIVER=4.19.49 at com.ibm. tpc.disk.collection.DiskCIMProcessor.persist(DiskCIMProcessor.ja va:1926) at com.ibm.tpc.discovery.parser.NAPI_DS_SVC_Parser.per sistEntity(NAPI_DS_SVC_Parser.java:349) at com.ibm.tpc.discover y.parser.NAPI_DS_SVC_Parser.processOutputFile(NAPI_DS_SVC_Parser .java:277) at com.ibm.tpc.disk.discovery.ELASTIC_CLI_PostProces s.parse(ELASTIC_CLI_PostProcess.java:83) at com.ibm.tpc.disk.di scovery.NAPIProbePostProcess.process(NAPIProbePostProcess.java:4 14) at com.ibm.tpc.Router.perform(Router.java:724) at com.ibm.tpc.Router.perform(Router.java:452) at com.ibm.tpc.disc overy.ProcessProcessor.process(ProcessProcessor.java:78) at com .ibm.tpc.infrastructure.threads.TPCThread.run(TPCThread.java:253 ) Caused by: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;TPC.T_RES_NSD2REDUNDANCY, DRIVER=4.19.49 <truncated> at com.ibm.tpc.infrastructure.database.DBPreparedSt atement.executeUpdate(DBPreparedStatement.java:114) at com.ibm. tpc.infrastructure.mapping.AbstractDBAttributeMapper.attemptInse rt(AbstractDBAttributeMapper.java:2527) at com.ibm.tpc.infrastr ucture.mapping.AbstractDBAttributeMapper.persistWithJDBC(Abstrac tDBAttributeMapper.java:2654) at com.ibm.tpc.infrastructure.map ping.AbstractDBAttributeMapper.persist(AbstractDBAttributeMapper .java:1202) at com.ibm.tpc.infrastructure.mapping.ELASTIC_NSD2R edundancyDBMapper.persist(ELASTIC_NSD2RedundancyDBMapper.java:96 ) at com.ibm.tpc.disk.collection.DiskCIMProcessor.persist(DiskC IMProcessor.java:1888) ... 8 more <date_and_time_removed> [NAPIPostProcess-10.113.115.141_stage2.D1PRPSTG2NSD3] [NAPIProbePostProcess.process] [ERROR] Encountered an SQL exception while persisting data: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;TPC.T_RES_NSD2REDUNDANCY, DRIVER=4.19 .49 com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;TPC.T_RES_NSD2REDUNDANCY, 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. tpc.infrastructure.database.DBPreparedStatement.executeUpdate(DB PreparedStatement.java:114) at com.ibm.tpc.infrastructure.mappi ng.AbstractDBAttributeMapper.attemptInsert(AbstractDBAttributeMa pper.java:2527) at com.ibm.tpc.infrastructure.mapping.AbstractD BAttributeMapper.persistWithJDBC(AbstractDBAttributeMapper.java: 2654) at com.ibm.tpc.infrastructure.mapping.AbstractDBAttribute Mapper.persist(AbstractDBAttributeMapper.java:1202) at com.ibm. tpc.infrastructure.mapping.ELASTIC_NSD2RedundancyDBMapper.persis t(ELASTIC_NSD2RedundancyDBMapper.java:96) at com.ibm.tpc.disk.c ollection.DiskCIMProcessor.persist(DiskCIMProcessor.java:1888) at com.ibm.tpc.discovery.parser.NAPI_DS_SVC_Parser.persistEntity (NAPI_DS_SVC_Parser.java:349) at com.ibm.tpc.discovery.parser.N API_DS_SVC_Parser.processOutputFile(NAPI_DS_SVC_Parser.java:277) at com.ibm.tpc.disk.discovery.ELASTIC_CLI_PostProcess.parse(EL ASTIC_CLI_PostProcess.java:83) at com.ibm.tpc.disk.discovery.NA PIProbePostProcess.process(NAPIProbePostProcess.java:414) at com.ibm.tpc.Router.perform(Router.java:724) at com.ibm.tpc.Router.perform(Router.java:452) at com.ibm.tpc.disc overy.ProcessProcessor.process(ProcessProcessor.java:78) at com .ibm.tpc.infrastructure.threads.TPCThread.run(TPCThread.java:253 ) <date_and_time_removed> [NAPIPostProcess-10.113.115.141_stage2.D1PRPSTG2NSD3] [NAPIProbePostProcess.process] [ERROR] Exception in Post Processing Not a valid message ID: SQL_Exception java.lang.IllegalArgumentException: Not a valid message ID: SQL_Exception at com.ibm.tpc.disk.common.log.LogTra ceHelper.extractLevel(LogTraceHelper.java:458) at com.ibm.tpc.d isk.common.log.LogTraceHelper.logMsg(LogTraceHelper.java:263) at com.ibm.tpc.disk.discovery.NAPIProbePostProcess.process(NAPIP robePostProcess.java:436) at com.ibm.tpc.Router.perform(Router.java:724) at com.ibm.tpc.Router.perform(Router.java:452) at com.ibm.tpc.disc overy.ProcessProcessor.process(ProcessProcessor.java:78) at com .ibm.tpc.infrastructure.threads.TPCThread.run(TPCThread.java:253 ) ____________________________________________________ The defect is against component: Storage Insights Server/Manager build/release (TPC): 5.3.5/5.3.6 Problem as described by customer: Storage Insights Spectrum Scale probes fail. Initial customer impact (low/med/high): high
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Storage Insights users monitoring Spectrum Scale devices * **************************************************************** * PROBLEM DESCRIPTION: * * Storage Insights probes fail to run against Spectrum Scale * * devices. * * * * The only visible messaging in the Storage Insights UI is * * this error: * * * * Error <date_and_time_removed> HWN021503E The * * action cannot be completed. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is targeted for the following release: IBM Storage Insights 3Q20 [ 5.4.0-IBM-SC ] ( release target 3Q 2020 / August ) 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
IT33302
Reported component name
STORAGE INSIGHT
Reported component ID
5608TPCSI
Reported release
537
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-06-23
Closed date
2020-07-28
Last modified date
2020-07-28
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSQRB8","label":"IBM Storage Insights"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"537","Line of Business":{"code":"LOB69","label":"Storage TPS"}}]
Document Information
Modified date:
12 January 2026