IBM Support

[APAR IV89617] Removal of an user or directory server may cause issues with accessing the LMT application

Troubleshooting


Problem

If a user gets removed from LMT or an entire directory server definition (LDAP configuration) is deleted, a mandatory reports is removed as well which causes issues after application restart.

Symptom

After logging in, UI is not displayed properly and 'We are sorry, but something went wrong.' message is displayed.

Similar error can be found in tema.log:
NoMethodError (undefined method ´[]' for nil:NilClass):
domains/sam/app/controllers/sam/pvureports_controller.rb:27:in
´report_link'
org/jruby/RubyKernel.java:1858:in ´tap'
domains/sam/app/controllers/sam/pvureports_controller.rb:25:in
´report_link'
app/views/layouts/application.rb:636:in
´add_menu_item_for_report_controller'
(eval):12:in ´tag_li'
(eval):11:in ´tag_li'
app/views/layouts/application.rb:636:in
´add_menu_item_for_report_controller'

Cause

A mandatory report is removed during the removal of an user or group of users.

Environment

LMT 9.2.4 and 9.2.5

Resolving The Problem

The report has to be regenerated in LMT. To do this one of the below SQL commands needs to be executed on LMT database:

DB2:
merge into dbo.reports r
using
(
select '___ibm_all_metrics___' as name from sysibm.sysdummy1
) as tmp on tmp.name = r.name
when not matched then
insert (user_id,pagestate_id,name,path,private) values
(-1,'___ibm_all_metrics______________________','___ibm_all_metrics___','/sam/pvureports','0')

MSSQL:
merge into dbo.reports r
using
(
select '___ibm_all_metrics___' as name
) as tmp on tmp.name = r.name
when not matched then
insert (user_id,pagestate_id,name,path,private) values
(-1,'___ibm_all_metrics______________________','___ibm_all_metrics___','/sam/pvureports','0');

LMT service needs to be restarted after the change.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
26 April 2021

UID

swg21992043