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

[JIRAALIGN-1561] Jira Align Admin > Jira Settings > Manage Projects > View Logs > Configuration Logs Query Timeout

    XMLWordPrintable

Details

    • 2
    • Severity 2 - Major
    • Sticky Bandits - VH1
    • No

    Description

      Issue Summary

      Jira Align Admin > Jira Settings > Manage Projects > View Logs > Configuration Logs Query Timeout

      Steps to Reproduce

      1. Navigate to Jira Align Admin > Jira Settings > Manage Projects > View Logs > Configuration Logs

      Expected Results

      User would be able to load the connector Configuration Logs

      Actual Results

      User receives a query time out in some instances.

        error_description: Query timeout expired
         error_id: 2893
         error_number: -2147217871
         error_source: Microsoft SQL Server Native Client 11.0
         log_type: exception
         logfrom_location: Website-ASP
         sql: SELECT t2.Uniq u_Uniq, t2.FirstName u_FirstName, t2.LastName u_LastName, t4.Uniq r_Uniq, t4.FirstName r_FirstName, t4.LastName r_LastName, t3.Name, t1.* FROM tblAuditLog t1 WITH(NOLOCK) LEFT OUTER JOIN sysmemberpermssion t2 WITH(NOLOCK) on t1.UserID=t2.UID LEFT OUTER JOIN tblWMSConnector t3 on t1.WMSConnectorId=t3.WMSConnectorId LEFT OUTER JOIN sysmemberpermssion t4 WITH(NOLOCK) on t1.RealUserUID=t4.UID WHERE t1.WMSConnectorID=1 AND ((AuditType = 'CONFIG' AND REQID IN ('JiraCustomFields1','ManageExternalTool1','ManageJiraBoards1','ManageJiraConnectors1','ManageJiraSprints1','ManageJiraStatusMappingsPush1','JiraDeletedReport','CON1')) OR AuditType IN ('ManageJiraBoards')) AND datediff(day, t1.AuditTimeStamp, '5/18/2020') = 0 ORDER BY AuditLogID DESC
         timestamp: 2020-05-18T18:29:18.011000-04:00
      

      Workaround

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

      Attachments

        Issue Links

          Activity

            People

              jwolfe@atlassian.com Jessica Wolfe (Inactive)
              tkeyes@atlassian.com Tim Keyes
              Votes:
              2 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync