Row handle referred to a deleted row or a row marked for deletion.

HI, I am working with linked servers and getting the error "Row handle referred to a deleted row or a row marked for deletion." Actually, the full error is
OLE DB provider "SQLNCLI10" for linked server "..." returned message "Row handle referred to a deleted row or a row marked for deletion.". [SQLSTATE 01000] (Error 7412).  The step failed.
So my destination server is failing with that error. The step it's failing on is a stored procedure on the "source" server that carries out many updates , inserts and deletes on the destination server. I am not getting this error all the time but often enough. What does this error mean and how can I resolve it?

Thank you.
LVL 1
AlizaNAsked:
Who is Participating?
 
lcohanDatabase AnalystCommented:
Considering the comments:

"The step it's failing on is a stored procedure on the "source" server that carries out many updates , inserts and deletes on the destination server."

In my opinion the issue you are having is caused by a slow "source" environment and from the little details posted above I suggest to lower the batch size you process in one cycle. Other thing to do at both source and destination - at least UPDATE SATTISTICS table_name for all tables having heavy INSERTs/DELETs and optimize as much as you can the SQL code, add missing (if any) indexes.
0
 
revteamCommented:
Need to check the dependent triggers or function on the tables
0
 
AlizaNAuthor Commented:
Check them for what?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.