Solved

Baffling CFScheduler Problem on Windows Server with IIS7

Posted on 2011-03-13
12
518 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
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

680 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