"the server failed to resume the transaction"

[Guest]

Hello CF Community!

Longtime lurker, first time poster.  Got a bit of a doozy and I can't seem to find useful info on it anywheres.

Running Coldfusion Standard version 9,0,0,251028 on Win Server 2008 (64-bit).  I have a data source connection to a MSSQL database running on the same machine - it's a SQL Server Express instance.  I'm also running Fusebox 5.5 framework.

Whilst attempting to do a simple CFQUERY with a single CFQUERYPARAM, I get an error from the JDBC Driver "the server failed to resume the transaction".  The line number is reported to be the line number containing the CFQUERYPARAM.  I found this with a simple search: 

http://blogs.msdn.com/b/jdbcteam/archive/2009/02/24/the-server-failed-to-resume-the-transaction-why....

but unfortunately this focuses on JDBC (which I don't know diddly squat about) and doesn't really suggest a resolution path for CF. 

Does anyone have any ideas about this one?

[goviatt]

Same problem with an upgrade to ColdFusion 9.0.2 from ColdFusion 8.  I suddenly have reports that throw this error.

I've found that these reports were using one query to generate data and a second to further process the data.  Combining the two CFQUERYs was the work around of choice. 

Not elegant programming.... but maybe a hint for someone else with a similar problem.

BEFORE:

<cfquery name="qCreateData" datasource="#dataSourceName#">

    { CALL sp_CreateData ( '#param1#','#param2#', '#param3#') }

</cfquery>

<cfquery name="getRptData" datasource="#dataSourceName#">

     select ...

       from tmpCreatedData

     where ...

</cfquery>

AFTER:

<cfquery name="getRptData" datasource="#dataSourceName#">

    { CALL sp_CreateData ( '#param1#','#param2#', '#param3#') }

     select ...

     from tmpCreatedData

     where ...

</cfquery>