A few suggestions from someone who suffered from this ailment and somehow got it resolved :)
1. create a temp table with the same data and then query the temp table. This will eliminate issues with other user locking the main table. 2. change the query to a stored procedure. SPs do run much faster and also some how (don't ask me how other than expediting the total query and thus reducing deadlocking issues), help with the PCodeRuntimeContextImp errors in CF. 3. Lastly, if you are using application or session variables in CF 4, 4.5, or 5: MAKE SURE YOU ARE LOCKING THEM PROPERLY. I found this was the single biggest reason for these types of errors. Specially in Application.cfm. If you have one of these scope vars not properly locked (or using the wrong lock such as an app var being locked with a session scope or vice versa) then these errors will be A LOT more frequent. This link may be of help to you as well: http://www.macromedia.com/support/coldfusion/ts/documents/tn18234.htm btw... in my experience, neither cferror nor cfcatch will catch these errors. HTH Andres -----Original Message----- From: Buddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 1:25 PM To: CF-Talk Subject: PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag Okay so I have been handed a problem resulting from code that someone else wrote, I'm sure some of you can sympathize. Hopefully some of you might also have some advice. We run a report every month, this month it is much bigger then usual. Normally it takes a while to do, but never has any errors, this month it is taking a while then erroring out. The file in question does a big query on the main database, then does a bunch of queries of a query based on the original query. The main query looks like this: <cfquery name="SELECTMASTERDATA" datasource="blah" dbtype="ODBC" username="blah" password="blah">Select SIGNUPS, TDATE, SITEID,WMID from DATA WHERE TDATE> #CreateODBCDateTime(MASTERLASTPAY)# and TDATE<= #CreateODBCDateTime(ENDDATE)# and signups > 0</cfquery> Simple, no problems there. Here is the error: unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (116:4) to (116:51) in the template file E:\blah\blah Line 116 where the error resides looks like this: <cfquery name="SELECTSIGNUPDATA" dbtype="query">Select SIGNUPS from SELECTMASTERDATA WHERE ((TDATE>'#STARTDATE#') and (TDATE<= '#ENDDATE2#') and (WMID='#ID#'))</cfquery> Again, nothing seems wrong here. The thing that troubles me is that it will process a ton of rows and then seemingly error out at random, one time on the 500th row and the 750th the next time. And I think it might have something to do with the load on the box at the time. I have seen that error referenced in regards to q of q, but a lot of the problems people are having seem to have to do with locking, and I don't have anything to lock, so I don't think that is it. Any advice would be greatly appreciated. -Buddy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
