My Oracle Support Banner

E1:PKG: Full Package Build Failed From Deployment Server Only - PKGUTL0086 ERROR: Failed to Retrieve OL datasource For Table F9860 For Pathcode (Doc ID 1274076.1)

Last updated on JULY 18, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

Symptoms

Scenario 1

Full package build failed from deployment server only. Customer in EnterpriseOne 8.9 application release level TR 8.96_D1 and trying to build a Full Package for their custom pathcode named PU9 from deployment server, DEP9 environment and it is failing. If they build the package from a client workstation, it works fine.
Errors found in the ClientPkgBuild.log:

(...) Wed Nov 17 13:28:44 - spkgutil.c:5605 PKGUTL0086 ERROR: Failed to retrieve OL datasource for table F9860 for pathcode PU9.
Wed Nov 17 13:28:44 - PkgList.cpp:1397 PKGLST0020 ERROR: Validating objects in the package.
Wed Nov 17 13:28:44 - Building package list.
Wed Nov 17 13:28:44 - spkgutil.c:5605 PKGUTL0086 ERROR: Failed to retrieve OL datasource for table F9860 for pathcode PU9.
Wed Nov 17 13:28:44 - PkgList.cpp:425 PKGLST0008 ERROR: Failed to open f9860.
Wed Nov 17 13:28:44 - PkgList.cpp:100 PKGLST0002 ERROR: Failed to create list for the package.
Wed Nov 17 13:28:44 - PkgBuild.cpp:113 PKGBLD0004 ERROR: Failed to build the package lists.
Wed Nov 17 13:28:44 - Failed to build package PKGNAME. Correct the previous errors/warnings and resubmit. (...)


They have this issue since the very first time they attempted to build a full package from the deployment server. Up to now, they are only able to build packages from a client workstation. All pathcodes have this issue.


Customer has active OCM mappings for F9860 table for ALL pathcodes they have for both PLANNER and System Data Sources. Object Librarian datasource is mapped to a Sun database server. Package build engine is looking for data in one of the  two separate enterprise server (security servers). Machine Identification application (P9654A) is correct for all servers for Planner AND system.

Scenario 2

Unable to build full PD package from deployment server. Getting the following errors in clientpkgbuild.log and jde.log:

PKGUTL0086 ERROR: Failed to retrieve OL datasource for table F9860 for pathcode PD811.
PKGLST0020 ERROR: Validating objects in the package.Building package list.
PKGUTL0086 ERROR: Failed to retrieve OL datasource for table F9860 for pathcode PD811.
PKGLST0008 ERROR: Failed to open f9860.
PKGLST0002 ERROR: Failed to create list for the package.
PKGBLD0004 ERROR: Failed to build the package lists.

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
 Scenario 1
 Scenario 2
Cause
 Scenario 1
 Scenario 2
Solution
 Scenario 1
 Scenario 2
References


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