Application drops connection to 2005 SQL database when updating.
Posted on 2013-05-22
We are running a scheduled task that will update a database each day. The update can have anywhere between 2000 and 8000 records. When we run this process, it is stopping part way through. This process was initially running on an Informix DB and has been moved to a 2005SQL DB. Since we have moved the database, we have not been able to get this process to work on a regular basis.
When the task errors we are seeing the following information:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Transmission Control Protocol
Acknowledgment Number: 0x54a217f9 [should be 0x00000000 because ACK flag is not set]
Acknowledgment number: Broken TCP. The acknowledge filed is nonzero while the ACK flag is not set]
NT Status: STATUS_PIPE_DISCONNECTED (0xc00000b0)
It looks to me that the application server that executes the task is sending a request to the database server to disconnect the communication pipe between the two systems.
This process can be run again after removing the data that was successfully updated, sometimes it may take up to 8 times before it completes. The data in the update file is clean and accurate, void of any errors.
OS: Windows 2003 Standard 64 bit Server SP2
Database: 2005 SQL
DB Connectors: ODBC