E1: MIG: Table Conversion TCE009140 Errors - World to EnterpriseOne Software Migration - World Distribution Flexible Files Failing
(Doc ID 659151.1)
Last updated on APRIL 08, 2025
Applies to:
JD Edwards EnterpriseOne Tools - Version S13 and laterInformation in this document applies to any platform.
Checked for relevance on December 14, 2012 *ARCHIVED*
Symptoms
Migrating from World Software A7.3 to EnterpriseOne 8.12 application release level and getting errors on table conversions for the F42199 table.
From the R8942199D.log:
TCEngine Level 1 \builds\8.97.00.01.07\Rels\common\TCEngine\tcinit.c : Buffered insert turned on for output table F42199A.
TCEngine Level 1 \builds\8.97.00.01.07\Rels\common\TCEngine\tcinit.c : Output F42199A is using data source Business Data - PROD.
TCEngine Level 1 \builds\8.97.00.01.07\Rels\common\TCEngine\tcinit.c : Conversion method is Insert from Select.
TCEngine Level 1 \builds\8.97.00.01.07\Rels\common\TCEngine\tcdump.c :
TCEngine Level 0 \builds\8.97.00.01.07\Rels\common\TCEngine\tcrun.c : TCE009158 - JDB_InsertFromSelectExtended failed.
TCEngine Level 0 \builds\8.97.00.01.07\Rels\common\TCEngine\tcrun.c : TCE009203 - Fall back to a row by row conversion and ignore the preceding insert-from-select errors
TCEngine Level 0 \builds\8.97.00.01.07\Rels\common\TCEngine\tcrun.c : TCE009140 - JDB_SelectKeyed failed.
TCEngine Level 1 \builds\8.97.00.01.07\Rels\common\TCEngine\tcrun.c : Conversion R8942199D XJDE0001 done unsuccessfully. Elapsed time - 0.437000 Seconds.
From the jde.log:
TCE009158 - JDB_InsertFromSelectExtended failed.
TCE009203 - Fall back to a row by row conversion and ignore the preceding insert-from-select errors
ODB0000156 - Number of columns in table F42199 [60] (DSN: Business Data - PDTEMP) not equal to SPECS [218].
ODB0000027 - JDBODBC_DescribeTable failed. Table F42199.
JDB9900168 - Failed to initialize db request
JDB9909007 - Unable to obtain driver request handle
TCE009140 - JDB_SelectKeyed failed.
From jdedebug.log:
ODB0000027 - JDBODBC_DescribeTable failed. Table F42199.
JDB9900168 - Failed to initialize db request
JDB9909007 - Unable to obtain driver request handle
Exiting JDB_SelectKeyed with Failure
TCE009140 - JDB_SelectKeyed failed.
The main thing to note from the logs is that the number of columns in the F42199 is 60, while the TC is expecting there to be 218.
NOTE: For some Table Conversions, it is all right to see messages about the number of columns not equal to specs because they won't be equal until after the TC runs, but in this case the number was way off and if you look in the Programmers Guide and verify what the TC R8942199D is doing, you'll see all it's doing is dumping records from the F42199 into the F42199A.
Changes
Customer doing a Direct Migration from World software A7.3 to EnterpriseOne 8.12 application release level.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| Working with JD Edwards World Distribution Flexible Files |
| References |