Database Administration (MOSC)

MOSC Banner

Why we got ORA-00001: unique constraint?

edited Dec 3, 2009 2:55AM in Database Administration (MOSC) 4 commentsAnswered
We got an error on inserting into tIssueArticle for a period of about 4 minutes from 22.07 to 22.11 last night (01-12-2009).  The error is for unique constraint (PROD.IDX_ISSUEARTICLE_KEYPARENT), but this index is not unique.  
I tried the insert this morning and it worked fine.  Prior to 22.07 and subsequent to 22.11 the inserts worked OK
 
I checked the alert logs and there are no errors.
 
ORA-00001: unique constraint (PROD.IDX_ISSUEARTICLE_KEYPARENT) violated (INSERT INTO tIssueArticle (iua_lKey, iua_lStatus, iua_art_lKey, iua_iss_lKey, iua_fty_lKey, iua_lPageNo, iua_sPageName, iua_lExternalKey, iua_sSectionName, iua_lKeyParent, iua_lArticleNo, iua_sAuthor, iua_sTitle, iua_arc_lKey, iua_sContinued, iua_sContinuation, iua_lSourcePageCount, iua_lWordCount) VALUES (824405267, 0, 177342123, 25030815, 1, 1, '5', 25030815, 'Business', 0, 1, 'Jamie Dunkley', 'Pearl moves closer to London listing with warrant swaps', 0, NULL, NULL, 1, 311))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center