IJ40497: DATA IMPORT FAILED AFTER ILMT UPGRADE TO 9.2.27, ERROR "NOMETHODERROR (UNDEFINED METHOD `CLEAR_WR_CONNECTION' FOR NIL:NILCLASS)"

APAR status

• Closed as program error.

Error description

• The issue is that recently we dropped the feature that allowed
  users to authenticate in ILMT using the BigFix WebReports user
  credentials. Error in import log:
  ERROR: RuntimeError: LMT ETL step failed
  Error in tema.log
  
  00000024 com.ibm.ws.webcontainer.webapp
       I SRVE0292I: Servlet Message - [tema]:.[DEBUG] (0.000000s)
  SELECT * FROM [datasources] WHERE [id] = N'1'
  00000024 com.ibm.ws.webcontainer.webapp
       I SRVE0292I: Servlet Message - [tema]:.[FATAL]
  
  NoMethodError (undefined method `clear_wr_connection' for
  nil:NilClass):
  
  
  
  
  
  TS009398964
  

Local fix

• Please instruct customer to login to ILMT UI, go to Management >
  Users panel and change the authentication method of those users
  to any other than WebReports or delete those users.
  To find users
  select * from dbo.users
  The problem users (not system) will be the users with NULL in
  password column and "web_reports" in the authentication_method
  column
  

Problem summary

• ****************************************************************
  *****************
  ERROR DESCRIPTION:
  
  The issue is that recently we dropped the feature that allowed
  
  users to authenticate in ILMT using the BigFix WebReports user
  
  credentials. Error in import log:
  
  ERROR: RuntimeError: LMT ETL step failed
  
  Error in tema.log
  
  
  
  00000024 com.ibm.ws.webcontainer.webapp
  
       I SRVE0292I: Servlet Message - Ýtema¨:.ÝDEBUG¨ (0.000000s)
  
  SELECT * FROM Ýdatasources¨ WHERE Ýid¨ = N'1'
  
  00000024 com.ibm.ws.webcontainer.webapp
  
       I SRVE0292I: Servlet Message - Ýtema¨:.ÝFATAL¨
  
  
  
  NoMethodError (undefined method `clear_wr_connection' for
  
  nil:NilClass):
  
  
  
  
  
  
  
  
  
  
  
  TS009398964
  
  ****************************************************************
  *****************
  * 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.29.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