IJ44813: ILMT INACCESSIBLE AFTER UPGRADE DUE TO DATABASE NAME ISSUE

APAR status

• Closed as program error.

Error description

• ILMT in a specific database call does not surround the database
  name with brackets. The brackets are required if you use
  keywords, spaces, hyphens or special characters in the database
  name, so in such circumstances, ILMT will not be operational
  after upgrade. The following message can be found in the
  tema.log file:
  
  ---
  ERROR: initialization
  failed:.org.jruby.rack.RackInitializationException: DBNAME:
  ILMT-DB - NativeException:
  com.microsoft.sqlserver.jdbc.SQLServerException: Database 'ILMT'
  does not exist. Make sure that the name is entered correctly.
  ---
  
  TS011484636
  

Local fix

• 1)
  Stop ILMT server application.
  
  2)
  - Open "<LMT_install_dir>\wlp\usr\servers\server1\apps\tema.war
  \WEB-INF\lib\database.rb" with a text editor.
  
  - Locate the line number 1282 - it should look exactly like:
  
  def validate_default_schema (db)
  
  - Right after the above line, insert a new line containing:
  
  return true
  
  3)
  Save the file edited.
  
  4)
  - Open "<LMT_install_dir>\wlp\usr\servers\server1\apps\tema.war
  \WEB-INF\lib\database_validation.rb" with a text editor.
  
  - Locate the line number 267 - it should look exactly like:
  
  def validate_database_default_schema
  
  - Right after the above line, insert a new line containing:
  
  return true
  
  5)
  Save the file edited.
  
  6)
  Start ILMT server application.
  

Problem summary

• ****************************************************************
  *****************
  ERROR DESCRIPTION:
  
  ILMT in a specific database call does not surround the database
  
  name with brackets. The brackets are required if you use
  
  keywords, spaces, hyphens or special characters in the database
  
  name, so in such circumstances, ILMT will not be operational
  
  after upgrade. The following message can be found in the
  
  tema.log file:
  
  
  
  ---
  
  ERROR: initialization
  
  failed:.org.jruby.rack.RackInitializationException: DBNAME:
  
  ILMT-DB - NativeException:
  
  com.microsoft.sqlserver.jdbc.SQLServerException: Database 'ILMT'
  
  does not exist. Make sure that the name is entered correctly.
  
  ---
  
  
  
  TS011484636
  
  ****************************************************************
  *****************
  * 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.31.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