E1: ESU: Information And Troubleshooting Known Errors And Issues With UBE R98407 - "Table and Index Creation" When Installing A Software Update Patch (ESU or ASU) (Doc ID 1502692.1)

Last updated on JULY 14, 2023

Applies to:

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

Purpose

This document is part of an Information Center - to see other documents related to Software Updates, please use the links provided below:

Information Center: Software Updates(ESUs, ASUs), Product Packaging, Change Assistant, Configuration Assistant and OBA in the JD Edwards EnterpriseOne Tools and Technology Product > Information Center: Troubleshooting Software Updates(ESUs and ASUs) in the JD Edwards EnterpriseOne Tools and Technology Product > Software Updates - "Application Table Merges" section

This document was created to provide vital information on UBE R98407 and assist customers on troubleshooting the different scenarios, causes and resolutions for issues involving Software Update (ESU or ASU) patch install errors when there are errors occurring on running UBE report

Solution: To correct this issue, follow these steps:

On the Deployment Server, log into the JDEPLAN environment.
Go to (GH9612) into the Software Updates application (Electronic for an ESU or Application for an ASU).
Highlight and Select the ESU or ASU you are attempting to apply. Click Next.
Highlight the desired environment. UNCHECK the Unattended Workbench checkbox (to place install in "Attended" Mode and allow the ESU install process to stop through the workbenches scheduled to run) and UNCHECK the Backup checkbox and the Create OMW Project checkbox. Click Next.
Once the application stops (should be at the Table Conversion screen with the failed R98407), leave the screen up and return to the main menu screen.
Go to menu GH961 and launch the Custom Installation Plan application.
In the Custom Installation Plan -[Work with Installation Plans] (P98240/W98240B) form click Find.
Expand the ESU or ASU's latest plan. Each time the ESU/ASU is run, a new project is created with a unique name by appending the project with the next sequential number, e.g. JL123-4. The highest number should match the project you are currently working with in the other window.
Expand Base Location, the Location, Environments, and then the given environment, e.g. DV900. Set focus on Table Conversion and click Select.
In the grid row for the environment, it should have a row where Table Name is F0101 and the Program Name as R98407. Focus in the Dtl Sts box on that grid row and use the Visual Assist to choose 60 (Installed). Click Save and return to the ESU/ASU application.
Return to the active window for the Software Updates application and click the Back button until you get to the screen before the R98407.
Click Next. If there is another process on the Table Conversions, it will stop there so you can complete any unprocessed conversions. If the R98407 was the only unsuccessfully processed job, the Software Updates application should move past it to the next workbench in the installation.