Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
57
Views
5
Comments
2729754
2729754 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

<?xml version="1.0" encoding="ISO-8859-1"?>

<SunopsisExport>

<Admin RepositoryVersion="04.03.04.02" />

<Object class="com.sunopsis.dwg.dbobj.SnpSession">

  <Field name="AgentName" type="java.lang.String"><![CDATA[OracleDIAgent]]></Field>

  <Field name="ContextCode" type="java.lang.String"><![CDATA[GLOBAL]]></Field>

  <Field name="ErrorMessage" type="java.lang.String"><![CDATA[ODI-1217: Session GENERATE_SUMMARY_REPORT (2094500) 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 "<string>", line 76, in <module>

>>>>>>Raising Custom Exception>>>>>> Error generating report file: /u01/app/obitest/product/fmw11g/instances/instance1/biapps/logs/etl/BIA_DW_ETL_LPI_Summary_10500_1_2094500.html

java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

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:2474)
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:2925)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
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:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1899)
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:85)
at java.lang.Thread.run(Thread.java:662)

Caused by: Traceback (most recent call last):

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

We are using linux. Please help to solve the issue. Thanks,

Answers

  • Venkata Yaswanth Ramisetty
    Venkata Yaswanth Ramisetty Rank 5 - Community Champion

    Hi,

    Are you able to access the path /u01/app/obitest/product/fmw11g/instances/instance1/biapps/logs/etl/ ?

    If possible share us the screenshot of the error to debug more.

    Thanks,

    Yaswanth

  • 2729754
    2729754 Rank 1 - Community Starter

    Hi Venkata,

    Thanks for response. Yes we can access the this path and there is no error while accessing.

    Thanks,

  • Venkata Yaswanth Ramisetty
    Venkata Yaswanth Ramisetty Rank 5 - Community Champion

    Hi,

    Can you share us the screenshot of the error in the load plan.

    Thanks,

    Yaswanth

  • 2729754
    2729754 Rank 1 - Community Starter

    pastedImage_0.png

  • Venkata Yaswanth Ramisetty
    Venkata Yaswanth Ramisetty Rank 5 - Community Champion

    Hi,

    Share the session report any time when anyone ask  for screenshot to be a best practice because it will be the lowest level the granularity which helps to debug the issue easily instead of multiple cross questions. Can you share the session log like below so that we can trace easily at which step the load failed.

    pastedImage_0.png

    Thanks,

    Yaswanth