Also if you dont want these messages to be logged u can try this.
altermessage 1608, with_log, false
I hope this works for you.
Cheers,
Main Topics
Browse All Topics
Loading Advertisement...
Question
Urgent : Error : 1608 A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
Hi guys,
We are using SYBASE ASE 11.9.2.2. version, Our error log is flooded with message 1608, client process exited abnormally..
1608 A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
Searched various websites including SYBASE,read the documentation which says not to worry, (all our client machines running Visual basic connecting to sybase are running fine and none of them have been disconnected as described in the message, there are about 150 simultaneous users connecting to sybase). But for us it has become serious message, flooded with hundereds and hundereds , I have to say thousands of 1608 messages per day. Network guys say network is fine. For this error we had to restart SYBASE server once in a while (for deleting log). I am really worried why sybase is not coming with a solution to this. I tried sp_altermessage 1608, with_log, false, it didn't have any effect, documentation says it works only for the "true", false doesn't have any effect. don't know what to do. I am giving 500 points, I can still increase the points depending on the answer. Can anyone please tell me how to avoid this error in my SYBASE error log file. Please help me. Thank You so much.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Subscribe now for full access to Experts Exchange and get
Instant Access to this Solution
- Plus...
- 30 Day FREE access, no risk, no obligation
- Collaborate with the world's top tech experts
- Unlimited access to our exclusive solution database
- Never be left without tech help again
Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.
- "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
- "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
- "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.
See what Experts Exchange can do for you.
Got a question?
We've got the answer.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
Need individual assistance?
Our experts are ready to help.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Want to learn from the best?
Read articles from industry experts.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Working on a long term project?
Store your work and research.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Trusted by the world's most respected brands.
Faithfully serving IT professionals since 1996.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Free Tech Articles
-
WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
-
SCCM OSD Basic troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
-
Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
-
Create a Win7 Gadget
This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
-
Outlook continually prompting for username and password
There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
-
Backup Exchange 2010 Information Store using Windows Backup
There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...
Cloud Class Webinars
- Avoiding Bugs in Microsoft Access
Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
- Top 10 Best New Features in Visio 2010
Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
- IT Consultant Business Secrets Revealed
Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
- Disaster Recovery and Business Continuity
Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
- Organize Your Visio Diagrams with Containers and Lists
Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
- How to Us Objects, Properties, Events and Methods in Microsoft Access
Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Answers
it sounds like the application is not closing the connection gracefully.
do a controlled test: start the app and then exit. If you get a 1608 then blame your developers, maybe a newer version of the ODBC drivers is required ???
maybe you can run your log analysis through a "grep -v" to strip out the 1608 lines.
Hi guys, first things first, thanks to all for answering, but
If you see my question, I tried all the options suggested by many of you (with of no help) except the one by ChrisKing "grep-v",
Chris could you please tell me how do I do grep-v,
regarding ODBC driver, we are using the latest one (released nov 2002 - 04.10.0020 - syodase.dll)
Also we checked all the users none of them has exited abnormally as per 1608 message.
Hy,
grep -v is a Unix command and you seem to be on a windows environment.
You can use grep command on windows with cygwin (a unix "emulator").
Just find the cygwin1.dll and grep.exe on cywgin.com.
Check if you have a line like
Cannot send, host process disconnected: MyServer 2092 spid: 14
just before your error message.
You must investigate on client processes (you can know which are the connected processes with a sp_who or a query like
use master
go
select spid,hostname,hostprocess,
go
)
Try to launch it in a loop and log the processes details. Then compare with your error log and identify spid's that exit abnormaly.
Bye
Hi,
Once again, you should investigate on client processes.
You talk about VB applications. Maybe one of them causes problems.
An application can generate such messages without a crash.
If you use ct_lib, there are some rules that must be respected.
For example, in an application, you can connect to the database with the ct_connect function, you send commands with ct_send, etc... but at the end of your code you must use ct_cancel to cancel all pending transactions, and ct_close to close connection with the database. If you don't do so, your application won't crash or produce any error message, but errors 1608 will appear in server log.
And it is exactly the same with ODBC functions.
I guess it won't be easy, but you must tell your developpers to check their code
Good luck
PS : sp_altermessages only works with user-defined messages
Hi everyone,
Sorry for causing you so much trouble.
Christking, I just wanted to explain praveenpoli what exactly could make such errors. In your first message, you say that this kind of error can result from application not closing connection gracefully (just like explained by mansoor a khan ... :-) ...) and you finish with : maybe you should get a newer version of the ODBC drivers... Then praveenpoli answered that the problem was still unsolved. So, convinced that the problem was due to client application, i tried to explain praveenpoli what are exactly the connection mechanisms to help him identify problematic code, and i think that this was the "something new to the thread"
So now I think it's up to praveenpoli to tell us if my explanations have been helpfull.
3 Ways to Join
Business Accounts
- Perfect for organizations
- Multiple users
- Save over 36%
- Create a Business Account
Answer for Membership
- Earn free access
- Showcase your knowledge
- No credit card required
- Sign Up to Answer
Loading Advertisement...
by: mansoor_a_khanPosted on 2003-10-15 at 00:14:27ID: 9552700
Here is the information which I could find for u.
The following Error appears in the Sybase Error Log
Error 1608, Severity Level, 21
A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
Explanation:
This error occurs when a client process stopped without informing SQL Server and a subsequent attempt by SQL Server to send results to this client fails.
Error 1608 is usually not serious and may be viewed as notification that a client process no longer exists. Some of the possible reasons a client process can disappear are:
The client application was killed or ended abnormally
The client machine was powered off or rebooted
There is excessive network traffic
The network connection has been dropped or interrupted
Resolution:
Do not be concerned if this error occurs only sporadically. However, if the error occurs frequently and continuously, or frequently for short periods of time, it may be a result of excessive network traffic or network problems.
If it is suspected that there are network problems, contact the network administrator in order to run diagnostics on the network between the client and the SQL Server machines to isolate the problem.
Note: If this error is preceded by another Sybase error then obtain a complete and current copy of the Sybase error log and forward it to the SPS Help Desk for further analysis. The error log can be found in the c:\sybase\install directory on
cheers,
Mansoor