IC92992: STATUS 12/HWN021802E MESSAGES WHEN TRYING TO ADD NEW STORAGE DEVICES OR CREATE NEW MONITORING JOBS.

Fix Pack 5.1.1.2 (September 2013) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.5 (July 2014) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.6 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.9 (October 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.12 (October 2016) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.13 (February 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.14 (June 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.15 (Sept 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.8 (July 2015) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• Status 12 pop-up message when trying to add new storage devices
  to TPC (or re-define devices that were deleted previously), or
  when trying to save a new probe job or performance monitor job
  definition within the TPC GUI.  Observed messaging in the pop-up
  dialog box contains the following:
  [Attributes={}] [faultCode=SOAP-ENV:Server]
  [faultString=Exception from
  service object: HWN021802E Experienced SQL problems while
  working with
  database: DB2 SQL error: SQLCODE: -802, SQLSTATE: 22003,
  SQLERRMC:
  null.] [faultActorURI=/ITSRM/ServiceManager] [DetailEntries=
  [(0)=<detailEntry
  SOAP-ENV:encodingStyle="http://schemas.xmlsoap.
  org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.
  org/soap/envelope/" xmlns:ns1="com.ibm.tpc.common.api.
  TPCServerException" xsi:type="ns1:JavaObject"
  xmlns:xsi="http://www.w3.
  org/2001/XMLSchema-instance"
  SQLSTATE 22003 with SQLCODE -802 indicates a failure due to a
  numeric value out of range detected during database insert,
  update, or delete operations.
  This is caused by the TPC code requesting unique identifier
  numbers beyond the defined range.
  Several issues including frequent deletion and creation of
  storage volumes within a subsystem, removal and re-defining of
  storage devices (switches/subsystems/SRAs), and defects in the
  TPC server code such as what is described in APAR IC90057 can
  cause this limit to be hit.   As such, the TPC server code needs
  to better handle this condition and not prevent users from
  defining new storage assets and monitoring tasks.
  RECREATE STEPS:
  N/A
  ________________________________________________________________
  DB2 Version used for Server:    All supported DB2 versions
  The defect is against component:   5608TPCS0
  Server/Manager build/release (TPC):   4.2.2
  Agent build/release (TPC):    N/A
  Server/Manager (OS):     All supported server OS platforms
  Agent (OS):       N/A
  ________________________________________________________________
  Problem as described by customer:   Not able to add new
  subsystems
  Initial customer impact (low/med/high): high
  

Local fix

• Contact support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC 5.1.x and earlier users                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Long-running failing fabric probes against a Cisco fabric    *
  * resulted in exhaustion of of available ID values for         *
  * entities in TPC, which caused problems trying to start new   *
  * jobs.  See ERROR DESCRIPTION for details.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix pack maintenance when available.  If you are       *
  * already encountereing this, contact support for a cleanup    *
  * procedure.                                                   *
  ****************************************************************
  

Problem conclusion

• A code change has been made to resolve the ID exhaustion.  The
  fix for this APAR is targeted for the following maintenance
  package:
  
  | fix pack | 5.1.1-TIV-TPC-FP0002 - target September 2013
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future fix packs 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:

  IC91212

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• FABRIC
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels

• R510 PSY

     UP

• R511 PSY

     UP