E1: UPGTC: R89800 Failing With TC Input Table Does Not Exist (Doc ID 1928759.1)

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

On :
Apps Release E1 9.1
Tools Release: 9.1.4.4

When attempting to do an upgrade from ERP 8 to 9.1 and running table conversions, the following error occurs.

ERROR
-----------------------
R984052.pdf shows: 'TC input table does not exist' for the R89800 program

There is no table conversion log being generated in the printqueue, and nothing in the jde.log

From the jdedebug.log:

CheckTableExists : JDB_DBGetLastErrorNum returned 0 after calling JDB_DBTableExists
Sep 16 10:02:16.290001 - 3876/3772 WRK:Starting jdeCallObject         ODBC:I DBFreeConnection pool(0) con=218ACAF0 env=020BD718 dbc=020BE6B0 spid=0 cur=0,0,0 sep=/ S068857R A (JDE@Business Data - CRP)
Sep 16 10:02:16.290002 - 3876/3772 WRK:Starting jdeCallObject         Exiting JDB_TableExists with Failure(Table F98800)
Sep 16 10:02:16.290003 - 3876/3772 WRK:Starting jdeCallObject         Entering JDB_FreeBhvr (UserHandle 219F8148)
Sep 16 10:02:16.290004 - 3876/3772 WRK:Starting jdeCallObject         Exiting JDB_FreeBhvr with Success(UserHandle 219F8148)
Sep 16 10:02:16.290005 - 3876/3772 WRK:Starting jdeCallObject         **********************************************************************************
Sep 16 10:02:16.290006 - 3876/3772 WRK:Starting jdeCallObject         *** Start dumping data structure for business function CompareSpecsToTableLayout
Sep 16 10:02:16.290007 - 3876/3772 WRK:Starting jdeCallObject         **********************************************************************************
Sep 16 10:02:16.290008 - 3876/3772 WRK:Starting jdeCallObject         OUT->[  1] <Item>: szEnvironment                    <type>: STRING           <Value>: [PD7334]
Sep 16 10:02:16.290009 - 3876/3772 WRK:Starting jdeCallObject         OUT->[  2] <Item>: szTableName                      <type>: STRING           <Value>: [F98800]
Sep 16 10:02:16.290010 - 3876/3772 WRK:Starting jdeCallObject         OUT->[  3] <Item>: szTableDataSourceName            <type>: STRING           <Value>: [Business Data - CRP]
Sep 16 10:02:16.290011 - 3876/3772 WRK:Starting jdeCallObject         OUT->[  4] <Item>: szReturnMessage                  <type>: STRING           <Value>: [Table not found in data source. ]

Note that it's looking for the F98800 table in Business Data instead of Control Tables.


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