One of the first things I always check with CFSHEDULE problems is does the user account that the Cold Fusion service run as, usually system if not modified, have permission to all the resources necessary to do its task.  In your case I would check the file security on the directories to which you are trying to write.  You may also want to double check the permissions to Oracle as well.  

The basic issue is that when you "browse" to the template the system uses your premisssions and can access resources that you have permission to utilize.  But when CFSHEDULE runs the same template it can only use the permissions of the account used by the CF service and these are usually very limited if left to the defaults.

Hope that helps.

Ian
BloodSource
www.bloodsource.org

>We're getting an Oracle error when we run a page through CFSCHEDULE but not
>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]

Reply via email to