My Oracle Support Banner

E1: UPG: Upgrade From EnterpriseOne 8.12 to 9.0 With Local Database From SSE to OEE - Previous System Data Source Error (Doc ID 970761.1)

Last updated on FEBRUARY 01, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Checked for relevancy on 15-07-2011
Checked for relevance on February 26, 2013


Upgrade from EnterpriseOne 8.12 with SSE to E1 9.0 application release level with OEE in the same deployment server. Customer used snapshot to save 8.12 configuration and continue to apply ESUs in 8.12,  E812 share is preserved.

The following actions were performed:

1 - Saved 8.12 Configuration in Snapshot
2 - Reinstalled OEE and E1 9.0 OEE deployment server software pre-downloaded from e-delivery
3 - Installed latest 8.98 Tools Release level                                                                                              
4 - Install Planner ESU JL12846 and perfomed relevant Special Instructions
5 - Cmd line "set" and verified environment variables for 9.0, mainly for variable JDE_B9_ICU_DATA which had correct path pointing for 9.0 .

Checked in Planner 9.0 all the Database Data Sources , and reconfigured Data source "Planner - 8.12" , which was pointing to MSDE and made it point to SSE.

Also, datasource Planner - B9 was pointing to EnterpriseOne Local ODBC Datasource, corrected that to point to Oracle E1Local instance, th 9.0 OEE.
Local - Planner Specs Datasource is correctly pointing to Database Name = SPEC_E900.
When we launch the Upgrade Plan, it connects to local SSE database and OEE, however when we get to the [Previous EnterpriseOne Configuration] screen, for the previous System datasource, we manually select System - 8.12, and press ok, it gives an error as:

"Error - Failed to copy Data Sources - F986116"

and system crashes.  From this moment on, no applications work. We can reboot the deployment server, login in JDEPLAN again, but no applications work, giving invalid command. Cannot proceed with any actions in the deployment server apart from uninstall everything and try it again.


Customer is upgrading system from EnterpriseOne 8.12 to EnterpriseOne 9.0 application release level.


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

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