E1: UBE: Suddenly UBE Jobs Do Not Process Correctly on AS/400 Server in spite of completing in ' D - Done ' Status - Error SQL0803 (Doc ID 1340508.1)

Last updated on AUGUST 21, 2017

Applies to:

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

Symptoms

Suddenly UBE Jobs do not run well, although the status is reported as Done. UBE that supposed to clear file and populate with new data, does not do the job.

No changes have been done to EnterpriseOne and AS/400 Server.

All EnterpriseOne SQL package files have been deleted, but it did not help.

Nearly all kernels show the following errors:

OS40002001 - Error Type: SQL sqlcode: -803 Duplicate key value specified.
JDB3400009 Failed to perform insert for <file name>
KNT0000099 - JDEK_DispatchCallObjectMessage: Pooled Connection: SPP:0000 :1aefJDENET_K ONEWORLD 123456 :400000:0:11 timed out !

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