IBM Security Guardium - Enable Quick Search fails with err 3322 Couldn't store trigger 'DataMartExtractionJobTrigger

Troubleshooting

Problem

The CLI command to enable quick search fails with the error described.

CLI Command to enable quick search: grdapi enable_quick_search all=false schedule_interval=2 schedule_units=MINUTE debug=3

Instead of enabling quick search, you get an error:

ERR=3322
Couldn't store trigger 'DataMartExtractionJobTrigger_1' for 'DataMartExtractionJob_1' job:Duplicate entry 'DataMartExtractionJobTrigger_1-DataMartExtractionJobGroup' for key 'PRIMARY' java.sql.SQLIntegrityConstraintViolationException: Duplicate entry 'DataMartExtractionJobTrigger_1-DataMartExtractionJobGroup' for key 'PRIMARY'
Failed to enable schedule for quick search

Symptom

Error is returned:

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z0000001ercAAA","label":"QUICK SEARCH\\OUTLIER"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

TS013230624

Was this topic helpful?

Document Information

Modified date:
10 August 2023

UID

ibm17025137

Tips

IBM Security Guardium - Enable Quick Search fails with err 3322 Couldn't store trigger 'DataMartExtractionJobTrigger_1'