My Oracle Support Banner

Loading Data To OFSAA (vSess) Fails With Exception "com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpret" (Doc ID 2620338.1)

Last updated on DECEMBER 18, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Symptoms

When executing a batch to move dimension data with Oracle Data Integrator (ODI) using the Data Integration Hub (DIH) connector to Oracle Financial Services Analytical Application (OFSAA), the following error occurs:

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: BeanShell script error: Sourced file: inline evaluation of: ``out.print("create table OFSATM.\"C$_") ; out.print(vSess) ; out.print("0DS_22597 . . . '' : Undefined argument: vSess : at Line: 2 : in file: inline evaluation of: ``out.print("create table OFSATM.\"C$_") ; out.print(vSess) ; out.print("0DS_22597 . . . '' : ( vSess )
 BSF info: null at line: 0 column: columnNo, Pre-execution code:
out.print("create table OFSATM.\"C$_") ;
out.print(vSess) ;
out.print("0DS_225975\"\n(\n\tN_PRODUCT_DISPLAY_CODE\tNUMBER(14) NULL,\n\tV_ATTRIBUTE_VARCHAR_LABEL\tVARCHAR2(30) NULL,\n\tV_ATTRIBUTE_ASSIGN_VALUE\tVARCHAR2(1000) NULL\n)\nNOLOGGING ") ;

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.