IT35110: SVC PROBE IS FAILING ON STORAGE INSIGHTS WITH A SQL EXCEPTION

APAR status

• Closed as program error.

Error description

• SVC probe fails when compression saving space is zero.
  
  Probe fails with this error:
  HWN021503E The action cannot be completed however performance
  collections continue to run successfully.
  
  In the database the compression saving space is zero and so
  there
  is a divide by zero in the SQL statement.
  
  
  This is the errors in the logs:
  
  [NAPIPostProcess-xxxxxxx_FlashSystem 9100-]
  [NAPIProbePostProcess.finishProbe] [ERROR] Error occurred during
  performing post process tasks
  com.ibm.tpc.common.api.TPCServerException:
  HWN021503E The action cannot be completed
  ...
  Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error:
  SQLCODE=-801, SQLSTATE=22012, SQLERRMC=null, DRIVER=4.19.49
  ...
  [NAPIPostProcess-xxxxxx FlashSystem xxxxx]
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Storage Insights users monitoring SVC when compression   *
  * saving space is zero                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Storage Insights users experience SVC probe failures         *
  * when compression saving space is zero.                       *
  *                                                              *
  * The probe fails with this error:                             *
  * HWN021503E The action cannot be completed however            *
  * performance collections continue to run successfully.        *
  *                                                              *
  * In the database the compression saving space is zero         *
  * and so there is a divide by zero in the SQL statement.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following release:
  
  IBM Storage Insights 1Q21   [ 5.4.1-IBM-SI-Patch ]
  
  IBM Storage Insights 2Q21   [ 54X-IBM-SI ]
  
  IBM Spectrum Control 5.4.2  [ 5.4.2-IBM-SC ]
  
  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

• Fixed component ID

  5608TPC00

Applicable component levels