"The Physical Path Is Not Ending With A Slash" Error Received in ODI 12c when Extracting Data from SAP to Oracle

(Doc ID 2367142.1)

Last updated on MARCH 05, 2018

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12c, when attempting to extract data from SAP using the Learning Knowledge Module (LKM) SAP BW to Oracle (SQLLDR), the following error occurs:

ERROR
-----------------------
[2017-10-30T16:46:45.530+01:00] [odi] [WARNING] [ODI-1134] [oracle.odi.agent] [tid: 346] [ecid: 0000LxhaBms2zGaLxMo2yW1Pxn5F000002,0:9450:60:57] [oracle.odi.runtime.MrepExtId: 1506328643140] [oracle.odi.runtime.AgentName: <AGENT_NAME>] [oracle.odi.runtime.ExecPhase: ExecuteTask] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.WrepName: WORKREP] [oracle.odi.runtime.EntityGuid: f9b4dfc7-9ae1-48a1-b600-6d42146c2920] [oracle.odi.runtime.SessName: <SESSION_NAME>_Physical_SESS] [oracle.odi.runtime.SessId: 1470] [oracle.odi.runtime.SessStep: 10/Physical_STEP/1] [oracle.odi.runtime.SessTask: 10.150/Extract Data,LKM SAP BW to Oracle (SQLLDR),null] [oracle.odi.runtime.ExecHierarchy: 1470] Agent <AGENT_NAME> encountered an error: ODI-1226: Step Physical_STEP fails after 1 attempt(s).
[2017-10-30T16:46:45.538+01:00] [odi] [ERROR] [ODI-1217] [oracle.odi.agent] [tid: 346] [ecid: 0000LxhaBms2zGaLxMo2yW1Pxn5F000002,0:9450:60:57] [oracle.odi.runtime.MrepExtId: 1506328643140] [oracle.odi.runtime.AgentName: <AGENT_NAME>] [oracle.odi.runtime.ExecPhase: ExecuteTask] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.WrepName: WORKREP] [oracle.odi.runtime.EntityGuid: f9b4dfc7-9ae1-48a1-b600-6d42146c2920] [oracle.odi.runtime.SessName: <SESSION_NAME>_Physical_SESS] [oracle.odi.runtime.SessId: 1470] [oracle.odi.runtime.SessStep: 10/Physical_STEP/1] [oracle.odi.runtime.SessTask: 10.150/Extract Data,LKM SAP BW to Oracle (SQLLDR),null] [oracle.odi.runtime.ExecHierarchy: 1470] Session <SESSION_NAME>_Physical_SESS (1470) fails with return code ODI-1298.[[
ODI-1217: Session <SESSION_NAME>_Physical_SESS (1470) fails with return code ODI-1298.
ODI-1226: Step Physical_STEP fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection .
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-SAP_BW_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-SAP_BW_UNIT (20)" failed because child task "Extract Data-LKM SAP BW to Oracle (SQLLDR)- (150)" is in error.
Caused By: oracle.odi.km.exception.OdiKMException: Error occurred in open tool execute method: {0}...Error in executing ABAP program: {0}...Error in executing ABAP program: {0}...
The physical path is not ending with a slash
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
....
....

Changes

 

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