mtrottier
Well Known Member
8.12 tools release 8.96.1.4
Only the last Envronment installed on the fat client can be logged into. Logging into any env other than the last one installed get messages like this in the jde.log:
4496/4872 MAIN_THREAD Tue Jan 29 18:25:58.197000 Jdb_ctl.c3489
Starting OneWorld
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947000 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947001 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SPEC_DVF101108.DBO.F98740DVF101108'.
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947002 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947003 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F98740DVF101108, ODBC DSN EnterpriseOne Local.
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947004 Jdbodbc.c3273
ODB0000027 - JDBODBC_DescribeTable failed. Table F98740DVF101108.
If I install the last full PD and then the last PY package I can only login to PY. If I then go back and install the last PD again I can login to PD but cannot login to PY.
I know the problem has to do with the local package spec files in the local MSSQL server but the fact that it works for that last installed environment and no others is confusing.
As I also mentioned it is important to note that each package seems to be OK becuase if it is the last one installed then the environment works witout issues and no messages appear in the JDE.LOG file.
I'm so confused
Only the last Envronment installed on the fat client can be logged into. Logging into any env other than the last one installed get messages like this in the jde.log:
4496/4872 MAIN_THREAD Tue Jan 29 18:25:58.197000 Jdb_ctl.c3489
Starting OneWorld
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947000 Odbc_u1.c901
ODB0000163 - wSQLNumResultCols failure. rc=-1
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947001 Odbc_u1.c901
ODB0000164 - STMT:00 [42S02][208] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SPEC_DVF101108.DBO.F98740DVF101108'.
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947002 Odbc_u1.c901
ODB0000164 - STMT:01 [42000][8180] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947003 Odbc_u1.c909
ODB0000155 - SQLNumResultsCols failed. Table F98740DVF101108, ODBC DSN EnterpriseOne Local.
4496/4872 MAIN_THREAD Tue Jan 29 18:26:09.947004 Jdbodbc.c3273
ODB0000027 - JDBODBC_DescribeTable failed. Table F98740DVF101108.
If I install the last full PD and then the last PY package I can only login to PY. If I then go back and install the last PD again I can login to PD but cannot login to PY.
I know the problem has to do with the local package spec files in the local MSSQL server but the fact that it works for that last installed environment and no others is confusing.
As I also mentioned it is important to note that each package seems to be OK becuase if it is the last one installed then the environment works witout issues and no messages appear in the JDE.LOG file.
I'm so confused