What are the challenges you face when working across database platforms? Take the survey
Options

Error Dialog When Using SSMS - Invalid name character in Workstation Id

timetrak_awtimetrak_aw Posts: 3 New member
I am getting an error dialog on an extremely frequent basis whenever I do any of the following in SSMS:
  • Saving Scripts
  • Executing Scripts
  • Change Tabs
  • Scrolling Object Explorer

I have no idea where this issue is coming from, but I'm getting very close to a point where I may have to uninstall SQL Prompt so that I can use SSMS without spending half of my time closing error dialogs.

Error Dialog Screenshot:
7te8b5ypvdpf.png

From the log file:
03 May 2017 14:33:59,035 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Document saved
03 May 2017 14:33:59,036 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<>c__DisplayClass42_0.<DocumentSaved>b__0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)
03 May 2017 14:34:06,973 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Query executed
03 May 2017 14:34:06,974 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<QueryExecuted>b__41_0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)
03 May 2017 14:34:30,873 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<>c__DisplayClass35_0.<WindowActivated>b__0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)
03 May 2017 14:38:30,894 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Query executed
03 May 2017 14:38:30,896 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<QueryExecuted>b__41_0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)
Tagged:

Comments

  • Options
    timetrak_awtimetrak_aw Posts: 3 New member
    edited May 3, 2017 4:10PM
    Didn't think to put this in the original post... SSMS is 13.0.16106.4. SQL Prompt version is 7.5.1.1000. Error comes up in a 2016 SQL Server (13.0.4001.0) or 2014 SQL Server (12.0.2000.8). If there's anything else that might be helpful, let me know.
  • Options
    MikeKMikeK Posts: 5 New member
    I'm having the exact same issue, but my error states the invalid character is in the network library.
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Hi Mike and timetrak_aw,

    Thanks for the post and reporting the issue to us.

    We are looking into this issue and logged this as a bug in our internal tracking system whose tracking id is SP-6321.

    I will email you as soon as we have further update.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Russell DRussell D Posts: 1,324 Diamond 5
    This was fixed in 8.0.2.1508 so if you haven't already please update.
    Have you visited our Help Centre?
Sign In or Register to comment.