6 Replies Latest reply on Mar 27, 2018 6:39 AM by 3667668

JDE 9.2 Installation issue

3667668 Mar 23, 2018 7:01 AM

Hi All,

I have installed deployment server and able to login JDEPLAN environment and also DB and platform pack and able to connect to ORCL from deployment server. I have created a plan but not able to run it from workbench.

And also porttest is failed in enterprise server. Below are logs in each server. please share your thoughts.

Deployment server log:

452/840 MAIN_THREAD Fri Mar 23 12:15:18.755000 jdb_ctl.c4196

Starting OneWorld

2452/1080 WRK:Starting jdeCallObject Fri Mar 23 12:16:28.730000 dbinitcn.c929

OCI0000065 - Unable to create user session to database server

2452/1080 WRK:Starting jdeCallObject Fri Mar 23 12:16:28.730001 dbinitcn.c934

OCI0000141 - Error - ORA-01017: invalid username/password; logon denied

Enterprise server log:

8/1180 Fri Mar 23 11:56:36.033003 IPCMISC.C299

process 1868 <jdenet_k> registered in entry 1

1868/1180 Fri Mar 23 11:56:36.049000 NETCFG.C297

Starting Kernel of Type:METADATA KERNEL

1868/1180 Fri Mar 23 11:56:37.018000 ServerDispatch.cpp267

INITIALIZING METADATA SERVER KERNEL

1868/1180 SYS:Metadata Fri Mar 23 11:56:37.018001 JDETOOLS.C3065

LIB0000569 - WARNING!!! [SECURITY][Password] Password not encrypted in the INI

1868/1180 SYS:Metadata Fri Mar 23 11:56:37.049000 JDETOOLS.C3065

LIB0000569 - WARNING!!! [SECURITY][Password] Password not encrypted in the INI

1868/1180 SYS:Metadata Fri Mar 23 11:56:37.049001 JDETOOLS.C3065

LIB0000569 - WARNING!!! [SECURITY][Password] Password not encrypted in the INI

1868/1180 SYS:Metadata Fri Mar 23 11:56:37.190000 dbperfrq.c471

OCI0000178 - Unable to execute - SELECT OMENHV, OMAPPLID, OMOBNM, OMDATP, OMDATS, OMUGRP, OMOAPP, OMDATM, OMOVRE, OMSY, OMSTSO, OMFUNO, OMOCM2, OMOCMDSC FROM SVM920.F986101 WHERE ( OMENHV = :KEY1 AND OMSTSO = :KEY2 AND OMFUNO = :KEY3 AND OMOBNM = :KEY4 AND OMUGRP = :KEY5 ) ORDER BY OMSTSO ASC,OMAPPLID ASC

1868/1180 SYS:Metadata Fri Mar 23 11:56:37.190001 dbperfrq.c477

OCI0000179 - Error - ORA-00942: table or view does not exist

1868/1180 SYS:Metadata Fri Mar 23 11:56:37.190002 JDB_DRVM.C999

JDB9900170 - Failed to execute db request

1868/1180 SYS:Metadata Fri Mar 23 11:56:37.190003 JDB_OMP1.C3181

JDB9900258 - Failed to select from F986101

1. Re: JDE 9.2 Installation issue

Jim-D Mar 23, 2018 6:16 PM (in response to 3667668)

Welcome! This JD Edwards (Chinese) space doesn't have a lot of activity, and there are not dedicated spaces for E1 in the Oracle Developer Community. However, there are several spaces in the My Oracle Support Community, which is available to you if you have an active Oracle Support account. In the ACTIONS menu on the right, you should be able to click on "Move", and then specify the correct space, such as CNC, DB and Operating System - JDE1 (MOSC) , so that E1 experts can see your question.
Good luck!
Like Show 0 Likes(0)

Actions
2. Re: JDE 9.2 Installation issue

Karthickrajan.K-Oracle Mar 26, 2018 4:20 AM (in response to 3667668)

Hi,

From the error message , looks like you are giving wrong password while login into JDEPLAN. Default Oracle Database is case sensitive so please provide the correct case while login into JDEPLAN. ( Default Password is JDE )

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

OCI0000141 - Error - ORA-01017: invalid username/password; logon denied

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Once Plan is created you can do port test and see whether above mentioned error is resolved or not. As of now focus the invalid username.password error message to proceed further.

Best Regards
Karthickrajan K
Like Show 1 Likes(1)

Actions
3. Re: JDE 9.2 Installation issue

3667668 Mar 26, 2018 8:27 AM (in response to Karthickrajan.K-Oracle)

thanks Karthik.
I am able to run the plan and it has been installed. But when am trying to run porttest from enterprise it is getting failed.
I have the below error in server log. Please have a look.

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.490003 IPCMISC.C299
process 3368 <PORTTEST> registered in entry 6

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.537000 JDETOOLS.C3065
LIB0000569 - WARNING!!! [SECURITY][Password] Password not encrypted in the INI

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.537001 JDETOOLS.C3065
LIB0000569 - WARNING!!! [SECURITY][Password] Password not encrypted in the INI

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928000 jdbodbc.C1345
ODB0000163 - SQLDriverConnect failure. rc=-1

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928001 jdbodbc.C1345
ODB0000164 - DBC:00 [IM002][0][1] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928002 jdbodbc.C1355
ODB0000010 - SQLDriverConnect failed. ODBC DSN: ENTSVR - 920 Server Map.

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928003 JDB_DRVM.C798
JDB9900164 - Failed to connect to ENTSVR - 920 Server Map

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928004 JTP_CM.C282
JDB9909003 - Could not init connect.

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928005 JTP_TM.C1140
JDB9909100 - Get connect info failed: Transaction ID =

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928006 JDB_RQ1.C2458
JDB3100013 - Failed to get connectinfo

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928007 JDB_OMP1.C3369
JDB9900257 - Failed to open F986101

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928008 jdbodbc.C1345
ODB0000163 - SQLDriverConnect failure. rc=-1

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928009 jdbodbc.C1345
ODB0000164 - DBC:00 [IM002][0][1] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928010 jdbodbc.C1355
ODB0000010 - SQLDriverConnect failed. ODBC DSN: ENTSVR - 920 Server Map.

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928011 JDB_DRVM.C798
JDB9900164 - Failed to connect to ENTSVR - 920 Server Map

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928012 JTP_CM.C282
JDB9909003 - Could not init connect.

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928013 JTP_TM.C1140
JDB9909100 - Get connect info failed: Transaction ID =

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928014 JDB_RQ1.C2458
JDB3100013 - Failed to get connectinfo

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928015 JDB_OMP1.C1220
JDB9900240 - Failed to open F986101

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928016 JDB_CACH.C1450
JDB9900011 - Failed to load Object Map (F986101)

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928017 JDB_OMP1.C629
JDB9900246 - Failed to find existence of default OMAP for environment DV920

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928018 JDB_RQ1.C2023
JDB3100011 - Failed to get location of table F00921 for environment DV920

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928019 JDECGSC.C201
MSC0000028 - Could not load F00921 cache

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928020 JDB_RQ1.C3061
JDB2700019 - Failed to get data source for the table

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928021 JDB_CTL.C4439
JDB1100016 - Failed to load Environment - DV920

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928022 JDETOOLS.C3065
LIB0000569 - WARNING!!! [SECURITY][Password] Password not encrypted in the INI

3368/3408 MAIN_THREAD                        Mon Mar 26 13:46:04.928023 IPCMISC.C299
API ipcSawUnregisterProcV1 : process 3368 unregistered in entry 6
Like Show 0 Likes(0)

Actions
4. Re: JDE 9.2 Installation issue

Karthickrajan.K-Oracle Mar 26, 2018 8:39 AM (in response to 3667668)

Hi,

Required 32 bit ODBC entry is missing in your enterprise server

++++++++++++++++++++++++++++++++++++++++++++++++++++++

ODB0000010 - SQLDriverConnect failed. ODBC DSN: ENTSVR - 920 Server Map.

++++++++++++++++++++++++++++++++++++++++++++++++++++++

Add the ODBC Entry ENTSVR - 920 Server Map in ODBC32.exe then restart the E1 Service and check the log to proceed further.

Best Regards
Karthickrajan K
Like Show 1 Likes(1)

Actions
5. Re: JDE 9.2 Installation issue

3667668 Mar 26, 2018 9:56 AM (in response to Karthickrajan.K-Oracle)

Hi Karthik,

Thanks for your reply. But i dont find odbc.exe file instead i could see odbc.dll under folder \\ENTSVR\e\app\OracleHomeUser\product\12.1.0\dbhome_1\perl\site\lib\auto\Win32\ODBC .

Regards,
Thandapani A.
Like Show 0 Likes(0)

Actions
6. Re: JDE 9.2 Installation issue

3667668 Mar 27, 2018 6:39 AM (in response to Karthickrajan.K-Oracle)

Hi Karthik,

I have added the ODBC entry by running odbdcad32.exe. i have added under System DNS as shown below.
But still am getting same error in enterprise server log. Please have a look.
Like Show 0 Likes(0)

Actions

Go to original post