IBM Support

IJ25318: PERFORMING A 'DEPLOYMENT CONFIGURATION' RESTORE REQUIRES RESTORING 'RULES' ALSO

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

  • Performing a config restore for "Deployment Configuration" does
    not include custom rules dependencies of reference data,
    therefore restoring "Rules" is also required.
    Messages similar to the following might be visible in
    /var/log/qradar.log when "Rules" are not selected to be
    restored during a "Deployment Configuration" config restore:
    User@127.0.0.1[hostcontext.hostcontext]
    [BackupServices_restore] java.lang.Exception: unable to execute
    sql statement: ALTER TABLE public.reference_data_rules ADD
    CONSTRAINT reference_data_rules_rule_id_fkey FOREIGN KEY
    (rule_id) REFERENCES public.custom_rule(id) ON DELETE CASCADE;
    User@127.0.0.1[hostcontext.hostcontext]
    [BackupServices_restore] at
    com.q1labs.hostcontext.capabilities.PostgresAction.executeSql(Po
    stgresAction.java:668)
    User@127.0.0.1[hostcontext.hostcontext]
    [BackupServices_restore] at
    com.q1labs.hostcontext.capabilities.PostgresAction.applyConstrai
    nts(PostgresAction.java:287)
    User@127.0.0.1[hostcontext.hostcontext]
    [BackupServices_restore] at
    com.q1labs.hostcontext.backup.BackupRecoveryEngine.doDbRestore(B
    ackupRecoveryEngine.java:2974)
    User@127.0.0.1[hostcontext.hostcontext]
    [BackupServices_restore] ... 5 more
    

Local fix

  • Select to restore "Rules" also when performing a 'Deployment
    Configuration" config restore.
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 7.4.3.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 7.4.3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ25318

  • 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

    2020-06-01

  • Closed date

    2021-05-25

  • Last modified date

    2021-05-25

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

Document Information

Modified date:
26 May 2021