Database Connectivity Errors

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.

We had the same problem a few weeks ago. We had to validate all the passwords to the database (login) to make sure the passwords were correct. Also, they are case sensitive. Check your JDE.INI and make sure that the DB password matches the actual one used in SQL Server. I believe that both the DB and Security passwords should match. Oracle had me change ours to lower case but this did not resolve our issue. When I changed the security password to lowercase, my problems were resolved.

Finally, just double check to make sure you are using the new driver for SQL Server 2005. We installed the SQL Native Client and used it over SQL 2000 in advanced of our migration to 2005.

E1 v8.10
SQL Server 2005
Tools 8.98.0.2
Windows Server 2003
Citrix
Web
Fat

There are some MS hotfixes that you should install with SQL2005 SP2 to solve the connection lost - re-established problems. We also had this but it went away after installing the hotfixes

To emphasize this point, the Oracle Minimum Technical Requirements mention cumulative update 6 for SP2 as one of the requirements, and recommend whatever is the latest, which was CU 12 last I looked.

The MTRs also mention official support for SQL Server 2005 SP3.

For your UBE Performance try adding:

Rowset Size=1 to the [DB SYSTEM SETTINGS] stanza on the server you run your UBE's on.

Acutally adding the Rowset line in INI file did not work. We resolved the issue by using the SQL Native Client.

Thank you all for your help.