-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Platform
-
Labels:None
-
Environment:Production
-
Module:Platform - Security
-
Reported by:Client
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Hi Rakesh Roy,
We need to find out the places where we have missed to handle single quote scenario while generating password or searching user names in application. E.g Searching with First name or Last name with Single Quote in SA Utility is not working. We need to test all the places from where either we are generating or updating password.
I have listed down some items which we need validate for Single Quote scenario.
- Searching users in SA utility
- Password Generation with Single quote in SA utility
- Change User Password from the application
- Add User with Single Quote name
- Workterra Utility - Password generation
Satya, Rakesh Roy and Swapnil Pandhare you can add more scenarios if i have missed anything.
CC: Saurabh Sablaka Samir
- relates to
-
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Amnesh Goel [ amnesh.goel ] | Rakesh Roy [ rakeshr ] |
| Summary | Single Quote issue for User name and Password in application | Regression - Single Quote issue for User name and Password in application |
| Assignee | Rakesh Roy [ rakeshr ] | Priya Dhamande [ priya.dhamande ] |
Hi Priya Dhamande,
Import users with Single Quote also needs to validate.
Please try log in using user having single quote in username. I thing on stage it is not allowing to log in .
Rakesh Roy: please schedule this on high priority.
CC: SamirSatyaVijay Siddha
| Attachment | SingleQuote.xls [ 29705 ] |
I have checked the mentioned scenarios for the single Quote. The steps and error log are maintained in excel.
1. Searching users in SA utility
2. Password Generation with Single quote in SA utility
3. Change User Password from the application
4. Add User with Single Quote name
5. Workterra Utility - Password generation
6. Importing Employee with Single Quote
Please find the attachment for the excel along with jira.
| Assignee | Priya Dhamande [ priya.dhamande ] | Vikas Pawar [ vikas.pawar ] |
| Attachment | SingleQuote.xls [ 29881 ] |
| Attachment | SingleQuote.xls [ 29705 ] |
| Assignee | Vikas Pawar [ vikas.pawar ] | Satya [ ID10004 ] |
Satya, As discussed with Vikas, assigning the jira.
Vijay Siddha Saurabh Sablaka
Hi Samir,
As discussed, we need to assign this ticket.
Regards,
Satya Prakash
| Assignee | Satya [ ID10004 ] | Samir [ samir ] |
| Assignee | Samir [ samir ] | Rakesh Roy [ rakeshr ] |
| Assignee | Rakesh Roy [ rakeshr ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Attachment | SingleQuote_ScenariosTestedWithStatus.xls [ 32125 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Testing done on LB. Working as expected. Ready for Stage.
Testing scenario attached. SingleQuote_ScenariosTestedWithStatus_LocalTesting_14-Nov.xls
| Attachment | SingleQuote_ScenariosTestedWithStatus_LocalTesting_14-Nov.xls [ 32201 ] |
| Environment | Production [ 10005 ] | |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Hi All,
Attached are tested scenarios. There are 2 scenarios which is not working. SingleQuote_ScenariosTestedWithStatus_LocalTesting_14-Nov.xls
1) Import - Add employee through Import and try to login . Employe is not login into system.
2) Workterra Utility - Regenerate Password, It is not working.
Rest scenarios are fine.
Thanks,
Hrishikesh.
| Attachment | SingleQuote_ScenariosTestedWithStatus_LocalTesting_14-Nov.xls [ 32229 ] |
| Attachment | SingleQuote_ScenariosTestedWithStatus_LocalTesting_14-Nov.xls [ 32201 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
Additionally, Can you please check for '-' character if its working in password?
Example : On stage , Karma company employee having last name like 'Sharma-D'Souza'
Thanks,
Swapnil P.
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Swapnil Pandhare [ swapnil.pandhare ] |
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Priya Dhamande [ priya.dhamande ] |
| Attachment | SingleQuoteDash_ScenariosTestedWithStatus_StageTesting_16Nov.xls [ 32600 ] |
Environment: Stage
Company: Karma for Hspl and Asml for Hspl
The scenarios covered are updated in excel attached with Status.
Employee added through UI and Dash in Password - Pass
Employee added through Import and dash in Password - Fail
Other scenarios and issues are mentioned in excel.
Thanks,
Priya
| Assignee | Priya Dhamande [ priya.dhamande ] | Swapnil Pandhare [ swapnil.pandhare ] |
Two scenarios from import are failing . Please find commets and details above by Priya.
Please schedule this bug to fix.
Thanks,
Swapnil P.
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Vishal Bajad [ vishal.bajad ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
Hi,
Please find status for mentioned scenario for import ,
- Employee name with(`) Success (we need to update regexp for First Name and last name)
- Employee Login with ' in Password Success
- Employee Login with - in Password Success
Business logic for adding Employee through UI is same as Import even password also, Employee User ID and Password will generate on basis of User ID and Password Credentials customization, this is properly working as well but the issues is that we use password in lower case only, even we added employee First name or Last name in Capital letters ,
e.g. if we used last name and first 4 digit of SSN no in Password Credentials Customization ,
Employee First Name : Tom
Employee Last Name : D'souza
Employee SSN : 875429632
Employee Password will generate as "d'souza8754".
Satya Samir Swapnil Pandhare Jaideep Vinchurkar is it valid for Password Credentials ?
Thanks !
In WORKTERRA, passwords and usernames are by default in lower case. This is applicable to all screens and utilities.
As per Vishal Bajad, there is no issue in import. please check again.
| Assignee | Vishal Bajad [ vishal.bajad ] | Priya Dhamande [ priya.dhamande ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Hi,
The testing is in progess.
I have checked the scenarios for username and it is working. Will be verifying Password scenarios on monday.
Vishal Bajad 3 C's Please.
| Assignee | Priya Dhamande [ priya.dhamande ] | Rashmita Dudhe [ rashmita.dudhe ] |
| Attachment | As_test.txt [ 33539 ] |
| Attachment | As_test.txt [ 33540 ] |
Hi Vishal Bajad,
I have verified this through import on Stage Austin for hspl company.
Verified for character: ', ',- for default generated password when first name and last name having character ( ', ',- )
verified below scenarios:
1]hspl'stesti-ng-Pass
2]h-splt-est-Pass
3]h'splte-st-Failed SSN:450230231
For ` character import has validation records are not imported.
Refer attached file.
As_test.txt
Thanks,
Rashmita
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Vishal Bajad [ vishal.bajad ] |
| Resolution | Unresolved [ 10200 ] | |
| Status | Stage Testing [ 10201 ] | Reopen in Stage [ 10023 ] |
| Status | Reopen in Stage [ 10023 ] | In Development [ 10007 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Assignee | Vishal Bajad [ vishal.bajad ] | Rashmita Dudhe [ rashmita.dudhe ] |
Hi Vishal Bajad,
I have verified this on LB environment.
It is working fine For (' and -)
But for ` Character import is kicked out to back showing validation.
cross verified through Ui it is working fine for this ` character
Thanks,
Rashmita
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Remaining Estimate | 1h [ 3600 ] | |
| Original Estimate | 1h [ 3600 ] |
| Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 1h [ 3600 ] | |
| Worklog Id | 11045 [ 11045 ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Vishal Bajad [ vishal.bajad ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
| Original Estimate | 1h [ 3600 ] | 3h [ 10800 ] |
| Time Spent | 1h [ 3600 ] | 3h [ 10800 ] |
| Worklog Id | 11047 [ 11047 ] |
Hi Rashmita Dudhe ,
Script check in to allow "`" character in first name and last name and it will deploy on LB tomorrow.
Thanks !
| Remaining Estimate | 0h [ 0 ] | 1m [ 60 ] |
| Remaining Estimate | 1m [ 60 ] | 0h [ 0 ] |
| Time Spent | 3h [ 10800 ] | 4h [ 14400 ] |
| Worklog Id | 11205 [ 11205 ] |
-
- Time Spent:
- 2h
-
This issues has been resolved.
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Assignee | Vishal Bajad [ vishal.bajad ] | Rashmita Dudhe [ rashmita.dudhe ] |
Verified on Lb Environment.
1]File is imported successfully with ` Character.
2]Login to the system with default password generated with First name and lastname.
Working fine as expected.
| Original Estimate | 3h [ 10800 ] | 6h [ 21600 ] |
| Time Spent | 4h [ 14400 ] | 6h [ 21600 ] |
| Worklog Id | 11334 [ 11334 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Reopen in Stage [ 10023 ] |
| Status | Reopen in Stage [ 10023 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Developer | Vikas Pawar [ vikas.pawar ] |
| Developer | Vikas Pawar [ vikas.pawar ] | Vishal Bajad [ vishal.bajad ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Rajendra Joshi [ rajendraj ] |
Verified on Stage using company Austin For HSPL. Below issues are observed :
1. If ' is included in employee name, and is generated with first and last name, then user can not login using generated password.
2. Partner can not change password with ' character.
Hi Rashmita Dudhe ,
Please do the import related testing and assign to developer with your comments.
Rajendra Joshi (Inactive)
added a comment - Verified on Stage using company Austin For HSPL. Below issues are observed :
1. If ' is included in employee name, and is generated with first and last name, then user can not login using generated password.
2. Partner can not change password with ' character.
Hi Rashmita Dudhe ,
Please do the import related testing and assign to developer with your comments.
Rajendra Joshi (Inactive)
made changes -
| Assignee | Rajendra Joshi [ rajendraj ] | Rashmita Dudhe [ rashmita.dudhe ] |
Rajendra Joshi (Inactive)
made changes -
| Time Spent | 6h [ 21600 ] | 8h [ 28800 ] |
| Worklog Id | 12079 [ 12079 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
testing in progress
Verified this on Stage through UI And Import
1]File is imported successfully with ` Character.
2]Login to the system with default password generated with First name and lastname.
This issue is only for default password and it is Working fine as expected.
Swapnil Pandhare Observation: On change password page it showing validation message for Characters(`,'-) let us know an we consider it as bug or not.
| Original Estimate | 6h [ 21600 ] | 8h [ 28800 ] |
| Time Spent | 8h [ 28800 ] | 10h [ 36000 ] |
| Worklog Id | 12272 [ 12272 ] |
| Remaining Estimate | 0h [ 0 ] | 2h [ 7200 ] |
| Time Spent | 10h [ 36000 ] | 8h [ 28800 ] |
| Worklog Id | 12272 [ 12272 ] | |
| Worklog Time Spent | 2 hours [ 7200 ] |
| Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
| Time Spent | 8h [ 28800 ] | 10h [ 36000 ] |
| Worklog Id | 12273 [ 12273 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Time Spent | 10h [ 36000 ] | 12h [ 43200 ] |
| Worklog Id | 12613 [ 12613 ] |
| Original Estimate | 8h [ 28800 ] | 12h [ 43200 ] |
| Worklog Id | 12273 [ 12273 ] |
| Time Spent | 12h [ 43200 ] | 14h [ 50400 ] |
| Worklog Id | 13790 [ 13790 ] |
| Original Estimate | 12h [ 43200 ] | 14h [ 50400 ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Swapnil Pandhare [ swapnil.pandhare ] |
Swapnil Pandhare Please update.
SatyaVijay Siddha
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Satya [ ID10004 ] |
Validation on change password page is proper, we should not remove this.
Please verify this ticket & let's move to production in regular patch process.
Regards,
Satya Prakash
| Assignee | Satya [ ID10004 ] | Rashmita Dudhe [ rashmita.dudhe ] |
As per Above comment We will move this patch to production
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Code Reviewed By | Jaideep Vinchurkar [ 11908 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Resolution | Unresolved [ 10200 ] | Fixed [ 1 ] |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
46d 36m | 1 |
|
4h 45m | 2 |
|
4d 19h 44m | 2 |
|
5d 18h 46m | 2 |
|
2d 4h 5m | 2 |
|
5d 1h 6m | 5 |
|
9d 22h 41m | 3 |
|
37d 21h 59m | 1 |
|
19s | 1 |
|
63d 22h 6m | 1 |
As per discussion with Satya, assiging to Rakesh