IT31775: ALL STORAGE PROBES FAIL [MAX VALUE REACHED WITH AUTOIDS]

IBM Spectrum Control 5.3.7 (May 2020)

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 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