SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Warning: Fatal error 602 while trying to delete from linked server


Warning: Fatal error 602 while trying to delete from linked server

Author
Message
Igor Marchenko
Igor Marchenko
SSC Eights!
SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)

Group: General Forum Members
Points: 819 Visits: 485
Hello!

This is not directly data corruption related post, but I am hoping someone is able to assist.

I was trying to troubleshoot problem with sp call that came done to 'Warning: Fatal error 602...' while trying to delete entry from table on linked server.

delete from SPRStrata.SBMSData.sro.MediaPlanAdMap_Staging

This is executed from SQL Servr 2005. Linked server is SQL 2000.

I create test table using schema sro.MediaPlanAdMap_Staging and was able to run DELETE against it. I have also verified permissions of the remote user linked server is using. Also, I can run UPDATE against SPRStrata.SBMSData.sro.MediaPlanAdMap_Staging table. The problem appears to be with DELETE statement only.
Table in question has identity and PK defined. SBMSData participates in replication.
Error log on linked server has following error:

Could not find row in sysindexes for database ID 5, object ID 86291367, index ID 0. Run DBCC CHECKTABLE on sysindexes..

I ran DBCC CHECKDB and verified sysindexes, but found no problems.
Any ideas what might be causing this fatal error?

Thanks,
Igor
Igor Marchenko
Igor Marchenko
SSC Eights!
SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)

Group: General Forum Members
Points: 819 Visits: 485
As strange as it might seems:


delete from SPRStrata.SBMSData.sro.MediaPlanAdMap_Staging - error

delete from SPRStrata.SBMSData.sro.MediaPlanAdMap_Staging where mediaplanid = mediaplanid - works, although logically similar to previous one (assuming there are no NULLs)

delete from SPRSTRATA.sbmsdata.sro.MediaPlanAdMap_Staging - works

insert into SprStrata.SBMSData.sro.MediaPlanAdMap_Staging ( MediaPlanId, AdId )
values ( 1, 1 ) - fails - 'The statement has been terminated.
Msg 16933, Level 16, State 1, Line 1
The cursor does not include the table being modified or the table is not updatable through the cursor.
'
insert into SprStrata.sbmsdata.sro.MediaPlanAdMap_Staging ( MediaPlanId, AdId )
values ( 1, 1 ) - works


It looks like that making database lowercase(d) make query works in all scenarious. That doesn't make much sense to me.

Igor
Paul Randal
Paul Randal
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8296 Visits: 1719
Is the linked server case sensitive?

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Igor Marchenko
Igor Marchenko
SSC Eights!
SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)SSC Eights! (819 reputation)

Group: General Forum Members
Points: 819 Visits: 485
It is not. Actually, you don't event have to make database name in lower case. DELETE FROM [SPRSTRATA].[SBMsdata].[sro].[MediaPlanAdMap_Staging] also works.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search