Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ODIReadMail throws error

3753403Aug 23 2019

Hi,

I am using OdiReadMail to download attachments from a mail box like user@ourcompany.com. But we don't have an internal mail server. I am asked to use outlook.office365.com as mail server hostname. \

When i use no protocol, by default POP3 as ODI says, i'm getting below error:

ODI-1217: Session ULTIPRO_TO_EMP (9106) fails with return code 7000.

ODI-1226: Step OdiReadMail 1 fails after 1 attempt(s).

ODI-1241: Oracle Data Integrator tool execution fails.

Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Command is not valid in this state.

at com.sunopsis.dwg.tools.ReadMail.actionExecute(ReadMail.java:282)

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)

at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)

at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)

at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)

at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)

at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)

at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)

at java.lang.Thread.run(Thread.java:748)

Caused by: javax.mail.AuthenticationFailedException: Command is not valid in this state.

at com.sun.mail.pop3.POP3Store.protocolConnect(POP3Store.java:213)

at javax.mail.Service.connect(Service.java:366)

at com.sunopsis.dwg.tools.ReadMail.getConnected(ReadMail.java:937)

at com.sunopsis.dwg.tools.ReadMail.actionExecute(ReadMail.java:243)

... 20 more

I added below java options to product.conf file on %APPDATA%/Roaming/odi/12.2.1 as suggested in https://support.oracle.com/epmos/faces/BugDisplay?parent=DOCUMENT&sourceId=1989375.1&id=20576502

-Dmail.imap.starttls.enable=true

-Dmail.smtp.starttls.enable=true

Comments
Post Details