Blog Entry

(View Disclaimer)

When I attach a file or deploy a Correlation rule my Sentinel Control Center is not refreshing the status. So, I need to clic on refresh button and after that, I can see the changes made.

Errors

Tue Mar 31 12:16:36 GMT-06:00 2009|Thread-4585|SEVERE|Error; Going to rollback transaction.; Exception Violation of PRIMARY KEY constraint 'ANN_PK'. Cannot insert duplicate key in object 'dbo.ANNOTATIONS'.; java.sql.BatchUpdateException; ||||esecurity.base.query.db.BaseJDBCQuery|executeDMLBatch|

Tue Mar 31 12:16:36 GMT-06:00 2009|Thread-4585|SEVERE|java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'ANN_PK'. Cannot insert duplicate key in object 'dbo.ANNOTATIONS'.

Tue Mar 31 12:16:36 GMT-06:00 2009|Thread-4585|SEVERE|esecurity.base.exceptions.PersistenceException: Execute INSERT INTO ANNOTATIONS ( ANNOTATIONS.ACTION,ANNOTATIONS.DATE_MODIFIED,ANNOTATIONS.ANN_ID,
ANNOTATIONS.CREATED_BY,ANNOTATIONS.DATE_CREATED,ANNOTATIONS.TEXT,
ANNOTATIONS.MODIFIED_BY ) VALUES ( ?,?,?,?,?,?,? ) Params [[ 1: 'MODIFY INCIDENT', 2: '1238523396756 (Tue Mar 31 12:16:36 GMT-06:00 2009)', 3: '431547', 4: '157', 5: '1238523396756 (Tue Mar 31 12:16:36 GMT-06:00 2009)', 6: 'ASSIGNED. ', 7: '157' ]] - SQLState : 23000

Tue Mar 31 12:16:36 GMT-06:00 2009|Thread-4585|SEVERE|Error saving Incident; Exception Execute INSERT INTO ANNOTATIONS ( ANNOTATIONS.ACTION,ANNOTATIONS.DATE_MODIFIED,ANNOTATIONS.ANN_ID,
ANNOTATIONS.CREATED_BY,ANNOTATIONS.DATE_CREATED,ANNOTATIONS.TEXT,
ANNOTATIONS.MODIFIED_BY ) VALUES ( ?,?,?,?,?,?,? ) Params [[ 1: 'MODIFY INCIDENT', 2: '1238523396756 (Tue Mar 31 12:16:36 GMT-06:00 2009)', 3: '431547', 4: '157', 5: '1238523396756 (Tue Mar 31 12:16:36 GMT-06:00 2009)', 6: 'ASSIGNED. ', 7: '157' ]] - SQLState : 23000; esecurity.base.exceptions.PersistenceException; ; Caused by Violation of PRIMARY KEY constraint 'ANN_PK'. Cannot insert duplicate key in object 'dbo.ANNOTATIONS'.; java.sql.BatchUpdateException; ||||esecurity.ccs.comp.incident.IncidentService|saveIncident|

any idea?

Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).

It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test, test, test before you do anything drastic with it.