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

Server error in Prod - Utah Valley

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Query Resolution
    • Environment:
      Production
    • Reported by:
      White Label
    • Module:
      BenAdmin

      Description

      It is for Utah Valley in Prod for UHC. 
      Error is coming up with pulling EE David Prestriedge conf statement.  Checked a few other EEs and it seems isolated
      to him.

       

        Attachments

          Issue Links

            Activity

            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            Hi Jennifer Leugers,

            Concern : Server error on confirmation statement
            Cause : USer Ryan Sapp from UHC has updated SSN for few beneficiaries as "^" which is throwing while masking SSN on confirmation statement.
            We are checking on this scenario to reproduce this and fix this.
            Correction : There are 17 such employees whose beneficiary data needs to be corrected . Please let us know if we can go ahead with correction.
            Also, we will fix the update issue on beneficiary.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Jennifer Leugers , Concern : Server error on confirmation statement Cause : USer Ryan Sapp from UHC has updated SSN for few beneficiaries as "^" which is throwing while masking SSN on confirmation statement. We are checking on this scenario to reproduce this and fix this. Correction : There are 17 such employees whose beneficiary data needs to be corrected . Please let us know if we can go ahead with correction. Also, we will fix the update issue on beneficiary. Thanks, Swapnil P.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi Swapnil – please correct the records. Also – UHC had an additional question below as well.

            Yes – please update this record. I would like to understand however why a SSN update would result in the below. Can you scan this Client as they did have 96 records touched to correct SSNs for ACA resporting and I guess my concern now is that there is more impact than known as of current?

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi Swapnil – please correct the records. Also – UHC had an additional question below as well. Yes – please update this record. I would like to understand however why a SSN update would result in the below. Can you scan this Client as they did have 96 records touched to correct SSNs for ACA resporting and I guess my concern now is that there is more impact than known as of current?
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Rakesh Roy,

            Please try to reproduce the issue and let me know.

            CC:Swapnil Pandhare Satya
            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Rakesh Roy , Please try to reproduce the issue and let me know. CC: Swapnil Pandhare Satya Thanks, Sheetal Bodhale
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Swapnil Pandhare,Jennifer Leugers

            • Employee Beneficiary data is not considered in ACA reporting.
            • Employee Dependent spouse and Dependent Child data is used for ACA reporting for their Date of birth and Social Security No. i.e ACA only reads the data present in the system.
            • ACA reporting does not update any data related to Employee Beneficiary.

            CC: Sheetal Bodhale,Nandkumar Prabhakar Karlekar,Satya

            Thanks,
            Ramya

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Swapnil Pandhare , Jennifer Leugers Employee Beneficiary data is not considered in ACA reporting. Employee Dependent spouse and Dependent Child data is used for ACA reporting for their Date of birth and Social Security No. i.e ACA only reads the data present in the system. ACA reporting does not update any data related to Employee Beneficiary. CC: Sheetal Bodhale , Nandkumar Prabhakar Karlekar , Satya Thanks, Ramya
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have corrected data of all beneficiaries whose SSN was updated as "^".
            Also verified confirmation statement of mentioned employee .It is not throwing error.

            CC:Swapnil Pandhare Satya

            Thanks,
            Sheetal Bodhale.

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Jennifer Leugers , We have corrected data of all beneficiaries whose SSN was updated as "^". Also verified confirmation statement of mentioned employee .It is not throwing error. CC: Swapnil Pandhare Satya Thanks, Sheetal Bodhale.
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Rakesh Roy,

            We have verified this on production but not able to reproduce the issue.I have added and edited the record ,showing proper values/data.
            Please check this using both UI and import.

            CC:Swapnil Pandhare Satya
            Thanks,
            Sheetal Bodhale.

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Rakesh Roy , We have verified this on production but not able to reproduce the issue.I have added and edited the record ,showing proper values/data. Please check this using both UI and import. CC: Swapnil Pandhare Satya Thanks, Sheetal Bodhale.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - UHC still needs an answer to the below as well as confirmation that all records have been corrected (along with a list of the records if you have them).

            From UHC
            _I would like to understand however why a SSN update would result in the below. _

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - UHC still needs an answer to the below as well as confirmation that all records have been corrected (along with a list of the records if you have them). From UHC _I would like to understand however why a SSN update would result in the below. _
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Rakesh Roy,

            Please try to reproduce the issue.
            CC:Swapnil Pandhare Satya

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Rakesh Roy , Please try to reproduce the issue. CC: Swapnil Pandhare Satya Thanks, Sheetal Bodhale
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified this issue through import but it is not reproducible
            1]Pass Character ^ at place of child SSN and import file.
            2]File successfully imported.
            3]completed workflow successfully.
            4]also done change on enrollment and check confirmation statement

            Not getting any server Error.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified this issue through import but it is not reproducible 1]Pass Character ^ at place of child SSN and import file. 2]File successfully imported. 3]completed workflow successfully. 4]also done change on enrollment and check confirmation statement Not getting any server Error.
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified this issue through UI by changing demographics data of employee, spouse and child and traversed self serve mode successfully.

            Not getting any server error on confirmation statement.

            Shubhankar Joshi - Can you please take further action?

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified this issue through UI by changing demographics data of employee, spouse and child and traversed self serve mode successfully. Not getting any server error on confirmation statement. Shubhankar Joshi - Can you please take further action?
            Hide
            shubhankar Shubhankar Joshi (Inactive) added a comment - - edited

            Hi Swapnil Pandhare, Satya

            Based on the comments from Developer and QA, SSN update with value "^" is not causing the error. The issue is not reproduced even after entering " ^ " in the SSN field.

            Could you please confirm this is the cause of the error and update Jennifer Leugers accordingly?

            CC: Vijay Siddha

            Show
            shubhankar Shubhankar Joshi (Inactive) added a comment - - edited Hi Swapnil Pandhare , Satya Based on the comments from Developer and QA, SSN update with value "^" is not causing the error. The issue is not reproduced even after entering " ^ " in the SSN field. Could you please confirm this is the cause of the error and update Jennifer Leugers accordingly? CC: Vijay Siddha
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            Hi Shubhankar Joshi

            Please check this with import also.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Shubhankar Joshi Please check this with import also. Thanks, Swapnil P.
            Hide
            shubhankar Shubhankar Joshi (Inactive) added a comment -

            Hi Swapnil Pandhare

            Rashmita Dudhe has already tested it through import ( See comments dated 19Sep ) and again tested it today. She has not been able to reproduce this issue through import.

            CC: Vijay Siddha, Satya

            Show
            shubhankar Shubhankar Joshi (Inactive) added a comment - Hi Swapnil Pandhare Rashmita Dudhe has already tested it through import ( See comments dated 19Sep ) and again tested it today. She has not been able to reproduce this issue through import. CC: Vijay Siddha , Satya
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Are we still researching this? I really need a solid answer to get back to UHC especially since this client has had a ton of issues.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Are we still researching this? I really need a solid answer to get back to UHC especially since this client has had a ton of issues.
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            CC : Satya Samir Vijay Siddha Rakesh Roy

            Hi Jennifer Leugers

            QA team is not able to reproduce this issue. Also, checked this from import .

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Satya Samir Vijay Siddha Rakesh Roy Hi Jennifer Leugers QA team is not able to reproduce this issue. Also, checked this from import . Thanks, Swapnil P.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All - there is no way this can be resolved by just saying it isn't reproducible. Something caused the server error and you are saying we can't reproduce it?

            Show
            jennifer.leugers Jennifer Leugers added a comment - All - there is no way this can be resolved by just saying it isn't reproducible. Something caused the server error and you are saying we can't reproduce it?
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All - need a response.

            Show
            jennifer.leugers Jennifer Leugers added a comment - All - need a response.
            Hide
            satyap Satya added a comment -

            Hi Sheetal,

            UHC is asking for list of 17 employees corrected for this. Also is there any other character causing this issue?

            Regards,
            Satya Prakash

            Cc: Swapnil Pandhare Rakesh Roy

            Show
            satyap Satya added a comment - Hi Sheetal, UHC is asking for list of 17 employees corrected for this. Also is there any other character causing this issue? Regards, Satya Prakash Cc: Swapnil Pandhare Rakesh Roy
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - - edited

            Hi Rakesh Roy,

            Please re verify this issue through import.
            As per Rashmita's comment,it is allowing "^" character and said it is non repoducible.

            Also check for any other special character.
            CC:Hrishikesh DeshpandeSwapnil PandhareSatya
            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - - edited Hi Rakesh Roy , Please re verify this issue through import. As per Rashmita's comment,it is allowing "^" character and said it is non repoducible. Also check for any other special character. CC: Hrishikesh Deshpande Swapnil Pandhare Satya Thanks, Sheetal Bodhale
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Jennifer Leugers,

            Please find attached corrected employee list. UtahValleyCorrectedEmployeeList.xls
            CC:SatyaSwapnil PandhareVijayendra ShindeRakesh Roy

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Jennifer Leugers , Please find attached corrected employee list. UtahValleyCorrectedEmployeeList.xls CC: Satya Swapnil Pandhare Vijayendra Shinde Rakesh Roy Thanks, Sheetal Bodhale
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have done data correction of attached employees. Now there is no any error on confirmation statement.
            We are testing as possible as scenarios to reproduce this issue. We will get back to you with our testing status.

            Meantime you can check that Server error on confirmation is fixed.

            Let me know in case you need any information on this or also please share your input if any.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Jennifer Leugers , We have done data correction of attached employees. Now there is no any error on confirmation statement. We are testing as possible as scenarios to reproduce this issue. We will get back to you with our testing status. Meantime you can check that Server error on confirmation is fixed. Let me know in case you need any information on this or also please share your input if any. Thanks, Hrishikesh.
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Satya,

            We have tried below scenarios to repro this issue but is is not reproducing and working as expected on our end.

            1. Tested through UI - Removed Beneficiary SSN and tried to add ^ - It throws validation and can not add ^ in SSN.
            2. Tested through Import.
            3. Tested various scenarios by removing and adding SSN in various mode, Partner or Employee can not enter ^ in SSN,
            4. Blank SSN can update but its not replace with ^
            5. EE or Partner can not add ssn with XX - like masking.

            Can you let me know if any additional scenarios needs to be add.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Satya , We have tried below scenarios to repro this issue but is is not reproducing and working as expected on our end. Tested through UI - Removed Beneficiary SSN and tried to add ^ - It throws validation and can not add ^ in SSN. Tested through Import. Tested various scenarios by removing and adding SSN in various mode, Partner or Employee can not enter ^ in SSN, Blank SSN can update but its not replace with ^ EE or Partner can not add ssn with XX - like masking. Can you let me know if any additional scenarios needs to be add. Thanks, Hrishikesh.
            Hide
            satyap Satya added a comment -

            Hi Jennifer,

            Development has shared list of 17 employees for which correction was done. UtahValleyCorrectedEmployeeList.xls

            Also find mentioned details for scenarios tried out with QA team.

            Regards,
            Satya Prkash

            Show
            satyap Satya added a comment - Hi Jennifer, Development has shared list of 17 employees for which correction was done. UtahValleyCorrectedEmployeeList.xls Also find mentioned details for scenarios tried out with QA team. Regards, Satya Prkash

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              jennifer.leugers Jennifer Leugers
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: