CSS
Member
Second SQL DB for DV\\PY
Please help - what am I missing here?
-----------------------------
We added a second SQL 2000 DB to our environment to house DV and PY business data, control tables, central objects and versions. Each of these databases were copied to the new server, JDE datasources were updated to look at the new server and a full package was deployed to a test client updating that clients ODBCs.
The ODBCs on the client test and JDE is able to pull up data in apps and versions are showing in BV but... UTB can not find the tables and the user jde log has the follwing errors:
2192/3700 MAIN_THREAD Sun Jun 22 11:15:47.998000 Jdb_ctl.c3488
Starting OneWorld
2192/3700 MAIN_THREAD Sun Jun 22 11:15:59.389000 Env.cpp140
Solution Explorer Started
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.702000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.702001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.702002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.764000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.764001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.764002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.780000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.780001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.795000 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.811000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.811001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.811002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.827000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.827001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.827002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.858000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.858001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.858002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.874000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.874001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.874002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.889000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.889001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.905000 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.920000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.920001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.920002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.952000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.952001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.952002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.983000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.983001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.983002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
Please help - what am I missing here?
-----------------------------
We added a second SQL 2000 DB to our environment to house DV and PY business data, control tables, central objects and versions. Each of these databases were copied to the new server, JDE datasources were updated to look at the new server and a full package was deployed to a test client updating that clients ODBCs.
The ODBCs on the client test and JDE is able to pull up data in apps and versions are showing in BV but... UTB can not find the tables and the user jde log has the follwing errors:
2192/3700 MAIN_THREAD Sun Jun 22 11:15:47.998000 Jdb_ctl.c3488
Starting OneWorld
2192/3700 MAIN_THREAD Sun Jun 22 11:15:59.389000 Env.cpp140
Solution Explorer Started
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.702000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.702001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.702002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.764000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.764001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.764002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.780000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.780001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.795000 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.811000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.811001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.811002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.827000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.827001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.827002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.858000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.858001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.858002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.874000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.874001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.874002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.889000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.889001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.905000 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.920000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.920001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.920002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.952000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.952001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.952002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.983000 Jdbodbc.c6169
ODB0000163 - wSQLFetch failure. rc=-1
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.983001 Jdbodbc.c6169
ODB0000164 - STMT:00 [24000][0] [Microsoft][ODBC SQL Server Driver]Invalid cursor state
2192/2872 WRK:Starting jdeCallObject Sun Jun 22 11:16:24.983002 Jdb_drvm.c1577
JDB9900189 - Failed to verify that table exists in Versions - DV9