I don't think it's errors your looking for - it's more transactional than that. In other words, run a trace in Query Profiler and watch just the cdata and cglobal tables and see if there are any deadlocks occurring. Also check the number of rows in each of these tables and look for the oldest records (I believe the column is active_date). If you have anything over a week old, I'd say dump those records because the chances are the user has already obtained a new cfid and cftoken. Another thing you can do to somewhat diagnose the problem (potentially) is to look at the CPU's and maybe even do a tracemon and look at the I/O on the filesystem. Unfortunately, the problem you describe sounds much like the one we experienced here, and the only way it was really found was looking at the active transactions in profiler and seeing where problems came up as well as keeping an eye on all the system resources such as CPU, disk I/O, etc.
And, just to be clear, we had the same exact behavior you're mentioning. We'd see a server 500 error (the generic one), but the page would execute. That's what made it so troublesome to track down. We had placed stop points all throughout our code all the way up to the <cfapplication> tag and that's where we found the error to come from. And, only upon extensive review did we find that the error was actually taking place in the client push/pull. Another thing I might suggest is making sure you're not sharing that particular datasource with any others. What I mean by this is even if your cdata/cglobal tables are in a database with other application tables, create a datasource specifically for the client storage so that you at least have another level of separation for identifying the problem. This will also allow you to tweak the datasource independently of any others to see if some settings might eliminate the problem. I'm definitely not saying that this is your problem, just giving you what we'd found in the past. Allen ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Ajas Mohammed Sent: Wednesday, May 06, 2009 9:31 AM To: [email protected] Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ". Good morning all, Allen we ran CHECKDB on the DB and we found 0 errors ie. 0 allocation errors and 0 consistency errors. All, I have attached a snapshot of the message I am getting Because as Allen mentioned you can get similar message in default CF's gray box whenever error happens i.e. the way usually CF throws up error. But in my case, its shown at end of processing and its not stopping anything. I can access all pages in the application. Thanks, <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 4:34 PM, Ajas Mohammed <[email protected]<mailto:[email protected]>> wrote: Thanks, Yes, we are on CF 7 and I would prefer Application.cfc but its not in my hands. ;-) About excluding subfolder, yeah i do that depending on the needs. So back to my old problem of 500 Operation failed on the data source named "XYZ". <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 3:43 PM, Teddy R. Payne <[email protected]<mailto:[email protected]>> wrote: Ajas, You do not need to restart the ColdFusion server if you change the application framework for your application. Try making changes to your application framework by changing the name of the <cfapplication> tag. Also, you may want to define the timeouts on your application as in applicationtimeout and sessiontimeout: http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000217.htm As you are using CF7, are there any constraints to using Application.cfc? You might find the organization of the methods easier to deliniate your goals of various application environments. In development, I typically have a way to refresh my application framework through a URL variable that would either refresh my cached object factories or just to refresh a given set of instructions. Please allow me to stress "development only". Also, the nature of Application.cfm and Application.cfc is that a CFM or CFC will search up their directory paths to find an application framework. So, your Application.cfm affects the files in the same directory and subdirectories of your Application.cfm. If you ever want to exclude a subfolder inside a given Application.cfm structure, place a new Application.cfm in a subdirectory with either a new name on a <cfapplication> tag or just leave the document blank. Teddy R. Payne, ACCFD Google Talk - [email protected]<mailto:[email protected]> On Tue, May 5, 2009 at 2:46 PM, Ajas Mohammed <[email protected]<mailto:[email protected]>> wrote: Ok, here is another question for same issue. Lets say in Application.cfm, I had <cfapplication name="test" sessionmanagement="YES" setclientcookies="yes" clientmanagement="yes" clientstorage="XYZ"> and then I changed it to <cfapplication name="test" sessionmanagement="NO" setclientcookies="yes" clientmanagement="yes" clientstorage="XYZ"> i.e sessionmanagement to NO. Does this need a ColdFusion restart or changes take place automatically whenever a page is accessed inside that application i.e. pages inside the Same folder as the Application.cfm file ? Thanks, <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 2:10 PM, Ajas Mohammed <[email protected]<mailto:[email protected]>> wrote: Sorry. I meant that YES cookies are enabled on my system. And Yes, I am able to see the error message also. Its just happening for 1 or 2 users. Some users or shall I say user, sees it and some dont. It just happens that I can see the error on my PC and I have cookies enabled. Does that make sense? If not let me know. Thanks again, <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 2:05 PM, Teddy R. Payne <[email protected]<mailto:[email protected]>> wrote: What does "Yes" mean in this context? Does "Yes" mean that you are getting the same error as the the user who is complaining or are just saying "yes" that you have cookies turned on? Teddy R. Payne, ACCFD Google Talk - [email protected]<mailto:[email protected]> On Tue, May 5, 2009 at 2:02 PM, Ajas Mohammed <[email protected]<mailto:[email protected]>> wrote: Hmm... Good question. Yes. I tried on my system and I have cookies enabled. <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 1:58 PM, Teddy R. Payne <[email protected]<mailto:[email protected]>> wrote: The user with the issue, do they have cookies enabled? Teddy R. Payne, ACCFD Google Talk - [email protected]<mailto:[email protected]> On Tue, May 5, 2009 at 1:47 PM, Ajas Mohammed <[email protected]<mailto:[email protected]>> wrote: Yes, XYZ has CDATA and CGLOBAL in it. Let me know if you need more information. I am stumped. Thanks for the reply. <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne <[email protected]<mailto:[email protected]>> wrote: Can you confirm that the client store tables exist in the CF DSN that you are referencing in your application file? Does XYZ have CDATA and CGLOBAL in it? Teddy R. Payne, ACCFD Google Talk - [email protected]<mailto:[email protected]> On Tue, May 5, 2009 at 1:11 PM, Ajas Mohammed <[email protected]<mailto:[email protected]>> wrote: Hi, I believe so because same sql server account/user is used to for all DSN we have i.e. about 10-15 dsn's and we never had this problem with any of the dsn's. So its really weird. We have two appl's lets say MainApp and SubApp where MainApp is /MainApp and subApp is /MainApp/SubApp. Both have there own Appplication.cfm file and we have clientmanagement yes and clientstorage pointing to same DSN lets say XYZ like this sessionmanagement="no" setclientcookies="yes" clientmanagement="yes" clientstorage="XYZ" One user was getting this error in MainApp and I was getting the same error in subApp. Some users were not getting *any* errors at all. I got rid of MainApp error using this code at very end of logout screen. <cfset client.hitcount = 1> .Thats strange because I dont use StructClear(Client). Someone mentioned that if you used StructClear then use hitcount. I am so confused now because client.hitcount thing worked and we havent used it for any of our sites which work fine. Any suggestions? By the way, I have not tried hitcount method on the SubApp application yet. <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne <[email protected]<mailto:[email protected]>> wrote: Does the user that you bind for the datasource have access to create table? Client storage creates two database tables: CDATA, CGLOBAL Teddy R. Payne, ACCFD Google Talk - [email protected]<mailto:[email protected]> On Tue, May 5, 2009 at 11:15 AM, Ajas Mohammed <[email protected]<mailto:[email protected]>> wrote: Hi, I have a datasource defined lets say XYZ and I use this XYZ dsn as clientstorage. I am getting this error message after page request. Everything works fine except that the page has this error at end of page. 500 Operation failed on the data source named "XYZ". Operation failed on the data source named "XYZ". My search on google gave me clues that it could be a client variable causing problem or space for table storing client variables or Oracle db(which doesnt apply to me). So far, not sure what is the root of this problem. Which log file I need to check to track more info about this error? Any ideas as to what could be causing this error. Thanks, <Ajas Mohammed /> http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
