topic Re: Unable to send emails using Gmail: tSendMail in Talend Studio

Unable to send emails using Gmail: tSendMail

Anonymous — Fri, 10 Aug 2018 15:02:02 GMT

Hi,

I have been trying to export the data from Excel and send through email.

But am getting the below error while executing the job.

[statistics] connecting to socket on port 3720
[statistics] connected
Exception in component tSendMail_1 (Name)
javax.mail.AuthenticationFailedException: failed to connect
at javax.mail.Service.connect(Service.java:322)
at javax.mail.Service.connect(Service.java:172)
at javax.mail.Service.connect(Service.java:121)
at javax.mail.Transport.send0(Transport.java:190)
at javax.mail.Transport.send(Transport.java:120)
at local_project.Name_2_0.Name.tDBInput_2Process(Name.java:1180)
at local_project.Name_2_0.Name.runJobInTOS(Name.java:1572)
at local_project.Name_2_0.Name.main(Name.java:1423)
[statistics] disconnected

Job Name ended at 23:58 10/08/2018. [exit code=1]

Note : I would need to provide the OTP each and every time I login to gmail. Does this has any significance over here?

Your help would be appreciated !!

Thanks !!

Re: Unable to send emails using Gmail: tSendMail

Anonymous — Mon, 13 Aug 2018 05:05:50 GMT

Hi,

Could you please disable the secondary OTP authentication and try to send the email?

Warm Regards,

Nikhil Thampi

Re: Unable to send emails using Gmail: tSendMail

Anonymous — Mon, 13 Aug 2018 06:28:13 GMT

Thanks Nikhil !!

I couldn't able to do that as you said. Please find the screenshot below. Please suggest If any other approach for this.

Re: Unable to send emails using Gmail: tSendMail

Anonymous — Mon, 13 Aug 2018 09:43:51 GMT

Hi,

Could you please create another email id and try to send the mail where you need to turn off the two step authentication?

Warm Regards,

Nikhil Thampi

Re: Unable to send emails using Gmail: tSendMail

Anonymous — Mon, 13 Aug 2018 12:32:49 GMT

Hi,

I have tried using another email with 2nd step verification turned off. But I couldn't able to send mail in this step as well.

Re: Unable to send emails using Gmail: tSendMail

Anonymous — Wed, 15 Aug 2018 23:52:04 GMT

I have used the Gmail App Password and tsendmail is working fine now.

App Password can be taken from Google account settings.