IBM Support

IJ27235: THE 'REFERENCESETCONTAINS' AQL FUNCTION DOES NOT SEARCH INDEX FILES

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

  • AQL queries using referencesetcontains() lookups fail to search
    against index files when searching against indexed properties,
    only data files are searched.
    Performing the same searches using the QRadar User Interface
    works as expected.
    Messages similar to the following might be observed in
    /var/log/qradar.log when this issue occurs while performing
    related searches:
    ariel_client /127.0.0.1:47392 | [Action] [Search]
    [SearchExecuted] query starts,
    description="User:admin,Source:UI,Params:Id:ab137002-2aed-4433-9
    5d4-baaf53d399f2, DB:<events@/store/ariel/events/records,
    /store/ariel/events/payloads>, Time:<20-08-07,08:00:00 to
    20-08-07,12:00:00>, progress details 100, data snapshot size
    40, Criteria=<ReferenceSet(CustomProperty~DEFAULT_FILE_HASH,
    null):pr=[boolean(true)]>,
    MappingFactory=com.q1labs.core.types.event.mapping.NormalizedEve
    ntMappingFactory@4ee, retentionTime=86400000,
    prio=NORMAL,AQL:select 1 from events where
    REFERENCESETCONTAINS('HM_TestSet',"File Hash") start
    '2020-08-07 08:00' stop '2020-08-07 12:00'"
    ariel_query_1:ab137002-2aed-4433-95d4-baaf53d399f2 | [Action]
    [Search] [SearchCompleted] query finished, status=COMPLETED,
    stat details="Id:ab137002-2aed-4433-95d4-baaf53d399f2,
    FileStats [dataFileCount=480, compressedDataFileCount=0,
    indexFileCount=0, dataTotalSize=34790213,
    compressedDataTotalSize=0, indexTotalSize=0, progress=100.0%,
    totalResult=0, totalResultDataSize=24, searchTime=2476ms]",
    concurrent queries="1"
    *Note the indexFileCount=0
    

Local fix

  • Where possible, use the search functionality in the QRadar User
    Interface to perform the required searches.
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 7.4.1 FixPack
    2 QRoC InterimFix.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 7.4.1 FixPack
    2 QRoC InterimFix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ27235

  • 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-24

  • Closed date

    2021-04-26

  • Last modified date

    2021-04-26

  • 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:
27 April 2021