Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-598

Parkview - System Errors on EE records

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Environment:
      Production
    • Categories:
      Platform
    • Company:
      Parkview Medical Center
    • Reported by:
      Client

      Description

      When trying to open the employee records of Carol Spence and Stephanie Humphrey the client is getting the below error message and cannot access the records:

      apxCorruptData Error due to corrupt data due to failed import.

        Attachments

          Issue Links

            Activity

            amarra Ashley Marra (Inactive) created issue -
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            Adding Brandi Atencio to this list. She is unable to enroll as she is receiving this same error.

            Show
            amarra Ashley Marra (Inactive) added a comment - Adding Brandi Atencio to this list. She is unable to enroll as she is receiving this same error.
            amarra Ashley Marra (Inactive) made changes -
            Field Original Value New Value
            Issue Type New UI [ 11106 ] Task [ 3 ]
            Key UI-35 CT-4397
            Project WORKTERRA-UI [ 11504 ] WORKTERRA-CT [ 10800 ]
            Workflow RET: Project Management Workflow [ 66250 ] CT: Task Management Workflow [ 66334 ]
            Hide
            darryn.carter darryn.carter added a comment -

            Hello Ashley
            I see this Jira is assigned to Jennifer Leugers, I Partnered this Jira with Dev as well

            Show
            darryn.carter darryn.carter added a comment - Hello Ashley I see this Jira is assigned to Jennifer Leugers, I Partnered this Jira with Dev as well
            darryn.carter darryn.carter made changes -
            Link This issue relates to WB-585 [ WB-585 ]
            darryn.carter darryn.carter made changes -
            BA’s Darryn Carter [ 14205 ]
            Ticket is With With Dev [ 15103 ]
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            darryn.carter There are two more having this issue.

            Felicia Perez

            Show
            amarra Ashley Marra (Inactive) added a comment - darryn.carter There are two more having this issue. Felicia Perez
            jennifer.leugers Jennifer Leugers made changes -
            Categories Parent values: Platform(18563)
            Issue Type Task [ 3 ] Bug [ 1 ]
            Key CT-4397 WB-598
            Project WORKTERRA-CT [ 10800 ] Workterra BenAdmin [ 11501 ]
            Status To Do [ 10000 ] Open [ 1 ]
            Workflow CT: Task Management Workflow [ 66334 ] 0803 Copy of WB: Bugs Project Management Workflow [ 66408 ]
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Harshawardhan Phalake [ harshawardhan ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Assignee Harshawardhan Phalake [ harshawardhan ] Swapnil Pandhare [ swapnil.pandhare ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Link This issue duplicates WB-585 [ WB-585 ]
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            There is another employee seeing this error: Karen Johnson

            Please let me know when this can be resolved as this client's employees have not been able to enroll all week.

            Show
            amarra Ashley Marra (Inactive) added a comment - There is another employee seeing this error: Karen Johnson Please let me know when this can be resolved as this client's employees have not been able to enroll all week.
            darryn.carter darryn.carter made changes -
            Attachment screenshot-1.png [ 74693 ]
            Hide
            darryn.carter darryn.carter added a comment -

            Hello Ashley

            Cause : On 6th and 13th march demographic files got imported. Entries got inserted into employee table. Payroll table entries are missing for reported employees. We have scanned this company and found that there are 24 such employees. PFA employee list.
            This error is occurred because payroll information is not added through import for attached list of EE's

            Correction : We need to insert payroll entries for 24 employees from scanned list and execute back end routines after that.

            We need to add payroll information for these employee's. Could you please load latest payroll data for these employee's or you can provide it to us. so that we will import it.

            Dev will update you on the root cause of why payroll information not added through import.

            Show
            darryn.carter darryn.carter added a comment - Hello Ashley Cause : On 6th and 13th march demographic files got imported. Entries got inserted into employee table. Payroll table entries are missing for reported employees. We have scanned this company and found that there are 24 such employees. PFA employee list. This error is occurred because payroll information is not added through import for attached list of EE's Correction : We need to insert payroll entries for 24 employees from scanned list and execute back end routines after that. We need to add payroll information for these employee's. Could you please load latest payroll data for these employee's or you can provide it to us. so that we will import it. Dev will update you on the root cause of why payroll information not added through import.
            darryn.carter darryn.carter made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Ashley Marra [ amarra ]
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            darryn.carter Thank you for this info.

            Cindy Wibbing Can you please reload files from 3/13 and 3/6?

            Per the client:
            The first 4 people on the list terminated years ago, so we don’t need to do anything with their records. The rest of the people on the list were on our 500 files submitted on 3/13/18 and 3/6/18 with their annual salaries included in the last column of the spreadsheet. If you need me to re-submit those 500 files on your FTP site or if you need additional information to fix those records, let me know.

            Show
            amarra Ashley Marra (Inactive) added a comment - darryn.carter Thank you for this info. Cindy Wibbing Can you please reload files from 3/13 and 3/6? Per the client: The first 4 people on the list terminated years ago, so we don’t need to do anything with their records. The rest of the people on the list were on our 500 files submitted on 3/13/18 and 3/6/18 with their annual salaries included in the last column of the spreadsheet. If you need me to re-submit those 500 files on your FTP site or if you need additional information to fix those records, let me know.
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            Cindy Wibbing Hey Cindy, any chance you can load these files so that the employees can access to the system? Per the above, the salary info wasnt loaded. Thanks!

            Show
            amarra Ashley Marra (Inactive) added a comment - Cindy Wibbing Hey Cindy, any chance you can load these files so that the employees can access to the system? Per the above, the salary info wasnt loaded. Thanks!
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Hi Ashley Marra
            I loaded their information yesterday.
            Thanks!
            Cindy

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Hi Ashley Marra I loaded their information yesterday. Thanks! Cindy
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            Cindy Wibbing For both weeks? Thanks!

            Show
            amarra Ashley Marra (Inactive) added a comment - Cindy Wibbing For both weeks? Thanks!
            Hide
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

            Hi Ashley Marra
            I pulled the employees listed from both weeks.
            Thanks,
            Cindy

            Show
            Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Hi Ashley Marra I pulled the employees listed from both weeks. Thanks, Cindy
            darryn.carter darryn.carter made changes -
            Attachment Employee_Not_Have_Payroll (1).zip [ 74919 ]
            Hide
            darryn.carter darryn.carter added a comment -

            Up Date from Dev Ticket
            This error is occurred because payroll information is not added through import Employee_Not_Have_Payroll (1).zip . We need to add payroll information for these employee's. Could you please load latest payroll data for these employee's or you can provide it to us. so that we will import it.

            We will update you on the root cause of why payroll information not added through import.

            Following up on above comments, Do you have employee payroll information for the attached?. That need to load to avoid error for these employees

            Show
            darryn.carter darryn.carter added a comment - Up Date from Dev Ticket This error is occurred because payroll information is not added through import Employee_Not_Have_Payroll (1).zip . We need to add payroll information for these employee's. Could you please load latest payroll data for these employee's or you can provide it to us. so that we will import it. We will update you on the root cause of why payroll information not added through import. Following up on above comments, Do you have employee payroll information for the attached?. That need to load to avoid error for these employees
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            darryn.carter This has been corrected. Cindy loaded the last file and it corrected the payroll info

            Show
            amarra Ashley Marra (Inactive) added a comment - darryn.carter This has been corrected. Cindy loaded the last file and it corrected the payroll info
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 66408 ] 2203 WB: Bugs Project Management Workflow [ 66923 ]
            Hide
            darryn.carter darryn.carter added a comment -

            Up date from Dev Team
            Dev Has checked cause of employee payroll was not added through import and found import got failed due to this employee payroll information was not added in system. Please refer WB-583 IN DEVELOPMENT JIRA, which we have update details and code fix will move under WB-583 IN DEVELOPMENT .

            Show
            darryn.carter darryn.carter added a comment - Up date from Dev Team Dev Has checked cause of employee payroll was not added through import and found import got failed due to this employee payroll information was not added in system. Please refer WB-583 IN DEVELOPMENT JIRA, which we have update details and code fix will move under WB-583 IN DEVELOPMENT .
            darryn.carter darryn.carter made changes -
            Link This issue relates to WB-583 [ WB-583 ]
            Hide
            amarra Ashley Marra (Inactive) added a comment -

            darryn.carter We can close this.

            Show
            amarra Ashley Marra (Inactive) added a comment - darryn.carter We can close this.
            darryn.carter darryn.carter made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            darryn.carter darryn.carter made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            darryn.carter darryn.carter made changes -
            Status Local Testing [ 10200 ] Pre-prod Testing [ 11500 ]
            darryn.carter darryn.carter made changes -
            Status Pre-prod Testing [ 11500 ] Production Testing [ 10202 ]
            darryn.carter darryn.carter made changes -
            Resolution Unresolved [ 10200 ]
            Status Production Testing [ 10202 ] Production Review [ 11501 ]
            darryn.carter darryn.carter made changes -
            Status Production Review [ 11501 ] Closed [ 6 ]
            abhay.patil Abhay Patil (Inactive) made changes -
            Description When trying to open the employee records of Carol Spence and Stephanie Humphrey the client is getting the below error message and cannot access the records:

             !image-2018-03-12-11-57-27-396.png|thumbnail!
            When trying to open the employee records of Carol Spence and Stephanie Humphrey the client is getting the below error message and cannot access the records:

            !image-2018-03-12-11-57-27-396.png|thumbnail!

            apxCorruptData Error due to corrupt data due to failed import.
            abhay.patil Abhay Patil (Inactive) made changes -
            Comment [ apxCorruptData Error due to corrupt data due to failed import. ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 2203 WB: Bugs Project Management Workflow [ 66923 ] 0604 Issues Management Workflow [ 68397 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Done [ 10000 ]
            Status Closed [ 6 ] Resolution Setting [ 11616 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Resolution Setting [ 11616 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Jennifer Leugers made transition -
            To Do Open
            1d 23h 52m 1
            darryn.carter made transition -
            Open In Development
            12d 20h 46m 1
            darryn.carter made transition -
            In Development In LB Testing
            19s 1
            darryn.carter made transition -
            In LB Testing IN Pre-prod Testing
            7s 1
            darryn.carter made transition -
            IN Pre-prod Testing In Production Testing
            10s 1
            darryn.carter made transition -
            In Production Testing In Production Review
            7s 1
            darryn.carter made transition -
            In Production Review Closed
            3s 1
            Prashant Samal (Inactive) made transition -
            Closed Resolution Setting
            71d 10h 34m 1
            Prashant Samal (Inactive) made transition -
            Resolution Setting Closed
            42m 22s 1

              People

              Assignee:
              amarra Ashley Marra (Inactive)
              Reporter:
              amarra Ashley Marra (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: