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

    JDE 9.2 Installation issue

    3667668

      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

          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!

          • 2. Re: JDE 9.2 Installation issue
            Karthickrajan.K-Oracle

            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 

            • 3. Re: JDE 9.2 Installation issue
              3667668

              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

              • 4. Re: JDE 9.2 Installation issue
                Karthickrajan.K-Oracle

                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

                • 5. Re: JDE 9.2 Installation issue
                  3667668

                  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.

                  • 6. Re: JDE 9.2 Installation issue
                    3667668

                    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.