Problem: "The server failed to resume the transaction."?

See more:

C#

ASP.NET

SQL

Hi,
I have online store (solution: ASPDOTNETSTOREFRONT). For a show product site, this solution use xml document (name.xml.config). In this document is the code for displaying different views of product (if product have variants, if product in campaign, if is simple product...).

At the beginning is code for the SQL query (calling procedures, classic queries...). Here is an example:

<query name="Product" rowElementName="Cooperation" runif="showproduct">
  <sql>
    <![CDATA[
    exec dbo.aspdnsf_Cooperation @CustomerID, @ProductID

  </sql>
  <queryparam paramname="@ProductID"       paramtype="request" requestparamname="ProductID"       sqlDataType="int" defvalue="0"  validationpattern="" />
  <queryparam paramname="@CustomerID"       paramtype="system" requestparamname="CustomerID"       sqlDataType="int" defvalue="0"  validationpattern="" />
</query>

When is a lot of views of products, the server throws an exception:

The server failed to resume the transaction. Desc:3900006391.

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. 

Exception Details: System.Data.SqlClient.SqlException: The server failed to resume the transaction. Desc:3900006391.

I tried very much to find a solution, but none was successful. It is problem in code or SQL server? Code for calling procedures is avbove. It looks as the query is not finalized. Is this possible in procedures? Or it is the problem with the server? I know that the dataset be closed (c#), but here is the xml code (there datasets doesnt exist)...

All ideas are welcome, because the problem is hopeless.

Thanks!