IJ21800: THE UPGRADE OPERATION FAILED DUE TO LACK OF CHECKING FOR 'METRIC_OTHER_GR_1_IDX1' INDEX EXISTENCE.

APAR status

• Closed as program error.

Error description

• ILMT user may face an issue with database schema update to the
  9.2.18 level due to invalid handling of existing indexes. The
  following message may be found in the
  "tema.log":
  
  ---
  [12/30/19 13:08:12:897 UTC] 00000052
  com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message -
  [tema]:.[INFO] Begin applying migration
  1568220001_panoramix_aggr_outputs_split_part2.rb, direction:
  up
  
  [12/30/19 13:08:13:657 UTC] 00000052 SystemOut O 2019-12-30
  13:08:13 LMT [ERROR] [ILMTCore] (Default Executor-thread-14)
  createOutputTable com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  The name of the object to be created is identical to the
  existing name "AGGR.METRIC_OTHER_GR_1_IDX1" of type "INDEX"..
  SQLCODE=-601, SQLSTATE=42710, DRIVER=3.72.24
   at
  com.ibm.db2.jcc.am.hd.a(hd.java:813)
  ---
  
  TS003177932
  

Local fix

• If the upgrade was already attempted, drop the offending index
  reported in the error message in tema.log file. Repeat this
  procedure for each index reported in the consecutive attempts.
  
  If the upgrade is to be performed, to make sure the issue will
  not appear in the environment, go to the Management > Computer
  Groups panel and for each reporting computer group having
  "Install Instances and other metrics" checkbox enabled make
  sure the other checkbox (with PVU, RVU and other IBM metrics) is
  also enabled. The change will not need to be redone after
  the upgrade because 9.2.18.0 release unifies both
  checkboxes (so since 9.2.18.0 version there is no
  distinction between calculating IBM and non-IBM metrics,
  there is only option to enable calculation of all metrics
  or none of them).
  
  Plese refer to the below documentation page for the details
  about setting up computer groups in ILMT:
  
  https://www.ibm.com/support/knowledgecenter/SS8JFY_9.2.0/com.ibm
  .lmt.doc/Inventory/planinconf/t_setting_up_computer_groups.html
  

Problem summary

• ****************************************************************
  
  * ERROR DESCRIPTION:
  *
  * ILMT user may face an issue with database schema update to the
  *
  * 9.2.18 level due to invalid handling of existing indexes. The
  *
  * following message may be found in the
  *
  * "tema.log":
  *
  *
  *
  * ---
  *
  * Ý12/30/19 13:08:12:897 UTC¨ 00000052
  *
  * com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message -
  *
  * Ýtema¨:.ÝINFO¨ Begin applying migration
  *
  * 1568220001_panoramix_aggr_outputs_split_part2.rb, direction:
  *
  * up
  *
  *
  *
  * Ý12/30/19 13:08:13:657 UTC¨ 00000052 SystemOut O 2019-12-30
  *
  * 13:08:13 LMT ÝERROR¨ ÝILMTCore¨ (Default Executor-thread-14)
  *
  * createOutputTable com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  *
  * The name of the object to be created is identical to the
  *
  * existing name "AGGR.METRIC_OTHER_GR_1_IDX1" of type "INDEX"..
  *
  * SQLCODE=-601, SQLSTATE=42710, DRIVER=3.72.24
  *
  *  at
  *
  * com.ibm.db2.jcc.am.hd.a(hd.java:813)
  *
  * ---
  *
  *
  *
  * TS003177932
  *
  * **************************************************************
  *
  * EXPECTED RESULTS:
  * The issue does not occure.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
   | Update | ILMT 9.2.19
  ****************************************************************
  

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

  LIC METRIC TOOL

• Fixed component ID

  5724LMTEM

Applicable component levels