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

Password Policy -> Not working for Last 4 digit of SSN

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Company:
      Symphony
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Pre-Requisites

      1)Security setting -> Last four digits of SSN as password

      Steps :
      1)Login with partner
      2)Add Employee Through Import or UI
      3)Mail trigger
      4)As per security setting Username policy is generating properly but password Policy is generating incorrect.

      Please note : When password setting is last four character : Policy is not generating correct, also show "Please contact to your administrator"
      While when we select other Password security options its works fine.

        Attachments

        1. ImportEmail.JPG
          ImportEmail.JPG
          74 kB
        2. LBMail.txt
          2 kB
        3. MailUICorrected.txt
          2 kB
        4. RegressionTestCases.xls
          24 kB
        5. StageMailImport.txt
          3 kB
        6. StageMailUI.txt
          3 kB
        7. UIEmail.JPG
          UIEmail.JPG
          65 kB
        8. UI EMP ADD.txt
          3 kB

          Issue Links

            Activity

            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -
            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Hi Snehal Katkar,

            Please consider this scenario also through UI and Import

            2)When Password is not checked in security - Policy is not generating , but default user ID is generating, also displays "Please contact to your administrator"

            X-Receiver: stage@workterra.com
            X-Receiver: kunal@harbingergroup.com
            X-Receiver: saurabh.sablaka@harbingergroup.com
            X-Receiver: samir@harbingergroup.com
            X-Receiver: rashmita.dudhe@harbingergroup.com
            X-Sender: samir@harbingergroup.com
            thread-index: AdNYVpDrKDYFVROCQwyrf2ovVYsXvg==
            Thread-Topic: STAGE - Online Enrollment System - Login Credentials
            From: ,

            To: ,
            ,
            ,
            ,

            Cc:
            Bcc:
            Subject: STAGE - Online Enrollment System - Login Credentials
            Date: Tue, 7 Nov 2017 21:58:14 -0800
            Message-ID:
            MIME-Version: 1.0
            Content-Type: multipart/alternative;
            boundary="----=_NextPart_000_50CD5_01D35813.82CAD470"
            X-Mailer: Microsoft CDO for Windows 2000
            Content-Class: urn:content-classes:message
            Importance: normal
            Priority: normal
            X-MimeOLE: Produced By Microsoft MimeOLE V6.3.9600.18817

            This is a multi-part message in MIME format.

            ------=_NextPart_000_50CD5_01D35813.82CAD470
            Content-Type: text/plain;
            charset="iso-8859-1"
            Content-Transfer-Encoding: 7bit

            Dear hspl test , Congratulations!!! You have been added as the Member
            of the Online Enrollment System. Your login credentials to access
            Online Enrollment System are given below.

            UserName : First four characters of your first name with the first two
            characters of your last name and the last four digits of your SSNYour
            Username is last 4 digits of your social security number. ~6789.

            Password : First four characters of your first name with the first two
            characters of your last name Your.
            User ID:6789
            Password: Please contact to your administrator for password
            .

            Please visit us at our site https://uhc.workterra.net
            for more details.

            Thank You, The Benefits Team

            ------=_NextPart_000_50CD5_01D35813.82CAD470
            Content-Type: text/html
            Content-Transfer-Encoding: 7bit

            Dear hspl test , Congratulations!!! You have been added as the Member of the Online Enrollment System. Your login credentials to access Online Enrollment System are given below.

            UserName : First four characters of your first name with the first two characters of your last name and the last four digits of your SSNYour Username is last 4 digits of your social security number.
            ~6789.

            Password : First four characters of your first name with the first two characters of your last name Your.

            *User ID:6789
            Password: Please contact to your administrator for password*
            .

            Please visit us at our site https://uhc.workterra.net for more details.

            Thank You, The Benefits Team

            -----=_NextPart_000_50CD5_01D35813.82CAD470-

            cc : Rakesh Roy Prasad Pise Jaideep Vinchurkar

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Hi Snehal Katkar , Please consider this scenario also through UI and Import 2)When Password is not checked in security - Policy is not generating , but default user ID is generating, also displays "Please contact to your administrator" X-Receiver: stage@workterra.com X-Receiver: kunal@harbingergroup.com X-Receiver: saurabh.sablaka@harbingergroup.com X-Receiver: samir@harbingergroup.com X-Receiver: rashmita.dudhe@harbingergroup.com X-Sender: samir@harbingergroup.com thread-index: AdNYVpDrKDYFVROCQwyrf2ovVYsXvg== Thread-Topic: STAGE - Online Enrollment System - Login Credentials From: , To: , , , , Cc: Bcc: Subject: STAGE - Online Enrollment System - Login Credentials Date: Tue, 7 Nov 2017 21:58:14 -0800 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_50CD5_01D35813.82CAD470" X-Mailer: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.3.9600.18817 This is a multi-part message in MIME format. ------=_NextPart_000_50CD5_01D35813.82CAD470 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Dear hspl test , Congratulations!!! You have been added as the Member of the Online Enrollment System. Your login credentials to access Online Enrollment System are given below. UserName : First four characters of your first name with the first two characters of your last name and the last four digits of your SSNYour Username is last 4 digits of your social security number. ~6789. Password : First four characters of your first name with the first two characters of your last name Your. User ID:6789 Password: Please contact to your administrator for password . Please visit us at our site https://uhc.workterra.net for more details. Thank You, The Benefits Team ------=_NextPart_000_50CD5_01D35813.82CAD470 Content-Type: text/html Content-Transfer-Encoding: 7bit Dear hspl test , Congratulations!!! You have been added as the Member of the Online Enrollment System. Your login credentials to access Online Enrollment System are given below. UserName : First four characters of your first name with the first two characters of your last name and the last four digits of your SSNYour Username is last 4 digits of your social security number. ~6789. Password : First four characters of your first name with the first two characters of your last name Your. *User ID:6789 Password: Please contact to your administrator for password* . Please visit us at our site https://uhc.workterra.net for more details. Thank You, The Benefits Team ----- =_NextPart_000_50CD5_01D35813.82CAD470 - cc : Rakesh Roy Prasad Pise Jaideep Vinchurkar
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            3) When User name and Password is not selected from security setting.

            thread-index: AdNYV6WvX5LFfUlBRo64+PC1ua0NJw==
            Thread-Topic: STAGE - Online Enrollment System - Login Credentials
            From: ,

            To: ,
            ,
            ,
            ,

            Cc:
            Bcc:
            Subject: STAGE - Online Enrollment System - Login Credentials
            Date: Tue, 7 Nov 2017 22:05:58 -0800
            Message-ID:
            MIME-Version: 1.0
            Content-Type: multipart/alternative;
            boundary="----=_NextPart_000_50CDA_01D35814.978F0880"
            X-Mailer: Microsoft CDO for Windows 2000
            Content-Class: urn:content-classes:message
            Importance: normal
            Priority: normal
            X-MimeOLE: Produced By Microsoft MimeOLE V6.3.9600.18817

            This is a multi-part message in MIME format.

            ------=_NextPart_000_50CDA_01D35814.978F0880
            Content-Type: text/plain;
            charset="iso-8859-1"
            Content-Transfer-Encoding: 7bit

            Dear hspl test , Congratulations!!! You have been added as the Member
            of the Online Enrollment System. Your login credentials to access
            Online Enrollment System are given below.

            UserName : First four characters of your first name with the first two
            characters of your last name and the last four digits of your SSNYour.
            ~jodo01011987.

            Password : First four characters of your first name with the first two
            characters of your last name Your.
            User ID:jodo01011987
            Password: Please contact to your administrator for password
            .

            Please visit us at our site https://uhc.workterra.net
            for more details.

            Thank You, The Benefits Team

            ------=_NextPart_000_50CDA_01D35814.978F0880
            Content-Type: text/html
            Content-Transfer-Encoding: 7bit

            Dear hspl test , Congratulations!!! You have been added as the Member of the Online Enrollment System. Your login credentials to access Online Enrollment System are given below.

            *UserName : First four characters of your first name with the first two characters of your last name and the last four digits of your SSNYour.
            ~jodo01011987*.

            Password : First four characters of your first name with the first two characters of your last name Your.

            *User ID:jodo01011987
            Password: Please contact to your administrator for password*

            .

            Please visit us at our site https://uhc.workterra.net for more details.

            Thank You, The Benefits Team

            -----=_NextPart_000_50CDA_01D35814.978F0880-

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - 3) When User name and Password is not selected from security setting. thread-index: AdNYV6WvX5LFfUlBRo64+PC1ua0NJw== Thread-Topic: STAGE - Online Enrollment System - Login Credentials From: , To: , , , , Cc: Bcc: Subject: STAGE - Online Enrollment System - Login Credentials Date: Tue, 7 Nov 2017 22:05:58 -0800 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_50CDA_01D35814.978F0880" X-Mailer: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.3.9600.18817 This is a multi-part message in MIME format. ------=_NextPart_000_50CDA_01D35814.978F0880 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Dear hspl test , Congratulations!!! You have been added as the Member of the Online Enrollment System. Your login credentials to access Online Enrollment System are given below. UserName : First four characters of your first name with the first two characters of your last name and the last four digits of your SSNYour. ~jodo01011987. Password : First four characters of your first name with the first two characters of your last name Your. User ID:jodo01011987 Password: Please contact to your administrator for password . Please visit us at our site https://uhc.workterra.net for more details. Thank You, The Benefits Team ------=_NextPart_000_50CDA_01D35814.978F0880 Content-Type: text/html Content-Transfer-Encoding: 7bit Dear hspl test , Congratulations!!! You have been added as the Member of the Online Enrollment System. Your login credentials to access Online Enrollment System are given below. *UserName : First four characters of your first name with the first two characters of your last name and the last four digits of your SSNYour. ~jodo01011987*. Password : First four characters of your first name with the first two characters of your last name Your. *User ID:jodo01011987 Password: Please contact to your administrator for password* . Please visit us at our site https://uhc.workterra.net for more details. Thank You, The Benefits Team ----- =_NextPart_000_50CDA_01D35814.978F0880 -
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Snehal Katkar, please update 3C's, affected files, impacted area

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Snehal Katkar , please update 3C's, affected files, impacted area
            Hide
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Concern: Password Policy -> Not working for Last 4 digit of SSN. Also, [SystemURL] is not getting replaced by actual value for import.

            Cause: Using no. of last characters of SSN for password is a latest enhancement. It wasn't included while generating password policy (both for UI and Import). Import did not contain implementation for [SystemURL].

            Correction: Added rule of 'last characters of SSN' while generating password policy. Added implementation of [SystemURL] in Import process.

            Files Changed:
            1) WT/trunk/WORKTERRAweb/App/BusinessLogic/GenericLibrary/CommonBusinessRoutines.vb
            2) WT/trunk/WORKTERRAweb/App/BusinessLogic/GenericLibrary/GenericLibrary.dll.config
            3) WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportExportDTS.dll.config
            4) WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportValidation.vb
            5) WT/trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Import_SendUserCredentialNotifications.StoredProcedure.sql

            Impacted Areas:
            1) Email generation after adding employee into the system.
            2) Password policy in Email Message Format.

            Scenarios to Test:
            1) If password contains some last characters of SSN then, password policy should contain information about the same. (Both UI and Import)
            2) [SystemURL] in Email body should get replaced by actual value of the URL.

            Note:
            Value of [SystemURL] is taken from configuration file which is a hard coded value in a way. So, for each company URL will be the same. Whereas, it should have been displayed dynamically, according to the current company. This is yet to be discussed and finalized.

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Concern: Password Policy -> Not working for Last 4 digit of SSN. Also, [SystemURL] is not getting replaced by actual value for import. Cause: Using no. of last characters of SSN for password is a latest enhancement. It wasn't included while generating password policy (both for UI and Import). Import did not contain implementation for [SystemURL] . Correction: Added rule of 'last characters of SSN' while generating password policy. Added implementation of [SystemURL] in Import process. Files Changed: 1) WT/trunk/WORKTERRAweb/App/BusinessLogic/GenericLibrary/CommonBusinessRoutines.vb 2) WT/trunk/WORKTERRAweb/App/BusinessLogic/GenericLibrary/GenericLibrary.dll.config 3) WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportExportDTS.dll.config 4) WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportValidation.vb 5) WT/trunk/WORKTERRAweb/Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Import_SendUserCredentialNotifications.StoredProcedure.sql Impacted Areas: 1) Email generation after adding employee into the system. 2) Password policy in Email Message Format. Scenarios to Test: 1) If password contains some last characters of SSN then, password policy should contain information about the same. (Both UI and Import) 2) [SystemURL] in Email body should get replaced by actual value of the URL. Note: Value of [SystemURL] is taken from configuration file which is a hard coded value in a way. So, for each company URL will be the same. Whereas, it should have been displayed dynamically, according to the current company. This is yet to be discussed and finalized.
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Snehal Katkar,

            Verified on LB
            Company - QA CAISO for hspl

            Verified scenario through Import are attached in checklist :
            Issue of Password generation for last four character and System url is fixed.
            RegressionTestCases.xls

            Hrishikesh Deshpande, could you please assign this jira for verification through UI.

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise Gaurav Sodani Jaideep Vinchurkar

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Snehal Katkar , Verified on LB Company - QA CAISO for hspl Verified scenario through Import are attached in checklist : Issue of Password generation for last four character and System url is fixed. RegressionTestCases.xls Hrishikesh Deshpande , could you please assign this jira for verification through UI. Thanks, Jayshree cc : Rakesh Roy Prasad Pise Gaurav Sodani Jaideep Vinchurkar
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Snehal Katkar,

            Verified through UI
            Password scenario is working.
            But system url is not correct. its showing https://stage.workterra.net/

            through Import its showing https://www.workterra.net/ as system url

            Could you please correct it and assign me once the changes are done

            Thanks,
            Jayshree

            cc : Rakesh Roy Jaideep Vinchurkar Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Snehal Katkar , Verified through UI Password scenario is working. But system url is not correct. its showing https://stage.workterra.net/ through Import its showing https://www.workterra.net/ as system url Could you please correct it and assign me once the changes are done Thanks, Jayshree cc : Rakesh Roy Jaideep Vinchurkar Prasad Pise
            Hide
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Hi Jayshree Nagpure,

            Config file used by addEmployee through UI, contained duplicate values for SiteURL. System was fetching the first declaration which was 'stage.workterra.net' instead of 'www.workterra.net'. I have corrected config file. You can check now.

            Thanks,
            Snehal

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Hi Jayshree Nagpure , Config file used by addEmployee through UI, contained duplicate values for SiteURL. System was fetching the first declaration which was 'stage.workterra.net' instead of 'www.workterra.net'. I have corrected config file. You can check now. Thanks, Snehal
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Snehal Katkar,

            Verified on LB
            Company - QA CAISO for hspl

            Verified through UI
            System url is corrected. MailUICorrected.txt

            Verified Last character of password scenario - PAss
            Along with last character of password verified other scenario - Pass

            Verification through UI and Import is done.
            Scenario are attached in checklist.

            Marking item state as Ready for stage.

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Snehal Katkar , Verified on LB Company - QA CAISO for hspl Verified through UI System url is corrected. MailUICorrected.txt Verified Last character of password scenario - PAss Along with last character of password verified other scenario - Pass Verification through UI and Import is done. Scenario are attached in checklist. Marking item state as Ready for stage. Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Snehal Katkar,

            Verified on stage
            Company - Symphony for hspl

            Verified attached scenario for Import and UI
            Please find attached Testcases.

            Working fine

            StageMailImport.txt StageMailUI.txt

            Please note - Policy will be generate according to security setting when UserId and Password will be tagged in Email Message format, as its dynamic to all company.
            Same in case of System url, we need to tag SystemURL in email message format, then only workterra url will be displayed.

            Working fine, Marking item state as Ready for Production.

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise Hrishikesh Deshpande

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Snehal Katkar , Verified on stage Company - Symphony for hspl Verified attached scenario for Import and UI Please find attached Testcases. Working fine StageMailImport.txt StageMailUI.txt Please note - Policy will be generate according to security setting when UserId and Password will be tagged in Email Message format, as its dynamic to all company. Same in case of System url, we need to tag SystemURL in email message format, then only workterra url will be displayed. Working fine, Marking item state as Ready for Production. Thanks, Jayshree cc : Rakesh Roy Prasad Pise Hrishikesh Deshpande
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Company - ASML For hspl

            Verified attached scenario for Import and UI
            Please find attached Testcases.
            Working fine

            Please note - Policy will be generate according to security setting when UserID and Password will be tagged in Email Message format, as its dynamic to all company.
            Same in case of System url, we need to tag SystemURL in email message format, then only workterra url will be displayed.

            Working fine.

            Thanks,
            Jayshree

            cc: Rakesh Roy Prasad Pise Jaideep Vinchurkar Gaurav Sodani Snehal Katkar

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Company - ASML For hspl Verified attached scenario for Import and UI Please find attached Testcases. Working fine Please note - Policy will be generate according to security setting when UserID and Password will be tagged in Email Message format, as its dynamic to all company. Same in case of System url, we need to tag SystemURL in email message format, then only workterra url will be displayed. Working fine. Thanks, Jayshree cc: Rakesh Roy Prasad Pise Jaideep Vinchurkar Gaurav Sodani Snehal Katkar

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Developer:
              Snehal Katkar (Inactive)
              QA:
              Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 10h Original Estimate - 10h
                  10h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 26.25h
                  26.25h