Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

cfstoredproc no longer returns results after CF11 update 5

I have several SQL Server 2008 stored procedures. I am calling them via cfstoredproc. After I run a CF server update on April 17th, CF does not get the results anymore. Here is one of the calls:

<cfstoredproc procedure="proc_xxxx" datasource="#application.dsn#" debug="yes" returnCode="yes">
<cfprocparam type="in" cfsqltype="cf_sql_integer"  dbvarname="@myID" value="#arguments.myID#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar"  dbvarname="@EmailAddr" value="#trim(arguments.emailAddress)#"  null="#not len(arguments.emailAddress)#">
<cfprocparam type="out" cfsqltype="cf_sql_integer" dbVarName="@NewUserID"  variable="newUserID" > 
<cfprocresult name="qryUser">   
</cfstoredproc>

<cfoutput>newUserID = #newUserID#</cfoutput>

I get a newUserID not defined error. Again, everything used to run fine prior to update 5.

If I call the stored procs in SSMS, everything works fine. The cfstoredproc works as I am seeing my updates and inserts on the database. However, it simply won't return any results back anymore. Return code is 0, as I mentioned everything runs without any errors.

I tried :

 <cfprocresult resultset="1" name="qryResult">

With no luck. Any ideas? Thanks in advance.

like image 961
CFNinja Avatar asked Apr 21 '15 16:04

CFNinja


1 Answers

After quite a few back and forth emails with Adobe support, they told me to uncheck : Enable Request Debugging Output in CF admin.

Once done, the parameter comes back as expected:

 <cfprocparam type="out" cfsqltype="cf_sql_integer" dbvarname="@NewUserID" variable="newUserID"  > 

Needless to say, we need the debug outputs on local and development servers. I don't believe this bug should be marked as fixed but I guess they are doing so.

Hope it helps someone else who runs into same issue.

EDIT on 1 May 2015 : There is a fix for this now.

  1. Download this hotfix file [ hf1100-3971083.jar ].
  2. Place this file at /cfusion/lib/updates folder.
  3. Restart ColdFusion application service.

Boom, it works!

like image 131
CFNinja Avatar answered Nov 14 '22 18:11

CFNinja