How do i solve foreign key constraint error

Question

0.00/5 (No votes)

See more:

I keep getting this error after inserting text with over 200 characters into my database. I ve tried everything. Can anyone help me please. i have two tables: roles and departments. the roles table has the departments primary key as a foreign key and i have set the relationship to allow for this. I have tried not to enforce foreign key constraints but the problem still persists. The thing is that when i enter about a line or two of text it works fine but with large text it pops up the error below. Both the primary keys of the two tables are int.

System.Data.ConstraintExceptoin: Failed to enable constraints. One or more rows contain values violating non-null, unique or foreign-key constraints

Posted 13-Apr-11 7:22am

Member 7250221

Updated 13-Apr-11 8:01am

v3

Add a Solution

Comments

Kschuler 13-Apr-11 13:45pm

You need to post more information if you want any help on this. How is your table setup? What columns are keys? You said you've tried everything, well what have you tried and how/why didn't it work? What does the data look like that you are trying to add?

[no name] 13-Apr-11 14:01pm

i ve updated

pankajupadhyay29 13-Apr-11 13:49pm

[Edit]added tag for sql server[/Edit]

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2011-04-13T07:52:00

Solution 1

IMO, if you are getting this error, something is wrong with your data.
You can handle the error in your code, and step out of the code gracefully.

However, you should be looking at ways to correct this erroneous data rather than fix the error.
The entire concept behind the foreign key concept is to prevent wrong data from going into the database and corrupting it.

Posted 13-Apr-11 7:52am

Abhinav S

Comments

Manfred Rudolf Bihy 13-Apr-11 18:19pm

Good answer! 5+

Abhinav S 14-Apr-11 1:00am

Thank you.

wizardzz · Answer 2 · 2011-04-13T11:08:00

Solution 2

I'm going out on a limb here:

Perhaps that column that is a long string is getting truncated by the database column. For example

These 2 unique strings:

aaaaaaaaaaaaaaaaaaaabbbbbb

and

aaaaaaaaaaaaaaaaaaaacccccc

would be non unique if stored into a char(10). Thus breaking a key constraint if one is dependent on this column.

Posted 13-Apr-11 11:08am

wizardzz

v2

Comments

Manfred Rudolf Bihy 13-Apr-11 18:20pm

Interesting idea! Deserves a 5+

Rahul_Mukherjee · Answer 3 · 2011-04-13T18:25:00

if u r geting this error then two case may arise :
1st is that the data that u r going to store is wrong.
second the value or data that u r going to store didn't present in the primary key column of another table which u r refering,

so, at first try to insert data at first in primary key then in foreign key.....

or

before inserting use trim() method.... to trim the unwanted space...

How do i solve foreign key constraint error

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us