aspstate嵌套事务错误ms sql错误
我有以下错误：
Invalid object name 'aspstate.dbo.ASPStateTempSessions'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 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.
有人知道如何解决这个问题吗？
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 count = 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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
从外观上看，您已经打开了开始语句。需要用 commit 语句或 End 语句关闭。似乎发生在您正在进行的网络服务调用的另一端
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
有两个错误
BEGIN/COMMIT 的不匹配是由运行时编译失败引起的，因为缺少表 aspstate.dbo.ASPStateTempSessions。
因此执行了一个额外的 BEGIN 但它从未到达 COMMIT。
如果 @@TRANCOUNT 是 238，则可能有人在 238 次执行后删除了该表
There are two errors
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