IBM Support

IJ24630: PATCHING PROCESS TO QRADAR 7.4 CAN FAIL WHEN ATTACKER_HISTORY DATABASE TABLE CONTAINS DUPLICATE VALUES

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

  • QRadar patching process on Consoles and Managed Hosts can fail
    if the database attacker_history table has duplicate values.
    Messages similar to the following might be visible during the
    patching process when this issue is occurring:
    ERROR: could not create unique index
    "attacker_history_ipaddress_key"
    DETAIL: Key (ipaddress, domain_id)=(X.X.X.X, 0) is duplicated.
    CONTEXT: SQL statement "ALTER TABLE public.attacker_history ADD
    CONSTRAINT attacker_history_ipaddress_key UNIQUE(ipaddress,
    domain_id) WITH (fillfactor='50');"
    PL/pgSQL function create_inet_index(character varying,character
    varying,character varying,character varying,character varying)
    line 12 at EXECUTE
    SQL statement "SELECT create_inet_index(
    'attacker_history_ipaddress_key', 'attacker_history', 'public',
    'ipaddress', 'domain_id')"
    PL/pgSQL function create_offense_inet_indexes() line 6 at
    PERFORMError applying script [70/87]
    '/media/updates/opt/qradar/conf/templates/db_update_offense.inet
    .2.sql' for Test_qradar database.; details:
    

Local fix

  • Contact Support for a possible workaround that might address
    this issue in some instances.
    

Problem summary

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IJ24630

  • 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-04-29

  • Closed date

    2020-05-01

  • Last modified date

    2020-05-01

  • 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"}]}]

Document Information

Modified date:
02 May 2020