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

[JIRAALIGN-1892] Work Tree : MULTI_RPM_GET_EPIC_STATUS_BY_RELEASE times out and user gets logged out

XMLWordPrintable

    • 2
    • Severity 2 - Major
    • Avengers - WT1
    • No

      Issue Summary

      Work Tree : SP MULTI_RPM_GET_EPIC_STATUS_BY_RELEASE times out and user gets logged out

      Steps to Reproduce

      Unable to repro in LAB

      1. Browse to the Work Tree page
      2. Set tier1 filter options as necessary – provide Program & PI
      3. Expand any item

      Expected Results

      • Item is expanded and child objects are displayed

      Actual Results

      • User gets logged out after a few moments

      Investigation Done

      • Found error in HAR file, thrown by AjaxEpicDetails.asp page:
        https://instance/AjaxFiles/Error?er=9999
      • Splunk query to capture that error in server-side logs:
        er=9999 OR error_id=9999
        
      { [-]
         ASP_function: OOFunctionsSql.SetRSParamsCursor
         correlationid: 9/Js99CM99Ft9emtFh9sXPeFWahwjCafByGtk9lrBD9=
         customer_db: INSTANCE
         error_description: Query timeout expired
         error_id: 9999
         error_number: -2147217871
         error_source: Microsoft SQL Server Native Client 11.0
         log_type: exception
         logfrom_location: Website-ASP
         sql: EXEC MULTI_RPM_GET_EPIC_STATUS_BY_RELEASE N'100',99, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,99999,9,NULL, NULL,NULL,9,999,99
         timestamp: 2020-08-05T14:43:25.444000-04:00
         url: https://instance:443/AjaxFiles/AjaxEpicDetails.asp?Type=1&EpicID=1234&IterationID=undefined&ProgramID=77&ReleaseID=666
         urlverb: POST
         user: 123456
         version: 10.75.0.7183
      }
      
      2020-08-05 18:43:25 172.22.16.205 GET /AjaxFiles/Error er=9999 443 6 172.22.19.91 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/84.0.4147.105+Safari/537.36 https://instance/EpicDetailReport?FirstTime=True&Programs=77&Releases=666 302 0 0 9
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available.

              eac07d2d8a35 Roman Koshovskyi (Inactive)
              rcortez@atlassian.com Rodrigo Cortez
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: