IBM Support

IJ27129: GEO::DISTANCE IN AQL QUERIES DOES NOT CALCULATE DISTANCE CORRECTLY WHEN AN INTERNAL IP IS USED FOR THE SECOND ARGUEMENT

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

  • Using GEO::DISTANCE in AQL queries does not calculate distance
    correctly if a internal IP address is used for the second
    argument in the query.
    Using GEO::DISTANCE in AQL gueries -
    Works for two external IPs:
    Works for internal -> external
    Does not work for external -> internal IP:
    Does not work for internal IP -> internal IP if the distance is
    greater then 0
    For example -
    SELECT GEO::DISTANCE('external-IP', 'internal-IP') AS KM FROM
    events LIMIT 1
    Results in NA as the output.
    SELECT GEO::DISTANCE('internal-IP', 'internal-IP') AS KM FROM
    events LIMIT 1
    Results in incorrect distance in the output.
    

Local fix

  • No workaround available.
    APARs identified with no workaround may require a software
    delivery to resolve. This reported issue will be considered for
    a future release and administrators can subscribe to the APAR
    to get updates by clicking on the Subscribe button on the right
    side of this page or ask a question about this APAR in our
    Support Forums.
    https://ibm.biz/qradarforums
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 7.4.3.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 7.4.3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ27129

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    740

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-08-19

  • Closed date

    2021-05-25

  • Last modified date

    2021-05-25

  • 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

    QRADAR SOFTWARE

  • Fixed component ID

    5725QRDSW

Applicable component levels

[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"740"}]

Document Information

Modified date:
26 May 2021