Linked Server Error

I am getting below error while running select query.

OLE DB provider "SQLNCLI11" for linked server "scandfw1" returned message "The object is in a zombie state. An object may enter a zombie state when either ITransaction::Commit or ITransaction::Abort is called, or when a storage object was created and not yet released.".
Msg 7399, Level 16, State 1, Line 4
The OLE DB provider "SQLNCLI11" for linked server "scandfw1" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7320, Level 16, State 2, Line 4
VijayAsked:
Who is Participating?
 
ManjuConnect With a Mentor IT - Project ManagerCommented:
Check in the Performance tab if  'Enable pre-fetch of data for queries' is checked.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You should provide the code for better understanding.
I guess you're working with transactions and for some reason a rollback occurred and your SELECT is trying to access something that doesn't exist anymore.
0
 
VijayAuthor Commented:
Hi Vitor,

Please find the code here.
select distinct * from (
select a.DCName, a.GroupID, a.GroupName,a.OracleID,a.IsActive,format(a.ArchiveCount,'###,###') ArchiveCount,round(a.msgsizeGB,3) msgsizeGB,a.SearchType, a.MigratedFrom,  a.Status, Success, Pending, In_Progress, Error
from dbo.migration_tracker a 
where
a.Status <>'Completed' and a.status is not null
--and  a.isactive=1,
and a.groupid in (select GroupID from database12.[dbo].[ELS_DELATA_GROUPS])
and a.archiveCount is not null
and a.SearchType='Legacy'
and a.groupid  in (select distinct v. groupid from database12.dbo.vw_blobdirectoryqueue v union
select distinct v. groupid from scanels2.database12.dbo.vw_blobdirectoryqueue v union
select distinct v. groupid from scandfw1.database12.dbo.vw_blobdirectoryqueue v union
select distinct v. groupid from scandfw2.database12.dbo.vw_blobdirectoryqueue v )) c
where C.DCName='ELS'
order by msgsizeGB desc;

Open in new window

0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You're selecting data from at least 4 different databases. Is this code running inside a transaction?
0
 
VijayConnect With a Mentor Author Commented:
Just i am running from SSMS manually.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It's very hard to analyze from here, without having access to your databases.
We can't see what's happening in other databases when you're running this query.
I suggest you to remove the UNION selects and add them one by one to see if the issue is related only to one of those remote databases. Then you can focus only on that database so you can troubleshoot better.
0
 
VijayAuthor Commented:
Thank you Manju.
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.