IT18712: IBM SPECTRUM CONTROL PROBE JOB FAILS WITH ERROR: HWN099993E NUMBER FORMAT EXCEPTION ON AND FIELD SLOT_ID

IBM Spectrum Control V5.2.14 (May 2017)
IBM Spectrum Control V5.2.15 (August 2017)
IBM Spectrum Control V5.2.15.2 (November 2017)
IBM Spectrum Control V5.2.16 (March 2018)
IBM Spectrum Control V5.2.17 (May 2018)

APAR status

• Closed as program error.

Error description

• The following message can be see in the
  ...\TPC\device\log\dmSvcTrace.log:
  
  2017-01-04 04:41:29.625-0600 HWN099993E Number Format exception
  on  and field SLOT_ID
  @(NAPIPostProcess-XXX.XXX.XXX.XXX_FlashSystem
  V9000-9846-V9000_xxxxxx-IBM)
    java.sql.SQLException: Number Format exception on  and field
  SLOT_ID
      at
  com.ibm.tpc.infrastructure.mapping.AbstractDBAttributeMapper.set
  PreparedStatementParameter(AbstractDBAttributeMapper.java:3099)
      at
  com.ibm.tpc.infrastructure.mapping.AbstractDBAttributeMapper.set
  PSParam(AbstractDBAttributeMapper.java:2777)
      at
  com.ibm.tpc.infrastructure.mapping.AbstractDBAttributeMapper.att
  emptUpdate(AbstractDBAttributeMapper.java:2335)
      at
  com.ibm.tpc.infrastructure.mapping.AbstractDBAttributeMapper.per
  sistWithJDBC(AbstractDBAttributeMapper.java:2519)
      at
  com.ibm.tpc.infrastructure.mapping.AbstractDBAttributeMapper.per
  sist(AbstractDBAttributeMapper.java:1118)
      at
  com.ibm.tpc.infrastructure.mapping.CLISVC6_LDiskToPhysicalVolume
  DBMapper.persist(CLISVC6_LDiskToPhysicalVolumeDBMapper.java:362)
      at
  com.ibm.tpc.disk.collection.DiskCIMProcessor.persist(DiskCIMProc
  essor.java:1846)
      at
  com.ibm.tpc.discovery.parser.NAPI_DS_SVC_Parser.persistEntity(NA
  PI_DS_SVC_Parser.java:253)
      at
  com.ibm.tpc.discovery.parser.NAPI_DS_SVC_Parser.processOutputFil
  e(NAPI_DS_SVC_Parser.java:195)
      at
  com.ibm.tpc.disk.discovery.SVC_CLI_PostProcess.parse(SVC_CLI_Pos
  tProcess.java:83)
      at
  com.ibm.tpc.disk.discovery.NAPIProbePostProcess.process(NAPIProb
  ePostProcess.java:418)
      at com.ibm.tpc.Router.perform(Router.java:642)
      at com.ibm.tpc.Router.perform(Router.java:403)
      at
  com.ibm.tpc.discovery.ProcessProcessor.process(ProcessProcessor.
  java:71)
      at
  com.ibm.tpc.infrastructure.threads.TPCThread.run(TPCThread.java:
  262)   com.ibm.tpc.disk.collection.DiskCIMProcessor persist
  
  FlashSystem SLOT_ID is not reported when the disk is offline.
  The probe failed because the code checks for the presence of
  SLOT_ID first, before trying to use it.
  
  Affected Storage: FlashSystems
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control 5.2.x users who collecting data from    *
  * the SVC.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The issue occurs when SVC returns an invalid slot_id value.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available                         *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR was contained in the following maintenance
  package:
  
  | refresh pack | 5.2-TIV-TPC-RP0013 - March 2017
  
  Fixed in IBM Spectrum Control 5.2.13
  

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:

Modules/Macros

• STORAGE
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels