-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Obstacles - Dependencies
-
4
Issue Summary
Slow performance when trying to load dependencies grid
Steps to Reproduce
Have just a Program selected in Tier 1
Navigate to Program > Dependencies
Expected Results
Load Grid as quick as any other section in JA
Actual Results
Takes a lot of time to load.
As you can see from the logs, you have a clear defect causing a slow load of the dependantgrid:
ASP_function: OOFunctionsSql.LogToSqlTiming correlationid: kRSb0yMu5OT/tYWWrfhPahysTFhlhN3PGHoUov7RpDw= customer_db: JacksonTest log_type: warning logfrom_location: Website-ASP sql: EXEC RPM_GET_DEPENDENCY_LIST 10, 1, N' AND ( ( b.TypeID in (1,2,3,4) ) OR ( b.TypeID in (6,7,8,9) ) ) AND ( b.ReleaseID in (7) OR ( ( ( b.TypeID IN (1,2) AND b.TeamID IN (SELECT TeamID FROM sysmemberpermssionteam WHERE TeamType = 2) AND b.TeamIDDependent IN (SELECT TeamID FROM sysmemberpermssionteam WHERE TeamType = 2) ) OR b.TypeID IN (4,6,7,8,9) ) AND b.DeliveryDate >= (SELECT MIN(BeginDate) FROM tblRelease WHERE ReleaseID IN (7)) AND b.DeliveryDate <= (SELECT MAX(EndDate) FROM tblRelease WHERE ReleaseID IN (7)) ) OR ( b.IterationID IN (SELECT IterationID FROM tblIteration WHERE ReleaseID IN (7)) ) ) AND ( (b.TypeID in (1,2,3,4) AND ( s1.TeamID in (16,18,19) OR ( b.TypeID in (4) AND ( s1.TeamID in (16,18,19)) ) )) OR (b.TypeID in (6,7,8,9) AND ( b.ProgramIDRequesting in (5) ) ) )','DeliveryDate ', '','9',9,'','','', '' sqlCount: 3 sqlFunction: SetRSParams sqlTime: 4650 timestamp: 2021-02-22T14:25:14.350000-05:00 url: https://xxxxxx.jiraalign.com:443/DependentGrid.asp?FirstTime=True urlverb: GET user: 9 version: 10.88.0.14638
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
- is connected to
-
JALPM-233 Loading...
- is related to
-
-
-
- relates to
-
- resolves
-
-
-