SMTP Mail Attachment File Remains Open

muratkarabek

Hi friends,

I have a problem with smtp mail codeunit in Navision 5. I've prepared the code below. After the code executes, i try to delete the file on file system, i get an error message says: "File is already in use by Microsoft Dynamics NAV SQL...". Although the mail has already sent, the attached file remains open by Navision. Any idea?

SMTPMail is Codeunit "SMTP Mail"


SMTPMail.CreateMessage(
MailBuffer."Sender Name",
MailBuffer."Sender Address",
MailBuffer.Recipients,
MailBuffer.Subject,
MailBuffer.Body,
MailBuffer."Html Formatted");

SMTPMail.AddAttachment(AttachmentFile);
SMTPMail.Send;

mohana_cse06

Did you try by clearing the SMTPMail after send?

CLEAR(SMTPMail);

muratkarabek

mohana_cse06 wrote:

Did you try by clearing the SMTPMail after send?

CLEAR(SMTPMail);

Yes, but doesn't work.

muratkarabek

Is there any other idea? It's urgent!!! Please..

Alex_Chow

If you're creating the file in runtime, have you File.CLOSE the file?

Yashojit_Pandhare

Hey Friend,

Maybe there is very little execution time between creation of file, Sending it as Attachment and Deleting it. The File System may not be claring the Handles to the File.

So you can use the SLEEP(value in millisecs) function to put some delay. Try using Sleep befor smtp.attachment function and after smtp.send function.

+++++++
sleep(30000)
SMTPMail.AddAttachment(AttachFile);
SMTPMail.Send();
sleep(30000);
+++++++++

AndyDegaard

Hi all,

I have the exact same problem.

The attachment file lock is not released until you close the NAV client. Not even choosing File, Database, Close will release the attachment file. This indicates to me that the problem cannot be solved by C/AL since even singleinstance codeunits are cleared if you close the database.

/Anders

AndyDegaard

Hi all,

I now found that the problem only occurs when the SMTP.Send call fails.
If the mail is sent correctly the attachments are released and can be deleted.

/Anders

kine

This is known bug. Just search through Knowledge Base on partnersource. You need to download newer version of the dll and apply one additional KB article.