REPOST: Weird pcode error (please! help!)

Can *anyone* shed any light on this? Please? ======================== Help! Sometime yesterday around 19:49, my CF Server started throwing pcode errors by the hundreds, like this: unknown exception condition PCodeRuntimeContextImp::setVariableThe error occurred while processing an element with a general identifier of (CFSCHEDULE), occupying document position (3:1) to (5:13).Date/Time: 02/11/01 21:51:28Browser: Remote Address: Template: C:\CFUSION\Scripts\cfexectask.cfmQuery String: TASK=check for db upload (all of them in cfschedule processing) .....and right about the same time, this simple piece of code: <CFQUERY NAME="Getcarbrands" DATASOURCE="dsn">   SELECT distinct Merk FROM Cars </CFQUERY> <SELECT name="Merk">   <CFOUTPUT QUERY="Getcarbrands">   <OPTION VALUE="#Merk#">#Merk#</OPTION>   </cfoutput> </SELECT> started throwing this exception: QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (270:1) to (270:31) I have ab-so-lu-te-ly no idea why this happened, and a simple cycle of CF apparently took care of the problem. Any ideas why this would happen? It *is* one of our only remaining CF 4.0.1 servers, but it has plenty RAM & HD and it has been running for some time without that particular problem ever cropping up before. Michel Vuijlsteke Netpoint NV ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Need to put in a dbtype. ODBC OLE ... Joshua Tipton Can *anyone* shed any light on this? Please? ======================== Help! Sometime yesterday around 19:49, my CF Server started throwing pcode errors by the hundreds, like this: unknown exception condition PCodeRuntimeContextImp::setVariableThe error occurred while processing an element with a general identifier of (CFSCHEDULE), occupying document position (3:1) to (5:13).Date/Time: 02/11/01 21:51:28Browser: Remote Address: Template: C:\CFUSION\Scripts\cfexectask.cfmQuery String: TASK=check for db upload (all of them in cfschedule processing) ......and right about the same time, this simple piece of code: <CFQUERY NAME="Getcarbrands" DATASOURCE="dsn">   SELECT distinct Merk FROM Cars </CFQUERY> <SELECT name="Merk">   <CFOUTPUT QUERY="Getcarbrands">   <OPTION VALUE="#Merk#">#Merk#</OPTION>   </cfoutput> </SELECT> started throwing this exception: QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (270:1) to (270:31) I have ab-so-lu-te-ly no idea why this happened, and a simple cycle of CF apparently took care of the problem. Any ideas why this would happen? It *is* one of our only remaining CF 4.0.1 servers, but it has plenty RAM & HD and it has been running for some time without that particular problem ever cropping up before. Michel Vuijlsteke Netpoint NV ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Like I mentioned before the problem is probably your odbc drivers. -The problem can be your odbc drivers, cfhttp or cf being generally knackered. There is a knowledgebase article on allaire somewhere. "Michel Vuijlsteke" <michel@netpoint.be> wrote in message news:C1D682247E13D2119859008048EC6D07749155@jeeves.impakt.netpoint.be... > Can *anyone* shed any light on this? Please? > > ======================== > Help! > > Sometime yesterday around 19:49, my CF Server started throwing pcode errors ----- Excess quoted text cut - see Original Post for more ----- of > (CFOUTPUT), occupying document position (270:1) to (270:31) > > I have ab-so-lu-te-ly no idea why this happened, and a simple cycle of CF > apparently took care of the problem. > > Any ideas why this would happen? It *is* one of our only remaining CF 4.0.1 > servers, but it has plenty RAM & HD and it has been running for some time > without that particular problem ever cropping up before. > > Michel Vuijlsteke > Netpoint NV > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Really? Can anyone confirm that not putting a dbtype in <cfquery> causes <cfschedule> to throw PCode exceptions? ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Never has for us! David Michel Vuijlsteke wrote: ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Hi, are you doing something like <cfif myVar EQ ""> in your cfexectask.cfm? This is known to generate PCode errors sometimes. (Could even be that the CFSCHEDULE has nothing to do with the error at all, although it is mentioned in the error msg!) And for the "unknown query" ... maybe the crashing template uses the same datasource and when it crashes the datasource is locked? Just guessing though, hard to say without more details... HTH, Chris ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Course not. <Sigh> I'll just lump his together with the rest of the bloody ColdFusion bugs that no-one has any idea how to work around or avoid. Am I the only one who's getting disillusioned in a major way here? Michel ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

I know it's hard without more details. And that's exactly what stumps anyone trying to make sense of this. Even with all the details at hand and with three years' worth of heavy-duty ColdFusion experience I can't make heads or tails of it. To answer your questions: no, I don't do <cfif myVar EQ "">. If I need to do something like that I usually go for <cfif len(trim(myVar))>, but usually I make things so that I can do <cfif isdefined("myVar")>. The crashing template that generates PCode errors has nothing to do with datasources. It *is* a tmeplate that does cfhttp though. need i say more? Didn't think so. Bah. Michel Vuijlsteke Managing Director Netpoint NV ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm