The UPDATE statement conflicted with the FOREIGN K... - Qlik Community

_AnonymousUser · ‎2014-10-15

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.

Anonymous · ‎2014-10-16

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

_AnonymousUser · ‎2014-10-16

here

_AnonymousUser · ‎2014-10-16

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

Anonymous · ‎2014-10-16

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

Anonymous · ‎2014-10-16

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

The UPDATE statement conflicted with the FOREIGN KEY constraint

Big Data

v5.x