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

Features slide-out panel throws whoops error when the product associated to the feature is set to itself as a parent product

    XMLWordPrintable

Details

    • 1
    • Severity 3 - Minor
    • No

    Description

      Issue Summary

      Features slide-out panel throws whoops error when the product associated to the feature is set to itself as a parent product.

      Steps to Reproduce

      1. Navigate to any feature and link it to a product(product A).
      2. Go to products slide-out panel and select product A to open slide-out panel.
      3. Set the parent product to another product(product B) and click on Save & Close.
      4. Open product A slide-out panel again and set parent product to product A itself. Click on save & close.
      5. In the slide-out panel for product A the parent product field is empty but in products grid it shows parent A.
      6. Go back to the feature and try to open it.

      Expected Results

      Features slide-out panel is displayed.

      Actual Results

      Whoops error is thrown in Jira Align. The below exception is thrown in the Splunk logs:

      2022-02-03 21:31:25 172.28.1.236 GET /Error er=5926 443 1644 172.28.168.24 Mozilla/5.0+(Macintosh;+Intel+Mac+OS+X+10.15;+rv:96.0)+Gecko/20100101+Firefox/96.0 https://maxar.jiraalign.com/default?Portfolios=2&Releases=24,23,22,21,20,19,18,17,6,16,15,14,13,5,4,2,3,7,44,26,36,37,38,59,60,61,64,65,69,70,71,72,73,74,75,76,77,78 200 0 0 16
      
      { [-]
         ASP_function: OOFunctionsSql.SetRSParamsCursor
         correlationid: isrtF/SyM8RiX6rAXAF7/kfb55XK7ittkDFCebquJNw=
         customer_db: Maxar
         error_description: Arithmetic overflow error converting float to data type numeric.
         error_id: 5926
         error_number: -2147217833
         error_source: Microsoft SQL Server Native Client 11.0
         log_type: exception
         logfrom_location: Website-ASP
         sql: WITH CTE AS (  SELECT    ProductID, ProductName, ParentID,    CAST(row_number()over(PARTITION BY parentid ORDER BY ProductName) AS varchar(max)) AS [path],    0 as level,    row_number()over(partition by parentid ORDER BY ProductName) / power(100.0,0) AS x FROM tblProducts WHERE parentid IS NULL AND Active = 1  OR ProductId = 37 UNION ALL SELECT    t.ProductID,    t.ProductName,   t.ParentID,    [path] +'-'+ cast(row_number()over(PARTITION BY t.parentid ORDER BY t.ProductName) AS varchar(max)),    level+1,    x + row_number()over(PARTITION BY t.parentid ORDER BY t.ProductName) / power(100.0,level+1)  FROM    cte JOIN tblProducts t ON cte.ProductID = t.ParentID )   SELECT    ProductID,    ProductName,    ParentID,    [path],    x, Level FROM cte ORDER BY x
         timestamp: 2022-02-03T16:31:25.347000-05:00
         url: https://maxar.jiraalign.com:443/NewRequest.asp?FirstTime=True&RequestID=12976
         urlverb: GET
         user: 1644
         version: 10.104.3.22710
      }
      

      Workaround

      Open the slide-out panel for product A and click save when the parent product is empty or when it is set to another product(other than product A). To find the product associated with the feature we can either export features using under more actions in features grid or enable product column in features grid. 

      Attachments

        1. Screen Shot 2022-02-09 at 1.11.08 AM.png
          58 kB
          Sudeep Bale Ramakrishnappa

        Issue Links

          Activity

            People

              4f593be5d819 Anna Eshlin De Kassal (Inactive)
              2dd0052fba6f Sudeep Bale Ramakrishnappa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync