| Author |
 Topic  |
|
|
dingbat
Starting Member
5 Posts |
 Posted - 25 July 2005 : 21:24:40
|
I am currently hosted by GoDaddy. (yeah, I know... that might be the problem!)
So we've been there for just a month. My forum has been stable for a couple of weeks (i.e. I haven't applied any mods) and everything was working normally (apart from the host having to restart the server or something when they lost ASP for a while)
Suddenly today, we're having random issues. When we load a page, we show the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
A floating point exception occurred in the user process. Current transaction is canceled.
/forum/default.asp, line 109
Note that the page and line number will vary and that the error does not always manifest itself.
GoDaddy claims that the problem is with my scripts - though they are no different today than yesterday or even last week. I have compared the online script with my local copies and they match. I am able to run the local copy of the forum without issue. All my googling suggests that the problem lies with SQL and not the scripts.
Has anyone seen this before or can tell me what's going on?
Any help MUCH appreciated.
Ding |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 July 2005 : 23:29:54
|
I had never seen that bug. My own goggling suggests that you are indeed correct, that must be a SQL server bug. Some of the suggestions I've seen seem to indicate that SP4 should be applied to SQL Server, maybe it can correct it. Of course, that should be a task for your host.
You could try another option though. You can try to determine where exactly does the error occur and what is the data being retrieved from the query that causes the error. If you are to do that, then check every record to verify whether you have bad data (like a value that is not a valid floating point number). If you do, just correct it.
Regardless of the reason, it seems obvious this is a bug in SQL Server, not something you should be blamed for. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 25 July 2005 23:35:40 |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 July 2005 : 00:42:22
|
| The other quite possible thing would be OLEDB on the webserver has it's knickers in a twist .. in either case I would put money on a reboot of the SQL Server, Web Server, or both would completely resolve your issues (temporarily at least) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
dingbat
Starting Member
5 Posts |
Posted - 27 July 2005 : 19:03:35
|
An update...
After posting here, I went back to play. I used SQL web admin and discovered the same random error occurred when I was trying to display the tables. Further contact with the host (explaining this) resulted in an email stating that they acknowledged the server had a "known issue" which would be patched "later this week". They refused to elaborate on what the problem might be or even when the patch would be applied.
They seem to have fixed the issue now, but I'm thinking a new host might be in order.
Thanks for posting your responses. I appreciate the time you took to help me realize that I'm not insane.
Ding |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
