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

Azure >> UIRefresh QA Test1 >> Incomplete Tours >> Incorrect values displayed in 'Percentage Complete' column.

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: OnBoard
    • Labels:
      None
    • Bug Type:
      Functional
    • Level:
      Partner
    • Module:
      OnBoard
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Q2
    • Browser:
      IE 11
    • Sprint:
      WT Sprint 31-Bugs

      Description

      This issue is observed in Partner login : qatesting / Password@3

      on 'Incomplete Tours' report, in column 'Percentage Complete', value '#Error' is displayed for some of the records. PFA screen shot.

        Attachments

          Issue Links

            Activity

            rajendraj Rajendra Joshi (Inactive) created issue -
            rajendraj Rajendra Joshi (Inactive) made changes -
            Field Original Value New Value
            Link This issue is caused by NF-1368 [ NF-1368 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Assignee Swapnil Eksambekar [ swapnil.eksambekar ] Rajendra Joshi [ rajendraj ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Assignee Rajendra Joshi [ rajendraj ] Harshada Borole [ harshada.borole ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) logged work - 25/May/17 11:26 AM
            • Time Spent:
              0.5h
               

              Testing

            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)
            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 48786 [ 48786 ]
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Rajendra Joshi,

            This issue has been fixed.
            Please verify.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Rajendra Joshi , This issue has been fixed. Please verify.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Rajendra Joshi [ rajendraj ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Assignee Rajendra Joshi [ rajendraj ] Harshada Borole [ harshada.borole ]
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Swapnil Pandhare,

            This is functional issue. So, assigning it to you.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Swapnil Pandhare , This is functional issue. So, assigning it to you.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Swapnil Pandhare [ swapnil.pandhare ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Shubhangi Jadhav [ shubhangi.jadhav ]
            shubhangi.jadhav Shubhangi Jadhav (Inactive) logged work - 06/Jun/17 11:14 AM - edited
            • Time Spent:
              1.5h
               

              internal discussion
              reproduce issue and analysis on different environments

            shubhangi.jadhav Shubhangi Jadhav (Inactive) made changes -
            Time Spent 0.5h [ 1800 ] 2.5h [ 9000 ]
            Worklog Id 52868 [ 52868 ]
            shubhangi.jadhav Shubhangi Jadhav (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 0.5h [ 1800 ]
            Time Spent 2.5h [ 9000 ] 2h [ 7200 ]
            Worklog Id 52868 [ 52868 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Sprint WT Sprint 31-Bugs [ 71 ]
            Original Estimate 0.5h [ 1800 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Shubhangi Jadhav [ shubhangi.jadhav ] Harshada Borole [ harshada.borole ]
            harshada.borole Harshada Borole (Inactive) logged work - 22/Jun/17 04:10 PM
            • Time Spent:
              2h
               

              Analysis

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 2h [ 7200 ] 4h [ 14400 ]
            Worklog Id 57691 [ 57691 ]
            harshada.borole Harshada Borole (Inactive) logged work - 23/Jun/17 12:51 PM - edited
            • Time Spent:
              6h 2m
               

              Code analysis and discussion

            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 4h [ 14400 ] 7h [ 25200 ]
            Worklog Id 57957 [ 57957 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Time Spent 7h [ 25200 ] 38h [ 136800 ]
            Worklog Id 57957 [ 57957 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 23/Jun/17 09:00 PM
            • Time Spent:
              0.5h
               

              Root cause discussion

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 29h 58m [ 107880 ]
            Time Spent 38h [ 136800 ] 8h 2m [ 28920 ]
            Worklog Id 57957 [ 57957 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 29h 58m [ 107880 ] 27h 58m [ 100680 ]
            Time Spent 8h 2m [ 28920 ] 10h 2m [ 36120 ]
            Worklog Id 57957 [ 57957 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 27h 58m [ 100680 ] 27h 28m [ 98880 ]
            Time Spent 10h 2m [ 36120 ] 10h 32m [ 37920 ]
            Worklog Id 58165 [ 58165 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Developer Harshada Borole [ harshada.borole ]
            harshada.borole Harshada Borole (Inactive) logged work - 27/Jun/17 03:57 PM
            • Time Spent:
              4h
               

              Analysis,discussion,coding

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 27h 28m [ 98880 ] 23h 28m [ 84480 ]
            Time Spent 10h 32m [ 37920 ] 14h 32m [ 52320 ]
            Worklog Id 58393 [ 58393 ]
            harshada.borole Harshada Borole (Inactive) logged work - 28/Jun/17 10:24 AM
            • Time Spent:
              3h
               

              Analysis,Coding,Discussion

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 23h 28m [ 84480 ] 20h 28m [ 73680 ]
            Time Spent 14h 32m [ 52320 ] 17h 32m [ 63120 ]
            Worklog Id 59193 [ 59193 ]
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Swapnil Pandhare,

            We need your help in resolving this issue. If we have discussion at earliest, this issue can be resolved and closed.

            Thank you!

            cc: Nidhi Kaul

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Swapnil Pandhare , We need your help in resolving this issue. If we have discussion at earliest, this issue can be resolved and closed. Thank you! cc: Nidhi Kaul
            rajendraj Rajendra Joshi (Inactive) made changes -
            Summary Incomplete Tours >> Incorrect values displayed in 'Percentage Complete' column. Azure >> UIRefresh QA Test1 >> Incomplete Tours >> Incorrect values displayed in 'Percentage Complete' column.
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Jyoti Agarwal [ 16704 ]
            Dev Due Date 11/Jul/2017
            harshada.borole Harshada Borole (Inactive) logged work - 06/Jul/17 12:49 PM
            • Time Spent:
              2h
               

              Discussion and analysis

            swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 06/Jul/17 01:02 PM
            • Time Spent:
              1h
               

              Analysis and Discussion with report team.

            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Remaining Estimate 20h 28m [ 73680 ] 19h 28m [ 70080 ]
            Time Spent 17h 32m [ 63120 ] 18h 32m [ 66720 ]
            Worklog Id 61212 [ 61212 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 07/Jul/17 12:25 PM
            • Time Spent:
              0.5h
               

              Discussion and code review

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 19h 28m [ 70080 ] 18h 58m [ 68280 ]
            Time Spent 18h 32m [ 66720 ] 19h 2m [ 68520 ]
            Worklog Id 61615 [ 61615 ]
            harshada.borole Harshada Borole (Inactive) logged work - 07/Jul/17 12:34 PM
            • Time Spent:
              1.5h
               

              Code change,
              send code for review,
              Testing

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 18h 58m [ 68280 ] 17h 28m [ 62880 ]
            Time Spent 19h 2m [ 68520 ] 20h 32m [ 73920 ]
            Worklog Id 61632 [ 61632 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 17h 28m [ 62880 ] 15h 28m [ 55680 ]
            Time Spent 20h 32m [ 73920 ] 22h 32m [ 81120 ]
            Worklog Id 61669 [ 61669 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Component/s OnBoard [ 10001 ]
            Component/s OnBoard [ 11200 ]
            Key NF-1715 WT-10069
            Project New Features 2017 [ 11000 ] WORKTERRA [ 10000 ]
            ashwin.wankhede Ashwin Wankhede (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)
            Hide
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are the 3C's:

            Concern:- Incorrect values displayed in 'Percentage Complete' column.
            Cause:- Incorrect value in report occured when there was null value returned for percentage column. The null value was not handled in query.
            Correction:- Handled null value in query.

            Affected Area's:
            Fetching Tour Completion Reports which returned null values.

            Affected File's:
            OES_SP_GetTourDefaulters_Details

            Tested Scenario's:
            Pulled Tour Completion Reports with different dates.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Concern:- Incorrect values displayed in 'Percentage Complete' column. Cause:- Incorrect value in report occured when there was null value returned for percentage column. The null value was not handled in query. Correction:- Handled null value in query. Affected Area's: Fetching Tour Completion Reports which returned null values. Affected File's: OES_SP_GetTourDefaulters_Details Tested Scenario's: Pulled Tour Completion Reports with different dates.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Rajendra Joshi [ rajendraj ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Rajendra Joshi
            Please update status.
            Hrishikesh Deshpande

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Rajendra Joshi Please update status. Hrishikesh Deshpande
            rajendraj Rajendra Joshi (Inactive) made changes -
            Production Due Date 27/Jul/2017
            Stage Due Date 26/Jul/17 [ 2017-07-26 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Link This issue duplicates WT-10267 [ WT-10267 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Link This issue duplicates WT-10267 [ WT-10267 ]
            Hide
            rajendraj Rajendra Joshi (Inactive) added a comment -

            Verified on Azure using company 'UiRefresh QA Test1' in sa login. Above issue is resolved now. PFA screen shot.

            Show
            rajendraj Rajendra Joshi (Inactive) added a comment - Verified on Azure using company 'UiRefresh QA Test1' in sa login. Above issue is resolved now. PFA screen shot.
            rajendraj Rajendra Joshi (Inactive) made changes -
            Attachment azure-done.png [ 56469 ]
            rajendraj Rajendra Joshi (Inactive) logged work - 24/Jul/17 10:09 AM
            • Time Spent:
              1h
               

              Verified on Azure using company 'UiRefresh QA Test1' in sa login.

            rajendraj Rajendra Joshi (Inactive) made changes -
            Remaining Estimate 15h 28m [ 55680 ] 14h 28m [ 52080 ]
            Time Spent 22h 32m [ 81120 ] 23h 32m [ 84720 ]
            Worklog Id 65623 [ 65623 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Component/s OnBoard [ 11200 ]
            Component/s OnBoard [ 10001 ]
            Key WT-10069 NF-3934
            Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
            rajendraj Rajendra Joshi (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)
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Assignee Rajendra Joshi [ rajendraj ] 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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            closed

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - closed
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Closed [ 6 ] Reopen in Production [ 10027 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            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
            Harshada Borole (Inactive) made transition -
            Open In Development
            12d 3h 40m 1
            Harshada Borole (Inactive) made transition -
            In LB Testing Reopen in Local
            13d 23h 8m 1
            Harshada Borole (Inactive) made transition -
            Reopen in Local In Development
            37s 1
            Rakesh Roy (Inactive) made transition -
            Production Complete Closed
            2m 15s 1
            Sachin Hingole (Inactive) made transition -
            Closed Reopen in Production
            36d 2h 8m 1
            Sachin Hingole (Inactive) made transition -
            Reopen in Production In Development
            1m 14s 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            47d 17h 48m 3
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            149d 4h 22m 2
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            54d 23h 7m 2
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            8m 51s 2

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              rajendraj Rajendra Joshi (Inactive)
              Developer:
              Harshada Borole (Inactive)
              QA:
              Rajendra Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0.5h Original Estimate - 0.5h
                  0.5h
                  Remaining:
                  Time Spent - 23h 32m Remaining Estimate - 14h 28m
                  14h 28m
                  Logged:
                  Time Spent - 23h 32m Remaining Estimate - 14h 28m
                  23h 32m