?
Solved

Coldfusion administrator Scheduler issue

Posted on 2004-08-09
10
Medium Priority
?
204 Views
Last Modified: 2013-12-24
I am going to do my best to describe what is going on here....
I created an app where a user can enter information so that they can receive reports generated by oracle report server at scheduled intervals.

The page i created looks at the database and determines if it should tell report server to run the report...if it should then i use cfexecute to launch an instance of IE on the webserver passing it the parameters it needs to fulfill the report reuest...after IE is triggered which in turn triggers the report server i send another command to kill the IE process.  I repeat this for the number of records in the table.

i then used the coldfusion administrator to schedule when this page runs...
now here is the problem.  The first record that it sees it does not create the report...I set it to create some logs so i can see what is going on and it says that the report is being created, but then on the page that emails te attachments out it cannot find the attachment because in fact it was never created...it only does this for 1 or 2 records and then it works fine...

hard to picture what is going on here, but any helop would be appreciated...

one last note....If i MANUALLY hit the GO button in the scheduler ALL reports are generated fine...I even went as far as to schedule the pagfe to launch every 10 minutes and it worked fine, it just seems to flake out overnight.
0
Comment
Question by:jduawa
[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
10 Comments
 
LVL 2

Expert Comment

by:russmichaels
ID: 11757815
Have you checke dthe scheduler logs to make sur ethe cfschedule actually ran?
I have not found cfschedule to be especially reliable, if it's your own server you may want to consider setitng up a windows schedule to run your file instead, or ask the host if they will do this.

Regards
Russ Michaels
0
 
LVL 1

Author Comment

by:jduawa
ID: 11757855
it is in fact running, it just skips a few rows, i just set it up today to use MS scheduler i will know tomorrow if it wokred
0
 
LVL 2

Expert Comment

by:russmichaels
ID: 11760770
Is the page being called by the schedule a coldfusion page?

Russ
0
The Ideal Solution for Multi-Display Applications

Check out ATEN’s VS1912 12-Port DP Video Wall Media Player at InfoComm 2017. Kerri describes how easy it is to design creative video walls in asymmetric layouts and schedule detailed playlists ahead of time with its advanced scheduling feature.

 
LVL 1

Author Comment

by:jduawa
ID: 11763083
yes it is...using microsoft task scheduler worked, not sure why CF's is so flaky...maybe it is better in version 6.1
0
 
LVL 2

Expert Comment

by:russmichaels
ID: 11763567
I have actually seen thsi problem b4, but it was a long time ago so I do not even remember if I solved it.
At least using the windows scedhuler has given you a better solution though.
0
 
LVL 1

Expert Comment

by:cdman2k3
ID: 11782223
In past experience the CF scheduler has (or at least HAD) a problem if there there were two or more scheduled jobs ended up being scheduled so that their next execution were within a minute or so of each other then random jobs used to get dropped. My workaround when I had to do this was to carefully plan and "offset" the jobs, e.g. a nightly schedule may be at 12:02, a weekly at 12:04, and the "every 10 minutes" set to run at 12:00, 12:10, 12:20, etc etc.... It certainly was frustrating when my daily "midnight" or "2am" jobs only launched a couple of times a week because the "every few minutes" jobs knocked them out of the schedule...
0
 
LVL 1

Author Comment

by:jduawa
ID: 11783900
it wasnt the job that got dropped just rows of a query within the job, thanks for the input
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12108602
PAQed, with points refunded (125)

Computer101
E-E Admin
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

What You Need to Know when Searching for a Webhost Provider
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
Suggested Courses

801 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