IJ25986: UPGRADE TO 9.2.20 FAILS AT SCHEMA UPDATE STEP

APAR status

• Closed as program error.

Error description

• The schema update fails with the error message:
  
  "We are sorry,
  but something went wrong.
  Contact your IBM License Metric Tool
  administrator if the problem persists."
  
  
  The following errors
  can be observed in tema.log:
  
  
  [ERROR]
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot
  drop the trigger 'sam.computer_group_catalog_hierarchy_rollups_t
  rigger_uuid_guid', because it does not exist or you do not have
  permission.: drop trigger sam.computer_group_catalog_hierarchy_r
  ollups_trigger_uuid_guid
  [ERROR]
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: The DELETE
  statement conflicted with the REFERENCE constraint
  "FK__reports__pagesta__382F5661". The conflict occurred in
  database "temadb", table "dbo.reports", column 'pagestate_id'.:
  delete from dbo.pagestates where id in (select pagestate_id
  from dbo.reports where path like
  '%software_aggregates%')
  [WARN] The statement has been
  terminated.
  [FATAL] Sequel::ForeignKeyConstraintViolation
  (DBNAME: temadb -
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: The DELETE
  statement conflicted with the REFERENCE constraint
  "FK__reports__pagesta__382F5661". The conflict occurred in
  database "temadb", table "dbo.reports", column
  'pagestate_id'.):
  
   com.microsoft.sqlserver.jdbc.SQLServerExcept
  ion.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServer
  Exception.java:258)
   com.microsoft.sqlserver.jdbc.TDSTokenHandle
  r.onEOF(com/microsoft/sqlserver/jdbc/tdsparser.java:256)
   com.mi
  crosoft.sqlserver.jdbc.TDSParser.parse(com/microsoft/sqlserver/j
  dbc/tdsparser.java:108)
  [... stacktrace up until Thread.java
  ...]
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  TS003880979
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  *****************
  ERROR DESCRIPTION:
  
  The schema update fails with the error message:
  
  
  
  "We are sorry,
  
  but something went wrong.
  
  Contact your IBM License Metric Tool
  
  administrator if the problem persists."
  
  
  
  
  
  The following errors
  
  can be observed in tema.log:
  
  
  
  
  
  ÝERROR¨
  
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot
  
  drop the trigger 'sam.computer_group_catalog_hierarchy_rollups_t
  
  rigger_uuid_guid', because it does not exist or you do not have
  
  permission.: drop trigger sam.computer_group_catalog_hierarchy_r
  
  ollups_trigger_uuid_guid
  
  ÝERROR¨
  
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: The DELETE
  
  statement conflicted with the REFERENCE constraint
  
  "FK__reports__pagesta__382F5661". The conflict occurred in
  
  database "temadb", table "dbo.reports", column 'pagestate_id'.:
  
  delete from dbo.pagestates where id in (select pagestate_id
  
  from dbo.reports where path like
  
  '%software_aggregates%')
  
  ÝWARN¨ The statement has been
  
  terminated.
  
  ÝFATAL¨ Sequel::ForeignKeyConstraintViolation
  
  (DBNAME: temadb -
  
  Java::ComMicrosoftSqlserverJdbc::SQLServerException: The DELETE
  
  statement conflicted with the REFERENCE constraint
  
  "FK__reports__pagesta__382F5661". The conflict occurred in
  
  database "temadb", table "dbo.reports", column
  
  'pagestate_id'.):
  
  
  
   com.microsoft.sqlserver.jdbc.SQLServerExcept
  
  ion.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServer
  
  Exception.java:258)
  
   com.microsoft.sqlserver.jdbc.TDSTokenHandle
  
  r.onEOF(com/microsoft/sqlserver/jdbc/tdsparser.java:256)
  
   com.mi
  
  crosoft.sqlserver.jdbc.TDSParser.parse(com/microsoft/sqlserver/j
  
  dbc/tdsparser.java:108)
  
  Ý... stacktrace up until Thread.java
  
  ...¨
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Workaround for this issue is described under:
  https://www.ibm.com/support/pages/node/6244612
  
  
  
  
  TS003880979
  
  ****************************************************************
  *****************
  * 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.21.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