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

County of Sutter: Server error on SA utility. Can't delete test employees

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Support Task Type:
      Delete Request
    • Environment:
      Stage
    • Reported by:
      Client
    • Module:
      BenAdmin
    • Severity:
      Simple

      Description

      Forwarded email to EDI mail box.

      Message from Client:
      We’re trying to delete all the employees (there are supposedly no dependents, enrollments or QEs according to the SA Utility) in Stage for County of Sutter, but when any of us try to use the SA Utility to do it. We get an error like the following:

      Is this something you can fix or delete in some other way? We’re trying to load live data later today so we can submit the form to move them to live tomorrow.

      Thanks,

      Scott DeRousse | AVP, IT Engineering
      ph: 412.446.4609 | fax: 412.276.6650| Cell: 412.508.9655
      sderousse@benxcel.com

        Attachments

          Activity

          Monika.Demla Monika Demla (Inactive) created issue -
          Monika.Demla Monika Demla (Inactive) made changes -
          Field Original Value New Value
          Due Date 30/Mar/2017
          Resolution Unresolved [ 10200 ]
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          This is URGENT

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - This is URGENT
          Monika.Demla Monika Demla (Inactive) made changes -
          Priority Medium [ 3 ] Highest [ 1 ]
          Monika.Demla Monika Demla (Inactive) made changes -
          Account Executive Debbie Kulling [ dkulling ] Michelle Parker [ michelle.parker ]
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Michelle Parker Please follow up with EDI.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Michelle Parker Please follow up with EDI.
          Monika.Demla Monika Demla (Inactive) made changes -
          Assignee Cindy Wibbing [ cindy.wibbing ] Monika Demla [ monika.demla ]
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Abhay Patil
          This is Urgent from Client. I dont have have SA utility to respond this to. Someone from EDI please get in touch.

          Begin forwarded message:
          From: Scott DeRousse <sderousse@benxcel.com>
          Date: March 31, 2017 at 5:27:52 AM PDT
          To: Susan Zajacs <szajacs@benxcel.com>, Monika Demla <monika.demla@ebsbenefits.com>, Debbie Kulling <debbie.kulling@ebsbenefits.com>, Amit Thorve <amit.thorve@ebsbenefits.com>, Michelle Parker <michelle.parker@ebsbenefits.com>
          Cc: Shelly Bugay <sbugay@benxcel.com>
          Subject: RE: URGENT: THIS HAS NOT BEEN COMPLETED: Can't delete test employees
          This also happened with someone I manually entered this morning, Donna Bremmer. I used SA Toolbox to try to delete her and got an internal server error. Now, she shows up in the SA Toolbox search, but does not show up in County of Sutter’s Employee Search.

          Thanks,

          Scott DeRousse | AVP, IT Engineering
          ph: 412.446.4609 | fax: 412.276.6650| Cell: 412.508.9655
          sderousse@benxcel.com

          Benefit Coordinators Corporation (BCC)
          A SISCO Company
          Two Robinson Plaza, Suite 200 | Pittsburgh, PA 15205
          Follow Us | www.benxcel.com

          CONFIDENTIALITY NOTICE: This correspondence, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or Protected Health Information (PHI). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy all original copies.

          From: Susan Zajacs
          Sent: Friday, March 31, 2017 8:22 AM
          To: Monika Demla <monika.demla@ebsbenefits.com>; Scott DeRousse <sderousse@benxcel.com>; Debbie Kulling <debbie.kulling@ebsbenefits.com>; Amit Thorve <amit.thorve@ebsbenefits.com>; Michelle Parker <michelle.parker@ebsbenefits.com>
          Cc: Susan Zajacs <szajacs@benxcel.com>; Shelly Bugay <sbugay@benxcel.com>
          Subject: RE: URGENT: THIS HAS NOT BEEN COMPLETED: Can't delete test employees

          Something is definitely off. Print Screen #1: “Test” people appear in the SA Utility Toolbox”. However, when you go into Search Employee and search for one of the test people (Example: Add Newborn) they are not listed in the group – See Print Screen #2.

          Susan L. Zajacs | VP, Pittsburgh Operations
          ph: 412.446.4660 | Cell: 412.508.0505
          szajacs@benxcel.com

          Benefit Coordinators Corporation (BCC)
          A SISCO Company
          Two Robinson Plaza, Suite 200 | Pittsburgh, PA 15205
          Follow Us | www.benxcel.com

          CONFIDENTIALITY NOTICE: This correspondence, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or Protected Health Information (PHI). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy all original copies.

          From: Susan Zajacs
          Sent: Friday, March 31, 2017 8:11 AM
          To: Monika Demla <monika.demla@ebsbenefits.com>; Scott DeRousse <sderousse@benxcel.com>; Debbie Kulling <debbie.kulling@ebsbenefits.com>; Amit Thorve <amit.thorve@ebsbenefits.com>; Michelle Parker <michelle.parker@ebsbenefits.com>
          Cc: Susan Zajacs <szajacs@benxcel.com>
          Subject: URGENT: THIS HAS NOT BEEN COMPLETED: Can't delete test employees
          Importance: High

          Monika and Team –

          We are looking to submit the UAT for this client TODAY and the below noted participants have not been deleted. Can these please get deleted ASAP. In addition, we need to understand why we can no longer delete in the SA Toolbox.

          Thank you for your immediate attention to this mater.

          Susan L. Zajacs | VP, Pittsburgh Operations
          ph: 412.446.4660 | Cell: 412.508.0505
          szajacs@benxcel.com

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Abhay Patil This is Urgent from Client. I dont have have SA utility to respond this to. Someone from EDI please get in touch. Begin forwarded message: From: Scott DeRousse <sderousse@benxcel.com> Date: March 31, 2017 at 5:27:52 AM PDT To: Susan Zajacs <szajacs@benxcel.com>, Monika Demla <monika.demla@ebsbenefits.com>, Debbie Kulling <debbie.kulling@ebsbenefits.com>, Amit Thorve <amit.thorve@ebsbenefits.com>, Michelle Parker <michelle.parker@ebsbenefits.com> Cc: Shelly Bugay <sbugay@benxcel.com> Subject: RE: URGENT: THIS HAS NOT BEEN COMPLETED: Can't delete test employees This also happened with someone I manually entered this morning, Donna Bremmer. I used SA Toolbox to try to delete her and got an internal server error. Now, she shows up in the SA Toolbox search, but does not show up in County of Sutter’s Employee Search. Thanks, Scott DeRousse | AVP, IT Engineering ph: 412.446.4609 | fax: 412.276.6650| Cell: 412.508.9655 sderousse@benxcel.com Benefit Coordinators Corporation (BCC) A SISCO Company Two Robinson Plaza, Suite 200 | Pittsburgh, PA 15205 Follow Us | www.benxcel.com CONFIDENTIALITY NOTICE: This correspondence, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or Protected Health Information (PHI). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy all original copies. From: Susan Zajacs Sent: Friday, March 31, 2017 8:22 AM To: Monika Demla <monika.demla@ebsbenefits.com>; Scott DeRousse <sderousse@benxcel.com>; Debbie Kulling <debbie.kulling@ebsbenefits.com>; Amit Thorve <amit.thorve@ebsbenefits.com>; Michelle Parker <michelle.parker@ebsbenefits.com> Cc: Susan Zajacs <szajacs@benxcel.com>; Shelly Bugay <sbugay@benxcel.com> Subject: RE: URGENT: THIS HAS NOT BEEN COMPLETED: Can't delete test employees Something is definitely off. Print Screen #1: “Test” people appear in the SA Utility Toolbox”. However, when you go into Search Employee and search for one of the test people (Example: Add Newborn) they are not listed in the group – See Print Screen #2. Susan L. Zajacs | VP, Pittsburgh Operations ph: 412.446.4660 | Cell: 412.508.0505 szajacs@benxcel.com Benefit Coordinators Corporation (BCC) A SISCO Company Two Robinson Plaza, Suite 200 | Pittsburgh, PA 15205 Follow Us | www.benxcel.com CONFIDENTIALITY NOTICE: This correspondence, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information or Protected Health Information (PHI). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy all original copies. From: Susan Zajacs Sent: Friday, March 31, 2017 8:11 AM To: Monika Demla <monika.demla@ebsbenefits.com>; Scott DeRousse <sderousse@benxcel.com>; Debbie Kulling <debbie.kulling@ebsbenefits.com>; Amit Thorve <amit.thorve@ebsbenefits.com>; Michelle Parker <michelle.parker@ebsbenefits.com> Cc: Susan Zajacs <szajacs@benxcel.com> Subject: URGENT: THIS HAS NOT BEEN COMPLETED: Can't delete test employees Importance: High Monika and Team – We are looking to submit the UAT for this client TODAY and the below noted participants have not been deleted. Can these please get deleted ASAP. In addition, we need to understand why we can no longer delete in the SA Toolbox. Thank you for your immediate attention to this mater. Susan L. Zajacs | VP, Pittsburgh Operations ph: 412.446.4660 | Cell: 412.508.0505 szajacs@benxcel.com
          Monika.Demla Monika Demla (Inactive) made changes -
          Assignee Monika Demla [ monika.demla ] Cindy Wibbing [ cindy.wibbing ]
          Monika.Demla Monika Demla (Inactive) made changes -
          EDI Auditor Amit Thorve [ amitthorve ]
          Monika.Demla Monika Demla (Inactive) made changes -
          Assignee Cindy Wibbing [ cindy.wibbing ] Vijay Siddha [ vijays ]
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Vijay Siddha
          Please assign someone in your Team.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Vijay Siddha Please assign someone in your Team.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Vijay Siddha
          Please advise on this:
          What was the outcome of this. To the best of my knowledge this was never resolved. Can someone please look into this and also why the test people show deleted in the “search employee” but appear in the SA Toolbox as participants that need deleted.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Vijay Siddha Please advise on this: What was the outcome of this. To the best of my knowledge this was never resolved. Can someone please look into this and also why the test people show deleted in the “search employee” but appear in the SA Toolbox as participants that need deleted.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Please provide update Vijay Siddha CC Michelle Parker Kira Hamilton

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Please provide update Vijay Siddha CC Michelle Parker Kira Hamilton
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Vijay Siddha
          Client is* Concern*: Please see mesg below from client.

          Michelle and Kira –

          On or about March 31st, we logged an issue we had in Stage with the ability to delete participant records for the County of Sutter (I have re-attached the original e-mail trail). This group just recently moved to production and we are having the exact same issue. Participant: 566254205 was duplicated in the original file feed sent by the employer and needed deleted. We went into the SA Toolbox, brought his record up, set deletion and received a server error (see attached printscreen). However, when you go to the “search employee” feature of the system – it appears as though the participant is deleted (see attached printscreen). No one ever followed up with us on why this is occurring, what the solution is or how to ensure that we do not continue to have this problem with the County of Sutter. Can you all please log this issue again ASAP so that prior to our group going live into the system next week this issue is closed.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Vijay Siddha Client is* Concern*: Please see mesg below from client. Michelle and Kira – On or about March 31st, we logged an issue we had in Stage with the ability to delete participant records for the County of Sutter (I have re-attached the original e-mail trail). This group just recently moved to production and we are having the exact same issue. Participant: 566254205 was duplicated in the original file feed sent by the employer and needed deleted. We went into the SA Toolbox, brought his record up, set deletion and received a server error (see attached printscreen). However, when you go to the “search employee” feature of the system – it appears as though the participant is deleted (see attached printscreen). No one ever followed up with us on why this is occurring, what the solution is or how to ensure that we do not continue to have this problem with the County of Sutter. Can you all please log this issue again ASAP so that prior to our group going live into the system next week this issue is closed.
          Kira.Hamilton Kira Hamilton (Inactive) made changes -
          Environment Stage [ 10004 ]
          Issue Type Research [ 10709 ] Support Activity [ 10301 ]
          Key EDI-1539 WT-9263
          Project WorkTerraEDI [ 10300 ] WORKTERRA [ 10000 ]
          Status New [ 10508 ] Open [ 1 ]
          Support Task Type Data Correction [ 11203 ]
          Workflow WorkTerraEDI_Simple_ver 2.1 [ 38234 ] WT_Support [ 39632 ]
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Dev,

          Can you please review above comment? It looks like the employee above needs to be removed from WT. Please let me know if you have any questions.

          Debbie Kulling
          Kira Hamilton

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Dev, Can you please review above comment? It looks like the employee above needs to be removed from WT. Please let me know if you have any questions. Debbie Kulling Kira Hamilton
          Monika.Demla Monika Demla (Inactive) made changes -
          Labels Priority
          Monika.Demla Monika Demla (Inactive) made changes -
          Environment Stage [ 10004 ]
          Issue Type Support Activity [ 10301 ] Task [ 3 ]
          Status Open [ 1 ] New Request [ 10029 ]
          Support Task Type Data Correction [ 11203 ]
          Workflow WT_Support [ 39632 ] WT_Features [ 39634 ]
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          I changed this ticket to WT.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - I changed this ticket to WT.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          CC Amit Thorve Thank you so much for your help. Please let me know if you need anything else from me.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - CC Amit Thorve Thank you so much for your help. Please let me know if you need anything else from me.
          michelle.parker Michelle Parker (Inactive) made changes -
          satyap Satya made changes -
          Environment Stage [ 10004 ]
          Issue Type Task [ 3 ] Support Activity [ 10301 ]
          Status New Request [ 10029 ] Open [ 1 ]
          Support Task Type Delete Request [ 14904 ]
          Workflow WT_Features [ 39634 ] WT_Support [ 39681 ]
          satyap Satya made changes -
          Assignee Vijay Siddha [ vijays ] Satya [ ID10004 ]
          Resolution Unresolved [ 10200 ]
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          satyap Satya added a comment -

          Hi Monika,

          The SA Utility error had been resolved in ticket WT-8597. As of now, there is no Server error observed on Employee deletion.

          This fix had been deployed on Production as well. So when this company goes live, there won't be server errors for them.

          All employees of this companies can also be deleted in one instance. There are only 1095 employee count, however there is one JIRA ticket WT-1941 open with development when there is more employee count (about 3000 or above), in that case, SA utility gives timeout error while deleting all of the employees together. This optimization ticket is in development list and will be done by 04/28.

          Can you please check this once? Please let us know in case any difficulty.

          Regards,
          Satya Prakash

          Cc: Vijay Siddha Samir Jaideep Vinchurkar Rakesh Roy

          Show
          satyap Satya added a comment - Hi Monika, The SA Utility error had been resolved in ticket WT-8597 . As of now, there is no Server error observed on Employee deletion. This fix had been deployed on Production as well. So when this company goes live, there won't be server errors for them. All employees of this companies can also be deleted in one instance. There are only 1095 employee count, however there is one JIRA ticket WT-1941 open with development when there is more employee count (about 3000 or above), in that case, SA utility gives timeout error while deleting all of the employees together. This optimization ticket is in development list and will be done by 04/28. Can you please check this once? Please let us know in case any difficulty. Regards, Satya Prakash Cc: Vijay Siddha Samir Jaideep Vinchurkar Rakesh Roy
          satyap Satya made changes -
          Assignee Satya [ ID10004 ] Monika Demla [ monika.demla ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          Transition Time In Source Status Execution Times
          Kira Hamilton (Inactive) made transition -
          NEW Open
          19d 23h 20m 1
          Monika Demla (Inactive) made transition -
          Open New Request
          5m 18s 1
          Satya made transition -
          New Request Open
          15h 47m 1
          Satya made transition -
          Open In Progress
          1m 4s 1
          Satya made transition -
          In Progress Resolved
          10m 37s 1

            People

            Assignee:
            Monika.Demla Monika Demla (Inactive)
            Reporter:
            Monika.Demla Monika Demla (Inactive)
            Account Executive:
            Michelle Parker (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: