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

      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
          157 kB
          Kent Baxley

            [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 ]
            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 ]
            align-connector-bot made changes -
            Description Original: h3. 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.

            h3. 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.

            h3. Expected Results
            * User should be able to conduct a search.

            h3. Actual Results
            * User is kicked off of their session.


            The below exception is thrown in on the backend logs:
            {code}
            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{code}
            h3. Workaround
             Currently there is no known workaround for this behavior. A workaround will be added here when available             		New: h3. 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.

            h3. 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.

            h3. Expected Results
            * User should be able to conduct a search.

            h3. Actual Results
            * User is kicked off of their session.


            The below exception is thrown in on the backend logs:
            {code}
            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) &lt;&gt; 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) &lt;&gt; 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) &lt;&gt; 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) &lt;&gt; 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{code}
            h3. Workaround
             Currently there is no known workaround for this behavior. A workaround will be added here when available
            Priority Original: Medium [ 3 ] New: High [ 2 ]
            Summary Original: User is logged out when attempting to use left hand nav search bar New: [JIRAALIGN-2053] User is logged out when attempting to use left hand nav search bar

              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: