topic Re: The UPDATE statement conflicted with the FOREIGN KEY constraint in Talend Studio

The UPDATE statement conflicted with the FOREIGN KEY constraint

_AnonymousUser — Sat, 16 Nov 2024 11:28:02 GMT

Hello,
when I start my Job i got this message on my console.
"The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_BUSINESSES_CLIENTS". The conflict occurred in database "my_database", table "dbo.table", column 'Name_id'.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BUSINESSES_CLIENTS". The conflict occurred in database "my_database", table "dbo.table", column 'Name_ID'."
When I change the db of my input its work perfectly.
Thanks for your help.

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

Anonymous — Thu, 16 Oct 2014 05:32:07 GMT

Hi,
What's your job design? Please show us your job design screenshots so that we can get your current situation more precisely.
Best regards
Sabrina

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

_AnonymousUser — Thu, 16 Oct 2014 09:40:47 GMT

here

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

_AnonymousUser — Thu, 16 Oct 2014 09:41:32 GMT

Dont know why my photo and my link didnt work:
http :// imgur.com / 774gaIf

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

Anonymous — Thu, 16 Oct 2014 10:46:02 GMT

Hi proutprout,
We cannot see your image. Could you please register and log in as a Community member to see if you can upload your screenshots?

Best regards
Sabrina

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

Anonymous — Thu, 16 Oct 2014 13:19:23 GMT

Ok now i hope it's works
http://www.talendforge.org/forum/img/members/233700/mini_probleme.png