E1: UPG: UBEs R98403 and R98407 Fails to Copy Records and Re-generate Any Tables in "Business Data" Database (Doc ID 1062774.1)

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

In this case here, customer is doing an EnterpriseOne software upgrade from EnterpriseOne 8.10 to 9.0 application release level and Environment Database Creation R98403 and Table and Index Creation R98407 UBEs are failing. 
The R98403 PDF shows a status of error for the GT* objects located in Business Data and the R98407 PDF shows a status of error for all of the tables that need to be regenerated in Business Data. 

The messages in the jde.log for the R98403 are:

ODB0000164 - STMT:00 [42S01][2714] [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named 'F00165' in the database.
JDB9900401 - Failed to execute db request
JDB21000091 - Failed to create table F00165 in data source Business Data - CRP
ODB0000163 - wSQLExecute failure. rc=-1


The messages in the jde.log for the R98407 are the same except the table names are different.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms