| Author |
Topic |
|
spirit1
Cybernetic Yak Master
11752 Posts |
 Posted - 2004-09-30 : 10:58:07
|
hey guys and gals.this is a question my roommate gave me and if i can guess what's wronghe buys me drinks all night. it doesn't have to be 100% correct.he runs a sproc in QA.this sproc reads data from different tables into temp tables and then writes the data from all temp tables into 2 normal tables (not temp  )the sproc returns this error:[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (WrapperRead()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation.i've never seen that one before so i have no idea what it means.any takers?if it's the wrong forum freely move it elsewhere.Go with the flow & have fun! Else fight the flow  |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-09-30 : 11:04:59
|
| Drinks All night...man hw would sure be broke...Listen post the code, and we'll get you hammered....Brett8-)EDIT: and is the client using TCP/IP or Named Pipes? |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-30 : 11:09:11
|
| it means you have network problems (of the general type) Actually, I have seen this before. I believe it was when I ran a query from home while vpn'd into work...nnd then disconnected the vpn.Corey |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-30 : 11:11:18
|
| Oh... good one brett (tcp vs. named pipes) I think that has caused me problems in the past.Corey |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-30 : 11:13:07
|
| yeah but that's the whole point. i don't get to see the code. he works in another company so i can't see it...all the info i have i allready gave youGo with the flow & have fun! Else fight the flow |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-30 : 11:27:56
|
| If you google the WrapperRead error you find some stuff about named pipe connections and using aliases in the client network utility. There is also some mention of problems with pre-SP2 releases of SQL Server. The problems seemed to be fixed with SP2 or newer. Are they running an old release of SQL Server?-ec |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-30 : 11:29:15
|
| no. they have 2000 with all service packs.don't know about os though, but i don't think that acctually matters.Go with the flow & have fun! Else fight the flow |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-30 : 11:32:36
|
| since we can't get any DDL or sample data, the only suggestion I can make is to put a call into microsoft to get it resolved.-ec |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-30 : 11:38:48
|
| no need to call microsoft he resolved it already but i get free drinks if i can closely guess what it could be.so for now i've narrowed it down to named pipes and aliases.can anyone think of anything else?Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-30 : 23:18:55
|
| usually the cause of that error in our company is firewall or intermittent network connections. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-01 : 05:01:09
|
| well if anyone is interested, he solved the problem by increasing packet size in QA. beats me if i know why.....Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 05:11:33
|
quote:
Originally posted by spirit1
well if anyone is interested, he solved the problem by increasing packet size in QA. beats me if i know why.....Go with the flow & have fun! Else fight the flow
so no beer for you then...but i'm pretty much interested in what he did.is it because the data being manipulated is too large? how about if he converted his query to an sproc, is it the same scenario? how did he increase the packet size? |
|
|
|
Richard Branson
Yak Posting Veteran
84 Posts |
Posted - 2004-10-01 : 05:40:52
|
| I got the same error a while back - I think I was busy running "Pass Through Queries"Search for 'OpenRowSet' in Books on line and see if you can't figure somehing out.It's kind'a difficult because we can't see the code...You can't teach an old mouse new clicks. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-01 : 06:04:31
|
| jen:tools->options->connections->network packet sizeit is an sproc.we ended up each buying the round....Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 06:11:28
|
| generous of him, so i'll apply this to the server right.i actually had a post similar to this one, clients are having difficulty extracting data from the server which causes network problems for other users. My guess is that the network is not able to handle the load, so if i increase the packet size (like a dam), i might be able to solve this issue?i think i'm gonna try this one, but i'll benchmark the size first.thanks spirit! |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-01 : 06:19:07
|
| this packet size is set on the client (QA is a client ) so it means that the packet size that gets sent to the server is larger.but you already know this... Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 06:24:37
|
| now you just woke me up. our clients don't have qa.but i'll try the server side, might be worth a shot, else we really need to upgrade our switches. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-01 : 06:28:38
|
| NO!!! i woke u up... now you'll never go to sleep... well what do they have?? i think you can set the packet size in your conn string in the app.Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 06:39:09
|
quote:
Originally posted by spirit1
NO!!! i woke u up... now you'll never go to sleep... well what do they have?? i think you can set the packet size in your conn string in the app.Go with the flow & have fun! Else fight the flow
that's pretty interesting, i'll explore that option, i think that's possible coz some of sql's settings can be set in the application level. don't feel guilty about waking me up, i just started playing badminton coz somebody told me that exercise will help you get to sleep aside from being drunk (don't drink though). and it just might work... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-01 : 06:45:15
|
badminton? cool! your going to sweat in 15 minutes like you've never sweat before. you don't drink???? why on earth not??? what kind of DBA are you???? ... just kidding  Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 06:52:12
|
| i don't want to die young... just kidding, i never liked the taste of alcohol, i once had a can of beer and to finish it off, i added 2 bottles of soda just to mask the taste and ate half a box of pizza. same thing with wine and stuff like thati'm kinda skinny so i'm afraid drinking won't improve my weight. |
|
|
|
Next Page
|
beer dependant question