OBIA 11.1.1.10.1 - Load Plan 'Domain-only Extract and Load (SDE and SIL)' fails at Generate Failed T

Question

Hello, I have installed and configured OBI Apps 11.1.1.10.1 as per the documentation. Source System is Siebel CRM 8.2.2 When I am trying to run the Domain-only Extract and Load' , its failing with the following error message. ODI-1217: Session GENERATE_FAILED_TASKS_REPORT (230500) fails with return code 7000. ODI-1226: Step Generate Failed Tasks Report fails after 1 attempt(s). ODI-1232: Procedure Generate Failed Tasks Report execution fails. Caused By: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last): File "", line 11, in File "", line 11, in File "__pyclasspath__/codecs.py", line 817, in open IOError: [Errno 13] EACCES: 'C:\oracle\Middleware\instances\instance1\x08iapps/logs/etl/BIA_DW_ETL_LPI_Summary_1500_1_230500.html' 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: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:2925) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637) 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:2093) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84) at java.lang.Thread.run(Thread.java:745) I am not understanding from where its picking the path (mentioned in red). Can anybody help me with this regards ? Let me know if any more information is required. Thanks,

user1631962 · Answer

Thanks for the clarification ! I created a new Load Plan and then executed it. It worked fine with the new variables values.

Regards,

user1631962 · Answer

Thanks a lot !

The load plan execution worked now after I changed the path separator from \ to /

However one question to confirm my understanding - Since its a bug, do I change the other paths as well ? ie BIAPPS_DW_FILE and BIAPPS_DW_SHARED_FILE.

Regards,

841717 · Answer

You don't need to generate LP again. However, it will not work if you restart the same failed session again either. During next LP when new session for this task gets created, it should work fine.