Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-05-20 : 11:46:57
|
| My server (SQL SERVER 7) died briefly today (or more correctly started to refuse connections)On looking at the logs after it was revived the problem seems to be connected to ods (open data services - though I have no idea what they are used for apart from the clues in the errors)At first there was Error: 17801, Severity: 17, State: 1 Unknown internal error value..a couple of timesthenError: 17826, Severity: 18, State: 2 Could not set up ListenOn connection '1433'..along with Operating system error 10055., 2005-05-18 13:49:47.83 ods Error: 17826, Severity: 18, State: 2both of which repeated for a whileThen we got loads of Error: 17803, Severity: 17, State: 17Insufficient memory available..by which time the server was going so slowly that it refused to talk to anyone (this one repeated every three or four minutes until the problem was resolved)For all of these the source was ODS which I hadn't noticed before, though BOL has given me more insight now.My questions are two fold1) Is there anything obvious I can do to prevent a recurrence2) How likely is it that these errors are related to a new .NET app that is calling a couple of sprocs on this serverMany thankssteveA sarcasm detector, what a great idea. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-20 : 12:20:21
|
| Hmmm... Never heard of ODS before. Did a short read on it in BOL 2000, but not much there other than saying this is effectively a deprecated approach. If it just started about the same time the .NET app was deployed, then I would certainly be suspicious of the app and would grill the developer(s) with the brightest spotlight I could find. They would have to have an amazingly fantastic reason for whatever they are doing for me not to beat them about the head and shoulders.---------------------------EmeraldCityDomains.com |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-05-23 : 06:34:55
|
The developer will be over here tomorrow  Though to be fair all he can do is call about three stored proceduresI got the impression from SQL server 7 bol that ODS was some sort of forerunner to DTSsteveA sarcasm detector, what a great idea. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-23 : 07:58:50
|
| ODS provided gateway functions for extended procedures, embedded SQL and low-level ODBC programming calls. Since SQL Server 2000 I believe all of the utilities and functions that used it have removed it. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-10-31 : 11:52:31
|
| Hi GuysSorry to drag this one up from the depths but I am getting a related but different error which again shows the source as ODS. I strongly suspect that this time it is related to the Web Assistant wizard (does anyone use that?). Whatever the cause I am getting "Operating system error 3., The system cannot find the path specified." immediately followed by "." which is then followed by "Error: 16822, Severity: 16, State: 1". The latter is "SQL Web Assistant: Could not open the template file." but I'm not sure of why anyone would want to use that.Perhaps more importantly I am unsure on what to trace or what to look for to try to work out what is going on (bearing in mind this is SQL Server 7). Anyone have any ideas?Thanks in advancesteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
|
|
|
|
|
What are the ODS on that?