• Register
Welcome to Kodlogs Q&A, programming questions and answer website.

Most popular tags

java program python php javascript android c# r mysql spring c spring-boot eclipse arrays ggplot2 python-3 exception tomcat sql-server numpy jdbc windows string html hibernate ssl sockets x keytool python-2 pandas sql 7 asp net java-8 intellij-idea ssl-certificate entity-framework macos minecraft ios csv facebook security json list class spring-mvc heap-memory reactjs for-loop scikit-learn winforms glmnet webpack illegalstateexception matlab redirect code program junit pip django maven docker ubuntu typeerror linux loops node math datetime js jquery cryptography loop int import https laravel-5 tsql unity3d fatal-error struts java-applet pytorch runtime-error conda visual-studio apache-spark pyspark garbage-collection amazon-web-services sql-server-2005 quirks-mode internet-explorer-9 internet-explorer reporting-services anova machine-learning keras indentation-error laravel unit-testing android-studio jupyter-notebook orm qt virtualenv webclient prediction visual-studio-2010 compiler-errors numpy-ndarray postgresql curl vagrant aspnet reporting dataframe nullpointerexception javafx tensorflow jsp jpa wordpress servlet indentation xcode scanner sum github deployment socketexception git certificate css util oracle cmd recursion search tcp syntax connection float httpwebrequest dictionary database main function number file html5 functional-dependencies mysql-error-1064 node-sass gulp-sass archlinux sass data-science spring-batch psycopg2 backpropagation texture2d async-await net-mvc-4 google-calendar pdo ruby-on-rails-4 ruby-on-rails dbmigrate wp-mail github-for-windows facebook-android-sdk jsx xcb microsoft-metro react-router spring-data-jpa softmax elastic-beanstalk google-sheets-api google-spreadsheet-api cnf minidump xuggler acumatica gitlab elasticsearch-5 elasticsearch app-transport-security ios10 ios9 cdn cloudflare wampserver plpgsql aptitude salt-stack sysv parent-child android-edittext textview visual-studio-2012 android-workmanager unique-index unity2d electron theano maven-compiler-plugin pickle assetbundle rstudio bar-chart python-tesseract tomcat6 primefaces solr easymock jvm-crash tomcat7 apache-httpclient-4 web-services woodstox discord jersey-2 prepared-statement resultset sencha-cmd sencha-touch-2 sencha-touch powermock fips apex x509certificate ibm-bpm websphere-7 file-permissions file-io accesscontrolexception grizzly atmosphere slick2d lwjgl informetica twitter-bootstrap-3 jax-rs resteasy spring-security-kerberos spring-security kerberos long-integer mapnik git-review vpython continuation homebrew xgboost android-asynctask stack-trace user-interface jaxws-maven-plugin maven-3 maven-2 browser-notsupportedexception google-maps-api-3 google-maps visual-studio-code truststore firebase-authentication aws-organizations php-7 string-formatting cplusplus visual-studio-2015 net-core net-mvc msbuild extension-methods foreign-keys windows-services react-redux inputstream facebook-graph-api entity-framework-4 reportingservices-2005 mips linear-regression deep-learning block-device melt reshape2 floating-point webpack-dev-server javascrip 0-lollipop android-5 statsmodels avx eclipseide javafx-2 php-not-recognized command-line phpmyadmin tinyurl classnotfoundexception atom-editor android-emulator android-sdk-tools ionic2 cordova foobar2k tcplistener net-2 net-4 ole-db-provider export-to-excel openrowset windows-10 vagrantfile jvm-arguments global-variables autopostback classformatexception eof upstart ipv4 graphviz pydot atom curses unityeditor pandoc tesseract xls oledb redux spotify cxf wamp nio stacked headless typescript hyperlink outlook jackson keystore applicationcontext pipeline iis jstl encryption perfect-square objective-c carthage xcode8 indexing standard-deviation apt sudo xampp connector apple mdf kubernetes destructor gettime arithmeticexception gmail mix probability ioexception heuristics milliseconds disk angular cpu npm modx-revolution goldsky modx prevnext javascript-dictionary stack-smashing device-monitor radio-button android-actionbaractivity android-activity android-fragments java-long unqualified-id ora-12154 javc c++ java nullpointerexception runtime-error drjava awt-eventqueue dsx math-pow ajquery nosuchelementexception appcompatactivity jsf jtextfield awt jpanel thymeleaf inputmismatchexception glassfish deque anaconda jupyter flask lvalue gradle servlets netbeans simulation ibm factorial javax apache arduino boot opengl virtualbox jvm margins 2147483647 mongodb cloud firebase plot plugins processor automation crash card repository installer pointers editor concatenation formatting debugging devices module testing color arraylist sequence nested date caching expected build response ip directory algorithms release collections print figure casting url expression validation integer microsoft sorting sort read logging types replace rest 4 email ajax exe excel message required text variable time size dll system files table runtime static random code web map http error version 0 2 my
0 votes
12 views

Problem:

I have following table and i get message 'the insert statement conflicted with the foreign key same table constraint'

EMPID

EMPNAME

DESIGNATION

MANAGERID

101

James

Manager

1

102

Rabin

Group Lead

2

103

Suresh Jana

Group Lead

3

 INSERT INTO [dbo].[tbl_EMPLOYEEMASTER]
       (EMPID, EMPNAME, DESIGNATION, MANAGERID)
VALUES (103, 'Sukamal Jana', 'Group Lead', 4);     

GO

Msg 547, Level 16, State 0, Line 1

The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_MANAGERID_tbl_EMPLOYEEMASTER". The conflict occurred in database "PRACTICE_DB", table "dbo.tbl_EMPLOYEEMASTER", column 'EMPID'.

The statement has been terminated.

by (410 points)  

1 Answer

0 votes

Solution:

This looks like  you are inserting a value in the child table whereas the  parent table value does not exist.

When you insert a value in foreign key column , it must be null or point to existing reference to a row in the other table.

 Foreign key always refers to the another column of same table.

  Correct Inserts

   INSERT INTO [dbo].[tbl_EMPLOYEEMASTER]

       (EMPID, EMPNAME, DESIGNATION, MANAGERID)

      VALUES (101, 'Sudip Das', 'Manager', 1);

        GO

  CONCLUSION:

Manager ID 4 was not present in the table was the cause of error.

by (5k points)  
...