New Features 2017Project Type: software

New Features 2017

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

Functional - Any company - Partner Login - Functional-Global rates cloning on Company giving server error

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Bug Type:
      Functional
    • Level:
      Partner
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Production Deployment on Hold
    • Issue Importance:
      Q2

      Description

      1. Login as Partner
      2. Select company
      3. Search Employee
      4. Go to benadmin module
      5. Click on Rates
      6. Move Global rate to Company rate

      Actual result : Global rates cloning on Company giving SERVER ERROR
      Expected Result : Global rates cloning on Company should not give SERVER ERROR

        Attachments

        1. Checklist_for_WT_9658.doc
          26 kB
        2. WT_9658_Affected_Files.txt
          0.1 kB
        3. WT-9658.png
          WT-9658.png
          149 kB
        4. WT-9698.png
          WT-9698.png
          116 kB

          Issue Links

          clones

          Bug - A problem which impairs or prevents the functions of the product. NF-1172 UI Refresh-UI-Search Tool is Showing on clone to company

          • Medium - Has the potential to affect progress.
          • Resolution Setting
          is caused by

          New Feature - A new feature of the product, which has yet to be developed. NF-1053 Rates - Listing

          • Medium - Has the potential to affect progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            swapnil.eksambekar Swapnil Eksambekar (Inactive) created issue -
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones NF-1172 [ NF-1172 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Description # Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Click on clone to company

            Actual result : Search Tool is Showing on clone to company
            Expected Result : Search Tool should not Show on clone to company             		# Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Move Global rate to Company rate on clone to company

            Actual result : Search Tool is Showing on clone to company
            Expected Result : Search Tool should not Show on clone to company
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Description # Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Move Global rate to Company rate on clone to company

            Actual result : Search Tool is Showing on clone to company
            Expected Result : Search Tool should not Show on clone to company             		# Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Move Global rate to Company rate

            Actual result : Search Tool is Showing on clone to company
            Expected Result : Search Tool should not Show on clone to company
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Description # Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Move Global rate to Company rate

            Actual result : Search Tool is Showing on clone to company
            Expected Result : Search Tool should not Show on clone to company             		# Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Move Global rate to Company rate

            Actual result : Company giving SERVER ERROR
            Expected Result : Search Tool should not Show on clone to company
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Description # Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Move Global rate to Company rate

            Actual result : Company giving SERVER ERROR
            Expected Result : Search Tool should not Show on clone to company             		# Login as Partner
            # Select company
            # Search Employee
            # Go to benadmin module
            # Click on Rates
            # Move Global rate to Company rate

            Actual result : Global rates cloning on Company giving SERVER ERROR
            Expected Result : Global rates cloning on Company should not give SERVER ERROR
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Link This issue is caused by NF-1053 [ NF-1053 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Summary CLONE - UI Refresh-UI-Global rates cloning on Company giving SERVER ERROR CLONE - UI Refresh-Functional-Global rates cloning on Company giving SERVER ERROR
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Bug Type UI [ 15401 ] Functional [ 15402 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Summary CLONE - UI Refresh-Functional-Global rates cloning on Company giving SERVER ERROR  UI Refresh-Functional-Global rates cloning on Company giving SERVER ERROR
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Link This issue is cloned by NF-1176 [ NF-1176 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Level Partner [ 15802 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Link This issue is cloned by NF-1176 [ NF-1176 ]
            Hide
            Permalink
            mukund.patil Mukund Patil (Inactive) added a comment - - edited

            NF-1174 UI Refresh-Functional-Global rates cloning on Company giving SERVER ERROR

            Steps:
            1) Login as Partner
            2) Select company
            3) Search Employee
            4) Go to benadmin module
            5) Click on Rates
            6) Drag Global rate to Company rate

            Exception:
            The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Rate_subName_GenericEligibilityRules". The conflict occurred in database "UiRefresh_DC_Dev_13553", table "dbo.GenericEligibilityRules", column 'ID'.

            CC: Vijayendra Shinde

            Show
            mukund.patil Mukund Patil (Inactive) added a comment - - edited NF-1174 UI Refresh-Functional-Global rates cloning on Company giving SERVER ERROR Steps: 1) Login as Partner 2) Select company 3) Search Employee 4) Go to benadmin module 5) Click on Rates 6) Drag Global rate to Company rate Exception: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Rate_subName_GenericEligibilityRules". The conflict occurred in database "UiRefresh_DC_Dev_13553", table "dbo.GenericEligibilityRules", column 'ID'. CC: Vijayendra Shinde
            mukund.patil Mukund Patil (Inactive) made changes -
            Assignee Mukund Patil [ mukund.patil ] Jyoti Mayne [ jyoti.mayne ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Summary  UI Refresh-Functional-Global rates cloning on Company giving SERVER ERROR  Functional - Any company - Partner Login - Functional-Global rates cloning on Company giving server error
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Rohit Shete [ rohit.shete ]
            jyoti.mayne Jyoti Mayne made changes -
            Component/s UI Refresh [ 10902 ]
            Key NF-1174 WT-9658
            Project New Features 2017 [ 11000 ] WORKTERRA [ 10000 ]
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Rohit Shete [ rohit.shete ] Shailendra Honrao [ shailendra.honrao ]
            jyoti.mayne Jyoti Mayne made changes -
            Developer Mukund Patil [ mukund.patil ] Shailendra Honrao [ shailendra.honrao ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 51004 [ 51004 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Original Estimate 0h [ 0 ]
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 31/May/17 12:52 PM
            • Time Spent:
              6h
               

              discussion with jyoti,code debug,analysis

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Time Spent 1h [ 3600 ] 7h [ 25200 ]
            Worklog Id 51185 [ 51185 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
            Time Spent 7h [ 25200 ] 6h [ 21600 ]
            Worklog Id 51004 [ 51004 ]
            Worklog Time Spent 1h [ 3600 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 31/May/17 04:21 PM
            • Time Spent:
              0.5h
               

              discussion

            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
            Time Spent 6h [ 21600 ] 6.5h [ 23400 ]
            Worklog Id 51417 [ 51417 ]
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 01/Jun/17 12:33 PM
            • Time Spent:
              2h
               

              discussion,code debugging,analysis

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 6.5h [ 23400 ] 8.5h [ 30600 ]
            Worklog Id 51688 [ 51688 ]
            Permalink
            umesh.kadam Umesh Kadam (Inactive) logged work - 01/Jun/17 04:30 PM
            • Time Spent:
              0.75h
               

              Scenario discussion, Code review and Unit Testing with Shailendra
              Discussion with Amruta

            shailendra.honrao Shailendra Honrao (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)
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Code Review Date 02/Jun/2017
            Code Reviewed By Umesh Kadam [ 15302 ]
            Dev Due Date 02/Jun/2017
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment WT-9658 3C's.txt [ 50390 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment WT_9658_Affected_Files.txt [ 50391 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment WT-9658 3C's.txt [ 50390 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment Checklist_for_WT_9658.doc [ 50392 ]
            Hide
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - - edited

            Please find below 3C's:

            Concern: Cloning from Global Rate to Company shows server error

            Cause: During Cloning global rate to company, GenericEligibilityRulesID was set to be 0(zero) by default
            which gives foreign key conflict error.

            Correction: As discussed with Amruta to fix this issue, we have passed GenericEligibilityRulesID of 'InActive Status Rule' in case of cloning global rate to company .

            Please verify.

            Cc: Jyoti Mayne,Umesh Kadam

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - - edited Please find below 3C's: Concern: Cloning from Global Rate to Company shows server error Cause : During Cloning global rate to company, GenericEligibilityRulesID was set to be 0(zero) by default which gives foreign key conflict error. Correction: As discussed with Amruta to fix this issue, we have passed GenericEligibilityRulesID of 'InActive Status Rule' in case of cloning global rate to company . Please verify. Cc: Jyoti Mayne , Umesh Kadam
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 02/Jun/17 03:11 PM
            • Time Spent:
              2h
               

              coding,unit testing,review,code check in

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 10.5h [ 37800 ]
            Worklog Id 52049 [ 52049 ]
            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)
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Prasad Pise [ prasadp ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Time Spent 10.5h [ 37800 ] 11.25h [ 40500 ]
            Worklog Id 52310 [ 52310 ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Priya Handepatil [ priya.handepatil ]
            priya.handepatil Priya Handepatil (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)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment WT-9698.png [ 50715 ]
            Hide
            Permalink
            priya.handepatil Priya Handepatil (Inactive) added a comment - - edited

            Hi
            I have verified this issue on Azure;
            Verified with Partner login;
            Its still getting re-open
            PFA
            CC:Sachin Hingole Prasad Pise Rakesh Roy
            ErrorID : 0
            ErrorSource : ControllerAppTier.Clone->BenAdminControllerAppTier.Clone->Rate.Clone->Rate.CloneRates
            ErrorMessage: Invalid object name 'SubRatesEligibilityRules'.
            Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - - edited Hi I have verified this issue on Azure; Verified with Partner login; Its still getting re-open PFA CC: Sachin Hingole Prasad Pise Rakesh Roy ErrorID : 0 ErrorSource : ControllerAppTier.Clone->BenAdminControllerAppTier.Clone->Rate.Clone->Rate.CloneRates ErrorMessage: Invalid object name 'SubRatesEligibilityRules'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Assignee Priya Handepatil [ priya.handepatil ] Shailendra Honrao [ shailendra.honrao ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            Permalink
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 06/Jun/17 12:03 PM
            • Time Spent:
              1h
               

              unit testing,discussion with jyoti,

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Time Spent 11.25h [ 40500 ] 12.25h [ 44100 ]
            Worklog Id 52561 [ 52561 ]
            Permalink
            priya.handepatil Priya Handepatil (Inactive) logged work - 06/Jun/17 12:45 PM
            • Time Spent:
              0.75h
               
              <No comment>
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 12.25h [ 44100 ] 13h [ 46800 ]
            Worklog Id 52610 [ 52610 ]
            Hide
            Permalink
            jyoti.mayne Jyoti Mayne added a comment -

            Hi Priya Handepatil,

            This issue is related to Azure. Please assign this to respective team.

            We cross verified on LB and local, rate cloning from global to company has done successfully. No such error message was shown.

            Cc: Satya

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi Priya Handepatil , This issue is related to Azure. Please assign this to respective team. We cross verified on LB and local, rate cloning from global to company has done successfully. No such error message was shown. Cc: Satya
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Priya Handepatil [ priya.handepatil ]
            Hide
            Permalink
            satyap Satya added a comment -

            Ashwin Wankhede: Can we please check database scripts execution on this company?

            Rohan J Khandave: Let's discuss in case it doesn't get fixed after script execution.

            Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Ashwin Wankhede : Can we please check database scripts execution on this company? Rohan J Khandave : Let's discuss in case it doesn't get fixed after script execution. Regards, Satya Prakash
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Ashwin Wankhede Please assign QA once above task is done.

            SatyaPriya Handepatil

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Ashwin Wankhede Please assign QA once above task is done. Satya Priya Handepatil
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Priya Handepatil [ priya.handepatil ] Ashwin Wankhede [ ashwin.wankhede ]
            Hide
            Permalink
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment -

            Hi Rakesh Roy,

            I have not executed any script and checked with Priya Handepatil for issue on HSPL copy.

            The Rates are getting cloned from Global rate to company rate.

            Priya Handepatil, Can you please verify it again .

            Satya

            Show
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment - Hi Rakesh Roy , I have not executed any script and checked with Priya Handepatil for issue on HSPL copy. The Rates are getting cloned from Global rate to company rate. Priya Handepatil , Can you please verify it again . Satya
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Assignee Ashwin Wankhede [ ashwin.wankhede ] Priya Handepatil [ priya.handepatil ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment WT-9658.png [ 53711 ]
            Hide
            Permalink
            priya.handepatil Priya Handepatil (Inactive) added a comment -

            Hi
            Verified this issue
            Its working fine
            PFA
            Sachin Hingole Rakesh Roy Prasad Pise

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Verified this issue Its working fine PFA Sachin Hingole Rakesh Roy Prasad Pise
            Permalink
            priya.handepatil Priya Handepatil (Inactive) logged work - 29/Jun/17 08:52 AM
            • Time Spent:
              25m
               
              <No comment>
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Time Spent 13h [ 46800 ] 13h 25m [ 48300 ]
            Worklog Id 59168 [ 59168 ]
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Key WT-9658 NF-4041
            Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Priya Handepatil [ priya.handepatil ] Sachin Hingole [ sachin.hingole ]
            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: LB QA(10201)Level 1 values: On Hold(10211) 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
            Shailendra Honrao (Inactive) made transition -
            Open In Development
            		33d 4h 45m 1
            Priya Handepatil (Inactive) made transition -
            In LB Testing Reopen in Local
            		19h 9m 1
            Priya Handepatil (Inactive) made transition -
            Reopen in Local In Development
            		23d 2h 51m 1
            Priya Handepatil (Inactive) made transition -
            In Development In LB Testing
            		5d 2h 1m 2
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		201d 8h 3m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            		65d 16h 23m 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            		4m 26s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              swapnil.eksambekar Swapnil Eksambekar (Inactive)
              Developer:
              Shailendra Honrao (Inactive)
              QA:
              Swapnil Eksambekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 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 - 13h 25m
                  13h 25m