IBM Support

IJ24031: QRADAR ASSET CLEANUP PROCESS CAN FAIL AND GENERATE A PSQLEXCEPTION WHEN ATTEMPTING TO RUN

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 the QRadar Asset Cleanup attempts to run, it can sometimes
    fail with a PSQL Exception generated in QRadar logging.
    Messages similar to the following might be visible in
    /var/log/qradar.log when this issue is occurring:
    [assetprofiler.assetprofiler] [AssetCleanupThread]
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker: [INFO]
    [NOT:0000006000][127.0.0.1/- -] [-/- -]Following message
    suppressed 633 times in 300000 milliseconds
    [assetprofiler.assetprofiler] [AssetCleanupThread]
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker: [ERROR]
    [NOT:0000003000][127.0.0.1/- -] [-/-
    -]AssetCleanupWorker.run(): Unable to cleanup asset. Skipping
    to next...
    [assetprofiler.assetprofiler] [AssetCleanupThread]
    com.q1labs.assetprofile.cleanup.AssetCleanupException:
    org.postgresql.util.PSQLException: This statement has been
    closed.
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker.createCleanup
    Updates(AssetCleanupWorker.java:614)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker.cleanupAssetC
    omponents(AssetCleanupWorker.java:172)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker.cleanAsset(As
    setCleanupWorker.java:405)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker.walkAssetMode
    lAndClean(AssetCleanupWorker.java:260)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker.run(AssetClea
    nupWorker.java:99)
    [assetprofiler.assetprofiler] [AssetCleanupThread] Caused by:
    [assetprofiler.assetprofiler] [AssetCleanupThread]
    org.postgresql.util.PSQLException: This statement has been
    closed.
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(Abstract
    Jdbc2Statement.java:2637)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.postgresql.jdbc2.AbstractJdbc2Statement.getResultSet(Abstrac
    tJdbc2Statement.java:830)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.getResultSet(
    NewProxyPreparedStatement.java:1408)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.getResul
    tSet(DelegatingPreparedStatement.java:202)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.getResul
    tSet(DelegatingPreparedStatement.java:200)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedS
    tatement.executeQuery(PostgresDictionary.java:1026)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:265)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedSt
    atement.executeQuery(JDBCStoreManager.java:1774)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:265)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQ
    uery(DelegatingPreparedStatement.java:255)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    at
    com.q1labs.assetprofile.cleanup.AssetCleanupWorker.createCleanup
    Updates(AssetCleanupWorker.java:568)
    [assetprofiler.assetprofiler] [AssetCleanupThread]    ... 4 more
    

Local fix

  • No workaround available.
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 7.4.1 FixPack
    2 and 7.4.2 FixPack 2.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 7.4.1 FixPack
    2 and 7.4.2 FixPack 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ24031

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    730

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-31

  • Closed date

    2020-11-16

  • Last modified date

    2021-01-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":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSBQAC","label":"IBM QRadar SIEM"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"730"}]

Document Information

Modified date:
27 January 2021