ADO: Error thrown when exclude path includes apostrophe

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 10.85
    • Affects Version/s: 10.82
    • Component/s: Azure DevOps Connector
    • None
    • Severity 3 - Minor
    • Party Parrots - USH 5
    • None

      Issue Summary

      In the ADO connector, when a Program, exclude iteration path name has an apostrophe in it's name name it throughs an error when attempting to run the WIQL query

      Steps to Reproduce

      1. Add an iteration exclude path with an apostrophe
      2. Add a work item to any synced path in ADO except the excluded path

      Expected Results

      Sync executes without error and item is copied.

      Actual Results

      Sync executes with an error in Splunk log (not to user) and no items are not copied even if not in the excluded path.

      The error in splunk looks like:  

      Microsoft.TeamFoundation.WorkItemTracking.Client.ValidationException: Expecting closing quote. The error is caused by «'

      ORDER BY [Changed Date] DESC'»

      Workaround

      Update the path to not include an apostrophe

            Assignee:
            Kyle Foreman
            Reporter:
            Kyle Foreman
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: