ERPi Source Initialization Fails using a Microsoft SQL Server ERPI database (Doc ID 1534955.1)

Last updated on SEPTEMBER 02, 2015

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.1.000 to 11.1.2.1.000 [Release 11.1]
Information in this document applies to any platform.
9.2.15

Symptoms

When attempting to initialize Source in ERPi 11.1.2.1.502 against a Microsoft SQL Server database this shows in ODI:

COMM_SETUP_SOURCE_SYSTEM - Oracle Data Integrator Command - Session Failed: 20501 ODI-1217: PS_GL_SETUP_SOURCE_SYSTEM failed with return code 7000

PS_GL_SETUP_SOURCE_SYSTEM - 14 PS Extract SetID   ODI-17517 Error during task interpretation - Task:21
Beanshell script error. Sourced file.  inline evaluation of out.print("drop table ..\I$_"); SESS_NOout.print("AIF_PS_SETID_TBL_STG\"");;""Attempt to resolve method:print() on undefined variable class name:SESS_NO ...

** Note **   The above example is from a Peoplesoft source initialization.  For EBS, the table names would be different.

Cause

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