Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to send emails using Gmail: tSendMail

Hi,

 

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

 

0683p000009Lzqs.jpg

 

 

0683p000009LzPd.jpg

 

 

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 !!

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

App Password can be taken from Google account settings.

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Hi,

 

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

 

Warm Regards,

 

Nikhil Thampi

Anonymous
Not applicable
Author

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.

0683p000009Lzs0.jpg

Anonymous
Not applicable
Author

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

 

Anonymous
Not applicable
Author

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.

 

0683p000009LzaW.jpg

Anonymous
Not applicable
Author

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

App Password can be taken from Google account settings.