Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i keep getting this error
Exception in component tSendMail_1 (SQL_Server_stored_Proc)
javax.mail.AuthenticationFailedException: 535 5.7.139 Authentication unsuccessful, the request did not meet the criteria to be authenticated successfully. Contact your administrator. [BY1P220CA0011.NAMP220.PROD.OUTLOOK.COM 2025-08-04T21:12:49.628Z 08DDD2FDDF74F2E2]
any ideas of where to start to resolve this issue?
some info.
that is the version of talend we are using not sure if it matters
installed all the jars talend asked for to use the tsend component
i checked with my IT for MFA, we had emails with MFA so i had them create an email no MFA
same issue; hoping someone can shed some light on this, thank you very much.
Hi!
so i did what you asked
looks like im getting the same error?
[DEBUG] 08:39:46 talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc- tSendMail_1 - Start to work.
[DEBUG] 08:39:46 talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc- tSendMail_1 - Parameters:TO = "jchuan@picf.org" | FROM = "analytics@picf.org" | NEED_PERSONAL_NAME = false | CC = | BCC = | SUBJECT = "Talend Open Studio notification" | MESSAGE = "Hello" | CHECK_ATTACHMENT = true | ATTACHMENTS = [] | HEADERS = [] | SMTP_HOST = "smtp.office365.com" | SMTP_PORT = 587 | SSL = false | STARTTLS = true | IMPORTANCE = Normal | AUTH_MODE = BASIC | AUTH_USERNAME = "Analytics@picf.org" | AUTH_PASSWORD = enc:... | DIE_ON_ERROR = true | TEXT_SUBTYPE = plain | ENCODING = "ISO-8859-15" | SET_LOCALHOST = false | CONFIGS = [] |
[INFO ] 08:39:46 talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc- tSendMail_1 - Connection attempt to 'smtp.office365.com'.
DEBUG: Jakarta Mail version 1.6.7
DEBUG: successfully loaded resource: /META-INF/javamail.default.providers
DEBUG: Tables of loaded providers
DEBUG: Providers Listed By Class Name: {com.sun.mail.smtp.SMTPTransport=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle], com.sun.mail.imap.IMAPSSLStore=javax.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Oracle], com.sun.mail.pop3.POP3Store=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Oracle], com.sun.mail.smtp.SMTPSSLTransport=javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle], com.sun.mail.imap.IMAPStore=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Oracle], com.sun.mail.pop3.POP3SSLStore=javax.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Oracle]}
DEBUG: Providers Listed By Protocol: {imap=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Oracle], smtp=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle], pop3=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Oracle], imaps=javax.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Oracle], smtps=javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Oracle], pop3s=javax.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Oracle]}
DEBUG: successfully loaded resource: /META-INF/javamail.default.address.map
[INFO ] 08:39:46 talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc- tSendMail_1 - Connection to 'smtp.office365.com' has succeeded.
DEBUG: getProvider() returning javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Oracle]
DEBUG SMTP: need username and password for authentication
DEBUG SMTP: protocolConnect returning false, host=smtp.office365.com, user=jchuan, password=<null>
DEBUG SMTP: useEhlo true, useAuth true
DEBUG SMTP: trying to connect to host "smtp.office365.com", port 587, isSSL false
220 SJ0PR05CA0110.outlook.office365.com Microsoft ESMTP MAIL Service ready at Tue, 5 Aug 2025 15:39:46 +0000 [08DDD3CC0ABC3889]
DEBUG SMTP: connected to host "smtp.office365.com", port: 587
EHLO J-Chuan.picf.org
250-SJ0PR05CA0110.outlook.office365.com Hello [172.222.140.11]
250-SIZE 157286400
250-PIPELINING
250-DSN
250-ENHANCEDSTATUSCODES
250-STARTTLS
250-8BITMIME
250-BINARYMIME
250-CHUNKING
250 SMTPUTF8
DEBUG SMTP: Found extension "SIZE", arg "157286400"
DEBUG SMTP: Found extension "PIPELINING", arg ""
DEBUG SMTP: Found extension "DSN", arg ""
DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""
DEBUG SMTP: Found extension "STARTTLS", arg ""
DEBUG SMTP: Found extension "8BITMIME", arg ""
DEBUG SMTP: Found extension "BINARYMIME", arg ""
DEBUG SMTP: Found extension "CHUNKING", arg ""
DEBUG SMTP: Found extension "SMTPUTF8", arg ""
STARTTLS
220 2.0.0 SMTP server ready
EHLO J-Chuan.picf.org
250-SJ0PR05CA0110.outlook.office365.com Hello [172.222.140.11]
250-SIZE 157286400
250-PIPELINING
250-DSN
250-ENHANCEDSTATUSCODES
250-AUTH LOGIN XOAUTH2
250-8BITMIME
250-BINARYMIME
250-CHUNKING
250 SMTPUTF8
DEBUG SMTP: Found extension "SIZE", arg "157286400"
DEBUG SMTP: Found extension "PIPELINING", arg ""
DEBUG SMTP: Found extension "DSN", arg ""
DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""
DEBUG SMTP: Found extension "AUTH", arg "LOGIN XOAUTH2"
DEBUG SMTP: Found extension "8BITMIME", arg ""
DEBUG SMTP: Found extension "BINARYMIME", arg ""
DEBUG SMTP: Found extension "CHUNKING", arg ""
DEBUG SMTP: Found extension "SMTPUTF8", arg ""
DEBUG SMTP: protocolConnect login, host=smtp.office365.com, user=Analytics@picf.org, password=<non-null>
DEBUG SMTP: Attempt to authenticate using mechanisms: LOGIN PLAIN DIGEST-MD5 NTLM XOAUTH2
DEBUG SMTP: Using mechanism LOGIN
AUTH LOGIN
334 VXNlcm5hbWU6
QW5hbHl0aWNzQHBpY2Yub3Jn
334 UGFzc3dvcmQ6
UGljQW5hODA0Iw==
535 5.7.139 Authentication unsuccessful, the request did not meet the criteria to be authenticated successfully. Contact your administrator. [SJ0PR05CA0110.namprd05.prod.outlook.com 2025-08-05T15:39:53.960Z 08DDD3CC0ABC3889]
Exception in component tSendMail_1 (SQL_Server_stored_Proc)
javax.mail.AuthenticationFailedException: 535 5.7.139 Authentication unsuccessful, the request did not meet the criteria to be authenticated successfully. Contact your administrator. [SJ0PR05CA0110.namprd05.prod.outlook.com 2025-08-05T15:39:53.960Z 08DDD3CC0ABC3889]
at com.sun.mail.smtp.SMTPTransport$Authenticator.authenticate(SMTPTransport.java:947)
at com.sun.mail.smtp.SMTPTransport.authenticate(SMTPTransport.java:858)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:762)
at javax.mail.Service.connect(Service.java:364)
at javax.mail.Service.connect(Service.java:222)
at javax.mail.Service.connect(Service.java:171)
at javax.mail.Transport.send0(Transport.java:230)
at javax.mail.Transport.send(Transport.java:100)
at talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc.tSendMail_1Process(SQL_Server_stored_Proc.java:2973)
at talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc.runJobInTOS(SQL_Server_stored_Proc.java:3881)
at talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc.main(SQL_Server_stored_Proc.java:3562)
[FATAL] 08:39:53 talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc- tSendMail_1 535 5.7.139 Authentication unsuccessful, the request did not meet the criteria to be authenticated successfully. Contact your administrator. [SJ0PR05CA0110.namprd05.prod.outlook.com 2025-08-05T15:39:53.960Z 08DDD3CC0ABC3889]
javax.mail.AuthenticationFailedException: 535 5.7.139 Authentication unsuccessful, the request did not meet the criteria to be authenticated successfully. Contact your administrator. [SJ0PR05CA0110.namprd05.prod.outlook.com 2025-08-05T15:39:53.960Z 08DDD3CC0ABC3889]
at com.sun.mail.smtp.SMTPTransport$Authenticator.authenticate(SMTPTransport.java:947) ~[jakarta.mail-1.6.7.jar:1.6.7]
at com.sun.mail.smtp.SMTPTransport.authenticate(SMTPTransport.java:858) ~[jakarta.mail-1.6.7.jar:1.6.7]
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:762) ~[jakarta.mail-1.6.7.jar:1.6.7]
at javax.mail.Service.connect(Service.java:364) ~[jakarta.mail-1.6.7.jar:1.6.7]
at javax.mail.Service.connect(Service.java:222) ~[jakarta.mail-1.6.7.jar:1.6.7]
at javax.mail.Service.connect(Service.java:171) ~[jakarta.mail-1.6.7.jar:1.6.7]
at javax.mail.Transport.send0(Transport.java:230) ~[jakarta.mail-1.6.7.jar:1.6.7]
at javax.mail.Transport.send(Transport.java:100) ~[jakarta.mail-1.6.7.jar:1.6.7]
at talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc.tSendMail_1Process(SQL_Server_stored_Proc.java:2973) [classes/:?]
at talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc.runJobInTOS(SQL_Server_stored_Proc.java:3881) [classes/:?]
at talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc.main(SQL_Server_stored_Proc.java:3562) [classes/:?]
[statistics] disconnected
[INFO ] 08:39:53 talend_di_project.sql_server_stored_proc_0_1.SQL_Server_stored_Proc- TalendJob: 'SQL_Server_stored_Proc' - Finished - status: failure returnCode: 1
Job SQL_Server_stored_Proc ended at 08:39 05/08/2025. [Exit code = 1]
