ORA - 00001 1

[fuzzbox]

Hi guys
I have a table as follows...

DROP TABLE PERFORMANCEEVENTLOG CASCADE CONSTRAINTS ;

CREATE TABLE PERFORMANCEEVENTLOG (
ORIGINALHOSTNAME VARCHAR2 (128) NOT NULL,
ORIGINALPROCESSID NUMBER NOT NULL,
ORIGINALTHREADID NUMBER NOT NULL,
ORIGINALEVENTTIMESTAMP NUMBER NOT NULL,
ORIGINALIDENTIFYINGNUMBER NUMBER NOT NULL,
ORIGINALCOMPONENTID NUMBER NOT NULL,
ORIGINALSERVICEID NUMBER NOT NULL,
PARENTCOMPONENTID NUMBER,
PARENTSERVICEID NUMBER,
CURRENTCOMPONENTID NUMBER,
CURRENTSERVICEID NUMBER,
STARTDATE VARCHAR2 (21),
ENDDATE VARCHAR2 (21),
DURATION NUMBER,
PARENTCRC NUMBER,
LOGGEDPARENTCRC NUMBER,
LOGGEDPARENTHOPCOUNT NUMBER,
INVOKEPATHCRC NUMBER NOT NULL,
HOPCOUNT NUMBER NOT NULL,
SLMMARKED NUMBER,
RATINGMARKED NUMBER,
CONSTRAINT PK_PERFORMANCEEVENTLOG
PRIMARY KEY ( ORIGINALHOSTNAME, ORIGINALPROCESSID, ORIGINALTHREADID, ORIGINALEVENTTIMESTAMP, ORIGINALIDENTIFYINGNUMBER, ORIGINALCOMPONENTID, ORIGINALSERVICEID, INVOKEPATHCRC, HOPCOUNT )
USING INDEX
TABLESPACE USERS PCTFREE 10
STORAGE ( INITIAL 10K NEXT 3196K PCTINCREASE 50 ))
TABLESPACE USERS
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10240
NEXT 4909056
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 121
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;


I have an application which needs to execute update queries on this table.

However, what is occuring on the update is the following ...

ORA-00001: unique constraint (BDENNEHY.PK_PERFORMANCEEVENTLOG) violated
), Query (UPDATE PerformanceEventLog SET SLMMarked = 1 WHERE OriginalHostName = 'BORKBORK' AND OriginalProcessID = 2232 AND OriginalThreadID = 2184 AND OriginalEventTimestamp = 1048077903 AND OriginalIdentifyingNumber = 146 AND OriginalComponentID = 777 AND OriginalServiceID = 100080 AND InvokePathCRC = -18988885 AND HopCount = 1


The problem I have is that SLMMarked is not part of any key at all, and since it is the only thing being updated, surely there should be no problem.

Another problem I have is that there are a number of updates that are required, and some of them actually execute correctly, while others return the error listed above.

I have ORACLE 8i running on Windows 2000.

Is there something obvious that I am missing ?

Thanks in advance
Brian

 

[Murt]

The only thing I can think of is that there may be a trigger on the table that is executing with the update.
Check user_triggers or dba_triggers

Murt

 

[Larena]

Thanks Murt - this helped me fix a similar problem I was having