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'
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.
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"}}]
Was this topic helpful?
Document Information
Modified date:
26 April 2021
UID
swg21992043