Thank you! I tried that fix last month and it worked! I'll share the news with my team. Thanks again for the follow up. Jason Seminara -=-=-=-=-=-=-=-=-=-=-=-=- Web Developer Adobe Certified Coldfusion Developer Adobe Certified Flash Developer Information Technology & Support IS/Internet Communications Church Pension Group http://www.cpg.org (212) 592-6277 ... View more

"The best things in life are free" - some blonde said that, right? ... View more

Jose, In addition to this, ColdFusion 9 has implemented a 100 maxrow default for query select statements.  In order to override this you can set the maxrows value manually or you can set the value to -1.  The -1 value selects an unlimited number of results.  This isn't documented everywhere but it is a feature in ColdFusion 9. Sincerely, Braden Lake ... View more

Hey Charlie, Thanks for your responses. I didn't originally have questions about the missing Visual Query Builder (I've always been on a Mac), but your links did point out some really neat and interesting tools which I didn't know about. I just tried out Ray Camden's web-based "Database Explorer" which you link to in your CF411 column. This one is very cool! As for the two Eclipse plug-ins you mentioned, I haven't tried them out myself. I'd have to make sure I can get them to work with SQL Server before going anywhere with them. It appears you can with some additional configuration. Personally, the RDS Query Viewer is pretty good enough for the queries I need to run. I do have some complaints about it, but I think I'll create a separate thread for them. ... View more

Good to hear. BTW, I realized after writing that I missed something: when using the context menu key (if available on one's keyboard), there's no need to go to the synchronize>synchronize then enter. One can just go synchronize>upload. One less keystroke. Curiously, I notice that when I do that, in the console view, it shows the tool doing a list of all the files in the root of the FTP site (even if I'm uploading a file in a subdirectory). That's odd. /charlie ... View more

I concur. Beta 2 is much slower then Beta 1. And the longer you leave builder open the slower it becomes. It behaves like it has a memory leak or is consuming 100% of the cpu. But checking the Activity Monitor on my 64 bit Mac does not indicate a problem (about 2 gigs of free ram and only 5% of processor used). Running it on my 64 bit Vista PC is all but impossible  (about 2 gigs of free ram and only 5% of processor used). I really like the feature set of CFBuilder, but unless the performance issue is fixed it might as well be vaporware. Been waiting since 2001 for a new CF IDE, guess for now I'll continue using Coda on my Mac and HomeSite on my PC. ... View more

I think I'm just going to keep replying to this thread to see how skinny the column of text can get 😉 -- Adam ... View more

If you install AutoHotKey (free), you can add the following shortcuts (from Gist), ColdFusion Builder 2016 should more closely emulate HomeSite where it can. http://www.autohotkey.com/ HomeSite and ColdFusion Studio AutoHotKey Shortcuts for ColdFusion Builder 2016 https://gist.github.com/JamoCA/bb5ea4dcc3b06f3d35fc1426d3d5b105 ... View more

Oh, it always goes to the right thread. If (when you reply) you look at the TO address, it will be an alpha/num value: in this case, clearspace-1653323719-3316-2-2160993@mail.forums.adobe.com. So my point wasn't about concerns over things going to "the right thread". Rather, it's that when they DO get to the thread, there's no representation in the thread about which message it was responding to, no hierarchy view option. Worse, even if one leaves some text from the email being replied to (when replying via email), the forum system strips it. That's just annoying (trying to solve the problem of people never cutting out what they're replying to, by not letting someone keep even a snippet, is just short-sighted, given this problem of not seeing any hierarchy.) Anyway, moving on. Fair point about your wanting to be able to do the remote start/stop. I was just saying: not everyone would want to, so if they don't, they should maybe not worry and maybe the RDS server feature alone may give what they want. But you make a compelling case for someone to consider using the remote start/stop. As for the RDS features, I don't think there's much more than what you mentioned. I will note that the Component browser has something that some miss (just had a discussion on another thread today, with someone you would all know well who missed it): in the top right of that view, there's an option to switch from browsing components to browsing web services. Same features: see all the methods, their args, right-click a method to create code (CFINVOKE or createobject). That's interesting to hear that removing a server also removed an RDS server configuration. Since they're separate (per the point of the post), it doesn't seem right that deleting the former should delete the latter. That seems worth opening a bug report. They're great about responding to those (in my experience). Finally, as for using the "import RDS" feature, I wouldn't expect that to necessarily fix things with a problem of adding a new server in the Servers view. It could help, if the config of the former was right (and working) and importing it got things closer to being correct in creating the latter. But there can still be issues in the server (or perhaps in the settings being entered in the editor) that keep the remote feature from working. Too bad some people are having problems with that. I know you're already familiar with them, Jose, but in case anyone else reads this thread and hadn't heard, the CFBuilder team has two blog entries with more on setting up remote servers, one for whether you deployed CF in Server/Standalone mode and the other for if you deployed in Multiserver/Multiple instance mode: http://blogs.adobe.com/cfbuilder/2009/07/remote_server_setup_is_it_real.html and http://blogs.adobe.com/cfbuilder/2009/07/remote_server_setup_-_multiser.html But I realize, Jose, that even with that info and other on this thread, you're still stuck. It really sounds like a situation where someone should do a Connect session with you to be able to see what's up. Maybe there's something that would be clear in looking at things with you that's just not being communicated in all the email back and forth. I've got to prepare for lots of things next week at CFUnited or I'd offer to do it. I usually do it on a consulting basis (carehart.org/consulting/) but this problem is compelling enough that I'd do it for free. Certainly if the problem remains after next week, feel free to hit me up on the offer. /charlie ... View more

Thanks, Ram. I'll say that's a problem with these forums: even if we read them on the web, there's no indication of hierarchy, so we can't tell what a message is in reply to. Worse, if one does use the web form, there's no provision for including a copy of the message to which one is replying. Granted, we would want people to leave only enough to make that clear, but it would be nice if it was even an option. Better still, it would just be nice if the forum had a way to represent the hierarchy (even if the display wasn't the default). I'm sure this has caused plenty of confusion in other forums/threads. /charlie ... View more

Excellent! Thank you. You know this is the most excited I have been about a CF release since MX. I liked CF 7, really liked CF 8, but the fully supported scripting and ORM stuff are fantastic. I am so looking forward to writing code in all script and making more money doing it :-). I believe this will be the release that earns CF a bit more respect in the development world. Thanks again, JW ... View more

@charlie, thank you for your help.  This is an application that we have developed for a customer and we are unsure of their hosting environment.  We simply know that it will be cold fusion on a windows box, but are not sure if they are running IIS or not.  Our two server setup was to cover both instances so that we do not run into any surprises when we deliver the application to the customer. I will look at the link you provided to see if that sheds any light on the subject.  I can also try to contact the customer and get more information on their hosting environment.  In the mean time, if anyone else has any other ideas they are greatly appreciated. /tony ... View more

Hey Kit, going back to this thread from May, have things continued to work using the approach you had described above? All still well? I will add that, as for the stack trace you showed and your wondering what it told you, I'm sorry I never responded. Unfortunately, I had set the forum to send me all emails from this CF Server Admin forum, so I couldn't really have it notify me specifically of any one that I'd participated in. I've changed it to stop that, so I will from now on only get emails from threads in which I participate. If I somehow still miss any reply you make here, feel free to drop me a note at charlie at carehart.org. As for that stack trace, well, it really didn't have enough info. You would need to look at all the running threads and more important, compare them over multiple snapshots, to be able to identify if any indicate a given thread showing a request stuck doing the same thing across the snapshots. That would be a smoking gun to then investigate, and it would indeed identify the specific line of CFML code that the request was stuck on. I've approached the Adobe DevNet folks about doing a revision (or continuation) of the 4-part series from 2007. The Monitor isn't changing much in CF 9, but there are things I and others have learned that could be communicated, and solutions like yours could be shared. And while there are some old Adobe technotes on how to create and interpret stack traces and thread dumps, they're really quite old and refer to old manual approaches, with no reference to the server monitor, the snapshots, etc. We shall see if that updated article/series comes to pass. In the meantime, you may want to check out such technotes as http://kb2.adobe.com/cps/183/tn_18339.html. Hope that's helpful. Or ask away or update us on how things went for you. ... View more

Ayup, noticed the helpful and question answered radio buttons, used them on the first two replies.  Follow-up for clarification regarding terminology. ... View more

Jilani, you mention that this seems connected to SiteMinder. Do you mean you have your own version of SiteMinder, separate from the built-in one that came with CF 4 and 5? I wonder if there could be a conflict between them. Why are you using the full SiteMinder? And do you really need it? More curious is that you say this spike happens every hour. Can you confirm if it's every 67 minutes, specifically? If so, then I would assert that this could be a problem related to the client variable purge process, which I discuss here: http://www.carehart.org/blog/client/index.cfm/2006/10/4/bots_and_spiders_and_poor_CF_performance But that may not be the issue if simply enabling/disabling the siteminder service will immediately recreate your problem....unless somehow the DB used by SiteMinder is the same DB used for client variables. Do you have any datasources listed in the CF Admin page for client variables? Any chance there's a connection between them and siteminder? /charlie PS This whole issue of client variables and how they can hurt you unexpectedly is something I'll dicuss this Thursday at noon US EDT, when I present "Clients and Sessions and Crashes, Oh My", to the online ColdFusion Meetup: www.coldfusionmeeetup.com. ... View more

Wow, that's interesting (that you can invoke the web service without a username/password in CFML, but can't register it in the Admin). Still, I want to understand what makes you want to do that (register it in the admin). You say, "I have a pool of web services to manage so I assume admin to be the best place to maintain them seeing on a broader perspective." I'm not sure what you mean by that. Besides a little more explanation, I'd still ask: if you can't get around this (not saying that it should fail, but just if it can't be resolved), do you at least agree that you don't NEED to define the web services this way to use them. In fact, the opposite is true: if you invoke them in CFML (whether with createobject/cfobject/cfinvoke) that will populate this Admin page for each web service that's invoked, so you could "get around" the problem and have all your web services listed this way, for whatever value that offers. But yes, it seems it should work the way you want to. I'm not denying that. Just trying to help. /charlie ... View more

Most gracious offer Charlie, very much appreciated! Unfortunately, my workstation as the office is in a PCI DSS zone that is heavily restricted, for obvous reasons. Company does payment processing, so you can imagine what that entails. But again, than you very much for the offer! My brain is telling me to go back to basics here. It used to work. Then it didn't. What changed? SP1 was installed. What specifically changed due to SP1 that could affect CF? It seems that the jndi.properties file isn't being read, so Jrun can't run a select statement against... seemingly some sort of internal flat file database. So what in SP1 could prevent that? I don't know, just sort of spitting out my thought process here, since the caffeine is starting to kick in for this morning. ... View more

@Dhivya, I'm afraid this is just a possible limitation in using the Memory Tracking. It's a very resource-intensive operation. It works fine in development, and I've even seen some production sites use it also, but most experience what you have. The general consensus is just to avoid that feature in such a case. But there are a couple of other thoughts to consider. One is that you absolutely DO NOT need to start memory tracking in order to view the use of memory by CF (in aggregate). Go to the Memory Usage Summary page (in the Monitor, under the "Memory Usage" section on the "Statistics" tab) to see a graph of memory usage over recent time. Similarly, you can even see what simple variables are set in the session, application, and server scopes by viewing the corresponding pages for those in that "Memory Usage" section. You just won't see complex objects (queries, CFCs, arrays, etc.) in there without memory tracking turned on. Sadly, that has misled some who misunderstood that they weren't really seeing "all" variables in a given session, application, or the server scope. You also won't see any of the things that purport to show "size" with regard to memory. They'll be 0. But the bottom line is that the server monitor is still extremely useful without having that start memory tracking enabled. I wrote a 4-part series of articles for the Adobe Dev Center on the server monitor, which may help some readers. See http://www.carehart.org/articles/#2007_2 for the link to the first article, which points then to the others. Or you can skip to the other articles via links there on my site. One last thing I'll add, which most miss: you can use the "filter settings" feature (a tab within the settings button at the top of the monitor) to limit what code directories are monitored at all by the server monitor. In that case, you may find that you can turn on memory tracking while monitoring only THOSE pages you're interested in. I've not yet worked with someone who had the problem and was willing to turn it on to try this (since if it doesn't work, it can crash the server). If you do it, and it works for you, please let us know. (If it doesn't, notice also the "profile filter" option to try instead.) I do discuss these settings in the 4th article in the series, if you need a little more help in finding and using them (though at the time I did not discuss using it specifically to get around this occasional problem some have.) Hope that's helpful. ... View more

@Mixtheo, you said originally, "I can see jrun memory usage is spiking when the task runs but I do not get out of memory errors and the other sites are still responsive." But your last note said, "Checking the -out log in the runtime/logs dir confirms that I am getting java out of memory errors." So just to be clear, is it that you couldn't see the errors before, but the out log showed them? I ask because I want to help you connect if the problem is directly related to the pages in error (you said earlier, "The code is memory intensive and pulls large resultsets from the db and loops over them to send elerts to approx. 40k clients. By adding exittemplate calls I can short-circuit the code and so I can see that certain loops are causing the problem." If the problem is really this one template, then it's curious. The end of the CFQUERY should release the memory to garbage collection. Are there any CFC's involved here? You could be having the classic issue of storing instances in shared scopes where not using VAR scope causes unexpected memory leaks. But there are also other problems that can happen to affect you. You don't say if you're on CF8 Standard or Enterprise. If the latter, there can be useful info in the CF 8 Server Monitor. But as ke4pym, there's also a lot to be gained from FusionReactor as well, if you're on 8 Standard. I love both, and help people use them all the time in my consulting and training practice, but there are some things the CF8 Monitor can show that FR cannot, such as how many sessions you have active. In fact, if you're on Standard, I would recommend you check to see how many sessions you have, which may have a bigger impact on memory than you'd expect. I blogged about an easy to use tool. It doesn't say how much memory is used per session, but some have been shocked to find they had tens of thousands of sessions active. See http://www.carehart.org/blog/client/index.cfm/2009/1/22/tracking_count_of_sessions_per_application. Hope that helps. /charlie ... View more

No, Jochem, I'm only doing things through the traditional web interface. Perhaps some of the reason some things show up to people is based on whether one posts in one or the other interface. That, and the other things you mention, are really a shame to hear. Hope they're sorted out. ... View more

68manta wrote: > We're running the baseline version of coldfusion 8 using SSL and want to > apply a hotfix. The problem is that when we click on the 'BROWSE SERVER ICON" > from the System Information area, CF comes back with a "Retrieving Initial > Directories" panel but then it just sits there spinnnig it's wheels and never > returns. I'm thinking this may have something to do with our SSL configuration > but I'm also hoping someone knows a way to temporarily circumvent the issue by > manually applying the hotfix. Anyone know of a way to do this? Shut down CF, drop the .jar file in */WEB-INF/cfusion/lib/updates/ and restart CF. Jochem -- Jochem van Dieten Adobe Community Expert for ColdFusion ... View more

Great to hear, and glad to help. If you don't mind, could you mark the question as answered? That could help future readers and other helpers. Thanks. ... View more

@brentil, ah, ok. I understand now. Yep, that is curious. I can confirm that it wasn't there on Mar 17, per the Google cache page: http://74.125.93.104/search?rlz=1C1GGLS_en-USUS291US306&sourceid=chrome&ie=UTF-8&q=cache:http://kb.adobe.com/selfservice/viewContent.do%3FexternalId%3Dkb402604%26sliceId%3D1 Of course, by the time someone reads this in the future, it's possible that the cached page will be different again. One would want to note the date offered by Google at the top of the page it shows. So the real question is why the CHF link was note posted here until now. I'm with you that some resources are not always updated. I blogged about it: http://www.carehart.org/blog/client/index.cfm/2008/7/16/beware_technotes_may_not_be_listed_elsewhere Perhaps more dismaying is that the CHF2 technote lists many more HFs included than appear in the main hotfix page (the URL you pointed to). So one might ask why we should have had to wait for a CHF to get those hotfixes. Also, I notice that the main cf8 downloads page (which you pointed to originally) does not, in fact, refer to the 8.0.1 CHF (though it does list 8.0 CHFs). That should be address. I agree that we should expect the hotfixes page to list any hotfixes or CHFs as soon as they're available. Sorry I missed your main point. Sadly, I don't know that we can expect too much to come of this discussion here. There's just no guarantee that anyone responsible would see it. But here's good news. A couple of blog entries have raised the concern: http://www.creative-restraint.co.uk/blog/post.cfm/coldfusion-8-0-1-cumulative-hotfix-2 http://blog.pengoworks.com/index.cfm/2009/3/18/ColdFusion-v801-Hot-Fix-2-released-in-Oct-2008 And Ben Forta is a party to the second one, where I've just added a comment asking to find who we can press about this. Finally, just an FYI: that URL you offered is indeed the same page that I'd offered. The URL I gave ( http://www.adobe.com/go/kb402604) comes from the "permanent link" offered at the bottom of all Adobe technotes, which is just a nice shorter URL. ... View more

Sorry for the delay in responding. The "Template Cache Hit Ratio" averaged ~99% when Trusted Cache is enabled. So I set up the Cache Clear method for testing and it's not going to come close to satisfying our needs. I'm not exaggerating here, but it's literally going to take hours for each sweep. We have ~3500 folders in the root directory it has to search. Again, using the process monitor tool, the jrun process is literally traversing down to each file to read it. This behavior occurs when Sandbox Security is enabled. So I'm back to Sandbox Security implementation in 8 perhaps being somewhat flawed, at least in our infrastructure. Our content resides on a NetApp FAS3050.  Erick ... View more

Okay. Whatever. ... View more

Are there any benefits to having the client variables in, say a local datasource rather than cookies? Thanks john ... View more

I did not think you needed a serial number for development. Just install without a serial number and you are in developer mode. Am I wrong? ... View more