Four Stars

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

4 REPLIES
Twelve Stars TRF
Twelve Stars

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

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.


TRF
Four Stars

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

hi sorry now im facing this issue

 

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

Four Stars

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

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

Twelve Stars TRF
Twelve Stars

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

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.

TRF