Skip to main content
0
01blackerado
Participant
November 30, 2011
Answered

New to ColdFusion

  • November 30, 2011
  • 2 replies
  • 2015 views

Hello,

Im new to coldfusion and would like some help with troubleshooting. I just started at this company and they use cold fusion to do a few simple tasks. One of which is a script and windows scheduled task for birthdays. Coldfusion reads from a MS access db and sends out an email on based on the DOB of the person and their first name. For some reason it just stopped working sometime after November 1st 2011. I just need to know how to troubleshoot this, Im reading the log files that i know of thus far and they are not very informative.

Thanks

    This topic has been closed for replies.
    Correct answer 01blackerado

    Solved!! I had to repair the database in the OBDC. Thanks fellas

    2 replies

    I
    iSaid
    Known Participant
    December 1, 2011

    Silly question - have there been any Birthdays since 1st Nov?  (not knowing how big your list/DB is) 

    Have you checked the access database to see how many should have been sent out? 

    Has any code within the file(s) been changed?

    Also looking at the errors posted, you have a lot of "connection failures" - do you know what this is?

    Owainnorth
    Owainnorth
    Inspiring
    December 1, 2011

    Silly question - have there been any Birthdays since 1st Nov?

    It was my birthday back in February and I certainly didn't get an email, I'll let you know how it goes next year.

    What SMTP engine are you using? IIS? If so, do you have logging turned on there? That will show you very quickly whether an email was actually sent from the server or not, the CF mail logs can only show you whether or not it was successfully passed to the SMTP engine.

    0
    01blackeradoAuthorCorrect answer
    Participant
    December 2, 2011

    Solved!! I had to repair the database in the OBDC. Thanks fellas

    12Robots
    12Robots
    Participating Frequently
    November 30, 2011

    This could be any number of things.

    - Problem with the script

    - Problem with the system clock

    - Problem with the mail server

    - Problem with spam filter

    - etc

    Can you offer any more information?  Do the log files show *anything*, even if you don't understand them?  Which log files are you looking at?  You should look at

    <ColdFusion>/logs

    and

    <ColdFusion>/runtime/logs

    Can you should us the code that stopped working?

    jason

    0
    01blackeradoAuthor
    Participant
    November 30, 2011

    Well, I didn't get an error message. It just happen to be someones birthday today and i noticed we didnt get an email. I checked the last day an email had been received from "Birthday@domain.com" in my email account and that was Nov 1st. I then went on to the server that is hosting CF and checked the log files in CF\logs

    application.log

    scheduler.log

    server.log

    webserver.log

    I dont have a "Runtime" subdirectory in my CF folder.

    -Problem with script (Maybe, how can i tell or Reverse engineer this so that i can find out?)

    -Problem with system clock ( I dont think this is the case, I have the correct time displayed in the system tray, and if i log on to the "default website" from a remote computer, the date is at least showing correctly on the webpage as 11/30/2011)

    -Problem with mail server (I dont think so, we're receiving mail from all other sources. In fact CF is also set to send out an auto reminder every friday to all-employees@domain.com to fill out our timesheets and submit them. This email still has been delivered successfully each time)

    -Problem with spam filter ( Same as above )

    Ill be more than happy to share log information... please tell me which one would best serve for troubleshooting this and ill be happy to copy and paste.

    Thank you

    J
    Joshua_Cyr
    Participating Frequently
    November 30, 2011

    You should still confirm if the mail is generated, and just not leaving the

    server.

    In the cf install folder look for a mail/undelivr folder. It may be named

    slightly different in some versions, I can't remember. Are there any

    files there? Those are emails that can't be sent for some reason. Just

    open them as a text file and take a look.

    Is the scheduler log file showing any errors or failures. You can read

    this via the CF admin or manually.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices