WORKTERRAProject Type: software

WORKTERRA

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

Functional-Partner login-Global Level Secutiy- Server Error

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Platform
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Security
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Browser:
      Google Chrome

      Description

      Replication Steps:

      1.Login with Partner
      2.Go to Customizer
      3.Go to Secutiy Tab
      4.Do not change or update anything and Click On save

      Actual: Server encountered an internal error. Please contact your administrator appeared.

      Expected: It should Save and update sucessfully without any error

        Attachments

        1. CompanyLevel.jpg
          CompanyLevel.jpg
          270 kB
        2. CompanyLevelWithoutsaving.jpg
          CompanyLevelWithoutsaving.jpg
          184 kB
        3. Global.jpg
          Global.jpg
          256 kB
        4. Server Error on Global Level Security.jpg
          Server Error on Global Level Security.jpg
          133 kB
        5. StageWithoutCompany.jpg
          StageWithoutCompany.jpg
          251 kB
        6. Withoutsavingsecurity.jpg
          Withoutsavingsecurity.jpg
          187 kB

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. NF-5186 CLONE - Workterra needs to have a password that should use the last 4 of a SSN but only the first 4

          • Critical - This problem will block progress.
          • Resolution Setting

          Enhancement - An improvement or enhancement to an existing feature or task. WT-11723 Workterra needs to have a password that should use the last 4 of a SSN but only the first 4

          • Critical - This problem will block progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            priya.handepatil Priya Handepatil (Inactive) created issue -
            Hide
            Permalink
            priya.handepatil Priya Handepatil (Inactive) added a comment -

            Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Field Original Value New Value
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Akash Thakur [ akash.thakur ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Hi Sheetal Bodhale,

            We found that last 4 password changes deployed on LB but dbo.OES_SP_Update_ConfigurationUserNamePassword.StoredProcedure.sql is not updated on onlineenrollmentsb. it is throwing exception of mismatch parameter. Please check.
            Security page is failing on global level but working on company level

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Hi Sheetal Bodhale , We found that last 4 password changes deployed on LB but dbo.OES_SP_Update_ConfigurationUserNamePassword.StoredProcedure.sql is not updated on onlineenrollmentsb. it is throwing exception of mismatch parameter. Please check. Security page is failing on global level but working on company level
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Akash Thakur [ akash.thakur ] Sheetal Bodhale [ sheetal.bodhale ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 08/Nov/17 01:34 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Component/s Platform [ 10006 ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Remaining Estimate 4h [ 14400 ]
            Original Estimate 4h [ 14400 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3.5h [ 12600 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 89716 [ 89716 ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Amit Kumawat [ amit.kumawat ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Dev Due Date 13/Nov/2017
            Developer Amit Kumawat [ amit.kumawat ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Root Cause Scenario/Requirement Missed [ 18432 ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            Hide
            Permalink
            amit.kumawat Amit Kumawat (Inactive) added a comment - - edited

            Hello Priya Handepatil,

            Concern: Functional-Partner login-Global Level Secutiy- Server Error

            Cause: Changes related to "Password that should use the last 4 of a SSN" was not handled for Global Level

            Correction: Condition handled at Global Level.

            CC: Sheetal Bodhale, Swapnil Pandhare, Satya

            Thanks & Regards,
            Amit Kumawat

            Show
            amit.kumawat Amit Kumawat (Inactive) added a comment - - edited Hello Priya Handepatil , Concern : Functional-Partner login-Global Level Secutiy- Server Error Cause : Changes related to "Password that should use the last 4 of a SSN" was not handled for Global Level Correction : Condition handled at Global Level. CC: Sheetal Bodhale , Swapnil Pandhare , Satya Thanks & Regards, Amit Kumawat
            Hide
            Permalink
            amit.kumawat Amit Kumawat (Inactive) added a comment -

            Impacted Areas:- Global Level Security
            Affected files:-
            1. 176_WT-12037_WTB_EDS_ModTable_PasswordCredentials.sql
            2. OES_SP_Save_ConfigurationUserNamePassword
            3. OES_SP_Update_ConfigurationUserNamePassword

            Show
            amit.kumawat Amit Kumawat (Inactive) added a comment - Impacted Areas :- Global Level Security Affected files :- 1. 176_ WT-12037 _WTB_EDS_ModTable_PasswordCredentials.sql 2. OES_SP_Save_ConfigurationUserNamePassword 3. OES_SP_Update_ConfigurationUserNamePassword
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Code Review Date 10/Nov/2017
            Code Reviewed By Sheetal Bodhale [ 11905 ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0h [ 0 ]
            Time Spent 0.5h [ 1800 ] 4.5h [ 16200 ]
            Worklog Id 90195 [ 90195 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Time Spent 4.5h [ 16200 ] 4h 50m [ 17400 ]
            Worklog Id 90207 [ 90207 ]
            Permalink
            amit.kumawat Amit Kumawat (Inactive) logged work - 11/Nov/17 01:04 AM
            • Time Spent:
              4h
               

              Analysis
              Code Changes
              Code commit
              Discussion with Sheetal

            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 11/Nov/17 01:29 AM
            • Time Spent:
              20m
               

              code review
              discussion

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Assignee Amit Kumawat [ amit.kumawat ] Priya Handepatil [ priya.handepatil ]
            Hide
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Priya Handepatil,

            Please check this on Priority so that we can move this JIRA to stage.

            CC:Swapnil Pandhare

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Priya Handepatil , Please check this on Priority so that we can move this JIRA to stage. CC: Swapnil Pandhare Thanks, Sheetal Bodhale
            Hide
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Please check this on Priority.So that we can deploy this patch on production on Wednesday's patch.

            CC:SatyaSwapnil Pandhare

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Hrishikesh Deshpande , Please check this on Priority.So that we can deploy this patch on production on Wednesday's patch. CC: Satya Swapnil Pandhare Thanks, Sheetal Bodhale
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Priya Handepatil [ priya.handepatil ] Jayshree Nagpure [ jayshree.nagpure ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 13/Nov/17 12:34 PM
            • Time Spent:
              1h
               

              Testing on LB

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment Withoutsavingsecurity.jpg [ 67521 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment CompanyLevelWithoutsaving.jpg [ 67522 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Sheetal Bodhale,

            Verified on Lb
            Login - Partner

            Verified below scenario - Issue is fixed
            1) Saving Global level security page without any changes -> Pass
            2) Saving Global level security page with some changes -> Pass
            3) Saving Company level security page without any changes -> Pass
            4) Saving Company level security page with some changes -> Pass

            Working fine.
            Marking item state as Ready for Stage

            Thanks,
            Jayshree

            cc : Prasad Pise Sachin Hingole Rakesh Roy Amit Kumawat

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Sheetal Bodhale , Verified on Lb Login - Partner Verified below scenario - Issue is fixed 1) Saving Global level security page without any changes -> Pass 2) Saving Global level security page with some changes -> Pass 3) Saving Company level security page without any changes -> Pass 4) Saving Company level security page with some changes -> Pass Working fine. Marking item state as Ready for Stage Thanks, Jayshree cc : Prasad Pise Sachin Hingole Rakesh Roy Amit Kumawat
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 4h 50m [ 17400 ] 5h 50m [ 21000 ]
            Worklog Id 90473 [ 90473 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Link This issue relates to WT-11723 [ WT-11723 ]
            khandu.kshirsagar 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)
            Hide
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Jayshree Nagpure,

            This is deployed on stage.Please check this on Priority today.

            CC:SatyaSwapnil PandhareHrishikesh DeshpandeGaurav Sodani

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Jayshree Nagpure , This is deployed on stage.Please check this on Priority today. CC: Satya Swapnil Pandhare Hrishikesh Deshpande Gaurav Sodani Thanks, Sheetal Bodhale
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment StageWithoutCompany.jpg [ 67630 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Stage
            Login - Partner

            Verified below scenario - Issue is fixed
            1) Saving Global level security page without any changes -> Pass
            2) Saving Global level security page with some changes -> Pass
            3) Saving Company level security page without any changes -> Pass
            4) Saving Company level security page with some changes -> Pass

            Marking item state as Ready for Production.

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage Login - Partner Verified below scenario - Issue is fixed 1) Saving Global level security page without any changes -> Pass 2) Saving Global level security page with some changes -> Pass 3) Saving Company level security page without any changes -> Pass 4) Saving Company level security page with some changes -> Pass Marking item state as Ready for Production. Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            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)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 14/Nov/17 01:12 PM
            • Time Spent:
              0.5h
               

              Stage testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 5h 50m [ 21000 ] 6h 20m [ 22800 ]
            Worklog Id 90791 [ 90791 ]
            Permalink
            amit.kumawat Amit Kumawat (Inactive) logged work - 14/Nov/17 01:16 PM
            • Time Spent:
              0.5h
               

              Discussion with Sheetal
              Code checkin at Stage

            amit.kumawat Amit Kumawat (Inactive) made changes -
            Time Spent 6h 20m [ 22800 ] 6h 50m [ 24600 ]
            Worklog Id 90793 [ 90793 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 15/Nov/17 01:00 PM
            • Time Spent:
              0.5h
               

              Production testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment Global.jpg [ 67768 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment CompanyLevel.jpg [ 67769 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Login - Partner

            Verified below scenario - Issue is fixed
            1) Saving Global level security page without any changes -> Pass
            2) Saving Global level security page with some changes -> Pass
            3) Saving Company level security page without any changes -> Pass
            4) Saving Company level security page with some changes -> Pass

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Login - Partner Verified below scenario - Issue is fixed 1) Saving Global level security page without any changes -> Pass 2) Saving Global level security page with some changes -> Pass 3) Saving Company level security page without any changes -> Pass 4) Saving Company level security page with some changes -> Pass Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 6h 50m [ 24600 ] 7h 20m [ 26400 ]
            Worklog Id 90950 [ 90950 ]
            amit.kumawat Amit Kumawat (Inactive) made changes -
            Time Spent 7h 20m [ 26400 ] 8h 20m [ 30000 ]
            Worklog Id 90981 [ 90981 ]
            Permalink
            amit.kumawat Amit Kumawat (Inactive) logged work - 16/Nov/17 01:47 AM
            • Time Spent:
              1h
               

              Code check in
              Discussion with Ashwin & Sheetal

            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Link This issue relates to WT-12397 [ WT-12397 ]
            Transition Time In Source Status Execution Times
            Jaideep Vinchurkar (Inactive) made transition -
            Open In Development
            		5h 59m 1
            Jayshree Nagpure (Inactive) made transition -
            In Development In LB Testing
            		4d 23h 7m 1
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Stage Testing
            		20h 51m 1
            Jayshree Nagpure (Inactive) made transition -
            Stage Testing In Production Testing
            		23h 48m 1
            Jayshree Nagpure (Inactive) made transition -
            In Production Testing Production Complete
            		3h 46m 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              priya.handepatil Priya Handepatil (Inactive)
              Developer:
              Amit Kumawat (Inactive)
              QA:
              Priya Handepatil (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 8h 20m
                  8h 20m