IJ46505: UPGRADE TO 9.2.31 FAILS IN A VERY RARE CASE WHEN CONTENT OF ONE TABLE IS TEMPORARILY STALE BETWEEN DATA IMPORTS

APAR status

• Closed as program error.

Error description

• ILMT user may face an issue with database schema update to the
  9.2.31 level due to discrepancy between the 'computer_healths' &
  'computer_health_statuses' table content.
  Upgrade fails with the following error message:
  "Applying post server upgrade database changes failed.
  It might happen when you are installing a new instance of
  License Metric Tool and using a database from the old instance.
  In such case, the behavior is expected. For more information,
  refer to the tema.log file."
  
  The following error can be observed in tema.log:
  SRVE0292I: Servlet Message - [tema]:.[ERROR]
  Java::ComIbmDb2JccAm::SqlIntegrityConstraintViolationException:
  Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
  TABLEID=390, COLNO=5" is not allowed.. SQLCODE=-407,
  SQLSTATE=23502, DRIVER=4.28.11:         update
  sam.computer_health_statuses set last_software_scan_failed = (
           select
  
             case when (is_catalog_scan_successful = 1 and
  is_idtag_scan_successful = 1) then 0 else 1 end as
  last_scan_failed
  
           from sam.computer_healths
  
           where sam.computer_healths.computer_id =
  sam.computer_health_statuses.computer_id
         )
  
  
  
  
  
  
  
  
  
  
  
  TS012653778
  

Local fix

• Apply steps described in the following technote:
  https://www.ibm.com/support/pages/node/6988911
  

Problem summary

• ****************************************************************
  *****************
  ERROR DESCRIPTION:
  
  ILMT user may face an issue with database schema update to the
  
  9.2.31 level due to discrepancy between the 'computer_healths' &
  
  'computer_health_statuses' table content.
  
  Upgrade fails with the following error message:
  
  "Applying post server upgrade database changes failed.
  
  It might happen when you are installing a new instance of
  
  License Metric Tool and using a database from the old instance.
  
  In such case, the behavior is expected. For more information,
  
  refer to the tema.log file."
  
  
  
  The following error can be observed in tema.log:
  
  SRVE0292I: Servlet Message - [tema]:.[ERROR]
  
  Java::ComIbmDb2JccAm::SqlIntegrityConstraintViolationException:
  
  Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
  
  TABLEID=390, COLNO=5" is not allowed.. SQLCODE=-407,
  
  SQLSTATE=23502, DRIVER=4.28.11:         update
  
  sam.computer_health_statuses set last_software_scan_failed = (
  
           select
  
  
  
             case when (is_catalog_scan_successful = 1 and
  
  is_idtag_scan_successful = 1) then 0 else 1 end as
  
  last_scan_failed
  
  
  
           from sam.computer_healths
  
  
  
           where sam.computer_healths.computer_id =
  
  sam.computer_health_statuses.computer_id
  
         )
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  TS012653778
  
  ****************************************************************
  *****************
  * EXPECTED RESULTS:
  * The issue does not occur.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate update when available.
  ****************************************************************
  

Problem conclusion

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

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