E1: PKG: Package Build GBRSPEC and RDASPEC Only Fetch 250,000 Records.- AS400 iSeries Platform (Doc ID 626440.1)

Last updated on JULY 17, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
IBM i on POWER Systems

Goal

The host server database applications with large SQL tables that contain LOB columns can easily reach the architectural LOB locator limit of 250,000. From JD Edwards EnterpriseOne 8.9 or higher this limit will cause a problem during package builds with GBRSPEC and RDASPEC. In the builderror.txt (or ClientPkgBuild.log) you will see that GBRSPEC and RDASPEC only fetch 250,000 records.

NOTE:  Once you have put the latest PTFs onto the IBM i, you need to enable the new LOB locator functionality. If you do not do this, Specifications Merge and Package Build will fail.

 

Solution

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