Solved

Application drops connection to 2005 SQL database when updating.

Posted on 2013-05-22
6
347 Views
Last Modified: 2013-06-03
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:
Event Log:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Wire Shark
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]
SMB Header
      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.

SYSTEM INFORMATION:
OS:            Windows 2003 Standard 64 bit Server SP2
Database:            2005 SQL
DB Connectors:      ODBC
Program:            VB-6
0
Comment
Question by:piggly
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:Koen Van Wielink
ID: 39189737
Is it possible that the connection is timing out because the update takes too long?
0
 
LVL 12

Expert Comment

by:Koen Van Wielink
ID: 39189738
Is it possible that the connection is timing out because the update takes too long?
0
 
LVL 12

Expert Comment

by:Koen Van Wielink
ID: 39189739
Is it possible that the connection is timing out because the update takes too long?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:piggly
ID: 39195652
No, I don't believe this is the case, because one of the tests only ran for about two seconds.  The application processed about 120 records in that time before the error.  How would I test for this to be sure?
0
 

Accepted Solution

by:
piggly earned 0 total points
ID: 39205008
This issue was resolved by replacing the connection string.  Instead of using the server name we also replaced it with the IP address and port number.   The link below shows the steps we went through to resolve the problem.

http://www.tek-tips.com/threadminder.cfm?pid=183&page=1
0
 

Author Closing Comment

by:piggly
ID: 39215632
It was resolved by another technical site.  I just wanted to post what the resolution was in case anyone else has this issue.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This video discusses moving either the default database or any database to a new volume.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now