Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-8083

Connector - JSON Parsing Error in ManageExternalTool Page

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 11.8.1
    • Jira Connector - Other
    • 1
    • Severity 3 - Minor
    • No

      Issue Summary

      The ManageExternalTool?TabID=4 page encounters an error when attempting to parse JSON from the JiraSetupTypeVal column in the tblJIRASetup database table. This issue specifically occurs when the JSON data is invalid, leading to a failure in parsing and causing the page to error out.

      Steps to Reproduce

      1. Access the ManageExternalTool?TabID=4 page.
      1. Ensure the query retrieves data from tblJIRASetup where JiraSetupID = X and the specified connector ID.
      1. If the JiraSetupTypeVal column value begins with {}{, the page attempts to parse it as JSON.
      1. When the JSON is invalid or truncated (e.g., due to the 1000-character limit), the page errors out.

      Expected Results

      the page should be able to function if the JSON in the DB is invalid. And ideally we shouldn't store invalid JSON in the DB either.

      Actual Results

      The page does not gracefully handle JSON parsing errors, resulting in a complete failure.

      Exception: Newtonsoft.Json.JsonReaderException: Unterminated string. Expected delimiter: ". Path 'includedProjects', line 1, position 1000.
         <Shrinked>
         Level: Error
         MessageTemplate: LastError:InnerException
         Properties: { [-]
           Event: Application_Error
           ExceptionDetail: { [-]
             HResult: -2146233088
             LineNumber: 1
             LinePosition: 1000
             Message: Unterminated string. Expected delimiter: ". Path 'includedProjects', line 1, position 1000.
             Path: includedProjects
             Source: Newtonsoft.Json
             StackTrace:    <Shrinked>
           }
           HttpRequestId: XXXXXX-6c16-XXXX-ad8d-273fda85597b
           HttpRequestRawUrl: /ManageExternalTool?TabID=4
           HttpRequestType: GET
           HttpRequestUrl: https://CUSTOMER.jiraalign.com/ManageExternalTool.aspx?TabID=4
           SourceContext: Website.Common.ExceptionLogHandler
           UserName: 001
           customer_db: Customer
           logfrom_location: Website-ASPNET
           server: USSWAWEB56D
           version: 11.8.1.49696
         }
         RenderedMessage: LastError:InnerException
         
      } 

      Workaround

      Currently there is no known workaround for this behavior. 

            [JIRAALIGN-8083] Connector - JSON Parsing Error in ManageExternalTool Page

            There are no comments yet on this issue.

              fea1a6ef3355 Yannick Genin
              f58471712ff6 Victor Fragoso
              Affected customers:
              1 This affects my team
              Watchers:
              3 Start watching this issue

                Created:
                Updated: