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 OCTOBER 10, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms