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

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

Anonymous — Sat, 04 Nov 2017 18:22:52 GMT

Hi all,

I am doing the Oracle fusion integration in talend i.e from Fusion to Customer Engagement, so while mapping the tables from fusion to Customer Engagement tables in database level, i'm facing this issue even though i mapped all columns correctly..can anyone help me in this?

Regards

Rak**bleep**a

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

Anonymous — Mon, 06 Nov 2017 14:07:37 GMT

Is there any null value for cust_id from source?

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

Anonymous — Sat, 25 Nov 2017 15:24:36 GMT

but now im getting

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

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

Anonymous — Sat, 25 Nov 2017 16:00:40 GMT

Message is clear. You are trying to insert duplicate value for that field.

Data are being pushed to oracle correctly. Error is due due to data that your are trying to push