ERP9 Installation Plan Error

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

Can you find jdboci90.dll in you system/bin32 folder?
Are you using an old oracle client on the deployment server? (pre 9.x)

Re: RE: ERP9 Installation Plan Error

i have the jdboci90.dll in the path d:\PeopleSoft\B9\system\Bin32\.

The oracle client Version is 9.2.0.1

Thanks for the idea. Any more..
thanks a million times in advance