Getting unique constraint violation errors in the Foglight Management Server (FMS) database. In the alert.log of the FMS database the following error occurs:
Mon Jul 04 20:34:03 2011 error occurs from 192.168.164.133 <yourFogDB> sid : 623 Session user : <yourFogUser>
NLS_LANG : AMERICAN_AMERICA.AL32UTF8
TIMESTAMP FMT : DD-MON-RR HH.MI.SSXFF AM
DATE FMT : DD-MON-RR
Currency FMT : $
NUMERIC_CHARACTERS FMT : .,
Client_info : JDBC Thin Client - -
Stmt is : INSERT INTO topology_object ( to_type, to_unique_id, to_object_name, to_object_name_hash, to_last_updated, to_activity_day_number, to_activity_current_day) VALUES(:1, :2, :3, :4, :5, :6, :7) RETURNING to_id INTO :8
ORA-00001: unique constraint (<yourFogUser>.SYS_C00174403) violated