Remote stored procedure throwing zombie state error

Vote count:

0

I have a stored procedure that is called from a .NET MVC application that calls a remote procedure on our database server. I'd seen this error pop up interminably previously but the last week or so I'm getting this error several times a day.

Cannot execute the query "SELECT 1 FROM "xdb"."yyy"."session" "Tbl1011" WHERE ?=? AND "Tbl1011"."SessionID"=? AND ?="Tbl1011"."SelectId"" against OLE DB provider "SQLNCLI11" for linked server "iis". The OLE DB provider "SQLNCLI11" for linked server "iis" reported an error. The provider reported an unexpected catastrophic failure. OLE DB provider "SQLNCLI11" for linked server "iis" 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

I've tried the following but none of these resolve the issue:

1. Swapped views out for full remote path to tables back to webserver (the proc acccesses a few tables on the webserver)


2. I had a CTE loop that i swapped out for a simple update.

It's very strange because I thought that it was something on the .NET side causing the error, but if it pops up I've been recalling the proc using the same params the MVC app passed in directly in SQL and I'm getting it through SQL as well. The issue seems to resolve after a few minutes and it seems to be locked to that specific call to the proc (with same params that is)....

All the references to this particular error I can find are in regards to a transaction, which the proc does not use at all... any help would be appreciated!

asked 27 secs ago

zach

117

Remote stored procedure throwing zombie state error