Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieve previous step task log

XavierGrosfilsMay 29 2020 — edited Jun 9 2020

Hello,

I have an issue with mailing error logs (ODI 12.2.1.3).

I have packages that have this structure :

pastedImage_0.png

It start a scen and if any error unhandled it send an emails to operators.

To get the error message I use odiRef.getPrevStepLog("MESSAGE").

Unfortunatly the error message will always be :

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

ODI-1241: Oracle Data Integrator tool execution fails.

at oracle.odi.runtime.agent.execution.AbstractSessionTask.getExceptionOnStepTaskFailure(AbstractSessionTask.java:1509)

at oracle.odi.runtime.agent.execution.AbstractSessionTask.treatStepTaskError(AbstractSessionTask.java:1394)

at oracle.odi.runtime.agent.execution.AbstractSessionTask.postProcess(AbstractSessionTask.java:1365)

That's the Error Message for the start scen at step level while I would liek to have the full error from task level. It contains the real root cause "Caused By:..."

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

ODI-1241: Oracle Data Integrator tool execution fails.

Caused By: oracle.odi.runtime.agent.invocation.InvocationException: https://prodagent.net:15101/oraclediagent:java.net.SocketException: Connection reset

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:498)

at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)

at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:274)

at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:222)

I join concrete screenshots afterwards.

Problem is from the emails, we have no clue about what the real problem is, operator have to open the studio or web console...

Anyone faced this and found/developped a solution?

Thanks for help,

Xavier

pastedImage_3.png

pastedImage_4.png

This post has been answered by XavierGrosfils on Jun 9 2020
Jump to Answer
Comments
Post Details