My Oracle Support Banner

OBIA11g After upgrading ODI Load Plan Failing with Error ODI-1217 Session EXEC_GENERIC_TABLE_MAINT_PROC fails with return code 7000. Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getSchemaName("CM_BIACM", "D") (Doc ID 2692253.1)

Last updated on AUGUST 11, 2020

Applies to:

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

Symptoms

On : 11.1.1.10.1 version, DataWarehouse

We have upgraded ODI from 11.1.1.7.0 to 11.1.1.9.0 version. After upgrade we have run the load plan for the first time .We are facing an Error
ODI-1217: Session EXEC_GENERIC_TABLE_MAINT_PROC fails with return code 7000.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 1
java.lang.Exception: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getSchemaName("XXX_BIACM", "D") : SnpPschemaCont.getObjectByIdent : SnpPschemaCont does not exist BSF info: Initialization and log header at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpTaskNameCodeInterpretor.transform(SnpTaskNameCodeInterpretor.java:570)

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
References


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