IBM Support

Guardium Policy not installed - Err:Duplicate entry '2147483647' for key 'PRIMARY'

Troubleshooting


Problem

Getting following error on IBM Security Guardium when pushing policy from Central Manager (CM) to Managed Units (MU). Error on CM while pushing policy to MU: Err:Duplicate entry '2147483647' for key 'PRIMARY' - Policy not installed

Symptom

In a large environment where there is a requirement to schedule policy install on MU, the CM will keep on re-installing the policy on units. This causes AUTO_INCREMENT value in an internal policy related table to reach its maximum (2147483647) and hence produces the below error on CM

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Guardium Appliances","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.1.3","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

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.

Document Information

Modified date:
16 June 2018

UID

swg22011389