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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      LB QA - LB Deployed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 30 -Bugs

      Description

      Used UiRefresh QA Test2 and CAISO for rate cloning

      Steps

      1) Cloned 2017 Anthem Healthy Advantage HDHP Rate from CAISO to UiRefresh QA Test2 Company on Azure
      2) Clicked on Cloned Rate
      3) Edited Start Date
      4) Clicked on Save

      Result : Server Error

      Note: this is only for health plans

      Error Log

      ErrorID : 0
      ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->Rate.Save->Rate.UpdateRate
      ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
      The statement has been terminated.

        Attachments

          Issue Links

            Activity

            aniruddha.dev Aniruddha Dev (Inactive) created issue -
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Field Original Value New Value
            Link This issue is caused by NF-1100 [ NF-1100 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description Used UiRefresh QA Test2 and CAISO for rate cloning

            *Steps*
             
            1) Cloned *2017 Anthem Healthy Advantage HDHP* Rate from CAISO to UiRefresh QA Test2 Company on Azure
            2) Clicked on Cloned Rate
            3) Edited Start Date
            4) Clicked on Save


            *Result* : Server Error

            *Error Log *

            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->Rate.Save->Rate.UpdateRate
            ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
            The statement has been terminated.
            Used UiRefresh QA Test2 and CAISO for rate cloning

            *Steps*
             
            1) Cloned *2017 Anthem Healthy Advantage HDHP* Rate from CAISO to UiRefresh QA Test2 Company on Azure
            2) Clicked on Cloned Rate
            3) Edited Start Date
            4) Clicked on Save


            *Result* : Server Error

            Note: this is only for health plans

            *Error Log *

            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->Rate.Save->Rate.UpdateRate
            ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
            The statement has been terminated.
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Description Used UiRefresh QA Test2 and CAISO for rate cloning

            *Steps*
             
            1) Cloned *2017 Anthem Healthy Advantage HDHP* Rate from CAISO to UiRefresh QA Test2 Company on Azure
            2) Clicked on Cloned Rate
            3) Edited Start Date
            4) Clicked on Save


            *Result* : Server Error

            Note: this is only for health plans

            *Error Log *

            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->Rate.Save->Rate.UpdateRate
            ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
            The statement has been terminated.
            Used UiRefresh QA Test2 and CAISO for rate cloning

            *Steps*
             
            1) Cloned *2017 Anthem Healthy Advantage HDHP* Rate from CAISO to UiRefresh QA Test2 Company on Azure
            2) Clicked on Cloned Rate
            3) Edited Start Date
            4) Clicked on Save


            *Result* : Server Error

            Note: this is only for health plans

            *Error Log*

            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->Rate.Save->Rate.UpdateRate
            ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
            The statement has been terminated.
            rakeshr Rakesh Roy (Inactive) made changes -
            Level Partner [ 15802 ]
            archana.sagare Archana Sagare (Inactive) made changes -
            Assignee Archana Sagare [ archana.sagare ] Abhijeet Khandagale [ abhijeet.khandagale ]
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Assignee Abhijeet Khandagale [ abhijeet.khandagale ] Mukund Patil [ mukund.patil ]
            mukund.patil Mukund Patil (Inactive) made changes -
            Assignee Mukund Patil [ mukund.patil ] Archana Sagare [ archana.sagare ]
            archana.sagare Archana Sagare (Inactive) made changes -
            Assignee Archana Sagare [ archana.sagare ] Mukund Patil [ mukund.patil ]
            Hide
            mukund.patil Mukund Patil (Inactive) added a comment -

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

            Steps: 1) Cloned 2017 Blue View Vision Rate from CAISO to ASML Company on WT-Stage
            2) Clicked on Cloned Rate
            3) Edit Start Date
            4) Clicked on Save
            Result : Server Error
            Note: this is only for health plans

            Show
            mukund.patil Mukund Patil (Inactive) added a comment - NF > Rate Clonning - across company > Getting server error while updating start date for cloned health plan Steps: 1) Cloned 2017 Blue View Vision Rate from CAISO to ASML Company on WT-Stage 2) Clicked on Cloned Rate 3) Edit Start Date 4) Clicked on Save Result : Server Error Note: this is only for health plans
            mukund.patil Mukund Patil (Inactive) made changes -
            Assignee Mukund Patil [ mukund.patil ] Jyoti Mayne [ jyoti.mayne ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Summary NF > Rate Clonning - across company > Getting server error while updating start date for cloned health plan Functional - Any company - Partner Login - Rate Clonning - across company > Getting server error while updating start date for cloned health plan
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Rohit Shete [ rohit.shete ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jyoti.mayne Jyoti Mayne logged work - 29/May/17 11:30 AM
            • Time Spent:
              1h
               

              discussion, code review and unit testing

            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            Hi Prasad Pise,

            Please find below 3C's:

            Concern Functional - Any company - Partner Login - Rate Clonning - across company > Getting server error while updating start date for cloned health plan
            Cause 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.
            Correction We have fixed code for this. Now it working Properly.

            Cc: Satya,Jyoti Mayne,Prasanna Karlekar,Mukund Patil,Aniruddha Dev

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - Hi Prasad Pise , Please find below 3C's: Concern Functional - Any company - Partner Login - Rate Clonning - across company > Getting server error while updating start date for cloned health plan Cause 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. Correction We have fixed code for this. Now it working Properly. Cc: Satya , Jyoti Mayne , Prasanna Karlekar , Mukund Patil , Aniruddha Dev
            rohit.shete Rohit Shete (Inactive) logged work - 29/May/17 11:34 AM
            • Time Spent:
              4h
               

              Analysis and development and issue related discussion with mukund,jyoti,prasana

            rohit.shete Rohit Shete (Inactive) made changes -
            Link This issue relates to WT-9638 [ WT-9638 ]
            Hide
            rohit.shete Rohit Shete (Inactive) added a comment -

            We deploy it on lb after confirmation from Prasanna Karlekar.

            CC: Satya,Jyoti Mayne,Aniruddha Dev,Prasanna Karlekar,Mukund Patil

            Show
            rohit.shete Rohit Shete (Inactive) added a comment - We deploy it on lb after confirmation from Prasanna Karlekar . CC: Satya , Jyoti Mayne , Aniruddha Dev , Prasanna Karlekar , Mukund Patil
            jyoti.mayne Jyoti Mayne made changes -
            Component/s UI Refresh [ 10902 ]
            Key NF-1575 WT-9643
            Project New Features 2017 [ 11000 ] WORKTERRA [ 10000 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Remaining Estimate 20h [ 72000 ]
            Original Estimate 20h [ 72000 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Remaining Estimate 20h [ 72000 ] 16h [ 57600 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 50361 [ 50361 ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Rohit Shete [ rohit.shete ] Shailendra Honrao [ shailendra.honrao ]
            jyoti.mayne Jyoti Mayne made changes -
            Developer Shailendra Honrao [ shailendra.honrao ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Rohit Shete [ rohit.shete ]
            jyoti.mayne Jyoti Mayne made changes -
            Developer Shailendra Honrao [ shailendra.honrao ] Rohit Shete [ rohit.shete ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: On Hold(10207)
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 16h [ 57600 ] 15h [ 54000 ]
            Time Spent 4h [ 14400 ] 5h [ 18000 ]
            Worklog Id 51110 [ 51110 ]
            jyoti.mayne Jyoti Mayne logged work - 31/May/17 03:53 PM
            • Time Spent:
              0.5h
               

              code review and discussion

            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 15h [ 54000 ] 14.5h [ 52200 ]
            Time Spent 5h [ 18000 ] 5.5h [ 19800 ]
            Worklog Id 51413 [ 51413 ]
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 07/Jun/2017
            admin01 admin made changes -
            Sprint WT Sprint 30 -Bugs [ 70 ]
            rohit.shete Rohit Shete (Inactive) logged work - 06/Jun/17 02:54 PM
            • Time Spent:
              0.5h
               

              Discussion with jyoti and prsanna

            rohit.shete Rohit Shete (Inactive) made changes -
            Remaining Estimate 14.5h [ 52200 ] 14h [ 50400 ]
            Time Spent 5.5h [ 19800 ] 6h [ 21600 ]
            Worklog Id 52678 [ 52678 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 07/Jun/2017 08/Jun/2017
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment - - edited

            Hi Rohit Shete,

            WT-9638 got deployed on LB today.

            cc: Satya, Jyoti Mayne, [~parmeshwar.jumbade]

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - - edited Hi Rohit Shete , WT-9638 got deployed on LB today. cc: Satya , Jyoti Mayne , [~parmeshwar.jumbade]
            jyoti.mayne Jyoti Mayne made changes -
            Module Parent values: UI Refresh(14304) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            rohit.shete Rohit Shete (Inactive) made changes -
            Code Reviewed By Jyoti Mayne [ 11910 ]
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Rohit Shete [ rohit.shete ] Aniruddha Dev [ aniruddha.dev ]
            rohit.shete Rohit Shete (Inactive) logged work - 09/Jun/17 01:48 PM
            • Time Spent:
              1h
               

              discussion With prasanna and jyoti and analysis

            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Remaining Estimate 14h [ 50400 ] 13h [ 46800 ]
            Time Spent 6h [ 21600 ] 7h [ 25200 ]
            Worklog Id 54179 [ 54179 ]
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 14/Jun/17 11:20 AM
            • Time Spent:
              2h
               
              <No comment>
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            This fix is verified on Azure and it is working as expected . Fix is moved on production along with another JIRA WT-9638 so marking this as Closed.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - This fix is verified on Azure and it is working as expected . Fix is moved on production along with another JIRA WT-9638 so marking this as Closed.
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Remaining Estimate 13h [ 46800 ] 11h [ 39600 ]
            Time Spent 7h [ 25200 ] 9h [ 32400 ]
            Worklog Id 60113 [ 60113 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            Transition Time In Source Status Execution Times
            Rohit Shete (Inactive) made transition -
            Open In Development
            18d 19h 14m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            14d 4h 10m 1
            Aniruddha Dev (Inactive) made transition -
            In LB Testing Stage Testing
            2d 2h 7m 1
            Aniruddha Dev (Inactive) made transition -
            Stage Testing In Production Testing
            3s 1
            Aniruddha Dev (Inactive) made transition -
            In Production Testing Production Complete
            6m 35s 1
            Aniruddha Dev (Inactive) made transition -
            Production Complete Closed
            31s 1

              People

              Assignee:
              aniruddha.dev Aniruddha Dev (Inactive)
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              Developer:
              Rohit Shete (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 20h
                  20h
                  Remaining:
                  Time Spent - 9h Remaining Estimate - 11h
                  11h
                  Logged:
                  Time Spent - 9h Remaining Estimate - 11h
                  9h