.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

An invalid floating point operation occurred

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server

why do i get an error while running this command

select (POWER((0.1935 /-0.0972 ),0.5) - 1 )

and what is the solution for this

View Complete Post

More Related Resource Links

Invalid Floating Point operation when used with group by



This is related to a question I asked in the forum before and it looks like it is not handling the negative numbers within the log expression. Please let me know.



declare @insurance table


groupid int,

classid varchar(20),

creditamt varchar(20),

debitamt varchar(20),

insuraceflag varchar(30)




 ;with cte as


select groupid,classid,creditamt,debitamt,ROW_NUMBER() over (partition by GroupId order by ClassId ) as rn from @insurance


 cte1 as


select t.GroupId,t.debitamt,t1.Amt from 

(select * from cte where rn = 1)t

inner join (select GroupId,exp(SUM(LOG(CAST(isnull(creditamt,debitamt) as decimal(8,4))) )) as Amt from cte where rn <> 1 group by GroupID)t1 on t.GroupID = t1.GroupID


 select * from cte1 -- this bombs when the inside log expression is NEGATIVE or ZERO.


Why is ParseXPathExpression throwing a Floating-point invalid operation? (re: WinDbg)


I'm a software developer working for the federal government and we use a third party product that we are suddenly having problems with.  The product worked perfect on Friday but after the weekend it no longer works.  (ie. the application/process starts but nothing appears on screen and it appears to hang, etc)

I've never really used WinDbg but I'm trying to learn but looks like MS.Internal.Xml.XPath.XPathParser.ParseXPathExpresion is throwing a Floating-point invalid operation exception.  (0xc0000090)

I've stepped through the code (with WinDbg) and here is the managed stack trace when the exception is first thrown:

001EF98C 01D3BD83 System_Xml!MS.Internal.Xml.XPath.XPathParser.ParseXPathExpresion(System.String)+0x23
001EF9A0 01D3B301 System_Xml!MS.Internal.Xml.XPath.QueryBuilder.Build(System.String, Boolean, Boolean)+0x21
001EF9B8 01D3B2B7 System_Xml!MS.Internal.Xml.XPath.QueryBuilder.Build(System.String, Boolean ByRef)+0xf
001EF9C4 01D3B24A System_Xml!System.Xml.XPath.XPathExpression.Compile(System.String, System.Xml.IXmlNamespaceResolver)+0x2a
001EF9E0 01D3B200 System_Xml!System.Xml.XPath.XPathNavigator.Select(System.String)+0x10
001EF9EC 01D3AED2 System_Xml!System.Xml.XmlNode.SelectNodes(System.String)+0x32
001EFA00 01D309C4 TiS_TisCommon!TiS.TisCommon.Configuration.BaseConfigStorage.LoadConfigSections()&#

An exception occurred during the operation, making the result invalid

Hi I am using WCF services with WPF, both are .net 4 versions. I am calling asynchronously, During method calls, sometimes I get the following error Void RaiseExceptionIfNecessary()---An exception occurred during the operation, making the result invalid. Check InnerException for exception details. at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary() I tried alot to find the reason , but unable to find as it is unpredictable and inconsistent. Seeking for kind help from WCF guruzzz... Regards Zee

Error occurred in deployment step 'Activate Features': Invalid field name.

Hi, I've a empty sharepoint project where i've added a content type that looks like this: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Field ID="{45067EC7-078C-46A1-A075-E422C000215E}" Name="Schedule" DisplayName="Schedule" Group="Custom Fields" Type="Choice" Required="TRUE"> <CHOICES> <CHOICE>Minute</CHOICE> <CHOICE>Hour</CHOICE> <CHOICE>Day</CHOICE> </CHOICES> <Default>Hour</Default> </Field> <Field ID="{938CAAA4-C1AD-4E39-93D8-9C463391E006}" Name="Interval" DisplayName="Interval" Group="Custom Fields" Type="Integer" Required="TRUE" /> <Field ID="{3AD33CEA-6382-4BEE-8BB2-1C0902F13472}" Name="LastRun" DisplayName="Last Run" Group="Custom Fields" Type="Text" MaxLength="255" Required="FALSE" ReadOnly="TRUE" ShowInDisplayForm="TRUE" /> <!-- Parent ContentType: Document (0x0101) --> <ContentType ID="0x010100c293443c01ed4ac893ea199180df0244" Name="My Content Type" Group="Custom Content Types" Description=&quo

The operation failed because an unexpected error occurred. (Result Code: 0x81071003)


Hi all,  I have a SINGLE web service that I call through two different programs.  I input the same values into the service and call a sevice method.  One call fails every time, one call works every time.  I have installed Fiddler2 and copied the requests and responses from each.  They are identical except for the [VsDebuggerCausalityData] header value and the [Authorization:] value (data below)  what is this error? What can I do to address it? Why does it work for one app, but not the other when the requests are the same.  I guess since the Authorization is different it could be a security problem. But I'm not so sure because I'm not getting a security type error.  The first trace is the working example (look at the response) the second is the failing call.  I have changed the Authorization values.

POST http://kerryportal/global/DMS/CRM/_vti_bin/Lists.asmx HTTP/1.1
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4952)
VsDebuggerCausalityData: uIDPo+bNI0fMARFBsgZwKLhVCEUBAAAA2xBAL4gjpUWSP4dBtR8U/4q2nB9UKJVFvuCo3qZaaXUACQAA
Content-Type: text/xml; charset=utf-8
SOAPAction: "http://schemas.microsoft.com/

String.Format rounding down floating point number


Hi, I'm having an issue with String.Format, can somebody tell me if it's something I'm doing.


I'm using C# 2.0 I have code which looks a little bit like this:


Code Snippet

string result;

float floatToConvert = 10780503.000000f;


result = String.Format("{0:0,0}",floatToConvert);



Now I would expect result to have a value of "10,780,503" after this line of code, but it doesn't it has a value of "10,780,500"...


If however I do this:


Code Snippet

string result;

float floatToConvert = 10780503.000000f;

Sharepoint 2010 Configuration Wizard Failed- Invalid Operation was thrown



I installed SharePoint 2010 Standard on a Server with Windows 2008 Service Standard SP2 64bit OS. When I run the Configuraton Wizard it fails and the following message appears:

An exception of type System.Invalid OperationException was Thrown.Additional exception information: Cannot start service c2wts on computer.

the details are:

System.InvalidOperationException: Cannot start service c2wts on computer '.'. ---> System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion
   --- End of inner exception stack trace ---
   at System.ServiceProcess.ServiceController.Start(String[] args)
   at Microsoft.SharePoint.Win32.SPAdvApi32.StartService(String strServiceName)
   at Microsoft.SharePoint.Administration.SPWindowsServiceInstance.Start()
   at Microsoft.SharePoint.Administration.SPWindowsServiceInstance.Provision(Boolean start)
   at Microsoft.SharePoint.Administration.Claims.SPWindowsTokenServiceInstance.Provision()
   at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstanceInConfigDB(Boolean provisionTheServiceInstanceToo, String serviceInstanceRegistryKeyName, Object sharepointServiceObject)
   at Microsoft.SharePoint.PostSetupConfigur

Error occurred in deployment step 'Add Solution': Operation is not valid due to the current state


Hi all,

    I am trying to deploy my first Visual Webpart from Visual Studio 2010 to SharePoint 2010. It contains simple 'Hello World!' message. The project builds successfully, but when I try to deploy it, it gives "Error occurred in deployment step 'Add Solution': Operation is not valid due to the current state of the object"

I have enabled SharePoint Server Publishing Infrastructure in the site collection and site.  

Help please. 


Error occurred in deployment step 'Activate Features': Invalid file name


While deploying a sharepoint solution I'm getting the follwing error:

Error occurred in deployment step 'Activate Features': Invalid file name.The file name you specified could not be used.  It may be the name of an existing file or directory, or you may not have permission to access the file.

How to find which file is causing this error?

Quad-precision floating point in .NET?

When does Microsoft plan to add quad-precision floating support to its .NET CTS data types (such as IEEE 754 binary128)? I.e. when is it going to become available to .NET C#, C++, etc.? I have published a WP7 calculator app, and I am currently working on an enhanced scientific mode in landscape display. Currently, the only available floating point is float and double; hence, I have a maximum of 15 digits precision available using double.

While double precision (theoretically) is all anyone ever needs, in a competitive sense, that's not true. Microsoft supports 32 significant digits in the scientific mode of its Windows calculator, presumably because it's written using the unmanaged C++ quad-precision library. More importantly, other competitive platforms support more than double precision.  Rgardless of any theoretical arguments about how someone may never need to use more than double precision, if quad precision is supported elsewhere, for practical, competitive-product reasons .NET should support it too for WP7 apps.

The Decimal structure is not adequate for many reasons:

- Decimal was intended only for financial calculations where a loss of precision during rounding operations is unacceptable.
- Decimal is much (much) slower than double for most operations, primarily because double operations are done in binary,

learn basic about share point.

This learn basic about share point.

how to set break point at inline code

I set the element height value by using inline code 
<%# Eval("s") %>
where "s" is the variable declared in page load event. when i run the application it don't set the height. 
Is there any way, i can set break point into .aspx file. i mean how i can check if my Eval("s") get the value.  

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no



 I keep getting the following error. I also added time out parameter in the connection stirng and it still did not help. Has any one faced similar issues.

Thanks in adavance.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.


Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]

A lengthy operation in an ASP.NET web service


I've built an ASP.NET web service with .NET 2.0 (an asmx file). I invoke a web service method using Ajax. The method takes a substantial amount of time to execute (5 minutes to 1 hour). I believe it's not a good idea to "hang" the web request for so long.
I'm wondering if the web service method could spawn an additional process which in turn would execute the lengthy operation and notify the web service once the operation is completed.
Are there any good practices regarding this kind of functionality?


A generic error occurred in GDI+.



I'm getting this error on the yellow screen and I have no idea what to do with it, or where to start:

[ExternalException (0x80004005): A generic error occurred in GDI+.]
System.Drawing.Image.Save(String filename, ImageCodecInfo encoder, EncoderParameters encoderParams) +377630
NopSolutions.NopCommerce.BusinessLogic.Media.PictureManager.GetPictureUrl(Picture picture, Int32 targetSize, Boolean showDefaultPicture) in F:\Temp\Test\nopCommerce 1.60\Libraries\Nop.BusinessLogic\Media\PictureManager.cs:396
NopSolutions.NopCommerce.BusinessLogic.Media.PictureManager.GetPictureUrl(Picture picture, Int32 targetSize) in F:\Temp\Test\nopCommerce 1.60\Libraries\Nop.BusinessLogic\Media\PictureManager.cs:180
NopSolutions.NopCommerce.Web.Administration.Modules.CategoryInfoControl.BindData() in F:\Temp\Test\nopCommerce 1.60\NopCommerceStore\Administration\Modules\CategoryInfo.ascx.cs:63
NopSolutions.NopCommerce.Web.Administration.Modules.CategoryInfoControl.Page_Load(Object sender, EventArgs e) in F:\Temp\Test\nopCommerce 1.60\NopCommerceStore\Administration\Modules\CategoryInfo.ascx.cs:99
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14

A generic error occurred in GDI+


I am getting this error at this line in my code: ImgThnail.Save(ThumbnailPath, Img.RawFormat);

Here is the entire code :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Drawing;

    public static class Thumb2
        public static string createThumb(this HttpServerUtility srv, string endPath, string tempPath, int relSize)

            string ThumbnailPath = srv.MapPath("~\\Thumb\\" + endPath);
            string dimensions;
            using (System.Drawing.Image Img = System.Drawing.Image.FromFile(srv.MapPath("~\\" + tempPath))) 
                Size ThumbNailSize = NewImageSize(Img.Height, Img.Width, relSize);
                dimensions = Img.Width.ToString() + " x " + Img.Height.ToString();
                using (System.Drawing.Image ImgThnail = new Bitmap(Img, ThumbNailSize.Width, ThumbNailSize.Height))
                    ImgThnail.Save(ThumbnailPath, Img.RawFormat);
            return dimensions;
        private static Size NewImageSize(int OriginalHeight, int OriginalWidth, double FormatSize)
            Size NewSize;
            double tempval;
            bool landscape;

ToggleDebugCompilation fails trying to perform "an unauthorised operation"



We're having a problem with the Visual Studio 2008 RTW version of the web deployment projects on a colleagues machine. The project works fine if I run it on my machine, but when he tries to run it on his machine he gets:

<SNIP : Most output removed>
  Task "Exec"
    if exist ".\TempBuildDir\" rd /s /q ".\TempBuildDir\"
  Done executing task "Exec".
  Using "ToggleDebugCompilation" task from assembly "C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.Tasks.dll".
  Task "ToggleDebugCompilation"
    Updating Web.config <compilation> element debug attribute to 'True'.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error : Attempted to perform an unauthorized operation.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: The "ToggleDebugCompilation" task failed unexpectedly.
    C:\Program Files\MSBuild\Microsoft\WebDeployment\v9.0\Microsoft.WebDeployment.targets(639,7): error MSB4018: System.ArgumentNullException: Parameter "message" cannot be null.
    C:\Program Files\MSBuild\Microsoft\WebDeployment
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend