SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 A floating point exception occurred in the user...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sanjivus
Starting Member

16 Posts

Posted - 07/01/2007 :  11:18:37  Show Profile  Reply with Quote
We are using SQL Server 2000 + SP4 on Windows 2003 Ent Server + SP2.

I have a job scheduled on weekly basis unser the Database Maintenance Plan. During the execution of this job I get the following error:

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628: [Microsoft][ODBC SQL Server Driver][SQL Server]A floating point exception occurred in the user process. Current transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.


I have noticed that this error occurs when system tried to rebuild the index on a prticular table. This table has only one float column.

I have tried to get the MIN (=-1) and MAX (=100) values from this table which seems quite in the range of the float datatype.

I also tried to run "select * from MyTable where MyCol=0.0" and get the error message "A floating point exception occurred in the user process. Current transaction is canceled."

I did the research on web but did not find anything helpful. Microsoft recommends to install SP4 which is already installed.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q295030&SD=MSKB&

Please help.

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 07/01/2007 :  20:32:55  Show Profile  Reply with Quote
Tried rebuild index on the table manually?
Go to Top of Page

sanjivus
Starting Member

16 Posts

Posted - 07/02/2007 :  13:00:28  Show Profile  Reply with Quote
Sorry to ask you the stupid question, how can i rebuild the index on an individual table?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 07/02/2007 :  14:30:05  Show Profile  Reply with Quote
dbcc dbreindex(tab_name), check books online for details.
Go to Top of Page

sanjivus
Starting Member

16 Posts

Posted - 07/02/2007 :  15:03:03  Show Profile  Reply with Quote
There were 4 curroupt records in the table. I updated these record with the correct values for the column having float data type and it resolved the problem.

I had to export the whole table in ACCESS and did trial/error and able to isolate the 4 records (out of 300000 records)having problem.

rmiao: after updating the 4 records, I was able to rebuild the index. Thanks for your help.
Go to Top of Page

rmaginot
Starting Member

France
1 Posts

Posted - 10/19/2008 :  12:17:25  Show Profile  Reply with Quote
Another way, you can modify the structure of your table using Enterprise Manager.

So, Enterprise Manager generates SQL Script to unload/load datas from old table to new.

After that, datas are good !

See you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000