ERP9 Installtion Plan Error

sunnyind

Well Known Member
Hi All,

I am in the process of installing ERP9 on Win2K,Oracle 9i (9.2.0.4).After installing MSDE and deployment server I installed the latest planner ESU PF212.

Now I created a typical installation plan with default environments and data sources.While validating the plan it is popping up an error " Database driver load failed - jdboci90.DLL" (I am able to connect to the Database from the deployment server)

Did anyone get the same error...if yes can you please let me know how to proceed from here on.I am attaching jde.log and jdedebug.log for your understanding.

Thanks in advance.

Sunny

----------------------------------------------------------------------------------------------
JDE.LOG
----------------------------------------------------------------------------------------------


1088/1824 Mon Dec 15 16:48:45.734 jdb_ctl.c2700
Starting OneWorld

1088/1824 Mon Dec 15 16:48:55.218 Env.cpp136
Solution Explorer Started

1088/1224 Mon Dec 15 16:50:29.828 jdb_drvm.c423
JDB9900160 - Failed to load driver library jdboci90.DLL

1088/1224 Mon Dec 15 16:50:36.093 jdb_omp1.c1857
JDB9900254 - Failed to initialize driver.

1088/1224 Mon Dec 15 16:50:36.093 JTP_CM.C169
JDB9909002 - Could not init connect.

1088/1224 Mon Dec 15 16:50:36.093 JTP_TM.C1098
JDB9909102 - Get connect info failed: Transaction ID =

1088/1224 Mon Dec 15 16:50:36.093 jdb_rq1.c2410
JDB2700003 - Failed to connect to the DataSource (null) failed

1088/1224 Mon Dec 15 16:50:36.953 jdb_drvm.c423
JDB9900160 - Failed to load driver library jdboci90.DLL

1088/1224 Mon Dec 15 16:50:37.703 jdb_omp1.c1857
JDB9900254 - Failed to initialize driver.

1088/1224 Mon Dec 15 16:50:37.703 JTP_CM.C169
JDB9909002 - Could not init connect.

1088/1224 Mon Dec 15 16:50:37.703 JTP_TM.C1040
JDB9909100 - Get connect info failed: Transaction ID =

1088/1224 Mon Dec 15 16:50:37.703 jdb_rq1.c1950
JDB3100013 - Failed to get connectinfo

1088/1224 Mon Dec 15 16:50:37.718 jdb_rq1.c9526
JDB3100066 - Failed to open table F0101

1088/1224 Mon Dec 15 16:50:37.718 jdb_exem.c204
JDB3100076 - Failed to validate table specs

1088/1224 Mon Dec 15 16:52:18.843 jdb_exef.c3029
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.

1088/1224 Mon Dec 15 16:52:18.859 jdb_exef.c3029
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.

1088/1224 Mon Dec 15 16:53:01.687 jdb_ctl.c6251
JDB9900155 - Failed to get non - zero AB Number.

----------------------------------------------------------------------------------------------------------------------
JDEDEBUG.LOG
----------------------------------------------------------------------------------------------
Dec 15 16:50:36.828 - 1088/1224 Fetched the record
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.828 - 1088/1224 Entering JDB_FreeUser (UserHandle 07B3B580)
Dec 15 16:50:36.828 - 1088/1224 Exiting JDB_FreeUser with Success(UserHandle 07B3B580)
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocalIndexed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:36.828 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.843 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:36.859 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.859 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:36.859 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.859 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:36.859 - 1088/1224 SpecEncapsulation : jdeSpecSelectKeyed completed OK.
Dec 15 16:50:36.859 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:36.953 - 1088/1224 Database driver name is 'jdboci90.DLL'
Dec 15 16:50:36.953 - 1088/1224 JDB9900160 - Failed to load driver library jdboci90.DLL
Dec 15 16:50:37.703 - 1088/1224 Showing message (null)
Dec 15 16:50:37.703 - 1088/1224 JDB9900254 - Failed to initialize driver.
Dec 15 16:50:37.703 - 1088/1224 JDB9909002 - Could not init connect.
Dec 15 16:50:37.703 - 1088/1224 JDB9909100 - Get connect info failed: Transaction ID =
Dec 15 16:50:37.703 - 1088/1224 JDB3100013 - Failed to get connectinfo
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_OpenTable(Table = F0101) with Failure
Dec 15 16:50:37.718 - 1088/1224 JDB3100066 - Failed to open table F0101
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_ValidateTableSpecs with Failure for table F0101 in data source System - B9
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_FreeUser (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_FreeUser with Success(UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 JDB3100076 - Failed to validate table specs
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_CreateTableX with Failure (Table F0101)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_CreateTable with Failure (Table F0101)
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_GetEnv
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_GetEnv with Success
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_InitUser with (AUTO commit mode)
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_BeginTransaction (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_BeginTransaction with Success (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_InitUser with Success (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:37.718 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_FreeUser (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_FreeUser with Success(UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_GetEnv
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_GetEnv with Success
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_InitUser with (AUTO commit mode)
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_BeginTransaction (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_BeginTransaction with Success (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_InitUser with Success (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Entering JDB_FreeUser (UserHandle 0B213988)
Dec 15 16:50:37.718 - 1088/1224 Exiting JDB_FreeUser with Success(UserHandle 0B213988)
Dec 15 16:50:37.734 - 1088/1224 Entering JDB_GetEnv
Dec 15 16:50:37.734 - 1088/1224 Exiting JDB_GetEnv with Success
Dec 15 16:50:37.734 - 1088/1224 Entering JDB_InitUser with (AUTO commit mode)
Dec 15 16:50:37.734 - 1088/1224 Entering JDB_BeginTransaction (UserHandle 0B213988)
Dec 15 16:50:37.734 - 1088/1224 Exiting JDB_BeginTransaction with Success (UserHandle 0B213988)
Dec 15 16:50:37.734 - 1088/1224 Exiting JDB_InitUser with Success (UserHandle 0B213988)
Dec 15 16:50:37.734 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:37.734 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:37.734 - 1088/1224 Entering JDB_FreeUser (UserHandle 0B213988)
Dec 15 16:50:37.734 - 1088/1224 Exiting JDB_FreeUser with Success(UserHandle 0B213988)
Dec 15 16:50:37.734 - 1088/1224 ERROR INFO JDEERR - ID= 2, Error= 4838 - \\DENXPI44\B9\PD9\package\PF209\source\B9800200.c, Line= 141
Dec 15 16:50:37.734 - 1088/1224 Create Table Failed
Dec 15 16:50:37.734 - 1088/1224 SpecEncapsulation : jdeSpecOpenLocal completed OK.
Dec 15 16:50:37.734 - 1088/1224 SpecEncapsulation : Close completed.
Dec 15 16:50:37.734 - 1088/1224 **********************************************************************************
Dec 15 16:50:37.734 - 1088/1224 *** Start dumping data structure for business function CreateTable
Dec 15 16:50:37.734 - 1088/1224 **********************************************************************************
Dec 15 16:50:37.734 - 1088/1224 OUT->[ 1] <Item>: idApplication <type>: ID <Value>: [1]
Dec 15 16:50:37.734 - 1088/1224 OUT->[ 2] <Item>: szDatabasepath <type>: STRING <Value>: [System - B9]
Dec 15 16:50:37.734 - 1088/1224 OUT->[ 3] <Item>: szObjectownerid <type>: STRING <Value>: [SY9]
Dec 15 16:50:37.734 - 1088/1224 OUT->[ 4] <Item>: szSignonpassword <type>: STRING <Value>: [SY9 ]
Dec 15 16:50:37.734 - 1088/1224 OUT->[ 5] <Item>: szApplication <type>: STRING <Value>: [F0101]
Dec 15 16:50:37.734 - 1088/1224 **********************************************************************************
Dec 15 16:50:37.734 - 1088/1224 *** End dumping data structure for business function CreateTable
Dec 15 16:50:37.734 - 1088/1224 **********************************************************************************
Dec 15 16:50:37.734 - 1088/1224 Return value is 2 for CreateTable. (BSFNLevel = 1)
Dec 15 16:50:37.734 - 1088/1224 Entering AddObjectCache
Dec 15 16:50:37.734 - 1088/1224 Entering JDB_GetTableColnfo
Dec 15 16:50:37.734 - 1088/1224 Exiting JDB_GetTableColnfo
Dec 15 16:50:37.734 - 1088/1224 Entering JDB_GetTableColnfo
Dec 15 16:50:37.734 - 1088/1224 Exiting JDB_GetTableColnfo
Dec 15 16:50:37.734 - 1088/1224 Entering JDB_OpenTable(Table = F9860)
Dec 15 16:50:37.734 - 1088/1760 [JDBOLEDB] Session 0xAFCA490:135 added to map. Map size = 36.
Dec 15 16:50:37.734 - 1088/1760 [JDBOLEDB] ODDBInitConnection::main() 0xAFCA490 server = AGRD\JDELocal; DB server version = 08.00.0760; OLEDB version = 02.70; provider version = 08.10.9031; DB = JDELocal; uid = sa; comtype = A; JDBcurtype = 0; refNum = 7; share = Y.
Dec 15 16:50:37.734 - 1088/1224 Exiting JDB_OpenTable(Table = F9860) with Success
Dec 15 16:50:37.734 - 1088/1224 E
 
Hi Sunny,
try this

Check PathCode Master (P980042) for Planner pathcode.
Maybe was missing "OneWorld Local" in the field for the Deployment Data Source for Planner.

Good Luck
Gigi
 
Thanks Gigi,

Checked..Its alright.

Is there any setting or something that needs to be done for the JDE user after first time login..what should i check? or the MSDE database.

Thanks a million times ..:)
 
Sunny,
check database datasources fo Planner environment that point to MSDE database (OneWorld Local....), you must setup as Location the Deployment name not (local).
On the other hand I received a similar error on an installation of EnterpriseOne with UDB DB2 8.1, the problem was incorrect setup of UDB DB2 port of EnterpriseOne database datasource definition.

Gigi
 
Sunny,
the error "Database driver load failed - jdboci90.DLL" does not necessarily mean that this dll is missing. It may mean that it is not succeeding in findind other DLLs, like the Oracle libraries.
Check if your PATH variable on your client machine or DS points to the apropriate Oracle-client directories.
The Oracle client installation has a history of not setting these environment variables correctly. Check for spaces in the PATH=... string.

Good luck, Gerd
 
Thanks a Lot to all..
To a certain extent with respect to my case, Gred u are right .. After I reinstalled the Oracle Client on the Deployment Server I was able to Validate my Plan.

Thanks a million times..to ALL

:))
 
Back
Top