OK
I understand about the MTR stuff and all the local data sources are using native client 10.0 driver
However
I was using SQL Server express editions on deployment LONG before JDE admitted it would work and I don't see a technical reason why it would NOT work if it works on the full 2008 edition on ent servr and the 898.X service packs are in place.
My question is it appears E1 is looking SPECIFICALLY for what it calls a "key" in the spec.ini file
The reference Planner_Package=E900 to be exact. What is E900? As I say in 812 this was "MASTER" and the only MASTER I know of is local SQL Servr db. Is this entry same in others spec.ini?
Is E900 to specify release level or a Planner db? I have no such thing. Does anyone else have other Here is spec.ini I have and log below (other tables and fetches work fine)
You can see that the odbc connection is working for other tables in debug log "success"
Thanks again
[SPEC LOCATIONS]
PLANNER_DataSource=Local - PLANNER Specs
PLANNER_Package=E900
DV900_DataSource=Local - PLANNER Specs
DV900_Package=E900
PD900_DataSource=Local - PLANNER Specs
PD900_Package=E900
PS900_DataSource=Local - PLANNER Specs
PS900_Package=E900
PY900_DataSource=Local - PLANNER Specs
PY900_Package=E900
########################################
jdedebug.log
6 - 2880/2620 MAIN_THREAD Fetched the record
Aug 12 13:46:35.875027 - 2880/2620 MAIN_THREAD Fetched the record
Aug 12 13:46:35.875028 - 2880/2620 MAIN_THREAD Fetched the record
Aug 12 13:46:35.875029 - 2880/2620 MAIN_THREAD Fetched the record
Aug 12 13:46:35.875030 - 2880/2620 MAIN_THREAD No More Data found
Aug 12 13:46:35.875031 - 2880/2620 MAIN_THREAD Entering JDB_CloseTable
Aug 12 13:46:35.875032 - 2880/2620 MAIN_THREAD Entering JDB_CloseTable(Table = F98611)
Aug 12 13:46:35.875033 - 2880/2620 MAIN_THREAD Entering JDB_ClearSequencing
Aug 12 13:46:35.875034 - 2880/2620 MAIN_THREAD Exiting JDB_ClearSequencing with Success
Aug 12 13:46:35.875035 - 2880/2620 MAIN_THREAD Entering JDB_ClearSelection
Aug 12 13:46:35.875036 - 2880/2620 MAIN_THREAD Exiting JDB_ClearSelection with Success
Aug 12 13:46:35.875037 - 2880/2620 MAIN_THREAD Entering JDB_ClearAggregate
Aug 12 13:46:35.875038 - 2880/2620 MAIN_THREAD Exiting JDB_ClearAggregate with Success
Aug 12 13:46:35.875039 - 2880/2620 MAIN_THREAD Entering JDB_ClearGroupBy
Aug 12 13:46:35.875040 - 2880/2620 MAIN_THREAD Exiting JDB_ClearGroupBy with Success
Aug 12 13:46:35.875041 - 2880/2620 MAIN_THREAD ODBC:X DBFreeRequest(close) req=08944080 con=03924100
Aug 12 13:46:35.875042 - 2880/2620 MAIN_THREAD Entering JDB_ClearBuffers
Aug 12 13:46:35.875043 - 2880/2620 MAIN_THREAD Exiting JDB_ClearBuffers with success.
Aug 12 13:46:35.875044 - 2880/2620 MAIN_THREAD Exiting JDB_CloseTable(Table = F98611) with Success
Aug 12 13:46:35.875045 - 2880/2620 MAIN_THREAD Exiting JDB_CloseTable with Success
Aug 12 13:46:35.875046 - 2880/2620 MAIN_THREAD Entering JDB_OpenTable(Table = F00941)
Aug 12 13:46:35.875047 - 2880/2620 MAIN_THREAD ODBC:X DBInitConnection shr(5) con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 cur=0,3,6 sep=. (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.875048 - 2880/2620 MAIN_THREAD Exiting JDB_OpenTable(Table = F00941) with Success
Aug 12 13:46:35.875049 - 2880/2620 MAIN_THREAD Entering JDB_FetchKeyed
Aug 12 13:46:35.875050 - 2880/2620 MAIN_THREAD ODBC:X DBInitRequest(new) req=08993028 con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.875051 - 2880/2620 MAIN_THREAD SELECT * FROM JDEPlan900.DBO.F00941 WHERE ( LMLL = 'JDEPLAN' )
Aug 12 13:46:35.875052 - 2880/2620 MAIN_THREAD Entering DBPerformRequest
Aug 12 13:46:35.875053 - 2880/2620 MAIN_THREAD ODBC:X DBPerformRequest req=08993028 con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.875054 - 2880/2620 MAIN_THREAD Exiting DBPerformRequest
Aug 12 13:46:35.875055 - 2880/2620 MAIN_THREAD Opening up local metadata repository. Type - JDESPECTYPE_GBRLINK.
Aug 12 13:46:35.890000 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890001 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890002 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890003 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890004 - 2880/2620 MAIN_THREAD Package name not passed to SetupPackageRDB. Using current running package.
Aug 12 13:46:35.890005 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890006 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890007 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890008 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890009 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890010 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890011 - 2880/2620 MAIN_THREAD A value is not defined for the key, PLANNER_Package, in the SPEC LOCATIONS section of the spec.ini file.
Aug 12 13:46:35.890012 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890013 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890014 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890015 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890016 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890017 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890018 - 2880/2620 MAIN_THREAD A value is not defined for the key, PLANNER_DataSource, in the SPEC LOCATIONS section of the spec.ini file.
Aug 12 13:46:35.890019 - 2880/2620 MAIN_THREAD JDESPEC0000044 - Could not determine spec package name for the path code, PLANNER. Please check the key, PLANNER_Package, in the SPEC LOCATIONS section of the JDE.INI file or the spec.ini file. This settings need to be availabe in one of these files.
Aug 12 13:46:35.890021 - 2880/2620 MAIN_THREAD JDESPEC0000045 - Could not determine spec datasource name for the path code, PLANNER. Please check the key, PLANNER_DataSource, in the SPEC LOCATIONS section of the JDE.INI file or the spec.ini file. This settings need to be availabe in one of these files.
Aug 12 13:46:35.890023 - 2880/2620 MAIN_THREAD Local RDBMS data format is always XML.
Aug 12 13:46:35.890024 - 2880/2620 MAIN_THREAD SpecEncapsulation : jdeSpecOpenLocalOpt completed in error - JDESPECRESULT_FAILED.
Aug 12 13:46:35.890025 - 2880/2620 MAIN_THREAD jdeSpecOpenLocalOpt completed in error - JDESPECRESULT_FAILED.
Aug 12 13:46:35.890027 - 2880/2620 MAIN_THREAD Fetched the record
Aug 12 13:46:35.890028 - 2880/2620 MAIN_THREAD Entering JDB_CloseTable
Aug 12 13:46:35.890029 - 2880/2620 MAIN_THREAD Entering JDB_CloseTable(Table = F00941)
Aug 12 13:46:35.890030 - 2880/2620 MAIN_THREAD Entering JDB_ClearSequencing
Aug 12 13:46:35.890031 - 2880/2620 MAIN_THREAD Exiting JDB_ClearSequencing with Success
Aug 12 13:46:35.890032 - 2880/2620 MAIN_THREAD Entering JDB_ClearSelection
Aug 12 13:46:35.890033 - 2880/2620 MAIN_THREAD Exiting JDB_ClearSelection with Success
Aug 12 13:46:35.890034 - 2880/2620 MAIN_THREAD Entering JDB_ClearAggregate
Aug 12 13:46:35.890035 - 2880/2620 MAIN_THREAD Exiting JDB_ClearAggregate with Success
Aug 12 13:46:35.890036 - 2880/2620 MAIN_THREAD Entering JDB_ClearGroupBy
Aug 12 13:46:35.890037 - 2880/2620 MAIN_THREAD Exiting JDB_ClearGroupBy with Success
Aug 12 13:46:35.890038 - 2880/2620 MAIN_THREAD ODBC:X DBFreeRequest(close) req=08993028 con=0896CCC0
Aug 12 13:46:35.890039 - 2880/2620 MAIN_THREAD Entering JDB_ClearBuffers
Aug 12 13:46:35.890040 - 2880/2620 MAIN_THREAD Exiting JDB_ClearBuffers with success.
Aug 12 13:46:35.890041 - 2880/2620 MAIN_THREAD Exiting JDB_CloseTable(Table = F00941) with Success
Aug 12 13:46:35.890042 - 2880/2620 MAIN_THREAD Exiting JDB_CloseTable with Success
Aug 12 13:46:35.890043 - 2880/2620 MAIN_THREAD Entering JDB_OpenTable(Table = F00942)
Aug 12 13:46:35.890044 - 2880/2620 MAIN_THREAD ODBC:X DBInitConnection shr(6) con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 cur=0,3,6 sep=. (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.890045 - 2880/2620 MAIN_THREAD Exiting JDB_OpenTable(Table = F00942) with Success
Aug 12 13:46:35.890046 - 2880/2620 MAIN_THREAD Entering JDB_OpenTable(Table = F00945)
Aug 12 13:46:35.890047 - 2880/2620 MAIN_THREAD ODBC:X DBInitConnection shr(7) con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 cur=0,3,6 sep=. (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.890048 - 2880/2620 MAIN_THREAD Exiting JDB_OpenTable(Table = F00945) with Success
Aug 12 13:46:35.890049 - 2880/2620 MAIN_THREAD Entering JDB_FetchKeyed
Aug 12 13:46:35.890050 - 2880/2620 MAIN_THREAD ODBC:X DBInitRequest(new) req=04FAF3F8 con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.890051 - 2880/2620 MAIN_THREAD SELECT * FROM JDEPlan900.DBO.F00942 WHERE ( EMPATHCD = 'PLANNER' )
Aug 12 13:46:35.890052 - 2880/2620 MAIN_THREAD Entering DBPerformRequest
Aug 12 13:46:35.890053 - 2880/2620 MAIN_THREAD ODBC:X DBPerformRequest req=04FAF3F8 con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.890054 - 2880/2620 MAIN_THREAD Exiting DBPerformRequest
Aug 12 13:46:35.890055 - 2880/2620 MAIN_THREAD Opening up local metadata repository. Type - JDESPECTYPE_GBRLINK.
Aug 12 13:46:35.890056 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890057 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890058 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890059 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890060 - 2880/2620 MAIN_THREAD Package name not passed to SetupPackageRDB. Using current running package.
Aug 12 13:46:35.890061 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890062 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890063 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890064 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890065 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890066 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890067 - 2880/2620 MAIN_THREAD A value is not defined for the key, PLANNER_Package, in the SPEC LOCATIONS section of the spec.ini file.
Aug 12 13:46:35.890068 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890069 - 2880/2620 MAIN_THREAD PKGBLD: Entering IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890070 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890071 - 2880/2620 MAIN_THREAD Entering IntSvrPkgGetINIPaths
Aug 12 13:46:35.890072 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniFilePath
Aug 12 13:46:35.890073 - 2880/2620 MAIN_THREAD PKGBLD: Exiting IntSvrPkgGetSpecIniPrivateProfileString
Aug 12 13:46:35.890074 - 2880/2620 MAIN_THREAD A value is not defined for the key, PLANNER_DataSource, in the SPEC LOCATIONS section of the spec.ini file.
Aug 12 13:46:35.890075 - 2880/2620 MAIN_THREAD JDESPEC0000044 - Could not determine spec package name for the path code, PLANNER. Please check the key, PLANNER_Package, in the SPEC LOCATIONS section of the JDE.INI file or the spec.ini file. This settings need to be availabe in one of these files.
Aug 12 13:46:35.890077 - 2880/2620 MAIN_THREAD JDESPEC0000045 - Could not determine spec datasource name for the path code, PLANNER. Please check the key, PLANNER_DataSource, in the SPEC LOCATIONS section of the JDE.INI file or the spec.ini file. This settings need to be availabe in one of these files.
Aug 12 13:46:35.890079 - 2880/2620 MAIN_THREAD Local RDBMS data format is always XML.
Aug 12 13:46:35.890080 - 2880/2620 MAIN_THREAD SpecEncapsulation : jdeSpecOpenLocalOpt completed in error - JDESPECRESULT_FAILED.
Aug 12 13:46:35.890081 - 2880/2620 MAIN_THREAD jdeSpecOpenLocalOpt completed in error - JDESPECRESULT_FAILED.
Aug 12 13:46:35.890083 - 2880/2620 MAIN_THREAD Fetched the record
Aug 12 13:46:35.890084 - 2880/2620 MAIN_THREAD Entering JDB_FetchKeyed
Aug 12 13:46:35.906000 - 2880/2620 MAIN_THREAD ODBC:X DBInitRequest(new) req=04FC10C0 con=0896CCC0 env=03BF12A0 dbc=03BF2698 spid=52 (local) A (JDE@EnterpriseOne SSELocal)
Aug 12 13:46:35.906001 - 2880/2620 MAIN_THREAD SELECT * FROM JDEPlan900.DBO.F00945 WHERE ( RMRLS = 'E900' )