My Oracle Support Banner

ODI 12c OdiSendMail Tool Cannot Send Email Using Office365 Account, Encounters Errors: "ODI-1217, ODI-1226, ODI-1241" and "530 5.7.57 SMTP; Client was not authenticated" (Doc ID 2312440.1)

Last updated on JANUARY 14, 2019

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When using an Office365 email account with ODI 12c to send email using the OdiSendMail tool, the following error is returned:

ODI-1217: Session <PACKAGE_NAME> (17944) fails with return code 7000.
ODI-1226: Step Send Mail (Office365) fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.57 SMTP; Client was not authenticated to send anonymous mail during MAIL FROM [mailhostname.prod.outlook.com]
  at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:2267)
  at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1758)
  at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:1257)
  at com.sunopsis.dwg.tools.SendMail.actionExecute(SendMail.java:207)
  at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:235)
  at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:902)
  at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:583)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)
  ...

Sample command:

OdiSendMail "-MAILHOST=smtp.office365.com" "-PORT=587" "-PROTOCOL=smtp" "-AUTH=YES" "-AUTHMECHANISMS=LOGIN" "-USER=xxxxxxx" "-PASS=xxxxxxxxx" "-FROM=xxxxxxx@xxxxxx.com" "-SUBJECT=xxxx" "-TO=xxxxxx@xxxxx.com"

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.