My Oracle Support Banner

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

Last updated on JANUARY 20, 2021

Applies to:

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


In OBIA, 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: ODI-17517: Error during task interpretation.
Task: 4
java.lang.Exception: The application script threw an exception: 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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.