473,287 Members | 1,570 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

A floating point exception occurred in the user process

sql server 2000 sp4 build 2184

runs stats with maintenance plan
sp_msforeachtable
stored procedure updating full stats for each table and the results
are identical

A floating point exception occurred in the user process. Current
transaction is canceled.

all pointers are to move to latest service pack
Any pointers on how to avoid this error

Thanks for your time

Massa

Aug 20 '07 #1
6 3734
Massa Batheli (mn****@gmail.com) writes:
sql server 2000 sp4 build 2184

runs stats with maintenance plan
sp_msforeachtable
stored procedure updating full stats for each table and the results
are identical

A floating point exception occurred in the user process. Current
transaction is canceled.

all pointers are to move to latest service pack
Any pointers on how to avoid this error
It could certainly help if you could give some more detail. Do you get
the error when you run the maintenance plan? Or was running the maintenance
plan an attempt to cure the problem?

If it happens with a query, to try narrow down the query by exluding
columns or rows. Or even tables.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 20 '07 #2
Erland Thanks for your response as usual
The maintenance plan was intended to troubleshoot the process .

Mike

On Aug 20, 5:34 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
MassaBatheli (mng...@gmail.com) writes:
sql server 2000 sp4 build 2184
runs stats with maintenance plan
sp_msforeachtable
stored procedure updating full stats for each table and the results
are identical
A floating point exception occurred in the user process. Current
transaction is canceled.
all pointers are to move to latest service pack
Any pointers on how to avoid this error

It could certainly help if you could give some more detail. Do you get
the error when you run the maintenance plan? Or was running the maintenance
plan an attempt to cure the problem?

If it happens with a query, to try narrow down the query by exluding
columns or rows. Or even tables.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Aug 21 '07 #3
Massa Batheli (mn****@gmail.com) writes:
Erland Thanks for your response as usual
The maintenance plan was intended to troubleshoot the process .
I don't think floating-point errors are due to poor statistics or
fragmented indexes. You may be able to get rid of the error that
way if you get a different plan, that does not provoke the error.
But in that case, you never know when it comes back and bite you
again.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 21 '07 #4
Not been able to eliminate the error for months now .Strongly
considering calling MSFT but would want to be sure it is not something
that is an error of mine.Had some one reinstall sp4 when just in case
it was a fluke during my install but that did not take care of it
either .

Thanks again for your input

Aug 22 '07 #5
Not sure why about the floating point error.Started when there was an
upgrade to sp4 build 2187

Excuse me if this was posted earlier could not find it when I queried
google groups

Was considering calling MSFT but did not want to pay the per call fee
on something some

more knowledgeable person out here could help with ...
Mike

Aug 22 '07 #6
Massa Batheli (mn****@gmail.com) writes:
Not sure why about the floating point error.Started when there was an
upgrade to sp4 build 2187

Excuse me if this was posted earlier could not find it when I queried
google groups

Was considering calling MSFT but did not want to pay the per call fee
on something some
Notice that if the error is due to a bug in SQL Server, you will be
refunded.
more knowledgeable person out here could help with ...
Sure. If you provide information to work from. Ideally, that would be
a CREATE TABLE script, INSERT statements with sample data and a query
that reproduces the error. I reckon that this may be difficult to
achieve. But you could at least provide the table and index definitions
and the query where it happens. No one is going to help you if all you
say is that you get a floating point exception.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 22 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: riz | last post by:
We get the following error message. "a floating point exception occured in the user process. current transaction is cancelled". this message comes when trying to excute a stored procedure. This...
10
by: Vinny | last post by:
I have a few floating point questions/issues I wish to ask. An answer or discussion would be nice too :) Any links discussion the subject would be nice too.. 1. How do I generate an underflow...
2
by: chris.higginson | last post by:
Hi, I'm running SQL Server Version 8.00.194 on Windows 2000. I am am running this query: select TOP 2000 TheoVolImplied from OptionTrades where ReutersSymbol = 'IBM.N' and TheoVolImplied...
3
by: Mark L Pappin | last post by:
<puts on Compiler Vendor hat> I've recently discovered that our compilers don't make any attempt to handle floating point overflow in add/subtract/ multiply/divide, with the result that...
2
by: devendra pardeshi | last post by:
hi friends/seniors i am stuck on one problem in VB 6.0 and need solution. see if u can help me. first i describe the problem. Can u imagin the WinZip scenario. we right click on some file...
4
by: jacob navia | last post by:
Hi people I continue to work in the tutorial for lcc-win32, and started to try to explain the floating point flags. Here is the relevant part of the tutorial. Since it is a difficult part, I...
1
by: maidonical | last post by:
I am trying to run "select * from <table> where <columnname> = 0.0" in query analyzer <columnname> is a float I get the following error: Server: Msg 3628, Level 16, State 1, Line 1 A floating...
0
by: mike.varley1 | last post by:
Hi All We are getting the warning messages below several times a day in the app event logs on our Win2k3 server. Can anyone shed any light on the meaning\cause of the DC issue, especially: "This...
39
by: rembremading | last post by:
Hi all! The following piece of code has (for me) completely unexpected behaviour. (I compile it with gcc-Version 4.0.3) Something goes wrong with the integer to float conversion. Maybe somebody...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.