How to solve violation of PRIMARY KEY constraint 'PK_teacher'. Cannot insert duplicate key in object 'dbo.teacher' on NIOS registration site?

Question

1.00/5 (1 vote)

See more:

[SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_Teacher'. Cannot insert duplicate key in object 'dbo.Teacher'.
The statement has been terminated.]
DBAccess.DB.ExecuteSQL(String Sql) in C:\NIOS_DElEd_Bridge\DBAccess\DB.cs:106
NIOS.DElEd.Teacher.RegForm.Submit_Clicked(Object sender, EventArgs e) in C:\NIOS_DElEd_Bridge\NIOS_DElEd_Bridge\Teacher\RegForm.aspx.cs:601
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

What I have tried:

I have tried nothing yet. Emergency here.

Posted 17-Oct-17 7:58am

Member 13470606

Updated 20-Jul-23 6:00am

Add a Solution

Comments

A_Griffin 17-Oct-17 14:11pm

The error is pretty clear. You are trying to insert a record with primary key value that already exists in the database.

2 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)

ZurdoDev · Answer 1 · 2017-10-17T08:30:00

Solution 1

As mentioned in the comments, the error is telling you exactly what the problem is. You are trying to insert a value into Teacher table primary key field that already exists.

Posted 17-Oct-17 8:30am

ZurdoDev

Wendelius · Answer 2 · 2017-10-17T08:32:00

As the error says, you're trying to insert a record to the table with a key value already existing in the table.

The first thing to do is to have a look at the primary key definition. Open up SSMS and navigate to your table in your database. Expand the keys node and you should see the PK_Teacher. Right click it and select modify. This brings you to design window where you see the definition for your key.

Now check if the key is what you expect it to be. If it's a natural key, for example name, then you need to provide other information when inserting the data or alter the key to contain desired columns. If the key is an identity column it shouldn't cause duplicates unless someone has reseeded the counter. In such case reseeding the counter to last existing value should fix the problem.

But to be honest, it would help a lot to see the table definition so if you need more detailed information, please update the question to contain the script for the table.