JDE 9.2 New Deployment Server - Cannot connect to E1Local

I am building a new 9.2 deployment client. Install logs are clean with no errors. When attempting to login to the JDEPLAN environment I receive the following error:

Could not load environment - JDEPLAN

The jde.log file contains the following (just a subset of the actual log contents...)

1148/2000 MAIN_THREAD Thu Mar 16 10:43:07.148000 jdb_ctl.c4196
Starting OneWorld

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929000 dbperfrq.c471
OCI0000178 - Unable to execute - SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM JDEPlan920.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND OMFUNO = :KEY3 AND OMOBNM = :KEY4 AND OMUGRP = :KEY5 ) ORDER BY OMSTSO ASC,OMAPPLID ASC

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929001 dbperfrq.c477
OCI0000179 - Error - ORA-00942: table or view does not exist

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929002 jdb_drvm.c999
JDB9900170 - Failed to execute db request

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929003 jdb_omp1.c3181
JDB9900258 - Failed to select from F986101

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929004 dbperfrq.c471
OCI0000178 - Unable to execute - SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM JDEPlan920.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND ( OMUGRP = :KEY3 OR OMUGRP = :KEY4 OR OMUGRP = :KEY5 OR OMUGRP = :KEY6 ) ) ORDER BY OMSTSO ASC,OMAPPLID ASC

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929005 dbperfrq.c477
OCI0000179 - Error - ORA-00942: table or view does not exist

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929006 jdb_drvm.c999
JDB9900170 - Failed to execute db request

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929007 jdb_omp1.c1310
JDB9900241 - Failed to select from F986101

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929008 jdb_cach.c1369
JDB9900009 - Failed to load ObjectMap Cache

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929009 jdb_cach.c1386
Unable to load primary Object Configuration Manager - switching to secondary

I am also unable to connect to the E1Local database using SQLDeveloper or SQLPlus. SQLDeveloper shows the splash screen then goes away...nothing loads. SQLPlus tells me the login/password I'm using is invalid. Hopefully the resolution is the same for both issues.

Thanks for reading/replying to this post. This is my first new/fresh install so please be kind in your replies
 

glen7x

Active Member
Do you have your 32 bit oracle database client in place? Make sure you have the tnsnames file in place there.
 
Thank you for the reply. I greatly appreciate it. I have the 32 bit client in place. I also copied the tnsnames into this folder (\app\administrator\product\12.1.0\client_1\network\admin). Any other suggestions would be deeply appreciated.
 

JDEE1Tips

Well Known Member
I am building a new 9.2 deployment client. Install logs are clean with no errors. When attempting to login to the JDEPLAN environment I receive the following error:

Could not load environment - JDEPLAN

The jde.log file contains the following (just a subset of the actual log contents...)

1148/2000 MAIN_THREAD Thu Mar 16 10:43:07.148000 jdb_ctl.c4196
Starting OneWorld

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929000 dbperfrq.c471
OCI0000178 - Unable to execute - SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM JDEPlan920.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND OMFUNO = :KEY3 AND OMOBNM = :KEY4 AND OMUGRP = :KEY5 ) ORDER BY OMSTSO ASC,OMAPPLID ASC

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929001 dbperfrq.c477
OCI0000179 - Error - ORA-00942: table or view does not exist

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929002 jdb_drvm.c999
JDB9900170 - Failed to execute db request

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929003 jdb_omp1.c3181
JDB9900258 - Failed to select from F986101

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929004 dbperfrq.c471
OCI0000178 - Unable to execute - SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM JDEPlan920.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND ( OMUGRP = :KEY3 OR OMUGRP = :KEY4 OR OMUGRP = :KEY5 OR OMUGRP = :KEY6 ) ) ORDER BY OMSTSO ASC,OMAPPLID ASC

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929005 dbperfrq.c477
OCI0000179 - Error - ORA-00942: table or view does not exist

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929006 jdb_drvm.c999
JDB9900170 - Failed to execute db request

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929007 jdb_omp1.c1310
JDB9900241 - Failed to select from F986101

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929008 jdb_cach.c1369
JDB9900009 - Failed to load ObjectMap Cache

1148/2000 MAIN_THREAD Thu Mar 16 10:43:09.929009 jdb_cach.c1386
Unable to load primary Object Configuration Manager - switching to secondary

I am also unable to connect to the E1Local database using SQLDeveloper or SQLPlus. SQLDeveloper shows the splash screen then goes away...nothing loads. SQLPlus tells me the login/password I'm using is invalid. Hopefully the resolution is the same for both issues.

Thanks for reading/replying to this post. This is my first new/fresh install so please be kind in your replies

Error message clearly saying that there is no table in your database. JDE is able to make the connection with your E1local database. Most Probably your Installation was not successful. Check your Installactions.log from the location C:\Program Files (x86)\Oracle\Inventory\logs to identify the cause of the issue.
 

altquark

Legendary Poster
It sounds like you had issues in your installation steps.

1. Did you install the Oracle 32 bit client PRIOR to the installation ?
2. What do your installation logs state ?

More than likely, you need to start over. Make sure you follow ALL your installation steps in the documentation - including modifying the tnsnames.ora for the 32bit client.
 

habarric

Active Member
What user/password are you using on SQLPlus to try and login to E1Local? Did you try JDE/JDE? You can also run the ReconfigureDB.exe out of the e920\system\bin32 to reset the system/sys password on the E1local DB to a known password, then you can try and verify the schemas, tablespaces, tables, etc exist or not. B/c that error could also indicate a permissions issue as much as the table actually not existing.

And as Jon stated - check your install logs, make sure the db scripts and data pump imports all ran successfully.
 

glen7x

Active Member
Either your E1local install did not go well or the E1local database load during the deployment server install did not go well. As Jon suggested, you might be well off starting afresh.
Check this following -
- Are you able to do a tnsping e1local from cmd?
- Try connecting to the E1local instance as SYSDBA. Change the sqlnet.ora authenticaltion to NTS ( SQLNET.AUTHENTICATION_SERVICES=(NTS) ) and then connect as sqlplus / as sysdba
- Once you are connected, try to do a select on JDEPlan920.F986101. see if you get any results.
 
Top