Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    3

    Unanswered: Floating Point Exception in SQL Server 2000

    Hi,

    I got below error in the SQL Server Production Server and i checked in the microsoft site it needs to install SQL Server service pack 4 to resolve the
    problem.

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

    I need help that i want to reproduce this below problem in the SQL Server environment and tried several ways but no luck.

    Please advise me how to reproduce the problem.

    Would be appreciate your help.

    Regards
    Sathish

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    For what cause you are trying to do that? Check this ....Link
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  3. #3
    Join Date
    Oct 2006
    Posts
    3
    Wants to check after installing service pack 4. so that we can confirm it should not happen in future.
    Any clues to reprodue it.

    Regards
    Sathish

  4. #4
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by sathish_sh
    Wants to check after installing service pack 4. so that we can confirm it should not happen in future.
    Any clues to reprodue it.

    Regards
    Sathish
    FYI...
    If the following conditions are all true, Microsoft SQL Server may store floating point data with an exponent lower than -308, which may cause floating point underflow exceptions that terminate a clients connection to SQL Server:

    • The client application is using stored procedures or server side cursors to perform data modification
    and passes the request to the SQL Server server as a remote procedure call (RPC) event.
    • The client application is passing parameters for the RPC event to the SQL Server server.
    • The column of the table affected by the parameter that is passed is defined as a float datatype.
    • If a stored procedure is called, the parameter is defined as a float datatype.

    And plz check the previous link that I gave you...You could get you answer there.
    Last edited by rudra; 10-27-06 at 00:12.
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  5. #5
    Join Date
    Oct 2006
    Posts
    3
    Joydeep,

    Thanks for your information. I have tried following ways to reproduce it

    1. By using Index Tuning Wizard Execution
    2. By passing the expression 0/0 (zero divided by zero) to SQL Server as a floating point value for a stored procedure parameter
    3. By trying query with aggregate function
    4. By running a Complex Query
    5. By Query optimization

    But i couldnt able to reproduce it. Do you have any stored procedure or SQL Query to stimulate this problem.

    Regards
    Sathish

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •