Skip to Content
0
Former Member
Jan 12, 2009 at 11:57 PM

Error while adding Image: ORA-00001: unique constraint

37 Views

Dear all,

I have an error while adding images to MDM I can´t explain. I want to add 7231 images. About 6983 run fine. The rest throws this error.

Error: Service 'SRM_MDM_CATALOG', Schema 'SRMMDMCATALOG2_m000', ERROR CODE=1 ||| ORA-00001: unique constraint (SRMMDMCATALOG2_M000.IDATA_6_DATAID) violated

Last CMD: INSERT INTO A2i_Data_6 (PermanentId, DataId, DataGroupId, Description_L3, CodeName, Name_L3) VALUES (:1, :2, :3, :4, :5, :6)

Name=PermanentId; Type=9; Value=1641157; ArraySize=0; NullInd=0;

Name=DataId; Type=5; Value=426458; ArraySize=0; NullInd=0;

Name=DataGroupId; Type=4; Value=9; ArraySize=0; NullInd=0;

Name=Description_L3; Type=2; Value=; ArraySize=0; NullInd=0;

Name=CodeName; Type=2; Value=207603_Img8078_gif; ArraySize=0; NullInd=0;

Name=Name_L3; Type=2; Value=207603_Img8078.gif; ArraySize=0; NullInd=0;

Error: Service 'SRM_MDM_CATALOG', Schema 'SRMMDMCATALOG2_m000', ERROR CODE=1 ||| ORA-00001: unique constraint (SRMMDMCATALOG2_M000.IDATA_6_DATAID) violated

Last CMD: INSERT INTO A2i_Data_6 (PermanentId, DataId, DataGroupId, Description_L3, CodeName, Name_L3) VALUES (:1, :2, :3, :4, :5, :6)

Name=PermanentId; Type=9; Value=1641157; ArraySize=0; NullInd=0;

Name=DataId; Type=5; Value=426458; ArraySize=0; NullInd=0;

Name=DataGroupId; Type=4; Value=9; ArraySize=0; NullInd=0;

Name=Description_L3; Type=2; Value=; ArraySize=0; NullInd=0;

Name=CodeName; Type=2; Value=207603_Img8085_gif; ArraySize=0; NullInd=0;

Name=Name_L3; Type=2; Value=207603_Img8085.gif; ArraySize=0; NullInd=0;

I checked all data. There is no such dataset in the database. Can anybody give me a hint how to avoid this error.

One thing I wonder: The PermanentId is allways the same but I can´t do anything here.

BR

Roman

Edited by: Roman Becker on Jan 13, 2009 12:59 AM