Solved

Baffling CFScheduler Problem on Windows Server with IIS7

Posted on 2011-03-13
12
516 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

810 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