Post reply

Error from an SQL job once we migrated to sql 2008 R2

  • May 27, 2011 at 11:10 am

    #251674

    I have a job scheduled on srvr2 that calls a stored proc

    The stored proc pulls in some data from srvr1 (using linked server) and does some update on tables on srvr2. The jobs works fine but now and then we get the following error.

    Executed as user: Cannot get the data of the row from the OLE DB provider "SQLNCLI10" for linked server "DATA2LINK". [SQLSTATE 42000] (Error 7346) OLE DB provider "SQLNCLI10" for linked server "DATA2LINK" returned message "Row handle referred to a deleted row or a row marked for deletion.". [SQLSTATE 01000] (Error 7412). The step failed.

    All the tables involved in the query have primary keys.

    Any help wpuld be greatly appreciated.

    Thanks

  • May 27, 2011 at 11:22 am

    #1331140

    It sounds like a data set was read into memory to pull across the linked server but during the job run a record was deleted from the table. Have you checked for conflicting jobs or activity that might be deleting records during this job run?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 27, 2011 at 1:30 pm

    #1331210

    THanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply