IBM Support

IJ29680: NON-ADMIN USERS CANNOT OPEN THE EXTRACT PROPERTIES TAB WHEN A LARGE NUMBER OF LOG SOURCES EXIST

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

  • Non-admin QRadar users can experience a time out after a longer
    than expected period of wait time while trying to open the
    extract properties tab when using Log Source Management.
    This issue occurs when there are a large number of Log Sources
    as a permission check of all devices occurs one at a time.
    Messages similar to the following might be visible in
    /var/log/qradar.log when this issue occurs:
    "user@127.0.0.1 (4918) /console/do/qradar/arielProperties"
    Id=1835698 in RUNNABLE
    at org.postgresql.core.PGStream.receive(PGStream.java:467)
    at
    org.postgresql.core.PGStream.receiveTupleV3(PGStream.java:422)
    at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe
    cutorImpl.java:2146)
    at
    org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm
    pl.java:308)
    - locked org.postgresql.core.v3.QueryExecutorImpl@cdad6869
    at
    org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java
    :441)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
    at
    org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPrepa
    redStatement.java:143)
    at
    org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedS
    tatement.java:106)
    at
    com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(
    NewProxyPreparedStatement.java:76)
    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:270)
    at
    org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingCo
    nnection$LoggingPreparedStatement.executeQuery(LoggingConnection
    Decorator.java:1115)
    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:268)
    at
    org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedS
    tatement.executeQuery(PostgresDictionary.java:1011)
    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:268)
    at
    org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedSt
    atement.executeQuery(JDBCStoreManager.java:1800)
    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:268)
    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:258)
    at
    com.q1labs.frameworks.session.PreparedStatementWrapper.executeQu
    ery(PreparedStatementWrapper.java:270)
    at
    com.q1labs.core.shared.util.SqlUtil.runQuery(SqlUtil.java:177)
    at
    com.q1labs.core.shared.util.SqlUtil.runQuery(SqlUtil.java:162)
    at
    com.q1labs.core.util.sensors.SensorDeviceUtil.getAllLogSources(S
    ensorDeviceUtil.java:27)
    at
    com.q1labs.core.shared.util.UserUtils.getUserDeviceIds(UserUtils
    .java:803)
    at
    com.q1labs.core.shared.util.UserUtils.userHasDevices(UserUtils.j
    ava:741)
    at
    com.q1labs.core.shared.util.UserUtils.userHasDevices(UserUtils.j
    ava:1080)
    at
    com.q1labs.sem.ui.semservices.UISemServices.getSensorDevicesByDe
    viceType(UISemServices.java:3302)
    at
    com.q1labs.ariel.ui.action.ArielProperty.prepareDefaultRequestOp
    tions(ArielProperty.java:120)
    at
    com.q1labs.ariel.ui.action.ArielProperty.executeEdit(ArielProper
    ty.java:793)
    at
    com.q1labs.uiframeworks.actions.DispatchAction.edit(DispatchActi
    on.java:253)
    at sun.reflect.GeneratedMethodAccessor2973.invoke(Unknown
    Source)
    at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    

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 FixPack
    4 and 7.3.3 FixPack 10.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 7.4.3 FixPack
    4 and 7.3.3 FixPack 10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ29680

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    733

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-12-02

  • Closed date

    2021-11-15

  • Last modified date

    2021-11-29

  • 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 QRadar SIEM"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"733"}]

Document Information

Modified date:
30 November 2021