-
Bug
-
Resolution: Fixed
-
High
-
10.78
-
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
- resolves
-
ALIGNSP-5928 Loading...