Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Baffling CFScheduler Problem on Windows Server with IIS7

Posted on 2011-03-13
12
Medium Priority
?
523 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Command Line Tips and Tricks

The command line is a powerful tool at the disposal of every Linux user. Although Linux distros come with beautiful user interfaces, it's worthwhile to learn the command line because it allows you to do a number of things that you otherwise cannot do from the GUI.  

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…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

719 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