Subsonic stored procedure call timing out

subsonic

I am experiencing weird behavior when trying to call a stored procedure using subsonic from a website. I am getting "time out expired" error when I call the stored procedure using subsonic. If I execute the same stored procedure in sql server management studio, it runs instantly. I am not knowing what the problem is. I cannot step into the code because it is referenced as a dll. I am using version 2.1. Please let me know if you have any ideas.

Thanks,
sridhar.

Best Answer

It is my fault. I have a transaction open in the sql server management studio. Then I ran an update statement on a table. All the records affected by that update statement are locked because of transaction. it is working for some employees because those records are not locked. I ran the sp_who2 to determine the locked processes and figured out the problem.

Thanks, sridhar.

Related Solutions

R – How to execute SubSonic3 StoredProcedure with return value

I copied your sproc and stepped through the SubSonic code and .Output is never set anywhere. A work around would be using an output parameter and referring to it after executing: sproc.OutputValues[0];

R – Subsonic 3.0.0.3 not generating parameters for stored procedures

I had the same issue, and I had to tweak the SQLServer.ttinclude to get it working. Inside that file find the GetSPParams() method and change one line:

from

string[] restrictions = new string[4] { DatabaseName, null, spName, null };

string[] restrictions = new string[3] { null, null, spName };

BlackMael's answer has a helpful link that helped me figure out how to debug and step through the template code.

Now I'm not 100% sure yet that my change is a good one (there may be some adverse effects). I just haven't had a chance to test it thoroughly and need to read up some more on Restrictions as they pertain to the GetSchema() method. But for now, that solved my problem and I can successfully pass in my stored proc parameter.

Update: This may have something to do with the fact that my DB file is embedded in the VS solutin in App_Data. Perhaps this works better out of the box with a stand-alone SQL Server instance.

Best Answer

Related Solutions

R – How to execute SubSonic3 StoredProcedure with return value

R – Subsonic 3.0.0.3 not generating parameters for stored procedures

Related Topic