OBIA 11g: Many loads fail with error - "Lookup based on datasource 11 failed to get SDS schema BSF info: Initialization and log header at line: 0 column: columnNo" (Doc ID 2120115.1)

Last updated on AUGUST 11, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

 
On Oracle Business Intelligence Applications (OBIA) version : 11.1.1.10.1

Source and its version :Oracle E-Business Suite 12.1.3
Modules implemented : Financial Analytics.

During Full Load, Many session have failed with the following error

<![CDATA[ODI-1217: Session SDE_ORAR1213_ADAPTOR_SDE_ORA_DOMAINGENERAL_PROJECTNONLABORRESOURCE (829500) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942:
ORA-06512: at line 49

<![CDATA[
com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 3
java.lang.Exception: The application script threw an exception: java.lang.Exception: Lookup based on datasource 11 failed to get SDS schema BSF info: Initialization and log header at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:570)
at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:744)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$3.doAction(QueuedSessionsExecutor.java:246)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.executeQueuedSessions(QueuedSessionsExecutor.java:167)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.executeQueuedSessions(QueuedSessionsExecutor.java:99)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:707)
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)
Caused by: org.apache.bsf.BSFException: The application script threw an exception: java.lang.Exception: Lookup based on datasource 11 failed to get SDS schema BSF info: Initialization and log header at line: 0 column: columnNo
at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:556)
... 12 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms