Path Error c:\blackstone_final in coldfusionadministrator / Log files

[oguillot]

Hello,
I am running a linux Redhat ES 3, Coldfusion 7 Developper Edition recently
installed

I have got this really funny error in the coldfusion administrator when I go
to Verity Collections or Log Files section :

" Error Executing Database Query.

The error occurred in
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
113
Called from
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
1
Called from
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
113
Called from
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
1"

What seems really funny is the c:\blackstone_final path as I am on a redhat, I
really do not guess where this path comes from (none copy from a windows)

I supposed it was a config or something like that, so I tried grep in all the
coldfusion directory and /etc for "blackstone_final" string and found nothing
I also checked all the values I could in the coldfusion administrator and
found nothing.

I have also got an error when I check "Report execution times" in the
coldfusion administrator at the end of each page I get an error "Error
executing database query" and nothing else appears in the debug, even if none
query is executed on the page. I wonder if both errors are not linked.

Here is the full content of the error as it appears in coldfusion
administrator when I go to Log Files page

Error Occurred While Processing Request
Error Executing Database Query.

The error occurred in
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
113
Called from
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
1
Called from
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
113
Called from
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\logging\index.cfm: line
1

-1 : Unable to display error's location in a CFML template.

SQL select * from qLogFiles order by name asc
Please try the following:
______________________________
at
cfindex2ecfm197831797._factor6(C:\blackstone_final \cfusion\wwwroot\CFIDE\adminis
trator\logging\index.cfm:113) at
cfindex2ecfm197831797.runPage(C:\blackstone_final\ cfusion\wwwroot\CFIDE\administ
rator\logging\index.cfm:1) at
cfindex2ecfm197831797._factor6(C:\blackstone_final \cfusion\wwwroot\CFIDE\adminis
trator\logging\index.cfm:113) at
cfindex2ecfm197831797.runPage(C:\blackstone_final\ cfusion\wwwroot\CFIDE\administ
rator\logging\index.cfm:1)

java.sql.SQLException
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.jav a:76)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.jav a:59)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:214)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:498)
at
cfindex2ecfm197831797._factor6(C:\blackstone_final \cfusion\wwwroot\CFIDE\adminis
trator\logging\index.cfm:113)
at
cfindex2ecfm197831797.runPage(C:\blackstone_final\ cfusion\wwwroot\CFIDE\administ
rator\logging\index.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:343)
at coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:210)
at coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilt er.java:27)
at coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:50)
at coldfusion.filter.BrowserDebugFilter.invoke(Browse rDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38)
at coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:349)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:457)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

Here is the content of exception.log about this error :
"Error","jrpp-154","07/29/05","15:25:00","cfadmin","Error Executing Database
Query. The specific sequence of files included or processed is: /data/
cfadmin/CFIDE/administrator/logging/index.cfm "
coldfusion.tagext.sql.QueryTag$DatabaseQueryExcept ion: Error Executing
Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:578)
at
cfindex2ecfm197831797._factor6(C:\blackstone_final \cfusion\wwwroot\CFIDE\adminis
trator\logging\index.cfm:113)
at
cfindex2ecfm197831797.runPage(C:\blackstone_final\ cfusion\wwwroot\CFIDE\administ
rator\logging\index.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:343)
at coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65)
at
coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:210)
at coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilt er.java:27)
at coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:50)
at
coldfusion.filter.BrowserDebugFilter.invoke(Browse rDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38)
at coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at
coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:257)
at
jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:349)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:457)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

Thanks for any help you could offer

Best regards

[JohnAbbott]

Did you ever get this solved? I am having the same problem on a Linux Redhat 9
box when I try to go to the /CFIDE/Administrator/ pages. This happened on two
servers within an hour of turning on the "Timeout" attribute of cfchart/cfgrid.
I get:
The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.

Null Pointers are another name for undefined values.

The error occurred in
C:\blackstone_final\cfusion\wwwroot\CFIDE\administ rator\Application.cfm: line 50

-1 : Unable to display error's location in a CFML template.

[oguillot]

Yes we found the answer ... just update and it perfectly worked !
We had a lot of other problems with coldfusion MX 7, all were corrected
You can find the hotfix here :
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=fd71533[/url]
Hope it will help

Best regards

Olivier

[JohnAbbott]

How do I update when the administrator is not running? All the instructions I can find require the update to be installed via cfadmin.

[oguillot]

I read your post too quickly, sorry.

My problem was only in some administrator pages. I could log in the
administrator, access some pages, and so I've been able to update
I am sorry I cannot help as I do not know how update without using
administrator, I just know the solution has been the update for us.
Sorry ...

[rave]

Hello,

You can manually install the Cumulative Hot Fix 3 by placing chf700003.jar in <cf_root>/lib/updates directory and restarting ColdFusion.

Regards,

David.