E1: UPGTC: Table Conversion In iSeries Encounters Internal Driver Error (Doc ID 1462598.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
IBM i on POWER Systems
***Checked for relevance on 01-Nov-2013***

Symptoms

On : E1 9.0 / TR 9.1.0.2 version, Install/Change Mgmt - Upgrade

When attempting to upgrade from ERP 8.0 to E1 9.0
the following error occurs.

ERROR
-----------------------
Table conversions are failing on the enterprise server e.g. for the job R8942199D

JDE.LOG shows the following:

5668/260 WRK:Starting jdeCallObject            Mon May 28 00:15:30.518000    LaunchXMLUBE.c75
    Submitting R98405A, XJDE0001 to JDEENTSV for XML specs

5668/260 WRK:Starting jdeCallObject            Mon May 28 00:15:55.138000    Odbc_p3.c1013
    ODB0000163 - wSQLStatistics failure. rc=-1

5668/260 WRK:Starting jdeCallObject            Mon May 28 00:15:55.138001    Odbc_p3.c1013
    ODB0000164 - STMT:00 [HY000][30101][2] [IBM][System i Access ODBC Driver]Internal driver error.

5668/260 WRK:Starting jdeCallObject            Mon May 28 00:15:55.138002    Odbc_p3.c1681
    ODB0000163 - wSQLStatistics failure. rc=-1

TC conversion log show:

TCRunInsertFromSelectConversionTCEngine Level 0 /E910SYS/tcengine/tcrun.c : TCE009158 - JDB_InsertFromSelectExtended failed.TCEngine Level 2 /E910SYS/tcengine/tcrun.c : Ending TCRunInsertFromSelectConversionTCEngine Level 0 /E910SYS/tcengine/tcrun.c : TCE009203 - Fall back to a row by row conversion and ignore the preceding insert-from-select errorsTCEngine

qpjoblog from the QSQSRVR job shows the following;

CPC3102    Completion              00   05/28/12  03:09:48.708520  QDBINZPF     QSYS        024A     QSQCALL     QSYS        *STMT
                                     From user . . . . . . . . . :   JDE
                                     To module . . . . . . . . . :   QSQCALL
                                     To procedure  . . . . . . . :   CALLPROGRAM
                                     Statement . . . . . . . . . :   31606
                                     Message . . . . :   Member F42199A initialized with 4000 records.
                                     Cause . . . . . :   Member F42199A file F42199A in library PROD9DTA was
                                       initialized with 4000 records.
SQL0206    Diagnostic              30   05/28/12  03:09:48.726375  QSQRUN1      QSYS        *STMT    QSQRUN1     QSYS        *STMT
                                     From user . . . . . . . . . :   JDE
                                     From module . . . . . . . . :   QSQPREP
                                     From procedure  . . . . . . :   CLEANUP
                                     Statement . . . . . . . . . :   9981
                                     To module . . . . . . . . . :   QSQPREP
                                     To procedure  . . . . . . . :   CLEANUP
                                     Statement . . . . . . . . . :   9981
                                     Message . . . . :   Column SLCDCD not in specified tables.
                                     Cause . . . . . :   SLCDCD is not a column of table *N in *N. If the table is
                                       *N, SLCDCD is not a column of any table or view that can be referenced.
                                       Recovery  . . . :   Do one of the following and try the request again: --
                                       Ensure that the column and table names are specified correctly in the
                                       statement. -- If this is a SELECT statement, ensure that all the required
                                       tables were named in the FROM clause. -- If the column was intended to be a



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the table conversion on the iSeries enterprise server


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upgrade the production environment successfully.

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