My Oracle Support Banner

EXEC_TABLE_MAINT_PROC Fails In Full Load Due To ODI-17517 (Doc ID 2738547.1)

Last updated on DECEMBER 13, 2023

Applies to:

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

Symptoms

While running a load for the first time in 11.1.1.10.3, Domain load runs successfully but the full load fails with an Error within Source Extract Phase --> General --> General SIL --> Parallel --> 3 SIL General --> Initialize General --> Initialize: W_EXCH_RATE_G

The below error is seen for the corresponding session.

 

[CDATA[ODI-1217: Session EXEC_TABLE_MAINT_PROC (6198) fails with return code 7000.

ODI-1226: Step TABLE_MAINT_PROC fails after 1 attempt(s).
ODI-1232: Procedure TABLE_MAINT_PROC execution fails.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
Task: 7
java.lang.Exception: BeanShell script error: Sourced file: inline evaluation of: ''out.print("/*\n") ; import java.lang.Exception; import java.sql.Connection; i . . . '' : Void assignment. : at Line: 299 : in file: inline evaluation of: ''out.print("/*\n") ; import java.lang.Exception; import java.sql.Connection; i . . . '' : vtm_tab .mIsIncremental = vtmBaseTabIsIncr
BSF info: Build Table List at line: 0 column: columnNo

Changes

 Running a load for the first time in 11.1.1.10.3

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
Changes
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.