
Anonymous
Not applicable
2017-11-26
11:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
324 Views
4 Replies

Champion II
2017-11-27
02:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
324 Views

Anonymous
Not applicable
2017-11-27
04:16 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi sorry now im facing this issue
Message: ORA-01400: cannot insert NULL into ("RELATE"."CST_CUSTOMER"."CUST_ID")
324 Views

Anonymous
Not applicable
2017-11-27
04:20 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
324 Views

Champion II
2017-11-27
04:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
324 Views
