E1: ESU: Troubleshooting Known Errors And Issues With UBE R98403XB - Load XML Data to Table
(Doc ID 1072809.1)
Last updated on JULY 01, 2024
Applies to:
JD Edwards EnterpriseOne Tools - Version 8.98 and laterInformation 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:
- R98403XB version XJDE0001:
- R98403XB version XJDE0002:
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 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 |
| Scenario 17 - "oracle/jdbc/driver/OracleDriver has been compiled by a more recent version of the Java Runtime" When Trying To Run R98403XB And Going Into ESU Application |
| References |