-
Bug
-
Resolution: Fixed
-
Low
-
10.86, 10.87, 10.88, 10.99.3, 10.100.1, 10.123.2
-
5
-
Severity 2 - Major
-
No
Issue Summary
We are seeing an issue when users are created with apostrophes in the email address. The application throws an error code in UI as a result of a Type mismatch error in Splunk.
Per this wiki, apostrophe character is supported by RFC5322 and RFC6854
Steps to Reproduce
- Browse to People grid
- Click Add User button
- Fill in all necessary data
Ensure to use an apostrophe on the local-part of the email address - Click Save
Expected Results
- User is created
Actual Results
- The application throws an error code in UI as a result of a Type mismatch error in Splunk.
The below exception is thrown in Splunk:
{ [-]
ASP_function: OOFunctionsSql.DbExecReturnIDParams
correlationid: M23rK+9yV6tqXG5yMYSCvSTtBTf5T/4tfrIRvfQmklE=
customer_db: instance
error_description: Type mismatch
error_id: 3939
error_number: 13
error_source: Microsoft VBScript runtime error
log_type: exception
logfrom_location: Website-ASP
sql: SET NOCOUNT On Insert Into sysmemberpermssion (Tips, CreateDate, StartDate, UID, FirstName, LastName, Email, Title, RID, OrgManager, Manager, Region, CostCenter, DivisionID, ViewPublicERs, ExternalUser, Skin, TimeType, IsTimeTracking, TTStartDate, HolidayCalendarID, Notes, HolidayCityID, TimeZoneId, IncludeInCalculations, IsComplianceManager , CityID, ValidFrom, ValidTo, ContractorManager, LastModified, IsUserManager ) Select 1,'3/4/2021 5:47:56 PM','3/4/2021 5:47:56 PM','','John,'O''Doe','John.O'Doe@instance.com','Developer',50,NULL,NULL,1,1,1,0,0,14,1,0,NULL,NULL,N'2021/03/04 - Creating by request of Admin',NULL,'Pacific Standard Time',NULL,0,4,'3/4/2021',NULL,NULL,'3/4/2021 5:47:56 PM',0 SELECT SCOPE_IDENTITY() AS NewID Set NOCOUNT OFF
timestamp: 2021-03-04T17:47:56.684000-05:00
url: https://instance.jiraalign.com:443/MasterUserEdit.asp
urlverb: POST
user: 200
version: 10.88.0.15267
}
Workaround
Create the new user with a bogus email address; then update it right after to the correct one, containing an apostrophe.
- Browse to the People grid
- Click Add User button
- Fill in all necessary data
Ensure NOT to use an apostrophe on the local-part of the email address – feel free to provide a bogus email address - Click Save & Close
- Select the newly created user (the slide-out details will displaye)
- Replace the email address with correct email address
- Click Save & Close
- is related to
-
ALIGNSP-16634 Loading...
- mentioned in
-
- resolves
-
-
-