-
Bug
-
Resolution: Fixed
-
Medium
-
10.78
-
1
-
Severity 2 - Major
-
Rangers - WT1
-
No
Issue Summary
In the Work Tree Strategy View, when attempting to expand the capability to view the Features underneath, the Expansion appears to be stuck and the user is unable to see the list of child Features underneath.
Steps to Reproduce
- Navigate to the Work Tree
- Select a Portfolio and PI in Tier 1
- Click Extra Configs and enable Strategy View
- Expand a theme to view epics underneath
- Expand an Epic to view capabilities underneath
- Expand a capability in an attempt to see the features
Expected Results
A list of child features should be seen.
Actual Results
The expansion appears to be 'stuck' and ever opens up so that the user can see the list of features underneath.
Running a HAR capture while this occurs shows that we are spending over a minute trying to complete calls to:
https://xxxxx.agilecraft.com/AjaxFiles/AjaxEpicDetails?Type=10&themeID=525&themeGroupID=
and
https://xxxxx.agilecraft.com/EpicDetailReport?AJAX_GRID=1&chkSnapshots=22
Splunk logging during the time of the capture shows several sql warnings:
9/25/20
8:16:33.752 AM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: QmWUxeSiKeGuA65gllUA0AG5anT7710PQP4cOb8CZRw=
customer_db: xxxxx
log_type: warning
logfrom_location: Website-ASP
sql: EXEC MULTI_RPM_GET_FEATURES_STATE_BY_RELEASE 100,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,N'250,262,252,257,180,103,127,70,248,168,104,68,261,263,80,143,295,69,74,265,205,167,281,118,196,259,290,115,258,256,75,140,264,266,117,174,67,328,249,78,77,72,73,187,71,124,185,109,76,150,130,129,91,90,128,297,146,106,293,197,89,61,147', NULL
sqlCount: 1
sqlFunction: SetRSParams
sqlTime: 3130
timestamp: 2020-09-25T09:16:33.752000-04:00
url: https://xxxxx.agilecraft.com:443/EpicDetailReport.asp?FirstTime=True
urlverb: GET
user: 12977
version: 10.78.0.8457
}
9/25/20
8:16:33.905 AM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: FOFk77OzrYqS/naVINwVxsw4R7/O+/DSSaHhSPnr5EA=
customer_db: xxxxx
log_type: warning
logfrom_location: Website-ASP
sql: EXEC MULTI_RPM_GET_RELEASE_DETAIL_STATUS '98,99,100,101', NULL,NULL,NULL,NULL, NULL, 138, NULL,NULL,NULL,NULL,NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL,NULL
sqlCount: 4
sqlFunction: SetRSParams
sqlTime: 3904
timestamp: 2020-09-25T09:16:33.905000-04:00
url: https://xxxxxx.agilecraft.com:443/EpicDetailReport.asp?AJAX_GRID=1&chkSnapshots=22
urlverb: GET
user: 8234
version: 10.78.0.8457
}
9/25/20
8:16:45.560 AM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: FOFk77OzrYqS/naVINwVxsw4R7/O+/DSSaHhSPnr5EA=
customer_db:xxxxx
log_type: warning
logfrom_location: Website-ASP
sql: EXEC MULTI_RPM_GET_RELEASE_DETAIL_STATUS '98,99,100,101', NULL,NULL,NULL,NULL, NULL, 133, NULL,NULL,NULL,NULL,NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL,NULL
sqlCount: 1
sqlFunction: SetRSParams
sqlTime: 4005
timestamp: 2020-09-25T09:16:45.560000-04:00
url: https://xxxxxxagilecraft.com:443/EpicDetailReport.asp?AJAX_GRID=1&chkSnapshots=22
urlverb: GET
user: 8234
version: 10.78.0.8457
}
9/25/20
8:16:51.007 AM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: FOFk77OzrYqS/naVINwVxsw4R7/O+/DSSaHhSPnr5EA=
customer_db: xxxxxx
log_type: warning
logfrom_location: Website-ASP
sql: EXEC MULTI_RPM_GET_RELEASE_DETAIL_STATUS '98,99,100,101', NULL,NULL,NULL,NULL, NULL, 137, NULL,NULL,NULL,NULL,NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL,NULL
sqlCount: 1
sqlFunction: SetRSParams
sqlTime: 3526
timestamp: 2020-09-25T09:16:51.007000-04:00
url: https://xxxxxx.agilecraft.com:443/EpicDetailReport.asp?AJAX_GRID=1&chkSnapshots=22
urlverb: GET
user: 8234
version: 10.78.0.8457
}
9/25/20
8:16:57.221 AM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: FOFk77OzrYqS/naVINwVxsw4R7/O+/DSSaHhSPnr5EA=
customer_db: xxxxxx
log_type: warning
logfrom_location: Website-ASP
sql: EXEC MULTI_RPM_GET_RELEASE_DETAIL_STATUS '98,99,100,101', NULL,NULL,NULL,NULL, NULL, 263, NULL,NULL,NULL,NULL,NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL,NULL
sqlCount: 4
sqlFunction: SetRSParams
sqlTime: 3549
timestamp: 2020-09-25T09:16:57.221000-04:00
url: https://xxxxxxx.agilecraft.com:443/EpicDetailReport.asp?AJAX_GRID=1&chkSnapshots=22
urlverb: GET
user: 8234
version: 10.78.0.8457
}
9/25/20
8:17:33.282 AM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: tWwmqzHOT5oZrdPZRdRCf2guqgEoEThfl6wgc0B4N5k=
customer_db: xxxxxxx
log_type: warning
logfrom_location: Website-ASP
sql: EXEC MULTI_RPM_GET_RELEASE_DETAIL_STATUS N'98,99,100,101', NULL,NULL,N'733',NULL,NULL,138,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL, NULL,NULL
sqlCount: 1
sqlFunction: SetRSParams
sqlTime: 3037
timestamp: 2020-09-25T09:17:33.282000-04:00
url: https://xxxxxx.agilecraft.com:443/AjaxFiles/AjaxEpicDetails.asp?Type=6&StrategyItemID=138&EnableCapabilityOption=1
urlverb: POST
user: 8234
version: 10.78.0.8457
}
8:17:30.228 AM
{ [-]
ASP_function: OOFunctionsSql.LogToSqlTiming
correlationid: tWwmqzHOT5oZrdPZRdRCf2guqgEoEThfl6wgc0B4N5k=
customer_db: xxxxxx
log_type: warning
logfrom_location: Website-ASP
sql: EXEC MULTI_RPM_GET_RELEASE_DETAIL_STATUS N'98,99,100,101', NULL,NULL,N'732',NULL,NULL,138,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL, NULL,NULL
sqlCount: 0
sqlFunction: SetRSParams
sqlTime: 3452
timestamp: 2020-09-25T09:17:30.228000-04:00
url: https://fxxxxxx.agilecraft.com:443/AjaxFiles/AjaxEpicDetails.asp?Type=6&StrategyItemID=138&EnableCapabilityOption=1
urlverb: POST
user: 8234
version: 10.78.0.8457
}
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available