1 Reply Latest reply on Feb 9, 2012 2:39 PM by robleskein

    ODI HTML Mail error

    802827
      Hello All,

      I am unable to send a mail using ODI send Mail. As an alternative i downloaded the jython script "TRT_Send_Jython_HTML_Email.xml" from the oracle support.

      When i am trying to execute the above procedure i am getting the following error.

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (most recent call last):
      File "<string>", line 3, in <module>
      File "C:\ODI11\oracledi\client\jdev\extensions\oracle.odi.navigator\scripting\Lib\smtplib.py", line 676, in sendmail
      if not (200 <= self.ehlo()[0] <= 299):
      File "C:\ODI11\oracledi\client\jdev\extensions\oracle.odi.navigator\scripting\Lib\smtplib.py", line 398, in ehlo
      (code,msg)=self.getreply()
      File "C:\ODI11\oracledi\client\jdev\extensions\oracle.odi.navigator\scripting\Lib\smtplib.py", line 352, in getreply
      line = self.file.readline()
      File "C:\ODI11\oracledi\client\jdev\extensions\oracle.odi.navigator\scripting\Lib\socket.py", line 1347, in readline
      data = self._sock.recv(self._rbufsize)
      File "C:\ODI11\oracledi\client\jdev\extensions\oracle.odi.navigator\scripting\Lib\socket.py", line 902, in recv
      raise mapexception(jlx)
      socket.error: (55, 'Software caused connection abort')

           at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
           at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:346)
           at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2458)
           at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48)
           at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.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 help me in this...


      thanks
      Ravikiran
        • 1. Re: ODI HTML Mail error
          robleskein
          Why can't you use ODI sendmail? Are you getting an error from it? I've used it successfully for some time now.
          The socket error tells me there's a network problem. Are you able to send e-mail from the machine where the ODI agent is? Did you try telnet <your SMTP server IP> 25 ?