Details

    • Environment:
      Production
    • Categories:
      Import
    • Company:
      City of Irvine
    • Reported by:
      Client

      Description

      Per client;
      Each time I search for employee Cristina Zamora in Workterra, and click on her name, I receive an error message that states “Server encountered an internal error. Please contact your administrator.” This does not occur when searching for other employees. Can you take a look at this for me, please?

      I told the client that I have seen this error before and was told that it was a payroll error. So I asked her to reload the payroll info but she is getting an error because the employee already exists in the system. Please advise.

        Attachments

          Issue Links

            Activity

            darryn.carter darryn.carter created issue -
            darryn.carter darryn.carter made changes -
            Field Original Value New Value
            Link This issue relates to CT-4456 [ CT-4456 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Satya [ ID10004 ] Swapnil Pandhare [ swapnil.pandhare ]
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 21/Mar/18 05:54 AM
            • Time Spent:
              3h
               
              <No comment>
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            Hi Ganesh Sadawarte,

            City of irvine reported that server error is shown while populating 1 of the employee records.
            We have analyzed this issue.
            Below are the details :
            Concern : Server error on employee dashboard from partner login.
            Cause : On 19th and 20th march, demographic files got imported. Entries got inserted into employee table. Payroll table entries are missing for reported employee. We have scanned this company and found that there are 4 such employees.
            Below are the employees :
            1. CRISTINA ZAMORA
            2. KAREN BICSKEI
            3. BRETT SMITH
            4. MADALYNE HANDY

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

            Please let me know if further details needed.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Ganesh Sadawarte , City of irvine reported that server error is shown while populating 1 of the employee records. We have analyzed this issue. Below are the details : Concern : Server error on employee dashboard from partner login. Cause : On 19th and 20th march, demographic files got imported. Entries got inserted into employee table. Payroll table entries are missing for reported employee. We have scanned this company and found that there are 4 such employees. Below are the employees : 1. CRISTINA ZAMORA 2. KAREN BICSKEI 3. BRETT SMITH 4. MADALYNE HANDY Correction : We need to insert payroll entries for 4 employees from scanned list and execute back end routines after that. Please let me know if further details needed. Thanks, Swapnil P.
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Ganesh Sadawarte [ ganesh.sadawarte ]
            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 21/Mar/18 07:06 AM
            • Time Spent:
              2.5h
               

              Analysis

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2.5h [ 9000 ]
            Worklog Id 109168 [ 109168 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Link This issue is duplicated by WB-583 [ WB-583 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Link This issue is duplicated by WB-583 [ WB-583 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Comment [ This issue is similar to WB-583 of Parkview company. ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Attachment Field Mapping.png [ 74996 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 21/Mar/18 12:57 PM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited

            Hi darryn.carter,

            Please find below 3C's.

            Concern: Server error on employee dashboard due to payroll information was not inserted into system.

            Cause: We have checked and found that education fields are mapped on _Employee_data_initial_load-NewHires template, which cause import failure. This similar to WB-583.

            Correction: We have load failed 4 employees after made following template customization changes.
            1) On import file education fields does not have any values, so we have removed those field mapping and load file.
            2) We have taken up backup of this template with name 'BKP_Employee_data_initial_load-NewHires' before made any customization changes.
            3) Code changes needed to fix this issue.

            Code changes will be deployed under WB-583.

            Please check and let us know if you face any issue.

            CC-Satya,Vinayak Kulkarni,Suraj Sokasane

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - - edited Hi darryn.carter , Please find below 3C's. Concern : Server error on employee dashboard due to payroll information was not inserted into system. Cause : We have checked and found that education fields are mapped on _Employee_data_initial_load-NewHires template, which cause import failure. This similar to WB-583 . Correction : We have load failed 4 employees after made following template customization changes. 1) On import file education fields does not have any values, so we have removed those field mapping and load file. 2) We have taken up backup of this template with name ' BKP_Employee_data_initial_load-NewHires ' before made any customization changes. 3) Code changes needed to fix this issue. Code changes will be deployed under WB-583 . Please check and let us know if you face any issue. CC- Satya , Vinayak Kulkarni , Suraj Sokasane Thanks, Ganesh
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Time Spent 2.5h [ 9000 ] 4.5h [ 16200 ]
            Worklog Id 109296 [ 109296 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Link This issue relates to WB-583 [ WB-583 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] darryn.carter [ darryn.carter ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 66774 ] 2203 WB: Bugs Project Management Workflow [ 67050 ]
            Hide
            darryn.carter darryn.carter added a comment -

            No issues reported
            Thank you

            Show
            darryn.carter darryn.carter added a comment - No issues reported Thank you
            darryn.carter darryn.carter made changes -
            Assignee darryn.carter [ darryn.carter ] Ganesh Sadawarte [ ganesh.sadawarte ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 4.5h [ 16200 ] 7.5h [ 27000 ]
            Worklog Id 110332 [ 110332 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 2203 WB: Bugs Project Management Workflow [ 67050 ] 0604 Issues Management Workflow [ 68250 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: Platform(18563)Level 1 values: Inaccessible(18567) Parent values: Import(18506)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status In Development [ 10007 ] Development on Hold [ 11608 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Development on Hold [ 11608 ] In Development [ 10007 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status In Development [ 10007 ] In Analysis [ 10008 ]
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Hi darryn.carter,

            This code fix of this issue is deployed on production under WB-583. Please check and close this if everything working properly.

            As we removed mapping of education field from template, if needed please map those field again you can refer 'BKP_Employee_data_initial_load-NewHires' template.

            Thanks,
            Ganesh

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi darryn.carter , This code fix of this issue is deployed on production under WB-583 . Please check and close this if everything working properly. As we removed mapping of education field from template, if needed please map those field again you can refer ' BKP_Employee_data_initial_load-NewHires ' template. Thanks, Ganesh
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] darryn.carter [ darryn.carter ]
            Status In Analysis [ 10008 ] Waiting for Input [ 11502 ]
            darryn.carter darryn.carter made changes -
            Status Waiting for Input [ 11502 ] In Analysis [ 10008 ]
            darryn.carter darryn.carter made changes -
            Resolution Bug Fixed [ 10402 ]
            Status In Analysis [ 10008 ] Rejected [ 10004 ]
            darryn.carter darryn.carter made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Labels ServerError_invalid_Inputs
            Transition Time In Source Status Execution Times
            Ganesh Sadawarte (Inactive) made transition -
            Open In Development
            7h 41m 1
            Ganesh Sadawarte (Inactive) made transition -
            In Development Development on Hold
            32d 21h 59m 1
            Ganesh Sadawarte (Inactive) made transition -
            Development on Hold In Development
            7s 1
            Ganesh Sadawarte (Inactive) made transition -
            In Development In Analysis
            4s 1
            Ganesh Sadawarte (Inactive) made transition -
            In Analysis Waiting for Input
            4m 39s 1
            darryn.carter made transition -
            Waiting for Input In Analysis
            3h 24m 1
            darryn.carter made transition -
            In Analysis Rejected
            1m 12s 1
            darryn.carter made transition -
            Rejected Closed
            6s 1

              People

              Assignee:
              darryn.carter darryn.carter
              Reporter:
              darryn.carter darryn.carter
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 7.5h
                  7.5h