Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
koushikchandra
Starting Member
24 Posts |
 Posted - 2011-08-18 : 08:57:15
|
| Hi,We are getting the following error messages in our production system for last two days :Executing the query "exec prL2MapCustPositionStatusDaily" failed with the following error: "Location: "xact.cpp":4362 Expression: !m_parNestedXactCnt SPID: 58 Process ID: 4412 Description: Trying to use the transaction while there are 1 parallel nested xacts outstanding". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Now from the resource point of view there are 48 CPU and 80 GB memory available in the server and the setting for Degree of Parallelism is 8. So can you please let me know what can be reason for this failure and how should we overcome from this?Regards,Koushik Chandra |
|
|
koushikchandra
Starting Member
24 Posts |
Posted - 2011-08-18 : 09:15:47
|
| Please also find below the version of our SQL Server :Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) Regards,Koushik Chandra |
 |
|
|
Sachin.Nand
2937 Posts |
|
|
|
|
|
parallel nested xacts outstanding