E1: TC: Foreign Table Connection via AS/400 EDRSQL Fails

(Doc ID 644598.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
IBM i on POWER Systems
Checked for relevance on Sep-08-2016

Symptoms

Table Conversion (TC) is set up with an Input/Output Foreign Table that resides on an AS/400 that does not have EnterpriseOne installed. EDRSQL services are running on both AS/400 servers. When the TC is run on the EnterpriseOne AS/400, it fails with the joblog error:

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