Solved

Baffling CFScheduler Problem on Windows Server with IIS7

Posted on 2011-03-13
12
521 Views
Last Modified: 2012-05-11
Hi Experts,
This is a known problem with ColdFusion on a Windows Server with IIS 7 but I cannot seem to get it resolved. I recently moved to a new host running IIS7 / Windows Server. I have CF9 on the box, upgraded from CF8. I am trying to schedule a recurring CF query job via the CFScheduler through the Admin panel. The job runs fine when kicked off from within my web application. But when run from the Administrator sched panel, it just says the task completed, but it never actually runs. I am writing output to a file and the file date gets updated, but no data is ever written to the file - no error message - nothing. The scheduler log file shows nothing either - as it thinks the job ran succesfully. My host says they have enabled anonymous access to the website, and disabled Windows Integrated Security. They have traced the job but they also get no message or indication on why it doesn't really kick off so they are unable to troubleshoot.  Additionally, I have tried calling the job via a CFHTTP request and again, it only works interactively, not from the scheduler. My host now just wants to build a script to call the job. But surely there must be a way around this? I have plans to use CFScheduler for many other tasks and would prefer that. Does anyone know a resolution or workaround to this problem? Thanks.
0
Comment
Question by:medsoos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 14

Expert Comment

by:RickEpnet
ID: 35123657
If you can post a screen shot of the scheduling for lets see how you have it setup. You can black out any sensitive information but black out as little as you have to.
0
 
LVL 1

Assisted Solution

by:medsoos
medsoos earned 0 total points
ID: 35124006
0
 
LVL 14

Expert Comment

by:RickEpnet
ID: 35124372
Have you tried running it with out the File attribute? See if that is an issue. You can alway put a cfmail tag to send an email to you in the logoutexpireduser.cfm to see if it runs.
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 14

Expert Comment

by:RickEpnet
ID: 35124379
Just thought of something else:
Does the service that runs this task have the rights to the folder that the file is being written too?
0
 
LVL 1

Author Comment

by:medsoos
ID: 35124384
Really good call - at least now I'm getting an error message:  Error while executing task 302 Moved Temporarily

0
 
LVL 1

Author Comment

by:medsoos
ID: 35124392
Sorry, missed your next post. Yes, it has rights to the folder. So I took off the write to output and now am picking up the 302 error. Will research. I had tried that earlier but my host had had other problems and so this didn't pop out.
0
 
LVL 14

Expert Comment

by:RickEpnet
ID: 35124393
I am not sure about the 302 error but i did find this

http://www.checkupdown.com/status/E302.html
0
 
LVL 1

Author Comment

by:medsoos
ID: 35124453
Yes, I found that too. So it's apparently a redirection problem... I have asked the ISP to look at it.
0
 
LVL 4

Expert Comment

by:dwkd
ID: 35143259
set your timeout to 120 seconds...se how that goes
0
 
LVL 1

Accepted Solution

by:
medsoos earned 0 total points
ID: 35143428
I actually resolved this by applying the CF 9.01 release/patch. It fixed IIS issues among other things, although this issue was not one of those noted. Thanks.
0
 
LVL 14

Expert Comment

by:RickEpnet
ID: 35143797
Glad you got it working.
0
 
LVL 1

Author Closing Comment

by:medsoos
ID: 35763197
the patch resolved the problem
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question