IBM Support

IJ15680: THE IMPORT OF DATA FAILS ON SAM::APPUSAGE OR USAGEMANAGER IMPORT STEP

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • BigFix Inventory 9.2.15 - import might fail on SAM::AppUsage or
    UsageManager import step.
    The issue does not apply to License Metric Tool 9.2.15. Only
    BigFix Inventory 9.2.15 is affected.
    
    Symptoms
    1) SAM::AppUsage step -  java.lang.NullPointerException
    exception
    INFO: ETL from <datasource name> - SAM::AppUsage
          (0x0000000000000000 - N/A): Start
    INFO:  (ImportThread)
    com.ibm.license.mgmt.etl.core.actions.bigfix.usage.ImportAppUsag
    eForDatasourceAction::doAction: Uploading Application Usage
    data from BigFix.
    ERROR:  (ImportThread) execute failed - unexpected exception
    java.lang.NullPointerException
        at
    com.ibm.license.mgmt.etl.core.actions.bigfix.usage.UploadAppUsag
    eToTempAction.parseAppUsageAnalysisRecord(UploadAppUsageToTempAc
    tion.java:124)
    
    2) SAM::AppUsage step - Error converting data type datetime2 to
    datetime
    ERROR:  (ImportThread) SQLException -> Message       :
    mainException
                 -> SQL Message   : Error converting data type
    datetime2 to datetime.
                 -> SQL ErrorCode : 8114
                 -> SQL State     : S0001
     java.sql.BatchUpdateException: Error converting data type
    datetime2 to datetime.
    
    3) UsageManager - Duplicate key
    com.ibm.license.mgmt.usage.bean.UsePathBean
    INFO: ETL from UsageManager: Start
    INFO:  (ImportThread)
    com.ibm.license.mgmt.etl.core.actions.RunUsageManagerAction::doA
    ction::Measuring usage by matching process and discovery
    paths...
    ERROR:  (ImportThread) execute failed - unexpected exception
    java.lang.IllegalStateException: Duplicate key
    com.ibm.license.mgmt.usage.bean.UsePathBean@<...>
    
    4) UsageManager - java.lang.StringIndexOutOfBoundsException
    exception
    INFO: ETL from UsageManager: Start
    INFO:  (ImportThread)
    com.ibm.license.mgmt.etl.core.actions.RunUsageManagerAction::doA
    ction::Measuring usage by matching process and discovery
    paths...
    ERROR:  (ImportThread) execute failed - unexpected exception
    java.lang.StringIndexOutOfBoundsException
    

Local fix

Problem summary

  • ****************************************************************
    
    * ERROR DESCRIPTION:
    *
    * BigFix Inventory 9.2.15 - import might fail on SAM::AppUsage o
    *
    * UsageManager import step.
    *
    * The issue does not apply to License Metric Tool 9.2.15. Only
    *
    * BigFix Inventory 9.2.15 is affected.
    *
    *
    *
    * Symptoms
    *
    * 1) SAM::AppUsage step -  java.lang.NullPointerException
    *
    * exception
    *
    * INFO: ETL from <datasource name> - SAM::AppUsage
    *
    *       (0x0000000000000000 - N/A): Start
    *
    * INFO:  (ImportThread)
    *
    * com.ibm.license.mgmt.etl.core.actions.bigfix.usage.ImportAppUs
    *
    * eForDatasourceAction::doAction: Uploading Application Usage
    *
    * data from BigFix.
    *
    * ERROR:  (ImportThread) execute failed - unexpected exception
    *
    * java.lang.NullPointerException
    *
    *     at
    *
    * com.ibm.license.mgmt.etl.core.actions.bigfix.usage.UploadAppUs
    *
    * eToTempAction.parseAppUsageAnalysisRecord(UploadAppUsageToTemp
    *
    * tion.java:124)
    *
    *
    *
    * 2) SAM::AppUsage step - Error converting data type datetime2 t
    *
    * datetime
    *
    * ERROR:  (ImportThread) SQLException -> Message       :
    *
    * mainException
    *
    *              -> SQL Message   : Error converting data type
    *
    * datetime2 to datetime.
    *
    *              -> SQL ErrorCode : 8114
    *
    *              -> SQL State     : S0001
    *
    *  java.sql.BatchUpdateException: Error converting data type
    *
    * datetime2 to datetime.
    *
    *
    *
    * 3) UsageManager - Duplicate key
    *
    * com.ibm.license.mgmt.usage.bean.UsePathBean
    *
    * INFO: ETL from UsageManager: Start
    *
    * INFO:  (ImportThread)
    *
    * com.ibm.license.mgmt.etl.core.actions.RunUsageManagerAction::d
    *
    * ction::Measuring usage by matching process and discovery
    *
    * paths...
    *
    * ERROR:  (ImportThread) execute failed - unexpected exception
    *
    * java.lang.IllegalStateException: Duplicate key
    *
    * com.ibm.license.mgmt.usage.bean.UsePathBean@<...>
    *
    *
    *
    * 4) UsageManager - java.lang.StringIndexOutOfBoundsException
    *
    * exception
    *
    * INFO: ETL from UsageManager: Start
    *
    * INFO:  (ImportThread)
    *
    * com.ibm.license.mgmt.etl.core.actions.RunUsageManagerAction::d
    *
    * ction::Measuring usage by matching process and discovery
    *
    * paths...
    *
    * ERROR:  (ImportThread) execute failed - unexpected exception
    *
    * java.lang.StringIndexOutOfBoundsException
    *
    * **************************************************************
    *
    * EXPECTED RESULTS:
    * The issue does not occure.
    ****************************************************************
    * RECOMMENDATION: Apply appropriate update when available.
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    packages:
     | Update | BFI 9.2.16
     | Update | ILMT 9.2.16
    ****************************************************************
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ15680

  • Reported component name

    IEM SW USE ANL

  • Reported component ID

    5725F57MT

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-04-24

  • Closed date

    2019-05-31

  • Last modified date

    2019-05-31

  • 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

    IEM SW USE ANL

  • Fixed component ID

    5725F57MT

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSKLLW","label":"IBM BigFix Inventory"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
31 May 2019