I have an issue where MailSend will work fine on a
server for months, then all of a sudden, it stops
working and produces a timeout failure when executing
the MailSend. And then it sends me an e-mail saying
that there was an error and it was the timeout failure
If I rebuild the server from scratch, run the same
exact script, it will work. It's just overtime,
something changes. Any idea what modules, calls, dll's
that the mailsend function is using? I am running
3.4.23. Additional info: reinstalling the app does
help.

Reinstalling is definitelly too much. Restarting the server should help if the problem is on 24x7 side.
Which email interface in 24x7 do you use (MAPI, SMTP, Lotes Notes)?
Do you have your email server running on the same network/domain?

: I have an issue where MailSend will work fine on a
: server for months, then all of a sudden, it stops
: working and produces a timeout failure when executing
: the MailSend. And then it sends me an e-mail saying
: that there was an error and it was the timeout failure
: If I rebuild the server from scratch, run the same
: exact script, it will work. It's just overtime,
: something changes. Any idea what modules, calls, dll's
: that the mailsend function is using? I am running
: 3.4.23. Additional info: reinstalling the app does
: help.

We use the SMTP interface. The Exchange 2003 server is on
on the same LAN as the server with the 24x7 issue.
: Reinstalling is definitelly too much. Restarting the server should help if
: the problem is on 24x7 side.
: Which email interface in 24x7 do you use (MAPI, SMTP, Lotes Notes)?
: Do you have your email server running on the same network/domain?

I guess the email in MailSend is not yours. Maybe there is a problem with the recipient's email server (slow, not available, ????) That's why when MailSend timeouts it can still send an error massage email to you.

I would like to suggest implementing mail retry options. Here is an example how this can be done.

Dim Count, Number, 4
Dim LastError, String

RETRY:
Subtruct Count, 1, Count
If Count, TRY_IT, REPORT_ERROR

TRY_IT:
OnErrorGoTo RETRY
Wait 10
MailSend .... recipient and message parameters here ...
Exit

REPORT_ERROR:
GetLastError LastError
RaiseError LastError

: We use the SMTP interface. The Exchange 2003 server is on
: on the same LAN as the server with the 24x7 issue.

The mail destination is a mailbox on that local
exchange server. It is a job completion message
for the administrators of the SQL Servers. The error
simply said that there was an error on Line 366: Timeout
and Line 366 is the MailSend command. It has worked
on this server before. It just all of a sudden stopped
working. Could you please tell me what dll's this
command is referencing so that I can replace them
and see if that fixes the problem?

: I guess the email in MailSend is not yours. Maybe there is a problem with the
: recipient's email server (slow, not available, ????) That's why when
: MailSend timeouts it can still send an error massage email to you.

: I would like to suggest implementing mail retry options. Here is an example
: how this can be done.

: Dim Count, Number, 4
: Dim LastError, String

: RETRY: Subtruct Count, 1, Count
: If Count, TRY_IT, REPORT_ERROR

: TRY_IT: OnErrorGoTo RETRY
: Wait 10
: MailSend .... recipient and message parameters here ...
: Exit

: REPORT_ERROR: GetLastError LastError
: RaiseError LastError

It uses 24x7ws.dll, but replacing DLL is not going to help. This is not a file problem! The very same DLL is used to send you the job error.

Another suggestion that I have is to set the job to run detached.

: The mail destination is a mailbox on that local
: exchange server. It is a job completion message
: for the administrators of the SQL Servers. The error
: simply said that there was an error on Line 366: Timeout
: and Line 366 is the MailSend command. It has worked
: on this server before. It just all of a sudden stopped
: working. Could you please tell me what dll's this
: command is referencing so that I can replace them
: and see if that fixes the problem?

I do run the job detached. What does MailSend not work
and the regular job error message from 24x7 work?

: It uses 24x7ws.dll, but replacing DLL is not going to help. This is not a
: file problem! The very same DLL is used to send you the job error.

: Another suggestion that I have is to set the job to run detached.