WORKTERRAProject Type: software

WORKTERRA

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

Rate Clonning - across company > Getting server error while updating start date for cloned health plan

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 30 -Bugs

      Description

      Steps: 1) Cloned any health Rate from Across Company.
      2) Clicked on Cloned Rate
      3) Edit Start Date
      4) Clicked on Save
      Result : Server Error
      In this scenario trgUpdBilledRateAndSelfInsuredChanges_Log trigger Getting server error while updating start date for cloned health plan because Sub-query returned more than 1 value.
      If we use 'in' instead of '=' then it works please verify.

      Note: this is only for health plans

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-9643 Functional - Any company - Partner Login - Rate Clonning - across company > Getting server error while updating start date for cloned health plan

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Concern: Getting server error while updating start date for cloned health plan
            Cause: While query execution it was failing due to Sub-query returned more than 1 value.
            Correction: Added In condition instead of equals to (i.e. =) condition

            *Affected Areas: *Health Rates cloning
            Affected File Name: trgUpdBilledRateAndSelfInsuredChanges_Log
            *Tested Scenario: *
            1. Checked save functionality with changing values and without changes in values.
            2. Checked effective date and end date/Termination date on screen after clone rates.
            3. Validate effective date are updated or not into BilledRateChanges_Log and SelfInsuredRateChanges_Log tables.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Concern: Getting server error while updating start date for cloned health plan Cause: While query execution it was failing due to Sub-query returned more than 1 value. Correction: Added In condition instead of equals to (i.e. =) condition *Affected Areas: *Health Rates cloning Affected File Name: trgUpdBilledRateAndSelfInsuredChanges_Log *Tested Scenario: * 1. Checked save functionality with changing values and without changes in values. 2. Checked effective date and end date/Termination date on screen after clone rates. 3. Validate effective date are updated or not into BilledRateChanges_Log and SelfInsuredRateChanges_Log tables.
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited

            Tested this issue on LB on FDU company. Working fine as expected.

            This is ready for Stage

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited Tested this issue on LB on FDU company. Working fine as expected. This is ready for Stage Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this issue on Stage on AFI For Hspl company. Working fine as expected.

            This is ready for Production

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this issue on Stage on AFI For Hspl company. Working fine as expected. This is ready for Production Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this issue on Production on AFI For Hspl company. Working fine as expected.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this issue on Production on AFI For Hspl company. Working fine as expected.

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              rohit.shete Rohit Shete (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 12.5h
                  12.5h