I am at my wits end trying to fix what I think is a client
variable problem. I am currently running CFMX 6.1 + updaters on a
Windows 2003 R2 SP1standard edition server with IIS 6.0. Since
implementing with this server (01/2007), we have installed all the
necessary Windows patches for security every month. I have
installed hot fixes for client variables (TN 19590) and a few
others for COM and cfforms issues. I have experienced CF 'hanging';
not allowing anyone into the application. I shut down the CF MX
Application service, the CF MX ADBC agent, and try to shut the CF
MX ODBC server, but it remains in a 'stopping' state, with a reboot
the only cure.
While trying to troubleshoot the problem, I have come across
the following error:
10/16 15:12:24 error Operation failed on the data source
named "Treasury".
coldfusion.runtime.ClientScopeDBException: Operation failed
on the data source named "Treasury".
at
coldfusion.runtime.JDBCHelper.Store(PersistenceFactory.java:261)
at
coldfusion.runtime.ClientScopeServiceImpl.PersistClientVariables(ClientScopeServiceImpl.java:282)
at
coldfusion.runtime.ClientScopeServiceImpl.PersistClientVariablesForRequest(ClientScopeServiceImpl.java:264)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:32)
at
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
That's it - nothing else. I have searched high an low,
finding similar errors, but they all have an additional error
message like outOfBounds. This error appears up to 200 times per
day, some within seconds of each other. (I never really looked at
the logs, but it has been occurring since I brought up each server,
test and production). I mentioned the client variable fix above
because of the references in the error message like
'ClientScopeServiceImpl.PersistClientVariables'. I am using an
Access DB to store the client variables, with a purge date of 90
days. Within the Access DB there are the CDATA and CGLOBAL tables,
but with only 278 records in each. I inheritated the system in
version 4.5, and have upgrade to 5 and the to 6.1, so I have never
really looked at client variables before.
Any ideas? Could these errors be created every time someone
logs onto the application? Your time and suggestions are greatly
appreciated.
Libby
... View more