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 ]
            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)
            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)
            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)
            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)
            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)
            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)
            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)
            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 ]
            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 ]
            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 ]

              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