New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5459

Pre-Prod: ADD/change plan design>> delete plan "PreProd test" on MATT

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Pre Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin
    • Reported by:
      Harbinger
    • Company:
      MATT
    • Item State:
      Stage QA - Production Deployment on Hold

      Description

      Unable to delete plan "PreProd test" on MATT getting below server error.

      ErrorID : 0
      ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->BenefitPlanDesign.Delete->BenefitPlanDesign.DeleteBenefitPlanDesign
      ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_ContingentEligibilityRules_PlanDesign". The conflict occurred in database "MATT_11878", table "dbo.ContingentEligibilityRules", column 'PlanDesignID'.
      The statement has been terminated.

      ------------------------------------------------------------------
      CC: Mandar Kulkarni, Satya, Prasad Patil, Rakesh Roy

        Attachments

          Issue Links

          relates to

          Support Activity - Support Activity NF-5195 Preprod build deployment

          • Medium - Has the potential to affect progress.
          • Open

            Activity

            Ascending order - Click to sort in descending order
            sumeet.kolge Sumeet.Kolge (Inactive) created issue -
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Field Original Value New Value
            Description Unable to delete plan "PreProd test" on MATT getting below server error.

            ErrorID : 0
            ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->BenefitPlanDesign.Delete->BenefitPlanDesign.DeleteBenefitPlanDesign
            ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_ContingentEligibilityRules_PlanDesign". The conflict occurred in database "MATT_11878", table "dbo.ContingentEligibilityRules", column 'PlanDesignID'.
            The statement has been terminated.             		Unable to delete plan "PreProd test" on MATT getting below server error.

            ErrorID : 0
            ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->BenefitPlanDesign.Delete->BenefitPlanDesign.DeleteBenefitPlanDesign
            ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_ContingentEligibilityRules_PlanDesign". The conflict occurred in database "MATT_11878", table "dbo.ContingentEligibilityRules", column 'PlanDesignID'.
            The statement has been terminated.

            ------------------------------------------------------------------
            CC: [~mandark], [~satyap], [~prasad.patil], [~rakeshr]
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Link This issue relates to NF-5195 [ NF-5195 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Vijayendra Shinde [ ID10506 ]
            mukund.patil Mukund Patil (Inactive) made changes -
            Assignee Vijayendra Shinde [ ID10506 ] Mukund Patil [ mukund.patil ]
            mukund.patil Mukund Patil (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            mukund.patil Mukund Patil (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            Permalink
            mukund.patil Mukund Patil (Inactive) logged work - 12/Dec/17 05:38 PM
            • Time Spent:
              7h
               
              • Issue analysis on local and pre-prod
              • Discussion with pratap and vijayendra sir
              • Verified script on pre-prod with pratap
              • Debugging
              • script preparation
              • Issue fixing
              • Unit Testing
            Hide
            Permalink
            mukund.patil Mukund Patil (Inactive) added a comment -

            Hi Sumeet.Kolge

            NF-5459 Issue resolved. Please verify after next build.

            Thanks,
            Mukund P

            Show
            mukund.patil Mukund Patil (Inactive) added a comment - Hi Sumeet.Kolge NF-5459 Issue resolved. Please verify after next build. Thanks, Mukund P
            mukund.patil Mukund Patil (Inactive) made changes -
            Code Reviewed By Vijayendra Shinde [ 11901 ]
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            mukund.patil Mukund Patil (Inactive) made changes -
            Assignee Mukund Patil [ mukund.patil ] Sumeet.Kolge [ sumeet.kolge ]
            Permalink
            mukund.patil Mukund Patil (Inactive) logged work - 13/Dec/17 05:44 PM
            • Time Spent:
              0.5h
               
              • Issue verified on codemap
            mukund.patil Mukund Patil (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 7h [ 25200 ]
            Worklog Id 96252 [ 96252 ]
            mukund.patil Mukund Patil (Inactive) made changes -
            Time Spent 7h [ 25200 ] 7.5h [ 27000 ]
            Worklog Id 96254 [ 96254 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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)
            sanjana.jadhav Sanjana Jadhav (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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment NF-5459.png [ 70470 ]
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 20/Dec/17 09:05 AM
            • Time Spent:
              20m
               

              Verified on codemap

            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on codemap.
            benefit plan design deleted successfully.
            PFA,

            Working properly.
            Ready for pre production.

            Thanks,
            Sanjana Jadhav

            CC: Prasad Pise Sachin Hingole Rakesh Roy

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on codemap. benefit plan design deleted successfully. PFA, Working properly. Ready for pre production. Thanks, Sanjana Jadhav CC: Prasad Pise Sachin Hingole Rakesh Roy
            sanjana.jadhav Sanjana Jadhav (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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 7h 50m [ 28200 ]
            Worklog Id 97097 [ 97097 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Assignee Sumeet.Kolge [ sumeet.kolge ] Sachin Hingole [ sachin.hingole ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Transition Time In Source Status Execution Times
            Mukund Patil (Inactive) made transition -
            Open In Development
            		14h 44m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		6d 4h 40m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		11d 1h 28m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            		83d 20h 56m 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            		4m 28s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              sumeet.kolge Sumeet.Kolge (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 7h 50m
                  7h 50m