IBM Support

IJ10070: [EVENT PROCESSOR] QRADAR CAN STOP GENERATING OFFENSES DUE TO AN INCORRECT NULL CHECK

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

  • It has been identified that QRadar can stop generating offenses
    when an incorrect null check occurs.
    Messages similar to the following might be visible in
    /var/log/qradar.log when this issue is occurring:
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]SQL Statement Parameters ===============
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]  size=2
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]  idList1=2331,2331,
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]  idList2=-1,43,
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]  eventCountList=1,1,
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]  startTimeList=1530591615910,1530591620361,
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]  endTimeList=1530591615910,1530591620361,
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.commands.category.CategoryAddOffense
    AttackerCommand: [ERROR] [NOT:0000003000][IP_ADDRESS/- -] [-/-
    -]========================================
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.ModelPersister: [WARN]
    [NOT:0180002100][IP_ADDRESS/- -] [-/- -]Exception encounted
    when executing transaction 19055.
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    com.q1labs.sem.magi.contrib.PersistenceException: Failed to
    persist sem model
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.processCurrentTransac
    tion(ModelPersister.java:640)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:417)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.process(ModelPersiste
    r.java:257)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.TxStateManager.playCurrent(TxStateMa
    nager.java:259)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister$Persister.playCurrent
    (ModelPersister.java:2854)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister$Persister.run(ModelPe
    rsister.java:2810)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055] Caused by:
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]
    org.postgresql.util.PSQLException: ERROR: insert or update on
    table "offense_category_attacker_link" violates foreign key
    constraint "offense_category_attacker_link_attacker_fkey"
      Detail: Key (attacker_id)=(-1) is not present in table
    "attacker".
      Where: SQL statement "INSERT INTO
    offense_category_attacker_link (category_type_id, offense_id,
    attacker_id,
    
    event_count, start_time, end_time)
                                                    VALUES
    (p_category, v_offense,  v_attacker,
    
    v_eventCount, v_startDate, v_endDate)"
    PL/pgSQL function
    link_category_offense_attacker(integer,character
    varying,character varying,character varying,character
    varying,character varying,integer) line 55 at SQL statement
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(Qu
    eryExecutorImpl.java:2412)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe
    cutorImpl.java:2125)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm
    pl.java:297)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java
    :428)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPrepa
    redStatement.java:169)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCalla
    bleStatement.java:78)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatem
    ent.java:158)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.commands.base.BaseMultiAssociatorWit
    hEvents.execute(BaseMultiAssociatorWithEvents.java:139)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:2464)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.processCommands(Model
    Persister.java:2428)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.executeOffenseUpdateC
    ommands(ModelPersister.java:2143)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.process(ModelPersiste
    r.java:1070)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    at
    com.q1labs.sem.magi.contrib.ModelPersister.processCurrentTransac
    tion(ModelPersister.java:543)
    [ecs-ep.ecs-ep] [MPC/PersisterThread@0000019055]    ... 5 more
    

Local fix

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 731 patch 7.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 731 patch 7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ10070

  • 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

    2018-10-03

  • Closed date

    2018-11-30

  • Last modified date

    2018-11-30

  • 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:
30 November 2018