tiradoj
Well Known Member
Hello Again Fellow JDE Warriors
I notice in my pretty new 9.0 Data Source Master screen a new? Data Source called "PkgBld MSDE WINDEP001" WINDEP001 being the name of my deployment server.
This is pointing to a default database entry of the same name "PkgBld MSDE WINDEP001"
Anyone know what this is for?
Did a search in the 9.0 manual, searched Known issues doc and searched via Knowledge Garden and guess what? No such hit on "PkgBld MSDE"
More slop from the slop factory
I get this error in JDE LOG during installation workbench.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.765000 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][SQL Native Client][SQL Server]Invalid
object name 'SPEC_DV900FA.DBO.F98770DV900FA'.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.765001 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][SQL Native Client][SQL
Server]Statement(s) could not be prepared.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.765002 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F98770DV900FA, ODBC DSN PkgBld MSDE
WINDEP001.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.781000
Jdbodbc.c3304
ODB0000027 - JDBODBC_DescribeTable failed. Table F98770DV900FA.
As an aside, I notice the database names--logical names for local dbs (on a workstation or under 'pkgspec' folder on dep svr) get create with an extra underscore in them (for example SPEC__PKGNAME) -even in 8.12 and it looks like the feature? is continued in 9.0.
When I do my manual attachments on workstations using sql server express 2005 I remove the extra underscore and then everything works fine.
If it is adding the extra underscore "by design" I am not sure what I am missing because I don't have pkg build issues on 8.12 or data retrieval issues, but I do have to remove the second underscore or it won't attach because the physical db has one underscore.
Anyone have other experiences? It looks like an issue relating to prepping the default "FA" pkgs delivered at the end of the installation plan.
I have a pkg name with ONE underscore in spec folder then in pkgspec folder have same pkg name with TWO underscores.
anyone know the RATIONAL reason we need two copies taking up double the disk space or might this be a pkg inf config issue where it generated a second set of spec dbs for workstation?
Joe Tirado
Senior CNC Consultant.
I notice in my pretty new 9.0 Data Source Master screen a new? Data Source called "PkgBld MSDE WINDEP001" WINDEP001 being the name of my deployment server.
This is pointing to a default database entry of the same name "PkgBld MSDE WINDEP001"
Anyone know what this is for?
Did a search in the 9.0 manual, searched Known issues doc and searched via Knowledge Garden and guess what? No such hit on "PkgBld MSDE"
More slop from the slop factory
I get this error in JDE LOG during installation workbench.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.765000 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][SQL Native Client][SQL Server]Invalid
object name 'SPEC_DV900FA.DBO.F98770DV900FA'.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.765001 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][SQL Native Client][SQL
Server]Statement(s) could not be prepared.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.765002 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F98770DV900FA, ODBC DSN PkgBld MSDE
WINDEP001.
2744/3688 WRK:Starting jdeCallObject Sun Aug 16 02:49:34.781000
Jdbodbc.c3304
ODB0000027 - JDBODBC_DescribeTable failed. Table F98770DV900FA.
As an aside, I notice the database names--logical names for local dbs (on a workstation or under 'pkgspec' folder on dep svr) get create with an extra underscore in them (for example SPEC__PKGNAME) -even in 8.12 and it looks like the feature? is continued in 9.0.
When I do my manual attachments on workstations using sql server express 2005 I remove the extra underscore and then everything works fine.
If it is adding the extra underscore "by design" I am not sure what I am missing because I don't have pkg build issues on 8.12 or data retrieval issues, but I do have to remove the second underscore or it won't attach because the physical db has one underscore.
Anyone have other experiences? It looks like an issue relating to prepping the default "FA" pkgs delivered at the end of the installation plan.
I have a pkg name with ONE underscore in spec folder then in pkgspec folder have same pkg name with TWO underscores.
anyone know the RATIONAL reason we need two copies taking up double the disk space or might this be a pkg inf config issue where it generated a second set of spec dbs for workstation?
Joe Tirado
Senior CNC Consultant.