thejdofva
Member
Hi All
I have just moved my production database from a SQL2000 server to a cluster 64bit sql2005 sp2 server with 32gb memory server.
After the move, my users started to have issue with their reports. following is a sample of the log file with the type of errors showing up:
------------------------------------
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388001 Jdbodbc.c7843
ODB0000163 - wSQLExecute failure. rc=-1
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388002 Jdbodbc.c7843
ODB0000164 - STMT:00 [01000][10054] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()).
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388003 Jdbodbc.c7843
ODB0000164 - STMT:01 [HY018][11] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388004 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388005 Jtp_cm.c1300
JDB9900255 - Database connection to F0911 (Business Data - PROD) has been lost.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388006 Jtp_cm.c1252
JDB9900256 - Database connection to F0911 (Business Data - PROD) has been re-established.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731000 Jdbodbc.c2668
ODB0000019 - DBResetRequest failed - lost database connection.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731001 Jdb_drvm.c1150
JDB9900176 - Failed to reset db request
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731002 Jtp_cm.c1300
JDB9900255 - Database connection to F0411 (Business Data - PROD) has been lost.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731003 Jtp_cm.c1252
JDB9900256 - Database connection to F0411 (Business Data - PROD) has been re-established.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.747000 Jdbodbc.c2668
ODB0000019 - DBResetRequest failed - lost database connection.
------------------------------
Also, on the old server(enterprise/sql2000), I used to run R0006P to gauge the performance and it used to take 1 second, now with all the power on the new server it takes 3 to 6 seconds.
Any ideas what is going on here....any suggestions
Thanking you in advance.
I have just moved my production database from a SQL2000 server to a cluster 64bit sql2005 sp2 server with 32gb memory server.
After the move, my users started to have issue with their reports. following is a sample of the log file with the type of errors showing up:
------------------------------------
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388001 Jdbodbc.c7843
ODB0000163 - wSQLExecute failure. rc=-1
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388002 Jdbodbc.c7843
ODB0000164 - STMT:00 [01000][10054] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()).
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388003 Jdbodbc.c7843
ODB0000164 - STMT:01 [HY018][11] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388004 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388005 Jtp_cm.c1300
JDB9900255 - Database connection to F0911 (Business Data - PROD) has been lost.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:36.388006 Jtp_cm.c1252
JDB9900256 - Database connection to F0911 (Business Data - PROD) has been re-established.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731000 Jdbodbc.c2668
ODB0000019 - DBResetRequest failed - lost database connection.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731001 Jdb_drvm.c1150
JDB9900176 - Failed to reset db request
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731002 Jtp_cm.c1300
JDB9900255 - Database connection to F0411 (Business Data - PROD) has been lost.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.731003 Jtp_cm.c1252
JDB9900256 - Database connection to F0411 (Business Data - PROD) has been re-established.
5960/5868 WRK:Starting jdeCallObject Mon Mar 23 12:52:37.747000 Jdbodbc.c2668
ODB0000019 - DBResetRequest failed - lost database connection.
------------------------------
Also, on the old server(enterprise/sql2000), I used to run R0006P to gauge the performance and it used to take 1 second, now with all the power on the new server it takes 3 to 6 seconds.
Any ideas what is going on here....any suggestions
Thanking you in advance.