APAR status
Closed as program error.
Error description
During ILMT upgrade to the latest version (9.2.17), when accessing ILMT UI for the first time after new binaries have been deployed, the following message is displayed indicating ILMT database schema update step: --- Your database must be updated to work with this version. Perform the following steps: 1. Back up the IBM License Metric Tool database. For detailed instructions, see the product documentation. 2. Click Update Schema to begin. (...) --- After the some time the following message is displayed: --- We are sorry, but something went wrong. Contact your IBM License Metric Tool administrator if the problem persists. ---- and the "tema.log" file of ILMT application contains the following [ERROR] entry: --- [11/11/19 11:12:13:123 UTC] 0000002d com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[INFO] Begin applying migration 1533110847_kermit_flexpoints_part4.rb, direction: up 11/11/19 11:12:13:124 UTC] 0000002d com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[ERROR] Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot insert duplicate key row in object 'sam.metrics' with unique index 'metrics_idx2'. The duplicate key value is (FLEXPOINT).: INSERT INTO [sam].[metrics] ([id], [code_name], [display_name]) VALUES (10, N'FLEXPOINT', N'FlexPoint') --- This is caused by an invalid item in ILMT software catalog with the FLEXPOINT metric assigned. TS003061625
Local fix
1) Stop ILMT application. 2) Backup ILMT database. 3) Run the following SQL query against ILMT database: delete from sam.metrics where code_name = 'FLEXPOINT' 4) Start ILMT application and access ILMT UI. Complete the schema update step. 5) Upload the latest ILMT catalog once again - this needs to be forced by uploading it one more time from ILMT UI - "Management > Catalog Upload". See: https://www.ibm.com/support /knowledgecenter/en/SS8JFY_9.2.0/com.ibm.lmt.doc/Inventory/softi nv/t_updating_software_catalogs_without_customization.html
Problem summary
**************************************************************** * ERROR DESCRIPTION: * * During ILMT upgrade to the latest version (9.2.17), when * * accessing ILMT UI for the first time after new binaries have * * been deployed, the following message is displayed indicating * * ILMT database schema update step: * * * * --- * * Your database must be * * updated to work with this version. Perform the following * * steps: * * 1. Back up the IBM License Metric Tool database. For * * detailed instructions, see the product documentation. * * 2. Click * * Update Schema to begin. * * (...) * * --- * * * * After the some time the * * following message is displayed: * * * * --- * * We are sorry, but * * something went wrong. * * Contact your IBM License Metric Tool * * administrator if the problem persists. * * ---- * * * * and the "tema.log" * * file of ILMT application contains the following ÝERROR¨ * * entry: * * * * --- * * Ý11/11/19 11:12:13:123 UTC¨ 0000002d * * com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - * * Ýtema¨:.ÝINFO¨ Begin applying migration * * 1533110847_kermit_flexpoints_part4.rb, direction: up * * * * 11/11/19 * * 11:12:13:124 UTC¨ 0000002d com.ibm.ws.webcontainer.webapp I * * SRVE0292I: Servlet Message - Ýtema¨:.ÝERROR¨ * * Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot * * insert duplicate key row in object 'sam.metrics' with unique * * index 'metrics_idx2'. The duplicate key value is (FLEXPOINT).: * * INSERT INTO Ýsam¨.Ýmetrics¨ (Ýid¨, Ýcode_name¨, Ýdisplay_name¨ * * VALUES (10, N'FLEXPOINT', N'FlexPoint') * * --- * * * * This is caused by * * an invalid item in ILMT software catalog with the FLEXPOINT * * metric assigned. * * * * TS003061625 * * ************************************************************** * * 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.18 ****************************************************************
Temporary fix
Comments
APAR Information
APAR number
IJ21245
Reported component name
LIC METRIC TOOL
Reported component ID
5724LMTEM
Reported release
920
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-11-28
Closed date
2019-12-03
Last modified date
2019-12-03
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"920","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
03 December 2019