IBM Support

IJ24819: OFFENSE PURGING CAN FAIL IN QRADAR 7.4.0 FP1 IF01 OR 7.4.0 FP2 WHEN THE PATCHING PATH BEGAN AT QRADAR 7.3.3 FP3

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 purging of Offenses within QRadar fails when QRadar has
    been patched to version 7.4.0 FP1 IF01 or 7.4.0 FP2 from QRadar
    7.3.3 FP3 specificallly due to an issue with database column
    ordering.
    Example patching paths affected:
    1) QRadar 7.3.3 FP3 -> 7.4.0 FP2
    2) QRadar 7.3.3 FP3 -> 7.4.0 FP1 and applied IF01
    Note: Customers who patch from QRadar versions prior to 7.3.3
    FP3 (eg. 7.3.3 FP2) to 7.4.0 FP1 IF01 or 7.4.2 FP2 should not
    be affected by this Offense purging failure issue.
    Messages similar to the following might be visible in
    /var/log/qradar.log when this issue is occurring:
    ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]
    com.ibm.si.mpc.magi.contrib.commands.offense.OffensePurgeCommand
    : [INFO] [NOT:0000006000][x/- -] [-/- -]Found 100 offense to
    purge in this transaction. The specified transaction size is
    100 and retention period is 2592000 seconds.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]
    com.ibm.si.mpc.magi.contrib.commands.offense.OffensePurgeCommand
    : [ERROR] Chained SQL Exception [1/2]: Batch entry 0 select *
    from purge_offense(10499)  as result was aborted: ERROR: column
    "first_target_ipaddress" is of type inet but expression is of
    type bigint
      Hint: You will need to rewrite or cast the expression.
      Where: PL/pgSQL function purge_offense(bigint) line 6 at SQL
    statement  Call getNextException to see other errors in the
    batch.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]
    com.ibm.si.mpc.magi.contrib.commands.offense.OffensePurgeCommand
    : [ERROR] Chained SQL Exception [2/2]: ERROR: column
    "first_target_ipaddress" is of type inet but expression is of
    type bigint
      Hint: You will need to rewrite or cast the expression.
      Where: PL/pgSQL function purge_offense(bigint) line 6 at SQL
    statement
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]
    com.ibm.si.mpc.magi.contrib.commands.offense.OffensePurgeCommand
    : [ERROR] [NOT:0000003000][x/- -] [-/- -]database executing
    purge command failed.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]
    java.sql.BatchUpdateException: Batch entry 0 select * from
    purge_offense(10499)  as result was aborted: ERROR: column
    "first_target_ipaddress" is of type inet but expression is of
    type bigint
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Hint: You
    will need to rewrite or cast the expression.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Where:
    PL/pgSQL function purge_offense(bigint) line 6 at SQL statement
     Call getNextException to see other errors in the batch.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHa
    ndler.java:148)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe
    cutorImpl.java:2184)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm
    pl.java:481)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:84
    0)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedS
    tatement.java:1538)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.commands.base.BasePurgeCommand.execu
    te(BasePurgeCommand.java:93)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:2528)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:2492)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.executePurgeCommands(
    ModelPersister.java:833)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.process(ModelPersiste
    r.java:1258)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCurrentTransac
    tion(ModelPersister.java:579)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:453)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.process(ModelPersiste
    r.java:293)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.TxStateManager.playCurrent(TxStateMa
    nager.java:259)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister$Persister.playCurrent
    (ModelPersister.java:2918)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister$Persister.run(ModelPe
    rsister.java:2874)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069] Caused by:
    org.postgresql.util.PSQLException: ERROR: column
    "first_target_ipaddress" is of type inet but expression is of
    type bigint
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Hint: You
    will need to rewrite or cast the expression.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Where:
    PL/pgSQL function purge_offense(bigint) line 6 at SQL statement
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(Qu
    eryExecutorImpl.java:2440)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe
    cutorImpl.java:2183)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    ... 14 more
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]
    com.ibm.si.mpc.magi.contrib.ModelPersister: [WARN]
    [NOT:0180002100][x/- -] [-/- -]Exception encounted when
    executing transaction 54069.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]
    com.ibm.si.mpc.magi.contrib.PersistenceException: Failed to
    persist sem model
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCurrentTransac
    tion(ModelPersister.java:676)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:453)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.process(ModelPersiste
    r.java:293)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.TxStateManager.playCurrent(TxStateMa
    nager.java:259)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister$Persister.playCurrent
    (ModelPersister.java:2918)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister$Persister.run(ModelPe
    rsister.java:2874)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069] Caused by:
    java.sql.BatchUpdateException: Batch entry 0 select * from
    purge_offense(10499)  as result was aborted: ERROR: column
    "first_target_ipaddress" is of type inet but expression is of
    type bigint
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Hint: You
    will need to rewrite or cast the expression.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Where:
    PL/pgSQL function purge_offense(bigint) line 6 at SQL statement
     Call getNextException to see other errors in the batch.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHa
    ndler.java:148)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe
    cutorImpl.java:2184)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm
    pl.java:481)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:84
    0)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedS
    tatement.java:1538)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.commands.base.BasePurgeCommand.execu
    te(BasePurgeCommand.java:93)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:2528)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:2492)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.executePurgeCommands(
    ModelPersister.java:833)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.process(ModelPersiste
    r.java:1258)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    com.ibm.si.mpc.magi.contrib.ModelPersister.processCurrentTransac
    tion(ModelPersister.java:579)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    ... 5 more
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069] Caused by:
    org.postgresql.util.PSQLException: ERROR: column
    "first_target_ipaddress" is of type inet but expression is of
    type bigint
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Hint: You
    will need to rewrite or cast the expression.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    Where:
    PL/pgSQL function purge_offense(bigint) line 6 at SQL statement
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(Qu
    eryExecutorImpl.java:2440)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe
    cutorImpl.java:2183)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000054069]    ... 14 more
    

Local fix

  • No workaround available.
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 7.4.0 Fix Pack
    3 and 7.3.3 FixPack 4.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 7.4.0 Fix Pack
    3 and 7.3.3 FixPack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ24819

  • 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-05-07

  • Closed date

    2020-06-16

  • Last modified date

    2020-07-13

  • 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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSBQAC","label":"IBM QRadar SIEM"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"740"}]

Document Information

Modified date:
14 July 2020