Error: msg 7344. Level 16 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Error: msg 7344. Level 16

Author

Topic

GRAYWOLF
Posting Yak Master

106 Posts

Posted - 2009-01-14 : 03:20:16

I am getting this error:

Msg 7344, Level 16, State 1, Line 330
The OLE DB provider "SQLNCLI" for linked server "sqlserver1\sql" could not INSERT INTO table "[sqlserver1\sql].[GlobalDBAServer].[dbo].[Restores]" because of column "Server". The data value violated the integrity constraints for the column.

the column "Server" is varchar(100). what does it mean "The data value violated the integrity constraints for the column."?

---------------------------

Working until "the morning sun sets the midnight sky on fire"!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-14 : 03:24:08

One of two things probably

1) The column Server is a foreign key to another table (primary key)
-- You can't insert a record for a foreign key table where primary key is missing in primary key table

2) The column Server has a unique constraint
-- There is already a record with same value in Server column

E 12°55'05.63"
N 56°04'39.26"

GRAYWOLF
Posting Yak Master

106 Posts

Posted - 2009-01-14 : 03:32:17

It only fails on this particular server name. It is not a key. I do not know if it has to do with the \ in the server name, or something else. I think that is the only real difference compared to other server names other than length (this one is 4 characters longer).

---------------------------

Working until "the morning sun sets the midnight sky on fire"!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-14 : 03:34:41

also if you've check constraint on column and inserted value violates it, then also you will get similar error

GRAYWOLF
Posting Yak Master

106 Posts

Posted - 2009-01-14 : 03:34:49

There are only 3 columns in this table:

server varchar(100)
database varchar(50)
Restore_date datetime

---------------------------

Working until "the morning sun sets the midnight sky on fire"!

GRAYWOLF
Posting Yak Master

106 Posts

Posted - 2009-01-14 : 03:38:23

There are no constraints listed. I don't see any place to check it relative to the column, just a folder in the tree of the Object Explorer window.

---------------------------

Working until "the morning sun sets the midnight sky on fire"!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-14 : 04:02:43

Can you post the content of table "[sqlserver1\sql].[GlobalDBAServer].[dbo].[Restores]".
Also post the data for record you are trying to insert.

E 12°55'05.63"
N 56°04'39.26"

GRAYWOLF
Posting Yak Master

106 Posts

Posted - 2009-01-14 : 04:14:12

SERVERDB0AA dbaseAgent 2009-01-14 02:57:34.853
SERVERDSQL01 dbaseate 2009-01-14 02:57:40.680
SERVERL12 dbaseC 2009-01-14 02:57:45.760
SERVERSQL01 dbasetage 2009-01-14 02:57:46.977
SERVERDSQL01 dbasessage 2009-01-14 02:57:52.150
SERVERL12 dbaseonManager 2009-01-14 02:58:07.760
SERVERDSQL01 dbaseAdmin 2009-01-14 02:58:13.337
SERVERL04 dbaseares 2009-01-14 02:58:24.053
SERVERL04 dbaseares 2009-01-14 02:58:33.900
SERVERL04 dbaseares 2009-01-14 02:58:43.680
SERVERL04 dbaseares 2009-01-14 02:58:53.553

---------------------------

Working until "the morning sun sets the midnight sky on fire"!

GRAYWOLF
Posting Yak Master

106 Posts

Posted - 2009-01-14 : 04:17:02

Trying to insert:

SERVERb1c2\sql dbaseReporting

---------------------------

Working until "the morning sun sets the midnight sky on fire"!

GRAYWOLF
Posting Yak Master

106 Posts

Posted - 2009-01-14 : 05:28:08

It appears to have correct itself! Go figure!

Thanks guys

---------------------------

Working until "the morning sun sets the midnight sky on fire"!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources