cancel
Showing results for 
Search instead for 
Did you mean: 

Error while adding Image: ORA-00001: unique constraint

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Roman

I am facing a similar issue. Can you please let me know how did you resolve this error please?

Regards,

Ritam

jason_boggans
Active Contributor
0 Kudos

Hi Ritam,

For such issues, can you please create a new thread or directly email the author rather than dragging back up a very old thread, it is unlikely that the resolution would be the same as the database/application/etc releases would most probably be very different.

For now I will close this thread as unanswered.

SAP SRM Moderators.