Fix Readme
Abstract
Upgrade of License Metric Tool to version 9.2.20.0 fails during the update of the database schema. The problem occurs if there are saved reports that are based on the Inventory Exploration (Deprecated) report.
Content
When the problem occurs, the following message is displayed in the web browser after update of the database schema is initiated:
-------------------------------------------------------------------------------------------------------------------------
We are sorry, but something went wrong.
Contact your IBM License Metric Tool administrator if the problem persists.
Contact your IBM License Metric Tool administrator if the problem persists.
-------------------------------------------------------------------------------------------------------------------------
One of the following errors is also written in the tema.log file:
- On Windows:
-------------------------------------------------------------------------------------------------------------------------
[29.06.20 17:49:05:189 UTC] 0000003a com.ibm.ws.webcontainer.webapp
I SRVE0292I: Servletnachricht - [tema]:.[ERROR] Java::ComMicrosoftSqlserverJdbc::SQLServerException:
Cannot drop the trigger 'sam.computer_group_catalog_hierarchy_rollups_trigger_uuid_guid',
because it does not exist or you do not have permission.:
drop trigger sam.computer_group_catalog_hierarchy_rollups_trigger_uuid_guid
[29.06.20 17:49:05:220 UTC] 0000003a com.ibm.ws.webcontainer.webapp
[29.06.20 17:49:05:220 UTC] 0000003a com.ibm.ws.webcontainer.webapp
I SRVE0292I: Servletnachricht - [tema]:.[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%')
[29.06.20 17:49:05:220 UTC] 0000003a com.ibm.ws.webcontainer.webapp
[29.06.20 17:49:05:220 UTC] 0000003a com.ibm.ws.webcontainer.webapp
I SRVE0292I: Servletnachricht - [tema]:.[WARN] The statement has been terminated.
[29.06.20 17:49:05:252 UTC] 0000003a com.ibm.ws.webcontainer.webapp
[29.06.20 17:49:05:252 UTC] 0000003a com.ibm.ws.webcontainer.webapp
I SRVE0292I: Servletnachricht - [tema]:.[FATAL]
Sequel::ForeignKeyConstraintViolation (DBNAME: temadb - Java::ComMicrosoftSqlserverJdbc::SQLServerException:
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.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:258)
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:258)
-------------------------------------------------------------------------------------------------------------------------
- On Linux:
-------------------------------------------------------------------------------------------------------------------------
[7/15/20 16:45:41:729 UTC] 0000004b com.ibm.ws.webcontainer.webapp
I SRVE0292I: Servlet Message - [tema]:.[INFO] Begin applying migration 1591775375_rambo_remove_inventory_panel.rb,
direction: up[7/15/20 16:45:42:814 UTC] 0000004b com.ibm.ws.webcontainer.webapp
I SRVE0292I: Servlet Message - [tema]:.[ERROR] Java::ComIbmDb2JccAm::SqlIntegrityConstraintViolationException:
A parent row cannot be deleted because the relationship "DBO.REPORTS.SQL141118115926620"
restricts the deletion.. SQLCODE=-532, SQLSTATE=23504, DRIVER=3.72.24:
delete from dbo.pagestates where id in (select pagestate_id from dbo.reports where path like '%software_aggregates%')[7/15/20 16:45:42:910 UTC] 0000004b com.ibm.ws.webcontainer.webapp
I SRVE0292I: Servlet Message - [tema]:.[FATAL]
Sequel::ForeignKeyConstraintViolation (DBNAME: suadb - Java::ComIbmDb2JccAm::SqlIntegrityConstraintViolationException:
Sequel::ForeignKeyConstraintViolation (DBNAME: suadb - Java::ComIbmDb2JccAm::SqlIntegrityConstraintViolationException:
A parent row cannot be deleted because the relationship "DBO.REPORTS.SQL141118115926620"
restricts the deletion.. SQLCODE=-532, SQLSTATE=23504, DRIVER=3.72.24):
com.ibm.db2.jcc.am.hd.a(com/ibm/db2/jcc/am/hd.java:809)
com.ibm.db2.jcc.am.hd.a(com/ibm/db2/jcc/am/hd.java:66)
com.ibm.db2.jcc.am.hd.a(com/ibm/db2/jcc/am/hd.java:809)
com.ibm.db2.jcc.am.hd.a(com/ibm/db2/jcc/am/hd.java:66)
-------------------------------------------------------------------------------------------------------------------------
To avoid this problem, perform the following steps.
- If you did not run the upgrade yet, log in to License Metric Tool, go to Reports > Saved Reports, and delete all saved reports that have Inventory Exploration (Deprecated) as the value in the Base Report Name cell. Select each row, and click Delete.
- If you already attempted upgrading the server, connect to the License Metric Tool database (TEMADB) and run the following SQL delete statement:
delete from dbo.reports where path like '%software_aggregates%'
Then, go the web browser, refresh the License Metric Tool UI page, and click on the Update Schema button again.
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"ARM Category":[{"code":"a8m0z000000CbkMAAS","label":"ComponentsUpgrade->LMTserver"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.2.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 July 2020
UID
ibm16244612