The DIH connector execute is failing in the DIH. (Doc ID 2861113.1)

Last updated on APRIL 13, 2022

Applies to:

Symptoms

The DIH execution is failing.

[03-03-22 19:00:30.813][INFO ] [ScenarioExecutor$1][write] Error msg -
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-Oracle_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-Oracle_UNIT (20)" failed because child task "Create work table-LKM SQL to Oracle- (40)" is in error.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
 Task: 40
com.sunopsis.tools.core.exception.SnpsSimpleNLSMessageException: ODI-17810: Error during BeanShell evaluation: Sourced file: inline evaluation of: ``out.print("create table ODI_REPO.\"C$_") ; out.print(vSess) ; out.print("0I_3076 . . . '' : Undefined argument: vSess : at Line: 2 : in file: inline evaluation of: ``out.print("create table ODI_REPO.\"C$_") ; out.print(vSess) ; out.print("0I_3076 . . . '' : ( vSess )
 in inline evaluation of: ``out.print("create table ODI_REPO.\"C$_") ; out.print(vSess) ; out.print("0I_3076 . . . '' at line number 2, Pre-execution code:
out.print("create table ODI_REPO.\"C$_") ;
out.print(vSess) ;
out.print("0I_3076\"\n(\n\tV_GAAP_CODE\tVARCHAR2(6 CHAR) NULL,\n\tV_ACCOUNT_NUMBER\tVARCHAR2(50 CHAR) NULL,\n\tN_LOAD_RUN_ID\tNUMBER(10) NULL,\n\tFIC_MIS_DATE\tDATE NULL\n)\nNOLOGGING ") ;

When we run the sqlldr file it is giving the below error.

"Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL"

Cause

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