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

Format paycheck: getting server error when try deleting paycheck line item

    Details

    • Type: Bug
    • Status: In Development
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Stage
    • Bug Severity:
      Low
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Item State:
      Development - On Hold

      Description

      Steps to reproduced :
      1]Added Paycheck line item valued on format paycheck page.
      2]Import Paycheck information.
      3]GO the format paycheck page and try to delete one of line item instead of showing valid message it is throwing server error

      below is error log:

      ErrorID : 0
      ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->EmployeeViewPaycheck.deleteFormatPaycheck
      ErrorMessage: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Employee_Paycheck_History_LiineItemID". The conflict occurred in database "LONGBuildingTechnologies_HSPL_12790", table "dbo.PaycheckLineItems", column 'ID'.
      The statement has been terminated.
      StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Delete(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.Delete(Int32 intProjectsId, String strInput)
      TargetSite: System.String Delete(ValueObjects.BenAdminControllerWebTierEntity

        Attachments

        1. ServerError_STAGE.jpg
          133 kB
          Prasad Pise
        2. WT-6985_OK.jpg
          65 kB
          Prasad Pise

          Activity

          Show
          rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Jaideep Vinchurkar , Swapnil Pandhare , Hrishikesh Deshpande , Rakesh Roy
          Hide
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          Sheetal Bodhale, Please update 3'c and assign back to me for testing.

          Thanks.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Sheetal Bodhale , Please update 3'c and assign back to me for testing. Thanks.
          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi Hrishikesh Deshpande,

          Please find below 3C's of the issue,
          Concern:getting server error while deleting paycheck line item
          Cause: Condition is not handled for used line item so it is giving server error of reference key.
          Correction: Condition is handled to check line item is already in use. Now it will show error message while deleting the line item

          Please verify and let me know.

          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Hrishikesh Deshpande , Please find below 3C's of the issue, Concern:getting server error while deleting paycheck line item Cause: Condition is not handled for used line item so it is giving server error of reference key. Correction: Condition is handled to check line item is already in use. Now it will show error message while deleting the line item Please verify and let me know. Thanks, Sheetal Bodhale
          Hide
          prasadp Prasad Pise (Inactive) added a comment - - edited

          HI Sheetal Bodhale

          This is working as expected on LB. It shows Alert message for line item already in use.

          Thanks

          Show
          prasadp Prasad Pise (Inactive) added a comment - - edited HI Sheetal Bodhale This is working as expected on LB. It shows Alert message for line item already in use. Thanks Prasad CC: Hrishikesh Deshpande Rakesh Roy Rashmita Dudhe
          Hide
          prasadp Prasad Pise (Inactive) added a comment - - edited

          Hi Sheetal Bodhale

          Server error is getting displayed on STAGE when I try to delete Line Item which in use by employee.

          PFA screenshot.

          Stage-Reopened.
          CC: Hrishikesh DeshpandeRashmita DudheRakesh RoySwapnil Pandhare

          Error Log:
          ErrorID : 0
          ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->EmployeeViewPaycheck.deleteFormatPaycheck
          ErrorMessage: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Employee_Paycheck_History_LiineItemID". The conflict occurred in database "LONGBuildingTechnologies_HSPL_12790", table "dbo.PaycheckLineItems", column 'ID'.
          The statement has been terminated.
          StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Delete(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
          at WORKTERRA.ControllerAppTier.Delete(Int32 intProjectsId, String strInput)
          TargetSite: System.String Delete(ValueObjects.BenAdminControllerWebTierEntity)

          Show
          prasadp Prasad Pise (Inactive) added a comment - - edited Hi Sheetal Bodhale Server error is getting displayed on STAGE when I try to delete Line Item which in use by employee. PFA screenshot. Stage-Reopened. CC: Hrishikesh Deshpande Rashmita Dudhe Rakesh Roy Swapnil Pandhare Error Log: ErrorID : 0 ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->EmployeeViewPaycheck.deleteFormatPaycheck ErrorMessage: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Employee_Paycheck_History_LiineItemID". The conflict occurred in database "LONGBuildingTechnologies_HSPL_12790", table "dbo.PaycheckLineItems", column 'ID'. The statement has been terminated. StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Delete(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Delete(Int32 intProjectsId, String strInput) TargetSite: System.String Delete(ValueObjects.BenAdminControllerWebTierEntity)
          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          We will plan this as per bandwidth.
          CC:Gaurav SodaniSatya

          Thanks,
          Sheetal B.

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - We will plan this as per bandwidth. CC: Gaurav Sodani Satya Thanks, Sheetal B.

            People

            Assignee:
            Unassigned
            Reporter:
            rashmita.dudhe Rashmita Dudhe (Inactive)
            Developer:
            Sheetal Bodhale (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 10h
                10h
                Remaining:
                Time Spent - 9.1h Remaining Estimate - 0.9h
                0.9h
                Logged:
                Time Spent - 9.1h Remaining Estimate - 0.9h
                9.1h