Dependency Grid - Using characters in the filters may break the dependency grid (Throws Whoops))

XMLWordPrintable

    • Type: Bug
    • Resolution: Cannot Reproduce
    • Priority: Medium
    • None
    • Affects Version/s: 10.123.2
    • Component/s: Obstacles - Dependencies

      Issue Summary

      If you use wildcard characters in the Apply Filter in the Dependency grid may break the grid view and throw a whoops error.
      After that, The Whoops error keeps happening every time the user's login (even impersonated) blocking it from using the dependencies grid

      More details on Steps to reproduce

      This is reproducible : (yes)

      Steps to Reproduce

      1. Go to Dependency Grid
      2. Click Apply Filter: where "Requested for Epic" contains '%Victor''s Fragoso%'
      3. Note that you will be redirected to a whoops error page
      4. Also the user gets blocked from using dependency grid, since his login is linked to its last filter used making the Dependency throws a whoops error every time it goes to the page
      5. I didn't identify this issue in other Grids even using the "Contains"

      Expected Results

      If wildcard characters are not supposed to be used here they must be treated like the example:
      Features Grid > Apply Filter = Owner contains '%Victor''s Fragoso%'

      Actual Results

      A Whoops error is thrown and the user gets its filter linked to this page causing a whoops error every time it tries to access the page in loop

      It generates the error below, and it was caught using:

      $.ajax({type : "POST", url: "AjaxFiles/AjaxTag?Type=264", async: false}).responseText.replace("|-|", ",") 
      ErrorID:3216,\tErrorType:\t-2147217900\nSQL:\tEXEC RPM_GET_DEPENDENCY_LIST 10, 1, N'       AND        (              (                  b.TypeID in (1,2,3,4)            )           OR             (                  b.TypeID in (6,7,8,9)            )          ) And (Exists(Select GroupName From tblAgileFeatureGroup Where GroupName like ''%''%Victor''''s Fragoso%''%'' And (FeatureGroupID = b.EpicIDRequesting OR FeatureGroupID = b.EpicIDDepends OR FeatureGroupID = b.RelatedEpicID ) And ParentID IS NULL)) And b.TypeID in (3,6) AND ( ( (ISNULL(b.Proposed,0) = ''1'' OR ISNULL(b.Proposed,0) = ''2'') AND Not(ISNULL(b.Commited,0) = ''1'' OR ISNULL(b.Delivered,0) = ''1'' OR ISNULL(b.NoWork,0) = ''1'' OR ISNULL(b.Rejected,0) = ''1'') ) OR (b.SyncSprintID IS NULL AND b.DeliveryDate IS NULL) ) AND ( (b.TypeID in (1,2,3)  AND (   s1.TeamID in (6018)  ))  OR  (b.TypeID in (6,7,8,9)  AND (      b.ProgramIDRequesting in (528)     ) ) )','DeliveryDate ', '','661759',9,'','','', ''\nError:\tError in SetRS: 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 (Exists(Select GroupName From tblAgileFeatureGroup Where GroupName like ''%''%Victor''''s Fragoso%''%'' And (FeatureGroupID = b.EpicIDRequesting OR FeatureGroupID = b.EpicIDDepends OR FeatureGroupID = b.RelatedEpicID ) And ParentID IS NULL)) And b.TypeID in (3,6) AND ( ( (ISNULL(b.Proposed,0) = ''1'' OR ISNULL(b.Proposed,0) = ''2'') AND Not(ISNULL(b.Commited,0) = ''1'' OR ISNULL(b.Delivered,0) = ''1'' OR ISNULL(b.NoWork,0) = ''1'' OR ISNULL(b.Rejected,0) = ''1'') ) OR (b.SyncSprintID IS NULL AND b.DeliveryDate IS NULL) ) AND ( (b.TypeID in (1,2,3)  AND (   s1.TeamID in (6018)  ))  OR  (b.TypeID in (6,7,8,9)  AND (      b.ProgramIDRequesting in (528)     ) ) )','DeliveryDate ', '','661759',9,'','','', '' Error=(Incorrect syntax near ''.)\nPage:\thttps://alignsupport.jiraalign.com:443/DependentGrid.asp?FirstTime=True&Programs=528&FilterID=565\nDate:\t2023-08-23 10:32:11\nUser:\t661759 Victor Fragoso\r\n\r\n

      Workaround

      As a workaround another user must go to the dependencies page and create any other functional filter example: Requested for Epic Contains: Victor.
      It will update the URL with a filter parameter (filterID=XX)
      Copy this entire URL and send it to the affected user asking it to access the page.
      After it accessing the page the old filter will be replaced and the issue is fixed for good.

              Assignee:
              Vishnuvardhan Vaidhyanathan (Inactive)
              Reporter:
              Victor Fragoso
              Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: