Thanks all for your responses. :-)
As per Allen's suggestion I started placing cfdump and cfabort in
application .cfm file and it turns out the error comes at line, where i set
client.dbname variable. we use this setting in all our applications and they
run fine. See below
<cfapplication name="MainApp" sessionmanagement="NO" setclientcookies="YES"
clientmanagement="YES" clientstorage="XYZ">
<cflock timeout="20" throwontimeout="YES"
name="#APPLICATION.APPLICATIONNAME#" type="EXCLUSIVE">
<cfif not #isdefined("APPLICATION.STARTED")#>
<cfset application.title="appTitle">
<cfset application.started="TRUE">
</cfif>
</cflock>
<cfset client.dbname = "XYZ"> // error happens here.....
SOME MORE CODE BELOW...
If I remove that line, error goes away.
So I have been able to narrow down the problem. Lets see what DB ppl come up
with.
Again, Thanks all for the valuable suggestions.
<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 3:04 PM, Charlie Arehart <[email protected]>wrote:
> 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:* [email protected] [mailto:[email protected]] *On Behalf Of *Ajas
> Mohammed
> *Sent:* Wednesday, May 06, 2009 2:28 PM
> *To:* [email protected]
> *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 <[email protected]>
> 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 <[email protected]>
> 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: [email protected]
>
>
> -------------------------------------------------------------
> 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 FusionLink <http://www.fusionlink.com>
> -------------------------------------------------------------
