IBM Support

IJ22370: TRAFFICANALYSIS API IN QRADAR CAN GENERATE ERROR 'CODE: 500 MESSAGE: UNEXPECTED INTERNAL SERVER ERROR'

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

  • The QRadar TrafficAnalysis API can fail with an error similar to
    {"http_response": {"code": 500, "message": "Unexpected internal
    server error"},
    "code": 1020,
    "description": "An error occurred during the attempt to update
    the Autodetection Config Record.",
    "details": {},
    "message": "An error occured while trying to update the
    Autodetection Config Record with id: 513"}
    Messages similar to the following might be visible in
    /var/log/qradar.error when this issue is occurring:
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43] Caused by:
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]
    java.lang.IllegalArgumentException: Parameter position 1 is not
    declared in query "select MIN(a.taOrder) from
    TrafficAnalysisConfigRecord a where a.taOrder > 10000 and 0 =
    (select COUNT(b) from TrafficAnalysisConfigRecord b where
    b.taOrder = a.taOrder + 1)". Declared parameter keys are "[]".
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    org.apache.openjpa.persistence.AbstractQuery.getParameter(Abstra
    ctQuery.java:406)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    org.apache.openjpa.persistence.AbstractQuery.setParameter(Abstra
    ctQuery.java:139)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    org.apache.openjpa.persistence.AbstractQuery.setParameter(Abstra
    ctQuery.java:47)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    com.q1labs.frameworks.session.JPASessionDelegate.namedQueryForSi
    ngleResult(JPASessionDelegate.java:739)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    com.q1labs.core.dao.qidmap.TrafficAnalysisConfigRecord.getTAConf
    igRecordForTAConfigRecordPrecedence(TrafficAnalysisConfigRecord.
    java:45)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    com.ibm.si.data_ingestion.api.impl.trafficanalysis.validation.Tr
    afficAnalysisConfigRecordValidator.validatePrecedence(TrafficAna
    lysisConfigRecordValidator.java:42)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    com.ibm.si.data_ingestion.api.v10_0.trafficanalysis.impl.Traffic
    AnalysisAPIImpl.updatePrecedence(TrafficAnalysisAPIImpl.java:217
    )
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    com.ibm.si.data_ingestion.api.v10_0.trafficanalysis.impl.Traffic
    AnalysisAPIImpl.updateTAConfigRecordWithoutNotificationMask(Traf
    ficAnalysisAPIImpl.java:200)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    at
    com.ibm.si.data_ingestion.api.v10_0.trafficanalysis.impl.Traffic
    AnalysisAPIImpl.updateTAConfigRecord(TrafficAnalysisAPIImpl.java
    :176)
    [tomcat.tomcat] [127.0.0.1(4690)
    /console/restapi/api/config/event_sources/log_source_management/
    autodetection/config_records/43]    ... 68 more
    

Local fix

  • No workaround available.
    

Problem summary

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IJ22370

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    731

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-01-29

  • Closed date

    2020-03-18

  • Last modified date

    2020-03-18

  • 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

[{"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":"731","Edition":""}]

Document Information

Modified date:
18 March 2020