I'll throw out that if you had FusionReactor or SeeFusion, you could enable their datasource monitoring feature to be able to see each SQL statement sent to the DBMS, which may also have helped you see when/where the problem was (and was not) occurring, since it may be that it happens sometimes and not others.
In both tools, this involves "wrapping" the DSN with a new wrapper they provide, using either manual or automatic steps provided with each tool. Of course, has been noted, you can also look at the queries from the DBMS side as well. It's just that sometimes the CF folks have a hard time getting at that. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Wednesday, May 06, 2009 2:28 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named "XYZ". Hi Cameron, I checked the transaction Log setting under database properties for the db under question and it has 75 mb space allocated for *.ldf file and its allowed to grow automatically by 10%. The empty disk space is about 51 gb on this drive. Our DB team is gonna look at indexes for CData and CGlobal tables. 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 Wed, May 6, 2009 at 2:07 PM, Cameron Childress <camer...@gmail.com> wrote: I would be curious to see if you'd looked at the DB. I've actually seen this exact error caused by a full transaction log on the clientvar datastore. Granted it was SQL Server and not Oracle, but worth looking at. -Cameron On Wed, May 6, 2009 at 10:02 AM, Cameron Childress <camer...@gmail.com> wrote: > This is at the bottom of every single page? Client vars are written > to the db at that end of each requrest so it sounds like a problem > with that. > > I would look at the DB server more closely. Are you out of disk > space? Transaction logs for that DB full? Write permissions changed > for DSN user account? -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: camer...@gmail.com ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.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 ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------
