2 Replies Latest reply on Dec 22, 2011 6:12 AM by Phanikanth

    odisendmail error

    904205
      how to rectify below error:

      ODI-1226: Step sending mail fails after 1 attempt(s).
      ODI-1241: Oracle Data Integrator tool execution fails.
      Caused By: com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. yg2sm28557161igb.1

           at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1388)
           at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959)
           at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583)
           at javax.mail.Transport.send0(Transport.java:169)
           at javax.mail.Transport.send(Transport.java:99)
           at com.sunopsis.dwg.tools.SendMail.actionExecute(SendMail.java:220)
           at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3430)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1491)
           at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)
           at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
           at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:540)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:338)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:272)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:263)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:822)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
           at java.lang.Thread.run(Thread.java:662)

      please share your opinions on this post

      Regards,
      sh.
        • 1. Re: odisendmail error
          Bhabani Ranjan Mahapatra
          Hi
          This is problem with ur smtp.What are you giving in your host credentials.Have you asked your dba for mail host credentials?You should keep in mind that
          if the mail server is gmail/yahoomail. it requires Authentication and the port numbedetails like 465 for ssl and 587 for TLS. odisendmail has no option to configure port number and user login and password for authentication. also odisendmail will not work over SSL or TLS.
          you can set up smtp else you install hmailserver for windows machine and proceed with the manuals mentioned in the website.
          http://www.hmailserver.com/index.php?page=welcome

          If you need authenticated smtp then you need to write procedure.Login to oracle support and read it
          How To Send Email Messages Through An Authenticated SMTP Server with ODI ? [ID 424304.1]

          Thanks
          1 person found this helpful
          • 2. Re: odisendmail error
            Phanikanth
            Hi SH,


            OdiSendMail, multiple lines in the message

            Regards,
            Phanikanth