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

[JIRAALIGN-2053] User is logged out when attempting to use left hand nav search bar

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • 10.80
    • 10.78
    • other - navigation menu
    • None
    • 1
    • Severity 3 - Minor
    • Party Parrots - TART6
    • None

      Issue Summary

      Customer is automatically logged out of Jira Align whenever they try and leverage the "Search" functionality from the menu on the left side of the application.

      Steps to Reproduce

      • Log in (this was tested and reproduced with super admin roles)
      • Click on the magnifying glass on the left side of the page and start typing search terms.

      Expected Results

      • User should be able to conduct a search.

      Actual Results

      • User is kicked off of their session.

      The below exception is thrown in on the backend logs:

      ASP_function: OOFunctionsSql.SetRSParamsCursor
   correlationid: EWQx+EtkpJnAabtthnRjJ6nbBnH4txvjAcWe3IStxRY=
   customer_db: xxxxxxx
   error_description: Ambiguous column name 'SMID2'.
   error_id: 460
   error_number: -2147217900
   error_source: Microsoft SQL Server Native Client 11.0
   sql: select * from  ( Select distinct 1 as Type, MenuExpanded, ModuleClass, Link, IsReport, rtrim(ltrim(keywordsexpanded)) as keywordsexpanded, tblMenuSub2X.SMID2 FROM tblMenuSub2X  inner Join (Select SMID2 from tblMenuRoleSubMap2_10X where RID=9)R ON R.SMID2 = tblMenuSub2X.SMID2  where ISNULL(tblMenuSub2X.SMID_10X,0) NOT IN (19) and ISNULL(tblMenuSub2X.ShowIn10X,1) <> 0  And tblMenuSub2X.MenuExpanded like '%it%' union Select distinct 1 as Type, MenuExpanded, ModuleClass, Link, IsReport, keywordsexpanded, tblMenuSub2X.SMID2 FROM tblMenuSub2X  where Actions in (Select Actions FROM tblMenuSub2X  inner Join (Select SMID2 from tblMenuRoleSubMap2_10X where RID=9)R ON R.SMID2 = tblMenuSub2X.SMID2  where ISNULL(tblMenuSub2X.SMID_10X,0) NOT IN (19)) and ISNULL(tblMenuSub2X.ShowIn10X,1) <> 0  And tblMenuSub2X.MenuExpanded like '%it%' union Select distinct 2 as Type, MenuExpanded, ModuleClass, Link, IsReport, rtrim(ltrim(keywordsexpanded)) as keywordsexpanded, tblMenuSub2X.SMID2 FROM tblMenuSub2X  inner Join (Select SMID2 from tblMenuRoleSubMap2_10X where RID=9)R ON R.SMID2 = tblMenuSub2X.SMID2  where ISNULL(tblMenuSub2X.SMID_10X,0) NOT IN (19) and ISNULL(tblMenuSub2X.ShowIn10X,1) <> 0  And (tblMenuSub2X.keywordsexpanded like '%it%' or tblMenuSub2X.keywords like '%it%') union Select distinct 2 as Type, MenuExpanded, ModuleClass, Link, IsReport, keywordsexpanded, tblMenuSub2X.SMID2 FROM tblMenuSub2X  where Actions in (Select Actions FROM tblMenuSub2X  inner Join (Select SMID2 from tblMenuRoleSubMap2_10X where RID=9)R ON R.SMID2 = tblMenuSub2X.SMID2  where ISNULL(tblMenuSub2X.SMID_10X,0) NOT IN (19)) and ISNULL(tblMenuSub2X.ShowIn10X,1) <> 0  And (tblMenuSub2X.keywordsexpanded like '%it%' or tblMenuSub2X.keywords like '%it%') )x  inner join tblPackagePermissions temp3 on temp3.SMID2 = x.SMID2  inner join (select * from tblPackages where Active = 1) temp2 on temp2.PackageID = temp3.PackageID where SMID2 not in (896,898,889)order by Type, MenuExpanded
   timestamp: 2020-09-14T14:32:47.026000+02:00
   url: https://xxxxxxxxx.jiraalign.com:443/AjaxFiles/AjaxMenuLoad.asp?LoadType=44&q=it
   urlverb: POST
   user: 235
   version: 10.78.0.8457

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

        1. screenshot-1.png
          screenshot-1.png
          157 kB

          Form Name

            [JIRAALIGN-2053] [JIRAALIGN-2053] User is logged out when attempting to use left hand nav search bar

            Clay Tidwell made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 511430 ]
            Clay Tidwell made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 509869 ]
            Caz (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]

            Caz (Inactive) added a comment -

            Fixed in 10.80 --user is not kicked out

            Caz (Inactive) added a comment - Fixed in 10.80 --user is not kicked out
            Khrystyna Mandziy (Inactive) made changes -
            Fix Version/s New: 10.80 [ 92797 ]
            Sprint Original: Batman! - Usher1 [ 6084 ] New: Party Parrots - TART6 [ 5970 ]
            Assignee Original: Khrystyna Mandziy [ f1f3263eeef1 ] New: Kyle Byrd [ kbyrd@atlassian.com ]
            Khrystyna Mandziy (Inactive) made changes -
            Status Original: In Review [ 10051 ] New: Waiting for Release [ 12075 ]
            akozak (Inactive) made changes -
            Status Original: In Progress [ 3 ] New: In Review [ 10051 ]
            akozak (Inactive) made changes -
            Assignee Original: akozak [ 798bf6a9c91f ] New: Khrystyna Mandziy [ f1f3263eeef1 ]
            akozak (Inactive) made changes -
            Status Original: Short Term Backlog [ 12074 ] New: In Progress [ 3 ]
            akozak (Inactive) made changes -
            Assignee New: akozak [ 798bf6a9c91f ]

              kbyrd@atlassian.com Kyle Byrd (Inactive)
              kbaxley Kent Baxley
              Affected customers:
              0 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: