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!

ODI Fails with "unexpected exception occured" Error

EBDJan 7 2016 — edited Jan 14 2016

Hello All,

I'm having an issue with ODI where it seems that the connection between ODI and the FDMEE 11.1.2.4.1 repository is severed due to a network of firewall issue. This occurs about once a week so thats why I suspect its a network issue however I nor Oracle Support can pinpoint the exact issue. I'll be able to run flat file data loads through-out the week and then it seems like randomly, I'll run a data load and the session will hang and not be assigned an ODI session code under process details in FDMEE. I checked the ERP0.log and it doesn't specify what the exact issue is.

Bouncing the server fixes the issue but then the issue will occur a week later and its not practical to bounce the server every single week.

Here is the log:

[2016-01-07T09:28:31.944-08:00] [EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 40] [userId: <anonymous>] [ecid: 00iXpWCAJJuFw00Fzzw0w00000hc00003N,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl] [SRC_METHOD: invoke_odi_process] Rule Name:HIST_RULE (Rule ID:29)

[2016-01-07T09:28:32.589-08:00] [EPMServer0] [NOTIFICATION] [EPMFDM-140140] [oracle.apps.erpi.model] [tid: 40] [userId: <anonymous>] [ecid: 00iXpWCAJJuFw00Fzzw0w00000hc00003N,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl] [SRC_METHOD: invoke_odi_process] An Error occurred while invoking ODI process.

[2016-01-07T09:28:32.589-08:00] [EPMServer0] [ERROR] [EPMFDM-140140] [oracle.apps.erpi.model] [tid: 40] [userId: <anonymous>] [ecid: 00iXpWCAJJuFw00Fzzw0w00000hc00003N,0:1:4] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.util.RuleServiceExecutor] [SRC_METHOD: executeDataRule] An Error occurred while invoking ODI process.[[

oracle.odi.runtime.agent.invocation.InvocationException: ODI-1220: Session preparation failure: an unexpected exception occurred.

Caused By: java.lang.NullPointerException

at oracle.odi.runtime.agent.coherence.OdiDisconnectedRepositoryList.isRepositoryDown(OdiDisconnectedRepositoryList.java:78)

at oracle.odi.runtime.agent.mbeans.SessionInformationBean.isWorkRepositoryDown(SessionInformationBean.java:567)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$1.doAction(StartScenRequestProcessor.java:297)

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

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.goPrepareOrDelegatePrepare(StartScenRequestProcessor.java:287)

at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doPrepareAgentTask(StartScenRequestProcessor.java:216)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:81)

at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:564)

at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:518)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

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

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartScenario(RemoteRuntimeAgentInvoker.java:604)

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartScenario(RemoteRuntimeAgentInvoker.java:565)

at com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl.invoke_odi_process(GLIntegrationBaseAMImpl.java:610)

at com.hyperion.aif.util.RuleServiceExecutor.executeDataRule(RuleServiceExecutor.java:398)

at com.hyperion.aif.gl.common.data.model.applicationModule.DataRuleAMImpl.executeRule(DataRuleAMImpl.java:1446)

at com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl.execDataRule(WorkBenchAMImpl.java:1415)

at com.hyperion.aif.workbench.model.applicationModule.WorkBenchAMImpl.executeImport(WorkBenchAMImpl.java:1269)

at com.hyperion.aif.workbench.userinterface.backing.WorkBenchBacking.executeRule(WorkBenchBacking.java:199)

at com.hyperion.aif.workbench.userinterface.backing.WorkBenchBacking.executeRule(WorkBenchBacking.java:1819)

at com.hyperion.aif.workbench.userinterface.backing.WorkBenchBacking.checkOverrideWarn(WorkBenchBacking.java:1810)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sun.el.parser.AstValue.invoke(AstValue.java:187)

at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)

at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:190)

at oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:181)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.broadcastEvents(LifecycleImpl.java:1100)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:446)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:219)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:211)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:131)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:447)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:447)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)