[JIRAALIGN-2329] Jira Settings : Filtering by Project Name renders a Whoops error message if Project Name has a comma in it

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

1. Create a Jira Project with a comma on its name
2. Sync this project to Jira Align
3. Browse to Jira Settings page
4. Filter by Project Name
5. Pick the project that has a comma on its name
6. 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