E1: UPGTC: Why Pristine Environment Must Be Loaded For Upgrade TCs to Run - Table Conversions Failing - "Environment Not Defined In F00941 On Host" Error
Last updated on MAY 30, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.
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
Upgrade from ERP8 to EnterpriseOne 9.0 application release level TR 18.104.22.168. 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:
Environment not defined in F00941 on Host
Other errors found after that, as:
ODB0000156 - Number of columns in table F0009  (DSN: MCBR-9SQL1) not equal to SPECS .
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 (...)
Customers starting the workbench, over the Table Conversion Workbench screen, can see the following error message at the bottom of the screen:
And the following errors are registered in the logs:
"Environment not defined in F00941 on Host"
In the jdedebug.log:
"Warning: Invalid cursor state failure" when accessing the F00941
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.
After upgrading E1 software to EnterpriseOne 9.0, doing a data only upgrade.
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