IJ28703: DATA IMPORT FAILS INTERMITTENTLY

APAR status

• Closed as program error.

Error description

• The data import fails but no error message is stated in the
  Import Log, however the following error message is logged in
  ILMT server log file (tema.log):
  
  ---
  Errno::EACCES: Permission
  denied - C:\Program Files\ibm\LMT\wlp\usr\servers\server1/config
  /aplication_info.yml
  ---
  
  The issue is caused by a file sharing
  collision between the Java & BESClient
  process.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  TS004292509
  TS004299095
  

Local fix

• - Go to the ILMT Server machine
  - stop ILMT Server
  - open following server file:
  <ILMT_installation_directory>/wlp/usr/servers/server1/apps/tema.
  war/WEB-INF/lib/database.rb
  - replace following method definition (lines 1047-1067):
  ----------------------------------------------------------------
  def update_database_version_file(db)
      version = get_database_version_string(db)
      Rails.logger.info("Detected License Metric Tool database
  version: #{version}")
  
      if File.exist?(version_yml_path)
        version_file_content = YAML.load_file(version_yml_path)
        if version_file_content == false
          version_file_content = {}
        end
      else
        version_file_content = {}
      end
  
  
      version_file_content['db_type']= (Sequel::Model.db.mssql? ?
  "MSSQL" : "DB2")
      version_file_content['db_version']=version
  
      File.open(version_yml_path,'w') do |h|
         h.write version_file_content.to_yaml
      end
    end
  ----------------------------------------------------------------
  
  with following method definition (please check that after
  pasting the code the lines indentation is correct and remove any
  extraneous newlines):
  ----------------------------------------------------------------
  def update_database_version_file(db)
      begin
        version = get_database_version_string(db)
        db_type = (Sequel::Model.db.mssql? ? "MSSQL" : "DB2")
        Rails.logger.info("Detected License Metric Tool database
  version: #{version}")
  
        version_file_content = YAML.load_file version_yml_path if
  File.exist?(version_yml_path)
        version_file_content ||= {}
  
        if version_file_content['db_type'] != db_type ||
  version_file_content['db_version'] != version
          version_file_content['db_type'] = db_type
          version_file_content['db_version'] = version
          File.open(version_yml_path,'w') do |h|
             h.write version_file_content.to_yaml
          end
        end
      rescue
        Rails.logger.info("Saving database version info into file
  failed at this time - will try during next data import.")
      end
    end
  ----------------------------------------------------------------
  - start ILMT server
  

Problem summary

• ****************************************************************
  *****************
  ERROR DESCRIPTION:
  
  The data import fails but no error message is stated in the
  
  Import Log, however the following error message is logged in
  
  ILMT server log file (tema.log):
  
  
  
  ---
  
  Errno::EACCES: Permission
  
  denied - C:\Program Files\ibm\LMT\wlp\usr\servers\server1/config
  
  /aplication_info.yml
  
  ---
  
  
  
  The issue is caused by a file sharing
  
  collision between the Java & BESClient
  
  process.
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  TS004292509
  
  TS004299095
  
  ****************************************************************
  *****************
  * 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.22.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