IBM Support

IV89064: THE QRADAR ARIEL API CAN SOMETIMES RETURN NO RESULTS WHEN PROCESSING LARGE NUMBERS OF SEARCH RESULTS

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

  • When attempting to receive a large number of search results
    using the QRadar Ariel API, the API can fail and no results are
    returned.
    
    Messages similar to the following might be visible in
    /var/log/qradar.log when this particular issue is occurring:
    
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]
    com.q1labs.restapi.servlet.apidelegate.APIDelegate: [ERROR]
    [NOT:0000003000][127.0.0.1/- -] [-/- -]Request Exception
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]
    com.q1labs.restapi_annotations.content.exceptions.APIMappedExcep
    tion: Invocation was successful, but transformation to
    content type "APPLICATION_JSON" failed
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.restapi.servlet.utilities.APIRequestHandler.outputRes
    ult(APIRequestHandler.java:707)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.restapi.servlet.utilities.APIRequestHandler.redirectR
    equest(APIRequestHandler.java:405)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.restapi.servlet.utilities.APIRequestHandler.handleReq
    uest(APIRequestHandler.java:243)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.restapi.servlet.apidelegate.APIDelegate.handleRequest
    (APIDelegate.java:292)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.restapi.servlet.apidelegate.APIDelegate.service(APIDe
    legate.java:198)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    more...
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results] Caused by:
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results] java.lang.Exception: Failed to transform
    ArielAPIResultSet to desired format
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.cve.api.v0_1.content.resultset.model.ArielAPIResultSe
    t.writeAPIResultSet(ArielAPIResultSet.java:35)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.cve.api.v0_1.content.resultset.outbound.ArielAPIResul
    tSetTransformer.transform(ArielAPIResultSetTransformer.java:47)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    com.q1labs.restapi.servlet.utilities.APIRequestHandler.outputRes
    ult(APIRequestHandler.java:699)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    ... 33 more
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results] Caused by:
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results] java.sql.SQLException:
    java.io.IOException:Connection reset by peer
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    sun.nio.ch.FileDispatcherImpl.read0(Native Method)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:52)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:236)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at sun.nio.ch.IOUtil.read(IOUtil.java:205)
    [tomcat] [admin@127.0.0.1 (5093)
    /console/restapi/api/ariel/searches/2a5a2305-5ad9-47e8-9a88-43c1
    d208ec84/results]    at
    sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:410)
    more...
    

Local fix

  • Performing smaller search query subsets can sometimes prevent
    this issue from occurring.
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 728 Patch 1
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 728 Patch 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV89064

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    726

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-09

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

  • 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

  • R728 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"726","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 March 2018