Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with tsendmail

Hello,
I have a problem with a tsendmail component.
i want to send an xls file but i always have this message
Exception in component tSendMail_1
javax.mail.MessagingException: IOException while sending message;
nested exception is:
java.io.FileNotFoundException: C:\ETL\Prevision\tableaux\tableau_de_bord_bis.xls (Le fichier spécifié est introuvable)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:625)
at javax.mail.Transport.send0(Transport.java:169)
at javax.mail.Transport.send(Transport.java:98)
at corep.test_mail_0_1.test_mail.tSendMail_1Process(test_mail.java:260)
at corep.test_mail_0_1.test_mail.runJobInTOS(test_mail.java:394)
at corep.test_mail_0_1.test_mail.main(test_mail.java:308)
Caused by: java.io.FileNotFoundException: C:\ETL\Prevision\tableaux\tableau_de_bord_bis.xls (Le fichier spécifié est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at javax.activation.FileDataSource.getInputStream(Unknown Source)
at javax.activation.DataHandler.writeTo(Unknown Source)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1350)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:845)
at javax.mail.internet.MimeMultipart.writeTo(MimeMultipart.java:361)
at com.sun.mail.handlers.multipart_mixed.writeTo(multipart_mixed.java:85)
at javax.activation.ObjectDataContentHandler.writeTo(Unknown Source)
at javax.activation.DataHandler.writeTo(Unknown Source)
at javax.mail.internet.MimeBodyPart.writeTo(MimeBodyPart.java:1350)
at javax.mail.internet.MimeMessage.writeTo(MimeMessage.java:1683)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:585)
... 5 more
i control, the file exist in the directory (it's not created by TOS).
If i create an other file in the directory the send mail run as well.
Thanks for your reply
Labels (3)
2 Replies
Anonymous
Not applicable
Author

Hi,
Check if your excel file is not already opned in excel.
If so Excel generates a read/write lock.
Closing the excel file should resolve it,
regards,
benjamin
Anonymous
Not applicable
Author

The excel file is not open. I find the solution, i copy my excel file and rename it in "tableau.xls" the tsendmail work well for this file.
I don't understand why TOS doesn't like the name of my excel file .......
Thanks for your help