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
            rohit.shete Rohit Shete (Inactive) created issue -
            rohit.shete Rohit Shete (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to NF-1575 [ NF-1575 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Prasanna Karlekar [ prasanna ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 29/May/17 07:30 PM
            • Time Spent:
              0.5h
               

              Issue discussion
              Code go through

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 50475 [ 50475 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 05/Jun/17 12:48 PM
            • Time Spent:
              6h
               

              Discussion With Prasanna ma'am
              Reproduced issue on local environment
              Changes to resolve issue
              Unit testing

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 0.5h [ 1800 ] 6.5h [ 23400 ]
            Worklog Id 52295 [ 52295 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 06/Jun/2017
            Sprint WT Sprint 30 -Bugs [ 70 ]
            Original Estimate 0h [ 0 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 05/Jun/17 09:00 PM
            • Time Spent:
              1h
               

              Issue repro, discussion on steps to repro
              Scenarios to be unit tested.

            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.
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 07/Jun/2017
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 07/Jun/17 10:00 PM
            • Time Spent:
              0.75h
               

              Scenario discussion and Code review for Rate cloning

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 09/Jun/17 11:57 AM
            • Time Spent:
              1h
               

              Testing on WT

            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
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 7.5h [ 27000 ]
            Worklog Id 53716 [ 53716 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Developer Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 12/Jun/17 12:24 PM
            • Time Spent:
              1h
               

              Testing on stage

            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
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 8.5h [ 30600 ]
            Worklog Id 54102 [ 54102 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 12/Jun/17 12:44 PM
            • Time Spent:
              0.25h
               

              Code merge into stage code branch and check-in

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 8.75h [ 31500 ]
            Worklog Id 54131 [ 54131 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 13/Jun/17 12:38 PM
            • Time Spent:
              0.25h
               

              Code check-in into production branch

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 8.75h [ 31500 ] 9h [ 32400 ]
            Worklog Id 54613 [ 54613 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 9h [ 32400 ] 10.5h [ 37800 ]
            Worklog Id 55175 [ 55175 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Link This issue is blocked by WT-9836 [ WT-9836 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Link This issue is blocked by WT-9836 [ WT-9836 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Comment [ Cannot test until linked ticket is resolved ]
            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.
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 10.5h [ 37800 ] 10.75h [ 38700 ]
            Worklog Id 55175 [ 55175 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 10.75h [ 38700 ] 11.75h [ 42300 ]
            Worklog Id 55316 [ 55316 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 15/Jun/17 06:43 PM - edited
            • Time Spent:
              1.75h
               

              Testing on Production

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 11.75h [ 42300 ] 12.5h [ 45000 ]
            Worklog Id 56609 [ 56609 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            		7d 1h 12m 1
            Venkatesh Pujari (Inactive) made transition -
            In Development In LB Testing
            		3d 22h 12m 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            		2d 23h 27m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            		1d 19h 18m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		1d 1h 11m 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		2s 1

              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