E1: MIG: Error Running R890007C Table Conversion - TCE009140 - JDB_SelectKeyed failed
(Doc ID 650398.1)
Last updated on APRIL 04, 2025
Applies to:
JD Edwards EnterpriseOne Tools - Version S13 and laterInformation in this document applies to any platform.
Symptoms
Customer Migrating from World A7.3 to EnterpriseOne 8.11 SP1 and the second table conversion for F0007 is failing (R890007C). The following is in the tc.log:
TCEngine Level 1 \b9\common\TCEngine\tcinit.c : Input F0007 is using data source Business Data - PYTEMP.
TCEngine Level 1 \b9\common\TCEngine\tcinit.c : Buffered insert turned on for output table F0007.
TCEngine Level 1 \b9\common\TCEngine\tcinit.c : Output F0007 is using data source Business Data - PY400.
TCEngine Level 1 \b9\common\TCEngine\tcinit.c : Conversion method is Row by Row.
TCEngine Level 1 \b9\common\TCEngine\tcdump.c :
TCEngine Level 0 \b9\common\TCEngine\tcrun.c : TCE009140 - JDB_SelectKeyed failed.
TCEngine Level 1 \b9\common\TCEngine\tcrun.c : Conversion R890007C XJDE0001 done unsuccessfully. Elapsed time - 0.841000 Seconds.
TCEngine Level 1 \b9\common\TCEngine\tcinit.c : Buffered insert turned on for output table F0007.
TCEngine Level 1 \b9\common\TCEngine\tcinit.c : Output F0007 is using data source Business Data - PY400.
TCEngine Level 1 \b9\common\TCEngine\tcinit.c : Conversion method is Row by Row.
TCEngine Level 1 \b9\common\TCEngine\tcdump.c :
TCEngine Level 0 \b9\common\TCEngine\tcrun.c : TCE009140 - JDB_SelectKeyed failed.
TCEngine Level 1 \b9\common\TCEngine\tcrun.c : Conversion R890007C XJDE0001 done unsuccessfully. Elapsed time - 0.841000 Seconds.
From the jde.log:
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967000 Odbc_u1.c880
ODB0000154 - SQLPrepare failed. Table F0007, ODBC DSN Business Data - PYTEMP.
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967001 Jdbodbc.c3177
ODB0000027 - JDBODBC_DescribeTable failed. Table F0007.
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967002 Jdb_drvm.c880
JDB9900168 - Failed to initialize db request
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967003 Jtp_cm.c1022
JDB9909007 - Unable to obtain driver request handle
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967004 tcrun.c199
TCE009140 - JDB_SelectKeyed failed.
ODB0000154 - SQLPrepare failed. Table F0007, ODBC DSN Business Data - PYTEMP.
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967001 Jdbodbc.c3177
ODB0000027 - JDBODBC_DescribeTable failed. Table F0007.
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967002 Jdb_drvm.c880
JDB9900168 - Failed to initialize db request
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967003 Jtp_cm.c1022
JDB9909007 - Unable to obtain driver request handle
2876/3496 WRK:Starting jdeCallObject Thu Aug 31 08:09:04.967004 tcrun.c199
TCE009140 - JDB_SelectKeyed failed.
Customer tried to open up the F0007 table in Business Data - PYTEMP via UTB on the deployment server and got the following error in the jde.log:
2900/1588 WRK:Starting jdeCallObject Thu Aug 31 13:01:42.574000 B9861110.c131
F0007 not found in Business Data - PYTEMP.
F0007 not found in Business Data - PYTEMP.
Changes
Running Table Conversions during a Migration from World to EnterpriseOne software.
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 |
| References |