general network error in sql server 2000 replication West Mineral Kansas

Address 906 N Broadway St, Pittsburg, KS 66762
Phone (620) 232-2302
Website Link http://www.cpol.net
Hours

general network error in sql server 2000 replication West Mineral, Kansas

The error message I keep getting from Event Viewer is:SubSystem Message - Job 'xxUKSCORPSQ01-RESxxxx-xxUKSCORPSQ01-122' (0x11A8166C016B2049804A3865513C294D), step 2 - General network error. It's completely reliably reproducible. Why would a password requirement prohibit a number in the last character? Can cats leave scratch marks on cars?

Username: Password: Save Password Forgot your Password? It appears if and only if there has been a prolonged (several hours at least) idle time. –Vilx- Jul 9 '10 at 10:54 add a comment| Your Answer draft saved In a sense you're trying toavoid timeouts being an issue, so set it as high as youwant - eg a day (or 0 for infinity, although as I saythere is some In a sense you're trying toavoid timeouts being an issue, so set it as high as youwant - eg a day (or 0 for infinity, although as I saythere is some

I checked the installation on the server and on the clients and it is okay. SQL server was not closing enough sockets in time for new connection requests. Edit Also, depending on the number of clients connecting to the db, not using the connection pool can cause another issue. Check your network documentation.ErrorId = 48, SourceTypeId = 4ErrorCode = '08S01'ErrorText = 'Communication link failure'[11/24/2005 3:52:08 PM]MLDDC1.distribution: {call sp_MSadd_repl_error(48, 0,
4, ?, N'08S01', ?)}Category:ODBCSource: ODBC SQL Server DriverNumber: 08S01Message: Communication link

There is some disagreement about whethersetting it to zero means wait indefinitely, but I haveused it assuming that's how it works, so that is anotheroption.HTH,Paul Ibison (SQL Server MVP)http://www.nwsu.com/0974973602p.html)what would be Our new SQL Server Forums are live! rishimainidba Starting Member 30 Posts Posted-02/22/2005: 12:44:17 Hi ..The kind of error that you have mentioned generally comes with irregular network connection between your Publisher and Subscriber.To prove this verbose loggin doesn't help much. (too old to reply) Combfilter 2004-10-14 16:48:11 UTC PermalinkRaw Message Here are the logs from this error..

You cannot post HTML code. KB Articles and Googling were much of a help. The processcould not bulk copy into table '"dpvHstGndItem"'.[10/14/2004 11:28:44 AM]DFW1-REPL02.vsql16_dist:{call sp_MSadd_repl_alert(3, 5, 1503, 14152, ?,
6, N'VSQL16\ENTERPRISE02', N'mam01',
N'MAINSTREET', N'alohadb', ?)}ErrorId = 1503, SourceTypeId = 5ErrorCode = '11'ErrorText = 'General network You cannot edit your own events.

Come on over! You cannot delete your own topics. With modern technology, is it possible to permanently stay in sunlight, without going into space? Although there are 65K sockets altogether, only the first 5000 are made available to the ADO (this is a default registry setting thing, so can be changed).

You cannot edit your own topics. If I refresh the web page, I can make it working sometimes. After that just checkout the results in trace.txt file and thus you can figure out whether your network breaks or not from Publisher to Subscriber and if it does then you Privacy Policy.

You cannot send private messages. Sometimes durring the replication we get the following message:SQL Server Error: 11 General network error. How exactly does the typical shell "fork bomb" calls itself twice? By using our services, you agree to our use of cookies.Learn moreGot itMy AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsBooksbooks.google.comhttps://books.google.com/books/about/A_Guide_to_SQL_Server_2000_Transactional.html?id=tlKJjqHxfRcC&utm_source=gb-gplus-shareA Guide to SQL Server 2000 Transactional and Snapshot ReplicationMy libraryHelpAdvanced Book SearchGet

Putting pin(s) back into chain How should I deal with a difficult group and a DM that doesn't help? Check your network documentation.[11/24/2005 3:52:08 PM]MLDDC1.distribution: {call
sp_MSadd_repl_alert(3, 24, 48, 14152, ?, 5, N'MLDDC1', N'scalaDB_MLD',
N'SQL1', N'scalaDB_MLD', ?)} ErrorId = 48, SourceTypeId = 1 ErrorCode = '' ErrorText = 'SET ARITHABORT Check your network documentation. Check your network documentation.

Are the words "expression" and "term" interchangeable in programming language theory? Preview this book » What people are saying-Write a reviewWe haven't found any reviews in the usual places.Selected pagesTable of ContentsIndexContentsSQL Server Installation 21 20 Being a DBA Chapter 2 SQL it seems to work fine for all my project, and then suddenly after some code (very classic ) I receive randomly this message eneral network error. You cannot post events.

Our connection is verystable and so is the subsribers. The increased manageability of SQL Server 2000 has also increased its popularity—anyone, not just database administrators, can use a SQL Server database. This setting will mark youragent as suspect which tells you that the agent is taking a long time. A new 'feature' was added that absolutely hammered the server, and after a few hours of using the app, things would suddenly slow to a crawl for everyone.

You cannot edit other posts. So clients had to wait until server side sockets closed and a new connection could then be created. Itusually gets about 1/2 done and then just crapsout and starts over. I cannot figureout why i get this..Table "dpvHstGndItem": 100000 row(s) copied.Total: 100000[10/14/2004 11:15:15 AM]DFW1-REPL02.vsql16_dist:{call sp_MSadd_distribution_history(5, 3, ?, ?,
0, 0, 0.00, 0x00, 1, ?, 0, 0x01, 0x01)}Table "dpvHstGndItem": 100000 row(s) copied.Total:

Top general network error by Um9i » Sat, 27 Sep 2008 01:36:01 Using ODBC Data Source Admin, when some users attempt to connect to a server (SQL authentication), specifying Named Pipes Users connect into the application via one of 4 citrix servers with this application, who all then go over the local network to the SQL Server, which has 2x100mb NIC's in The bottom line is that there is a limited number of available sockets on the server. It's somehow like overloading the system.Any idea?

share|improve this answer answered Jul 9 '10 at 10:31 Alex K. 106k16148194 No... However,just like with the ODBC connection timeout value overriding the LoginTimeoutSetting, if you set QueryTimeout to 0, you will eventually get a message(after 5 minutes) saying "The process is running and but the error isn't intermittent. The results of Google on the error message cover a very wide spectrum of different causes (since this is a very generic error) and none of the scenarios found there are

Check yournetwork documentation.[11/24/2005 3:52:08 PM]MLDDC1.distribution: {call
sp_MSadd_repl_alert(3, 24, 48, 14152, ?, 5, N'MLDDC1', N'scalaDB_MLD',
N'SQL1', N'scalaDB_MLD', ?)}ErrorId = 48, SourceTypeId = 1ErrorCode = ''ErrorText = 'SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF Since it's a backend server app this is a normal scenario. You can do this as follows:-From Publisher end give this command:-ping "subscriber name or ip" -t > c:\trace.txtwhat this command will do it will log the continous results of your ping Try to run the agent at a later time.+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++i could see there is ODBC SQL Server Driver that caused the communicationlink failure, so i have manually created a SQL SERVER odbc

And why doesn't it happen on WinXP? –Vilx- Jul 9 '10 at 11:21 Nice addition, I'll keep it in mind, but unfortunately this isn't the case. :( –Vilx- Jul To tell you the truth, I never got to the bottom cause of this problem either. Setting QueryTImeouts to 0 will decrease the visibility ofagents hanging especially if you have upped the inactivity level. Try to run the agent at a later time.+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++i could see there is ODBC SQL Server Driver that caused the communicationlink failure, so i have manually created a SQL SERVER odbc

You cannot post new polls. Not much you can do except get the problem with the network fixed I think.Andy AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter Post #33859 Antares686Antares686 Posted Thursday, You cannot post topic replies. All Rights Reserved.