Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ORA-00001: unique constraint (RELATE.PK1) violated

Hi all, 

 

im getting this error even though i am inserting unique value in the columns mentioned, 

 

can anyone help me

Labels (2)
4 Replies
TRF
Champion II

Hi,

 

If you are sure there is no duplicate rows in your import, is the target table empty?

Is there any trigger fired on the db which may produce duplicates for this table or an other?

 

Hope this helps.

Anonymous
Not applicable
Author

hi sorry now im facing this issue

 

Message: ORA-01400: cannot insert NULL into ("RELATE"."CST_CUSTOMER"."CUST_ID")

Anonymous
Not applicable
Author

even though the source column has value, 

i have mappped the soapui response side CUSTOMERACCOUNTID  '300000002158900'  to CUSTID '1' value in database

 

the source side has value to be put into database, 

 

i need help in this

TRF
Champion II

Change the destination to a file or use a tLogRow or run the job in debug mode to be sure the field has a value before to enter the tOracleXxxx component.