Environment
Sentinel 5.1.1.0
MS SQL 2000, 2005
MS SQL 2000, 2005
Situation
Event insertion failures on the database
Failed to insert 1 events to DB--Events were stored for later insertion.
.... Violation of PRIMARY KEY constraint'EVENTS_P_20060711170000_EVENTS_P_MAX_PK'. Cannot insert duplicate key in object 'dbo.EVENTS_P_20060711170000'.; DeviceCategory = ESEC;
Failed to insert 1 events to DB--Events were stored for later insertion.
.... Violation of PRIMARY KEY constraint'EVENTS_P_20060711170000_EVENTS_P_MAX_PK'. Cannot insert duplicate key in object 'dbo.EVENTS_P_20060711170000'.; DeviceCategory = ESEC;
Resolution
There was an issue with how the buffer handled correlated events
that has been fixed in the 5.1.1.0 SP2 Hotfix.
Please download and apply the patch from https://support.novell.com
Please download and apply the patch from https://support.novell.com