E1: UPGTC: Upgrade TC Error On R894072 - F0002 Record For System Code 45 Does Not Exist in Control Tables Datasource - TCE009153 Error (Doc ID 636669.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
Information in this document applies to any platform.
Checked for relevance on January 23, 2013

Symptoms

Customer doing an upgrade and getting an error on the R894072 table conversion.  In the R894072_XJDE0001.log is the following:

TC Stop Processing called in ER, ending conversion. User message 'Error returned from B8902005 - Update F4072 ERP 9'
TCE009153 - eTCOnRowFetched GBR failed.
Call JDB_FlushBufferInserts on table F4009
Inside ProcessTblInsertRtnCode
Conversion R894072 XJDE0001 done unsuccessfully.



The JDE.log has the following error messages:

= Fail to update table F4072TEM - Business Data - PROD
= TC Stop Processing called in ER, ending conversion. User message 'Error returned from B8902005 - Update F4072 ERP 9'
= TCE009153 - eTCOnRowFetched GBR failed.



and in the jdedebug.log:

SELECT NNSY, NNN004 FROM JDE_Conversion.PRODCTL.F0002 WHERE ( NNSY = '45' )
WRK:Starting jdeCallObject Entering DBPerformRequest
WRK:Starting jdeCallObject ODBC:S DBPerformRequest req=0C5E6E58 con=0B67C9A0 env=030712A0 dbc=0307BE80 spid=57 JDECONV A (PRODDTA@JDECONV)
WRK:Starting jdeCallObject Exiting DBPerformRequest
WRK:Starting jdeCallObject No More Data found
Fail to update table F4072TEM - Business Data - PROD

Changes

Customer doing an EnterpriseOne software upgrade and running Table Conversion Workbench

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