8.10 to 8.11 upgrade issues

[Edspec]

Hello all
In the process of a lab upgrade from 8.10 to 8.11 and finding a couple of issues

1 Installation plan spec merge shows as installed but the jde.log is showing

2484/2360 WRK:Starting jdeCallObject Thu Mar 16 09:04:13.789000 SpecRead.c1113
SpecRead - Object Name, 'F55EB00 ' for spec DDTABL is not in the F9860 table. This object needs to be in the F9860 table.

2484/2360 WRK:Starting jdeCallObject Thu Mar 16 09:04:16.899000 SpecRead.c1113
SpecRead - Object Name, 'F55EB01 ' for spec DDTABL is not in the F9860 table. This object needs to be in the F9860 table.

2484/2360 WRK:Starting jdeCallObject Thu Mar 16 09:04:17.446000 SpecRead.c1113
SpecRead - Object Name, 'F55EB02 ' for spec DDTABL is not in the F9860 table. This object needs to be in the F9860 table.

Errors for all F55 bespoke objects

2 Loging in on the deployment server into planner shows the following in jde.log

2640/3236 MAIN_THREAD Thu Mar 16 13:39:45.817000 Jdb_ctl.c3381
Starting OneWorld

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.207000 Jdb_rq1.c1289
JDB3100001 - Failed to open table F9200 because of invalid user handle

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.207001 Jdeddapi.c3937
JDB9910147 - Unable to open F9200

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.207002 Jdeddapi.c1451
JDB9900147 - Unable to open F9200

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.207003 Jdb_rst.c2726
JDB9900324 - Failed to find Data Dictionary Item NDNM

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.207004 Jdb_rst.c330
JDB9900913 - Failed to create global table specs for F986180

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.207005 Jdb_rst.c1128
JDB9900307 - Failed to find table specifications

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.207006 Jdb_rq1.c1601
JDB3100007 - Failed to get valid table specifications

2640/3236 MAIN_THREAD Thu Mar 16 13:39:57.223000 secnodemgr.c889
Unable to open table F986180

2640/1536 FOREIGN_THREAD Thu Mar 16 13:43:42.403000 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1

2640/1536 FOREIGN_THREAD Thu Mar 16 13:43:42.403001 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'PSData811.DBO.F96608'.


The two issues are probobly connected


System is Intel hardware Windows 2003 SQL 2000 with 8.10/8.11 tools release 8.95 and latest planner

Any help would be appreciated


Regards to all


John

 

[Terry Duffy]

Hi,

It would appear that the software is having problems connecting to your MSDE database.

Check it is attached and visible (you can use SQL Server enterprise manager from your database server to do this).

It may be visible from SQL but for some reasons JDE does not see it. I had a similar issue when trying to install ESU's.

The software could see and do everything within the planner environment BUT for some reason could not see the ESU databases, and would not install from Change Assistant or Software Updates.

The eventual cure for this was to install SP1 for Server 2003, (well it cured and got software updates working from within JDE at least - still waiting for GSS to resolve the Change Assistant part).

The problem lay with the oledb32.dll and msdart.dll files.

You could try this.