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 number
IJ44813
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
2023-01-04
Closed date
2023-01-19
Last modified date
2023-02-24
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"920","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
24 February 2023