As an FYI - we had a similar issue up here. There was a problem where there were issues such as deadlocks occurring in the database if there was high volume of traffic with large amounts of client data being written to and read from. I would (if you can) run a trace on that database with the client tables in it to see if you're getting any locks that are killing off your threads. For some reason, CF seems to ignore the sql errors that come from the client data read/write. It was a very odd issue that took a long time to find.
Another thing to do is to check and see how much old data is in those CDATA/CGLOBAL tables. Putting a db maintenance plan in place that cleans out those tables every couple of days did wonders for getting rid of the problem you describe. Allen ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Ajas Mohammed Sent: Tuesday, May 05, 2009 1:47 PM To: [email protected] Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ". 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 -------------------------------------------------------------
