E1: UPGTC: Why Pristine Environment Must Be Loaded For Upgrade TCs to Run - Table Conversions Failing - "Environment Not Defined In F00941 On Host" Error (Doc ID 1182273.1)

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

This document is part of an Information Center - to see other documents related to Upgrade EnterpriseOne software, please use the links provided below:

Information Center: JD Edwards EnterpriseOne 9.0 > Information Center: Upgrading to JD Edwards EnterpriseOne 9.0 > Upgrade Table Conversion > Doc ID 1182273.1

Information Center: JD Edwards EnterpriseOne 9.1 > Information Center: Upgrading to JD Edwards EnterpriseOne 9.1 > Upgrade Table Conversion > Doc ID 1182273.1

Information Center: JD Edwards EnterpriseOne 9.2 > Information Center: Upgrading to JD Edwards EnterpriseOne 9.2 > Upgrade Table Conversion > Doc ID 1182273.1

 

 

Scenario 1

Upgrade from ERP8 to EnterpriseOne 9.0 application release level TR 8.98.2.4. Data Only Conversion.
During a data only conversion, all jobs are failing.
Replaced E1 9.0 CRP/PY database with ERP8.0 PROD copy and configured (i.e. change schema from proddta to crpdta, etc), so could run data conversion in PY environment. Customer has copied across the old planner and system (ERP8) database and set up appropriate datasources. The plan validation report R9840B for the upgrade completes successfully, but the data conversion jobs fail.

Originally, customer ran their TCs on the enterprise server, but their server jde.ini wasn't set up with PS900. This raises a question on why does Pristine Environment has to be the environment in the jde.ini for Table Conversions?.
Then, customer decided to run the TC's on the deployment server, but still not working .
This is the error in the jde.log:

3544/2532 WRK:Starting jdeCallObject Wed Jul 21 23:27:58.990000 B984057.c392
Environment not defined in F00941 on Host


Other errors found after that, as:

(...) 3720/2268 WRK:Starting jdeCallObject Wed Jul 21 23:29:28.081000 Odbc_u1.c935
ODB0000156 - Number of columns in table F0009 [55] (DSN: MCBR-9SQL1) not equal to SPECS [66].
3720/2268 WRK:Starting jdeCallObject Wed Jul 21 23:29:28.082000 Jdbodbc.c3279
ODB0000027 - JDBODBC_DescribeTable failed. Table F0009.
3720/2268 WRK:Starting jdeCallObject Wed Jul 21 23:29:28.082001 Jdb_drvm.c1026
JDB9900168 - Failed to initialize db request
3720/2268 WRK:Starting jdeCallObject Wed Jul 21 23:29:28.082002 Jtp_cm.c1015
JDB9909007 - Unable to obtain driver request handle
3720/2268 WRK:Starting jdeCallObject Wed Jul 21 23:29:28.084000 Jdecgsc.c348
MSC0000025 - Could not load F0009 cache - ENVCACHE (...)

 

Scenario 2

Customers starting the workbench, over the Table Conversion Workbench screen, can see the following error message at the bottom of the screen:

"Default environment missing on server"


And the following errors are registered in the logs:

Error in JDE.log:
"Environment not defined in F00941 on Host"

In the jdedebug.log:
"Warning: Invalid cursor state failure" when accessing the F00941
and
DBInitRequest(new) req=25C4A718 con=09669A50 env=04591978 dbc=045A09F0 spid=0 WTES0046 A (JDE@SystemC0046-B83)
Jan 09 11:48:47.322000 - 1916/3564 WRK:Starting jdeCallObject SELECT * FROM CB046SY83/F00941 WHERE ( LMLL = 'PS812' )


In this case, we checked at table F00941 and there wasn't a record for Pristine PS812.

Changes

After upgrading E1 software to EnterpriseOne 9.0, doing a data only upgrade.

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