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 AUGUST 06, 2024

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

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
Symptoms
Cause
Solution


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