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!

Source System Initialization fails (FDMEE to EBS Integration)

shiv2Sep 23 2014 — edited Nov 12 2014

Hi,

Please comment is someone faced similar issue in past

Need help in below issue I am facing while initializing the Source system that is EBS 11i.

It is FDMEE 11.1.2.3 with latest patch.

Getting Below error

Session COMM_SETUP_SOURCE_SYSTEM
Step Name Launch EBS Setup Source System
Step Type ODI Command
Order Number 12
Context GLOBAL
Context GLOBAL
Maximum Number Of Errors 
Number of Executions 1

    Execution Statistics ? 
  

 
Start Date Monday, September 22, 2014 7:35:54 AM GMT+00:00
End Date Monday, September 22, 2014 7:40:54 AM GMT+00:00
Duration (s) 300
Status 
Return Code 7000
Message ODI-1226: Step Launch EBS Setup Source System fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: oracle.odi.runtime.agent.invocation.InvocationException: HTTP/1.1 503 Service Temporarily Unavailable
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:247)
at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:162)
at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:129)
at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:269)
at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.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$2.run(DefaultAgentTaskExecutor.java:83)
at java.lang.Thread.run(Thread.java:662)


    Record Statistics ? 
  

 
No. of Inserts 0
No. of Updates 0
No. of Deletes 0
No. of Errors 0

AND in FDMEE log I am getting  below Error

2014-09-22 07:35:48,996 INFO  [AIF]: FDMEE Process Start, Process ID: 61

2014-09-22 07:35:49,011 INFO  [AIF]: FDMEE Logging Level: 5

2014-09-22 07:35:49,011 INFO  [AIF]: FDMEE Log File: D:\GENFDM\outbox\logs\GEN-APPS_61.log

2014-09-22 07:35:49,011 INFO  [AIF]: User:admin

2014-09-22 07:35:49,011 INFO  [AIF]: Location:NA (Partitionkey:null)

2014-09-22 07:35:49,011 INFO  [AIF]: Period Name:NA (Period Key:null)

2014-09-22 07:35:49,011 INFO  [AIF]: Category Name:NA (Category key:null)

2014-09-22 07:35:49,011 INFO  [AIF]: Rule Name:NA (Rule ID:null)

2014-09-22 07:35:54,190 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

[Oracle JRockit(R) (Oracle Corporation)]

2014-09-22 07:35:54,190 INFO  [AIF]: Java Platform: java1.6.0_37

2014-09-22 07:40:54,806 FATAL [AIF]: Error in Launch EBS Setup Source System

2014-09-22 07:40:54,884 INFO  [AIF]: FDMEE Process End, Process ID: 61

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2014
Added on Sep 23 2014
2 comments
2,670 views