Details
-
Bug
-
Resolution: Cannot Reproduce
-
Medium
-
None
-
10.71
-
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
- 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