Regional settings stopping query

Category: sql server streaminsight


FarnhamSurrey on Mon, 08 Oct 2012 14:39:57

I have a simple passthrough query (var q=from e in input select e;) running on a polish OS (with regional settings that take a comma as a decimal separatpor).

My input stream includes double values with this decimal separator (comma). What is happening is that my query is stopping (my input adapter is receiving the Stop event). I am assuming initially that it is because of the regional settings but don't really have proof. All I know is that exactly the same system/configuration running on an english OS runs without error. If I change the regional settings on the english OS to polish settings, it also works. I only get the error when running with polish settings on a polish OS

I am looking for opinions on this, ideas as to what else may be causing the error, or ideas on how to narrow down the cause and location of the error


DevBiker on Mon, 08 Oct 2012 18:31:15

Do you have an error trace? Perhaps from the Event Flow Debugger when the query stops? (Exception info should be in there.) Have you turned on tracing before you started a test run to see if that gives you any information?

I'm assuming that you are parsing the double from a string? Is this correct? If so, are you specifying the culture to use when parsing? That may also be the problem.

I would suspect - based on the very limited information that you've supplied - that the issue has to do with the formatting and there is an invalid format exception happening. But it's hard to say definitively with the limited info supplied. Perhaps the LINQ statement that you suspect is causing the issue?

FarnhamSurrey on Tue, 09 Oct 2012 08:53:57

Thanks DevBiker

My app was embedding a Convert.ToString in the standing query so that was it. Needed to include a CultureInfo.CurrentCulture parameter