E1: DB: Database Has Lost Connection Issue in SQL 2005 SP1 and SP2 (Doc ID 657518.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Users see many database disconnect issues and long running processes are taking longer than usual after migrating to SQL 2005 from SQL 2000.  

The following errors are in the server JDE.LOG:

2272/3828 UNKNOWN                            Thu Sep 27 08:44:31.668007 Jdbodbc.c7837
ODB0000164 - STMT:00 [08S01][0] [Microsoft][SQL Native Client]Communication link failure

2272/3828 UNKNOWN                            Thu Sep 27 08:44:31.668010 Jdb_drvm.c982
JDB9900401 - Failed to execute db request

2272/3828 UNKNOWN                            Thu Sep 27 08:44:31.668012 Jtp_cm.c1300
JDB9900255 - Database connection to FZ103T1 (Business Data - SP_PROD) has been lost.

2272/3828 UNKNOWN                            Thu Sep 27 08:44:31.699003 Jtp_cm.c1252
JDB9900256 - Database connection to FZ103T1 (Business Data - SP_PROD) has been re-established.

2272/3828 UNKNOWN                            Thu Sep 27 08:46:56.809003 Odbclog.c435
ODB0000162 - Connection lost during earlier operation.

2272/3828 UNKNOWN                            Thu Sep 27 08:46:56.809005 Jdbodbc.c7837

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.