CNC: E9 install / upgrade error - has anyone seen this ??

cncjay

Well Known Member
Platform Win 2005 SP2 + SQL 2005

Summary:

Dep Server: Installed dep server with Pristine and Development as custom install. Also installed latest planner and tools 8.98.1

Ent server: Install platform pack, jde code + databases for pristine and dev pathcodes as upgrade option

Copied jdeplan.mdb from old system (ERP8) to new dep server for ease of access. Created OneWorld planner - B7334 datasource and pointed to it. Created other shared datasouces to point to the old ERP8 configuration.

Issue: In launching Custom Plan installer. Click on ADD plan, gave plan a name. Chose B7334 to E9 as upgrade. While no errors are seen on E1, the following is seen in jde.log

400/1696 WRK:Starting jdeCallObject Wed May 13 18:42:59.595000 SpecPkgBld.c4280
SPC0000502 - Could not determine database type for data source. Data source is probably invalid. (Datasource: Local - PLANNER Specs)

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:42:59.595001 SpecOpen.c2615
jdeSpecOpenLocalOpt completed in error - JDESPECRESULT_FAILED.

Clicking next, on plan screen, selecting System - B7334 as previous system datasource, by clicking next. Following errors are seen:

400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970000 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970001 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][SQL Native Client][SQL Server]Invalid object name 'JDESQL1.SYS7334.F0094'.

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970002 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970003 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F0094, ODBC DSN System - B7334.

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970004 Jdbodbc.c3285
ODB0000027 - JDBODBC_DescribeTable failed. Table F0094.

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970005 Jdb_drvm.c1026
JDB9900168 - Failed to initialize db request

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970006 Jtp_cm.c1015
JDB9909007 - Unable to obtain driver request handle

3400/1696 WRK:Starting jdeCallObject Wed May 13 18:43:29.970007 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1


Lastly, the "System - B7334" which was setup in ODBC as "SQL Server" is for some unknown reason changed to "SQL Native client"

Anyone has seen anything like this ??? Any input is greatly appreciated !!
 

Attachments

  • 145873-PLAN ERRORS1.zip
    1 KB · Views: 77
Hi,

You B7334 Planner database should be "Access", not "SQL".
Please, change its Data Source definition to Access, fix
the corresponding ODBC and try again
 
[ QUOTE ]
Hi,

You B7334 Planner database should be "Access", not "SQL".
Please, change its Data Source definition to Access, fix
the corresponding ODBC and try again

[/ QUOTE ]

Sebastian - Thank you for your feedback. My configuration was actually setup correctly.

The resolution was that I had a corrupted SQL Native client driver. As a last resort, I reinstalled it and everything worked like a champ. Something must not have installed correctly at the time of diskspin on the deployment server

Regards !!
CNCjay
 
Back
Top