Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-5155

Regression - Single Quote issue for User name and Password in application

    Details

    • 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

      Description

      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.

      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

      Satya, Rakesh Roy and Swapnil Pandhare you can add more scenarios if i have missed anything.

      CC: Saurabh Sablaka Samir

        Attachments

          Issue Links

            Activity

            Hide
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            As per discussion with Satya, assiging to Rakesh

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - As per discussion with Satya , assiging to Rakesh
            Hide
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Hi Priya Dhamande,

            Import users with Single Quote also needs to validate.

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Hi Priya Dhamande , Import users with Single Quote also needs to validate.
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            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

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - 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: Samir Satya Vijay Siddha
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

            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.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited 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.
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Satya, As discussed with Vikas, assigning the jira.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Satya , As discussed with Vikas, assigning the jira.
            Hide
            satyap Satya added a comment -

            Vijay Siddha Saurabh Sablaka
            Hi Samir,

            As discussed, we need to assign this ticket.

            Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Vijay Siddha Saurabh Sablaka Hi Samir, As discussed, we need to assign this ticket. Regards, Satya Prakash
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Testing done on LB. Working as expected. Ready for Stage.
            Testing scenario attached. SingleQuote_ScenariosTestedWithStatus_LocalTesting_14-Nov.xls

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Testing done on LB. Working as expected. Ready for Stage. Testing scenario attached. SingleQuote_ScenariosTestedWithStatus_LocalTesting_14-Nov.xls
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            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.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - 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.
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            Hi Hrishikesh Deshpande

            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.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Hrishikesh Deshpande 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.
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            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

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - 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
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            CC : Satya Samir

            Hi Jaideep Vinchurkar

            Two scenarios from import are failing . Please find commets and details above by Priya.
            Please schedule this bug to fix.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Satya Samir Hi Jaideep Vinchurkar Two scenarios from import are failing . Please find commets and details above by Priya. Please schedule this bug to fix. Thanks, Swapnil P.
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment - - edited

            Hi,

            Please find status for mentioned scenario for import ,

            1. Employee name with(`) Success (we need to update regexp for First Name and last name)
            2. Employee Login with ' in Password Success
            3. 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 !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - - edited 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 !
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            In WORKTERRA, passwords and usernames are by default in lower case. This is applicable to all screens and utilities.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - In WORKTERRA, passwords and usernames are by default in lower case. This is applicable to all screens and utilities.
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            As per Vishal Bajad, there is no issue in import. please check again.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - As per Vishal Bajad , there is no issue in import. please check again.
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Hi,

            The testing is in progess.
            I have checked the scenarios for username and it is working. Will be verifying Password scenarios on monday.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Hi, The testing is in progess. I have checked the scenarios for username and it is working. Will be verifying Password scenarios on monday.
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Vishal Bajad 3 C's Please.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Vishal Bajad 3 C's Please.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - 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
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - 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
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi Rashmita Dudhe ,

            Script check in to allow "`" character in first name and last name and it will deploy on LB tomorrow.

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Rashmita Dudhe , Script check in to allow "`" character in first name and last name and it will deploy on LB tomorrow. Thanks !
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            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.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - 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.
            Hide
            rajendraj 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.

            Show
            rajendraj 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.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            testing in progress

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - testing in progress
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            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.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - 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.
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -
            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Swapnil Pandhare Please update. Satya Vijay Siddha
            Hide
            satyap Satya added a comment -

            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

            Cc: Rakesh Roy Swapnil Pandhare

            Show
            satyap Satya added a comment - 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 Cc: Rakesh Roy Swapnil Pandhare
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            As per Above comment We will move this patch to production

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - As per Above comment We will move this patch to production

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              vikas.pawar Vikas Pawar (Inactive)
              Developer:
              Vishal Bajad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 14h
                  14h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 14h
                  14h