Forum Stats

  • 3,759,064 Users
  • 2,251,495 Discussions
  • 7,870,478 Comments

Discussions

Import Data fails in ERPI

Hi All,

I am trying to Import data in ERPI. I am on FDMEE Version 11.1.2.3.500.9

Error I am getting:

ODI-1226: Step EBS Extract Type fails after 1 attempt(s).

ODI-1240: Flow EBS Extract Type fails while performing a Loading operation. This flow loads target table AIF_GL_LOAD_AUDIT.

Caused By: org.apache.bsf.BSFException: exception from Jython:

Traceback (most recent call last):

  File "<string>", line 12, in <module>

  at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)

  at java.lang.Long.parseLong(Long.java:431)

  at java.lang.Long.<init>(Long.java:678)

  at sun.reflect.GeneratedConstructorAccessor903.newInstance(Unknown Source)

  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

  at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)

java.lang.NumberFormatException: java.lang.NumberFormatException: For input string: ""

  at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)

  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)

  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:2913)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)

  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)

  at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)

  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)

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

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

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

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

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

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

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

  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.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:57)

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

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

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

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

  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)

Caused by: Traceback (most recent call last):

  File "<string>", line 12, in <module>

  at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)

  at java.lang.Long.parseLong(Long.java:431)

  at java.lang.Long.<init>(Long.java:678)

  at sun.reflect.GeneratedConstructorAccessor903.newInstance(Unknown Source)

  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

  at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)

java.lang.NumberFormatException: java.lang.NumberFormatException: For input string: ""

  at org.python.core.PyException.fillInStackTrace(PyException.java:70)

  at java.lang.Throwable.<init>(Throwable.java:181)

  at java.lang.Exception.<init>(Exception.java:29)

  at java.lang.RuntimeException.<init>(RuntimeException.java:32)

  at org.python.core.PyException.<init>(PyException.java:46)

  at org.python.core.PyException.<init>(PyException.java:43)

  at org.python.core.Py.JavaError(Py.java:455)

  at org.python.core.Py.JavaError(Py.java:448)

  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:173)

  at org.python.core.PyReflectedConstructor.__call__(PyReflectedConstructor.java:138)

  at org.python.core.PyObject.__call__(PyObject.java:355)

  at org.python.core.PyMethod.__call__(PyMethod.java:215)

  at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)

  at org.python.core.PyMethod.__call__(PyMethod.java:206)

  at org.python.core.PyObjectDerived.dispatch__init__(PyObjectDerived.java:1097)

  at org.python.core.PyType.invoke_new_(PyType.java:444)

  at org.python.core.PyType.type___call__(PyType.java:1397)

  at org.python.core.PyType.__call__(PyType.java:1388)

  at org.python.core.PyObject.__call__(PyObject.java:397)

  at org.python.core.PyObject.__call__(PyObject.java:401)

  at org.python.pycode._pyx251.f$0(<string>:17)

  at org.python.pycode._pyx251.call_function(<string>)

  at org.python.core.PyTableCode.call(PyTableCode.java:165)

  at org.python.core.PyCode.call(PyCode.java:18)

  at org.python.core.Py.runCode(Py.java:1204)

  at org.python.core.Py.exec(Py.java:1248)

  at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)

  at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)

  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)

  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)

  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)

  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:2913)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)

  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

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

  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)

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

  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

  at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

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

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

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

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

  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)

  ... 6 more

Caused by: java.lang.NumberFormatException: For input string: ""

  at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)

  at java.lang.Long.parseLong(Long.java:431)

  at java.lang.Long.<init>(Long.java:678)

  at sun.reflect.GeneratedConstructorAccessor903.newInstance(Unknown Source)

  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

  at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

  at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:163)

  ... 69 more

Please help !!

Regards,

Aman

Tagged:
This discussion has been closed.