Error invoking CFC

For the life of me I can't figure out how to stop this error. Sometimes when I call the page that invokes the CFC, It gives an error: "Error invoking CFC ".  It does not happen all time though. 8 times out of ten it will load fine, then throw the error every once an a while. It's almost like the framework is sleeping, and can't load things quick enough before an error is thrown. I'm on a VPS.  Any suggestions appreciated, I'm out of ideas. -Jeff

More on this... Ok, more on this.  I'm using CFSelect and binding to this cfc.   <cfselect name="model" id="model"        value="model"       display="model"      bind="cfc:model.getdata.getmodels()"   class="input"   multiple="no"   bindonload="true"  /> Is there any odd issues with binding in a CFC?? jeff ----- Excess quoted text cut - see Original Post for more -----

Is that it for the error?  Any other details to go by? Did you check the log file to see if there were any other details? G On Thu, Nov 20, 2008 at 5:15 PM, Jeff F <cftalk_list@fongemie.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

>Is that it for the error?  Any other details to go by? Did you check the log >file to see if there were any other details? The complete error is: "Error invoking CFC /model/getfitmentdata.cfc : Internal Server Error [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]" Not much more help. I'll check the logs now.

Add cfdebug to your URL parameter and it will pop up the AJAX debugger. On Thu, Nov 20, 2008 at 5:51 PM, Jeff F <cftalk_list@fongemie.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

>Add cfdebug to your URL parameter and it will pop up the AJAX debugger. > >On Thu, Nov 20, 2008 at 5:51 PM, Jeff F <cftalk_list@fongemie.com> wrote: > >> Logs don't help. They just point to that getmodels.cfc. I'm wondering if my cfc is at fault. It's querying a rather large table. Possibly taking too long?? I'm going to add  CachedWithin="#CreateTimeSpan(1,0,0,0)#" to see if that helps. <cffunction name="getmodels" access="remote" returnType="query">       <cfset var data="">       <cfquery name="data" datasource="#THIS.dsn#" >          SELECT distinct model           FROM #THIS.table#          WHERE approved = <cfqueryPARAM value = "Y"    CFSQLType = "CF_SQL_VARCHAR">       ORDER BY model       </cfquery>       <cfreturn data>    </cffunction>

For the moment, it seems caching that query helped. I'm not getting any errors. I wish I'd seen that earlier. Thanks for your help G.. -Jeff ----- Excess quoted text cut - see Original Post for more -----        > <cfset var data=""> >       <cfquery name="data" datasource="#THIS.dsn#" >          > SELECT distinct model            > FROM #THIS.table#          > WHERE approved = <cfqueryPARAM value = "Y"    > CFSQLType = "CF_SQL_VARCHAR">        > ORDER BY model        > </cfquery>        > <cfreturn data>    > </cffunction>