-
Bug
-
Resolution: Fixed
-
Medium
-
10.82
-
None
-
1
-
Severity 2 - Major
-
Party Parrots - USH 6
Issue Summary
In Jira Settings page, filtering by Project Name renders a Whoops error message if Project Name has a comma in it
Steps to Reproduce
- Create a Jira Project with a comma on its name
- Sync this project to Jira Align
- Browse to Jira Settings page
- Filter by Project Name
- Pick the project that has a comma on its name
- Notice the Whoops error message
Expected Results
- Jira Settings page filter the results based on selected projects names
Actual Results
- A Whoops error message is rendered
The following error logs are thrown in Splunk:
- POST
2020-11-19 22:38:53 172.28.4.57 POST /ManageExternalTool - 443 51 172.28.170.193 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/86.0.4240.198+Safari/537.36 https://instance.jiraalign.com/ManageExternalTool?FirstTime=True 302 0 0 218
- GET
2020-11-19 22:38:53 172.28.4.57 GET /Error er=19097 443 51 172.28.170.193 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/86.0.4240.198+Safari/537.36 https://instance.jiraalign.com/ManageExternalTool?FirstTime=True 200 0 0 22
- POST (formatted)
{ [-] ASP_function: OOFunctionsSql.SetRSParamsCursor correlationid: qFmqkjC7qxyz+iy7odxgy/7PD1aSEqGX3/X8FAPDRyo= customer_db: NewTmobile error_description: Incorrect syntax near ','. error_id: 19097 error_number: -2147217900 error_source: Microsoft SQL Server Native Client 11.0 log_type: exception logfrom_location: Website-ASP sql: EXECUTE RPM_GET_JIRA_PROJECT_LIST ?, ?, ?, ?, ? timestamp: 2020-11-19T17:38:53.248000-05:00 url: https://instance.jiraalign.com:443/ManageExternalTool.asp urlverb: POST user: 51 version: 10.82.0.11242 }
- Ajax error dump
ErrorID:19097, ErrorType: -2147217900 SQL: EXECUTE RPM_GET_JIRA_PROJECT_LIST ?, ?, ?, ?, ? Error: Error in SetRS: EXECUTE RPM_GET_JIRA_PROJECT_LIST ?, ?, ?, ?, ? Error=(Incorrect syntax near ','.) Page: https://instance.jiraalign.com:443/ManageExternalTool.asp Date: 2020-11-19 17:38:53 User: 51 User Name
Workaround
- Remove comma from Jira Projects' names
- resolves
-
PS-69240 Loading...