My Oracle Support Banner

E1: ESU: Troubleshooting Known Errors And Issues With UBE R98403XB - Load XML Data to Table (Doc ID 1072809.1)

Last updated on AUGUST 19, 2021

Applies to:

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

Purpose

This document was created to assist customers on troubleshooting the different scenarios, causes and resolutions for issues involving ESU install errors when there are errors occurring on running UBE report R98403XB - Load XML Data to Table.


UBE R98403XB - "Load XML Data to Table" is often launched from a Planner ESU / Special Instructions step. This process loads XML data from your ESU in to the LOCAL database for use. The Special Instruction lists processing option settings to be used for this UBE.
This UBE can also be launched from a Baseline ESU and/or from an ASU type Update, like 9.0 Update 2 (UL2). It creates a PDF report that is one page long only. Here are a couple of examples of successful R98403XB PDFs:

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Scenario 1 - R98403XB Report - Load XML Data to Table - Fails For Baseline ESU JL12914 - Copy Failed - Oracle Errors OCI0000178, OCI0000179 -  JDB_CopyXMLToTable failed - GT92002
 Scenario 1B - jde.log for Table Conversion:
 Scenario 2 - R98403XB fails with DATABASE_CONNECT_FAILED errors on E9.0 Planner Special Instructions - JDB3100080 Error - JDB_CopyXMLToTable failed - F9860
 Scenario 3 - R98403XB Run for Planner ESU Special Instructions Stating "Open XML Failed" for All Tables
 Scenario 4 - R98403XB will not connect to Planner DB while running Planner ESU as part of Tools Release update - SQL Error "Cannot set a credential for principal sa".
 Scenario 5A - XML ESU Fails to Install. Error: JDB9900428 - Failed to Get New Instance Object or Method ID 
 Scenario 5B - TR 8.98.4.0 (same error in jde.log) - It is also triggered when Security Server is enabled in JDE.INI, but not fully configured (left blank in JAS.INI).
 Scenario 6 - R98403XB failing with "Retryable operation failed" error.
 Scenario 7 - R98403XB Ends In "Retryable operation failed" and JDB9900428 Errors When Attempting To Apply ASU Update 2 (UL2) To Recently Upgraded Environment With New iSeries 7 Enterprise Server
 Scenario 8 - UBE R98403XB (Load XML Data to Table) Error - All Tables End With "Copy Failed" Message
 Scenario 9 - Applying ESUs generating R98403XB related error messages - TCP/IP port 1433 connection refused
 Scenario 10 - Applying ESUs generating R98403XB related error messages - Io exception: The Network Adapter could not establish the connection
 Scenario 11 - When applying ESUs, R98403XB fails in Copy Failed and logs shows "ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" message
 Scenario 12 - When applying ESU R98403XB ends in error and get "Failed to open XML R99PVCDD" in jde.log
 Scenario 13 - When applying ESU java.lang.Exception: failed to login to environment=JDEPLAN
 Scenario 14 - R98403XB Run for 9.2 Planner ESU Special Instructions Fails, error: [CONNECTION_MANAGER_BOOT_ERROR] - : java.lang.UnsupportedClassVersionError: oracle/jdbc/driver/OracleDriver Unsupported major.minor version”  
 Scenario 15: R98403XB Run for 9.2 Planner ESU Special instructions fails with: JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: failed to login to environment = JDEPLAN
References

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