Why we got ORA-00001: unique constraint?
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))
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))
0