aspstate nesting transaction error ms sql error
I have the following error:
Invalid object name 'aspstate.dbo.ASPStateTempSessions'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous c开发者_高级运维ount = 238, current count = 239.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Does anyone have any idea how to fix this?
I found the cause of the exception: http://msmvps.com/blogs/greglow/archive/2007/02/04/improving-asp-net-session-state-database-performance-by-reducing-blocking.aspx
There are two errors
- Invalid object name 'aspstate.dbo.ASPStateTempSessions'.
- Transaction count after EXECUTE indicates a mismatching number of...
The mismatch of BEGIN/COMMIT is caused by a run-time compile failure because the table aspstate.dbo.ASPStateTempSessions is missing.
So an extra BEGIN was executed but it never got to the COMMIT.
If @@TRANCOUNT is 238, it could be that someone dropped the table after 238 executions
You have unclosed begin statments by the looks of it. Needs to be closed with a commit statment or End statement. Seems to be occusring on the other side of a webservice call that you're making
精彩评论