ODI-1217: Error: "Session DATALINEAGE_ETL_SDE_DL_ODI_DATASTORECOLUMN_DIMENSION (29218500) fails with return code 7000"

(Doc ID 1941389.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

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

Symptoms

In OBIA 11.1.1.8.1, The Data Lineage load plan failed at the scenario DATALINEAGE_ETL_SDE_DL_ODI_DATASTORECOLUMN_DIMENSION.

Error message is re-produced below:

ODI-1217: Session DATALINEAGE_ETL_SDE_DL_ODI_DATASTORECOLUMN_DIMENSION (29218500) fails with return code 7000.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 4
java.lang.Exception: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("R", "OBI_EXEC_SESS_", "D") : BSF info: Run Alter Session Commands-SRC (DB Link) at line: 0 column: columnNo.


Error occurs while simulating the respective package. Also noted in the package that 2 interfaces are trying to load into W_DATASTORE_COLUMN_D.



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