547 is the error code used for any constraint violation, not just foreign keys, e.g.: create table T ( ID int not null, constraint CK_Not1 CHECK (ID != 1) ) go insert into T (ID) values (2) go update T set ID = 1 (1 row(s) affected) Msg 547, Level 16, State 0, Line 1 The UPDATE statement conflicted with the CHECK constraint CK_Not1.
Symptoms. When you update the primary key column of the primary key table in Microsoft SQL Server 2005 by changing the case of the existing column values or by padding column values, you receive the following error message: Msg 547, Level 16, State 0, Line 1.
3/10/2003 · Parasolid® Kernel Interface Error PK error code 547- non manifold body or boundry What the heck does that mean?, ERROR 547 The INSERT statement conflicted with the CHECK constraint CK__PostCode__Code__44FF419A . The conflict occurred in database contact s , table dbo . PostCode , column ‘Code’ .
7/21/2016 · This parameter is configurable in the profile of the Distribution Agent and has as input the error number we may want to skip. The following picture shows an error (with code 547 related to an Foreign Key issue) in the Distribution Agent process and we see how the transactions are being queued due to this error, consequently, there is a need to fix it so as to allow the rest of pending transactions.
2/6/2015 · I have had this happen with solid created in MC, as well as from imported. We use Solid Edge for our cad, which also is kept up to date. Though as you probably know, most parts libraries are Solid Works, and sometimes I use these as well.
