when we browse to the page. The page does a full-text index on the database
by querying all the data, writing out text files for each record, and then
indexing the text files. (we found that writing text files and indexing
those is at least 10 times faster than indexing the query directly--no idea
why).
So when we browse to the page it runs though and indexes everythign fine.
When we run it via cfschedule, we get this weird error I've never seen
before and couldn't find anything about online.
Also look at the file list, it's odd that it lists the CF call stack twice
with part of the error message in between as a "Called from" template. The
Java stack trace is correct though.
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]Connection refused,
(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12
500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B
UF='32-bit Windows Error: 2: No such file or directory'))))
The error occurred in
E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select
_All.cfm: line 33
Called from
E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw
ord_docs.cfm: line 9
Called from
E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line
11
Called from
DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=125
00)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BU
F='32-bit Windows Error: 2: line -1
Called from
E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\qry_Task_Select
_All.cfm: line 33
Called from
E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\act_create_keyw
ord_docs.cfm: line 9
Called from
E:\WebDocs\SystemTest\Inventory2005\Input\browse\collections\index.cfm: line
11
32 :
33 : AND t.id = #id#
34 : ORDER BY
35 : t.nasa_id
SQL SELECT t.ID, t.UPN_ID, t.SUB_UPN, t.TASK_NAME, t.COMMENTS,
t.CCCLEVEL, t.RELEASE_NAME, t.URL, t.DATE_MODIFIED, m.Maturity_Descrip,
users.LoginName AS Modified_By, e.Enterprise_Name, c.center_name FROM Task
t, Maturity_LU m, InventoryUsers users, UPN_Lu upn, Enterprise_LU e,
Center_LU c WHERE t.Maturity_ID = m.Maturity_ID AND t.Modified_By_ID =
users.User_ID AND t.RecordStatus != 'D' AND upn.enterprise_id =
e.enterprise_id AND t.center_id = c.center_id AND t.upn_id = upn.upn_id
ORDER BY t.id
DATASOURCE SystemTestInput2005
Please try the following:
* Check the ColdFusion documentation to verify that you are using the
correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser CFSCHEDULE
Remote Address 128.183.235.210
Referrer
Date/Time 23-Sep-04 11:00 PM
Stack Trace
at
cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory
2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at
cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven
tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at
cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro
wse\collections\index.cfm:11) java.sql.SQLException: [Macromedia][Oracle
JDBC Driver][Oracle]Connection refused,
(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12
500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B
UF='32-bit Windows Error: 2: No such file or directory')))) at
cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory
2005\Input\browse\collections\qry_Task_Select_All.cfm:33) at
cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven
tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9) at
cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro
wse\collections\index.cfm:11)
java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]Connection
refused,
(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12
500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(B
UF='32-bit Windows Error: 2: No such file or directory'))))
at
coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:677
)
at
coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.ja
va:123)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:
138)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:
125)
at
coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:120)
at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at
cfqry_Task_Select_All2ecfm2018976324.runPage(E:\WebDocs\SystemTest\Inventory
2005\Input\browse\collections\qry_Task_Select_All.cfm:33)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at
cfact_create_keyword_docs2ecfm1358543822.runPage(E:\WebDocs\SystemTest\Inven
tory2005\Input\browse\collections\act_create_keyword_docs.cfm:9)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at
coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:
60)
at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:256)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1881)
at
cfindex2ecfm2020146618.runPage(E:\WebDocs\SystemTest\Inventory2005\Input\bro
wse\collections\index.cfm:11)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28)
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:252)
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:29
4)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]