ODI-1217: Error: "Session DATALINEAGE_ETL_SDE_DL_ODI_DATASTORECOLUMN_DIMENSION (29218500) fails with return code 7000"
Last updated on MARCH 04, 2018
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
In OBIA 18.104.22.168.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.
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.
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