Unhandled exception: input string was not in a correct format

Category: Troubleshooting & error messages
Date: 01 Feb 2011
Product: SQL Doc
When launching the SQL Doc application the following message may appear:

Unhandled exception: input string was not in a correct format

************* Exception Text *************
System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at DevExpress.Skins.Info.SkinXmlLoader.StringToObject(Type type, String val)
   at DevExpress.Skins.Info.SkinXmlLoader.LoadProperties(XmlNode xml, SkinCustomProperties properties, Boolean colors)
   at DevExpress.Skins.Info.SkinXmlLoader.LoadElement(XmlNode xml)
   at DevExpress.Skins.Info.SkinXmlLoader.LoadElements(XmlNode xml)
   at DevExpress.Skins.Info.SkinXmlLoader.LoadSkin(XmlNode xml, String skinName)
   at DevExpress.Skins.Info.SkinXmlLoader.LoadAllSkins(String skinName)
   at DevExpress.Skins.Info.SkinXmlLoader.LoadAllSkins(Stream stream, String skinName)
   at DevExpress.Skins.Info.SkinXmlCreator.Load()
   at DevExpress.Skins.Info.SkinBlobXmlCreator.Load()
   at DevExpress.Skins.SkinContainer.Load()
   at DevExpress.Skins.SkinContainer.GetSkin(Object productId)
   at DevExpress.Skins.SkinManager.GetSkin(Object productId, String skinName)
   at DevExpress.Skins.SkinManager.GetSkin(Object productId, ISkinProvider provider)
   at DevExpress.Skins.BarSkins.GetSkin(ISkinProvider provider)
   at DevExpress.XtraBars.ViewInfo.SkinBarConstants.Init()
   at DevExpress.XtraBars.ViewInfo.BarDrawParameters.InitDefaults()
   at DevExpress.XtraBars.ViewInfo.BarDrawParameters.UpdateScheme()
   at DevExpress.XtraBars.BarAndDockingController.OnChanged()
   at DevExpress.XtraBars.BarAndDockingController.OnLookAndFeelChanged(Object sender, EventArgs e)
   at DevExpress.LookAndFeel.UserLookAndFeel.OnStyleChanged()
   at DevExpress.LookAndFeel.UserLookAndFeel.OnParentStyleChanged(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at DevExpress.LookAndFeel.UserLookAndFeel.OnStyleChanged()
   at DevExpress.LookAndFeel.UserLookAndFeelDefault.OnStyleChanged()
   at DevExpress.LookAndFeel.UserLookAndFeel.set_SkinName(String value)
   at _1._2()
   at _21..ctor()
   at _40._10(Object , EventArgs )
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Click Continue and the application opens. Can connect to a server/database and view the tables, security, etc but the Preview pane is always empty.

One possible cause for this message is that the computer registry contains invalid information about the regional settings. There is a rare Microsoft bug that will set the following registry value:

HKEY_CURRENT_USER\Control Panel\International\sPositiveSign

This value should always be set to an empty string.

If the registry value is not empty, the resolution is to go to Control Panel-> Regional and Language Options -> Standards and formats setting. Change it from its current setting to a different language and back again. This should reset the relevant registry options.

Document ID: KB200812000330 Keywords: SQL,Doc, unhandled, exception, registry, empty, string

Was this article helpful?

Search support