Problem with tsendmail

Highlighted
One Star

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
Highlighted
Moderator

Re: Problem with tsendmail

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
Highlighted
One Star

Re: Problem with tsendmail

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog