E1: ESU: Information and Troubleshooting Of EnterpriseOne Software Update (ESU or ASU) Backup and Restore (Doc ID 1126197.1)

Last updated on JULY 18, 2023

Applies to:

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

Purpose

This document contains information and known issues on Software Updates "Backup" and "Restore Backup" procedures. It also contain information on how to back out a ESU. The knowledge provided here is not meant to be as a substitute for the Software Updates Guide, but as an aid for better understanding and troubleshooting issues involving Backup and Restore Backup during an E1 Software Update (ESU or ASU) Install. The knowledge included in this document is meant for users that have a basic understanding of the Software Update (ESU or ASU) Install process and have read the Software Updates Guide. Refer to JD Edwards EnterpriseOne Tools 8.98 Software Update Guide, Revised (Doc ID 757166.1); for JD Edwards EnterpriseOne Tools 8.98 Software Update Guide, Revised; refer to this link here for JD Edwards EnterpriseOne Tools Documentation - Software Updates Guide - Release 9.1.x; and refer to this link here for JD Edwards EnterpriseOne Tools Documentation - Software Updates Guide - Release 9.2.x.

During a software update patch install, you have the option to do a "Backup" of the objects being installed. If you have the backup check box selected when applying an ESU, then the system will make a back up of the affected EnterpriseOne objects. These objects are kept in a database on the deployment server located in the E9XX/Planner/Package/ESU#/Pathcode.BAK directory. This backup copy of the objects is also used during the Retrofitting of your modifications, using Visual ER Compare. The backup will contain your added or modified Event Rules to Oracle JDE objects that you will bring over using the Visual ER Compare tool. On the [Software Update Environment Selection] screen, selecting an environment and using the "Restore Backup" Button will fully restore all objects affected in the ESU process from the created, backup access database. It is important to realize that once the "Restore Backup" button is selected, then the process can not be stopped. The process will automatically restore the objects included in the Software Update, however it will not delete any Newly added objects from your Central Objects. In addition, you should be aware that the Restore Backup checkbox does not restore other items included in a Software Update like Control Tables and Data Dictionary items. And lastly, the Backup checkbox and restore functionality should NOT be used for large Cumulative Updates (ASUs) such as E1 9.0 Update 2. These ASUs Updates require a full system backup.

For more details in this process and many others occurring during a Software Update install, refer to <Document 1318978.1> Understanding ESUs Installs - Software Updates (ESUs and ASUs) Under the Covers - Updated to EnterpriseOne 9.0, 9.1 and 9.2.

Refer also to <Document 1052047.1> E1: DB: How to Backup and Restore the Local Planner Database (OEE or SSE) - for information on how to backup and restore the local Planner Database.