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

Pre Prod | Employee Count on Dashboard and Search EE page mismatched.

    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 Type:
      UI
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold

      Description

      The EE count on dashboard and Search EE is mismatched.

        Attachments

        1. Employee Count.png
          49 kB
          Prasad Patil
        2. Employee Count 2.png
          32 kB
          Prasad Patil
        3. NF-5452.png
          78 kB
          Sanjana Jadhav
        4. WTSQLLBONE-SystemHomePageCounterService.PNG
          62 kB
          Ashwin Wankhede

          Issue Links

            Activity

            prasad.patil Prasad Patil (Inactive) created issue -
            prasad.patil Prasad Patil (Inactive) made changes -
            Field Original Value New Value
            Bug Type Functional [ 15402 ] UI [ 15401 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Vijayendra Shinde [ ID10506 ]
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Prasad Patil
            Please select the fields correctly. Component and parent JIRA is missing

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Prasad Patil Please select the fields correctly. Component and parent JIRA is missing
            prasad.patil Prasad Patil (Inactive) made changes -
            Component/s UI Refresh [ 10902 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Link This issue relates to NF-5195 [ NF-5195 ]
            vijayendra Vijayendra Shinde (Inactive) made changes -
            Assignee Vijayendra Shinde [ ID10506 ] Sonali Farakate [ sonali.farakate ]
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Assignee Sonali Farakate [ sonali.farakate ] Swapnil Pandhare [ swapnil.pandhare ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Sheetal Bodhale [ sheetal.bodhale ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Prasad Patil,

            It is showing correct count as per system implementation.
            System will show count of employee count+ Spouse count + child count.

            WPA company has 15 employee,6 child and 8 spouse.So total count is 29.

            As discussed with Swapnil Pandhare,assigning this ticket to Vishal Yadav

            CC:Vijayendra ShindeSwapnil Pandhare

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Prasad Patil , It is showing correct count as per system implementation. System will show count of employee count+ Spouse count + child count. WPA company has 15 employee,6 child and 8 spouse.So total count is 29. As discussed with Swapnil Pandhare ,assigning this ticket to Vishal Yadav CC: Vijayendra Shinde Swapnil Pandhare Thanks, Sheetal Bodhale
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Vishal Yadav [ vishal.yadav ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 95764 [ 95764 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 13/Dec/17 12:21 AM
            • Time Spent:
              2h
               

              Analysis
              Updated comments

            vishal.yadav Vishal Yadav (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            vishal.yadav Vishal Yadav (Inactive) added a comment -

            Hi Prasad Patil,

            Please check this issue after next pre-production build.

            Thanks,
            Vishal Yadav

            Show
            vishal.yadav Vishal Yadav (Inactive) added a comment - Hi Prasad Patil , Please check this issue after next pre-production build. Thanks, Vishal Yadav
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Assignee Vishal Yadav [ vishal.yadav ] Prasad Patil [ prasad.patil ]
            vishal.yadav Vishal Yadav (Inactive) logged work - 13/Dec/17 02:29 PM
            • Time Spent:
              3h
               
              • Analysis for changes required to fix issue.
              • Discussion with Vijayendra, Sonali and Ashwin.
              • It is found that need to debug service created for showing Employee count on dashboard.
              • Checked service output on local environment and verified count with search employee page.
              • After observation it is found, while reading values from database, column name was mismatch with live members and Employees.
              • Unit testing
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Time Spent 2h [ 7200 ] 5h [ 18000 ]
            Worklog Id 95984 [ 95984 ]
            Hide
            vishal.yadav Vishal Yadav (Inactive) added a comment -

            affected file

            /branches/UiRefresh-LB/App/BusinessLogic/CollectionManager/CollectionManager.vb

            Show
            vishal.yadav Vishal Yadav (Inactive) added a comment - affected file /branches/UiRefresh-LB/App/BusinessLogic/CollectionManager/CollectionManager.vb
            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)
            vishal.yadav Vishal Yadav (Inactive) logged work - 19/Dec/17 01:09 PM
            • Time Spent:
              0.5h
               

              Code commit on codemap

            vishal.yadav Vishal Yadav (Inactive) made changes -
            Time Spent 5h [ 18000 ] 5.5h [ 19800 ]
            Worklog Id 96931 [ 96931 ]
            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 -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment NF-5452.png [ 70485 ]
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Hi Vishal Yadav

            Verified on codemap.
            This issue is still reproducible
            PFA,

            Thanks,
            Sanjana Jadhav

            CC: Prasad Pise Sachin Hingole Rakesh Roy

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Hi Vishal Yadav Verified on codemap. This issue is still reproducible PFA, 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: Re-open(10212)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Prasad Patil [ prasad.patil ] Vishal Yadav [ vishal.yadav ]
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            Hide
            vishal.yadav Vishal Yadav (Inactive) added a comment -

            Hi Ashwin Wankhede,

            As per discussed with Vijayendra, we are into conclusion that, OES_SP_Job_SystemUserHomePageService is not running on Codemap environment.
            Can you please run this service on Codemap?
            if you are facing any issues w.r.t script generation then please inform it to Vijayendra about the list of developers using Codemap server and causing the errors while executing service

            Thanks,
            Vishal Yadav

            CC : Vijayendra Shinde

            Show
            vishal.yadav Vishal Yadav (Inactive) added a comment - Hi Ashwin Wankhede , As per discussed with Vijayendra, we are into conclusion that, OES_SP_Job_SystemUserHomePageService is not running on Codemap environment. Can you please run this service on Codemap? if you are facing any issues w.r.t script generation then please inform it to Vijayendra about the list of developers using Codemap server and causing the errors while executing service Thanks, Vishal Yadav CC : Vijayendra Shinde
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Assignee Vishal Yadav [ vishal.yadav ] Ashwin Wankhede [ ashwin.wankhede ]
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 6.5h [ 23400 ]
            Worklog Id 97286 [ 97286 ]
            Hide
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Vishal Yadav
            What issue was fixed 3 days back. Please update the 3C's

            .Ashwin Wankhede
            Please check on the service immediately.

            Thanks,
            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Vishal Yadav What issue was fixed 3 days back. Please update the 3C's . Ashwin Wankhede Please check on the service immediately. Thanks, Nidhi.
            Hide
            vishal.yadav Vishal Yadav (Inactive) added a comment - - edited

            FYI : To display Employee count on dashboard we are using OES_SP_Job_SystemUserHomePageService. This service runs across all the companies.
            And display employee count on dashboard.

            3C's are :

            Concern : Employee count on Dashboard and Search employee page does not match

            Cause :
            1) While fetching values from database to application wrong column name was specified. ie. NoofLives => NoofEmployee and members => NoofLives
            2) On codemap, OES_SP_Job_SystemUserHomePageService service was not running, hence QA got this issue. Whereas in unit testing I have started this service hence it is not present on developer environment.

            Correction :
            1) In business logic, changed assignments of column. ie. NoofLives to NoofLives and members to NoofEmployee
            2) Need to run OES_SP_Job_SystemUserHomePageService service on codemap.

            thanks,
            Vishal Yadav

            CC : Nidhi Kaul , Vijayendra Shinde

            Show
            vishal.yadav Vishal Yadav (Inactive) added a comment - - edited FYI : To display Employee count on dashboard we are using OES_SP_Job_SystemUserHomePageService . This service runs across all the companies. And display employee count on dashboard. 3C's are : Concern : Employee count on Dashboard and Search employee page does not match Cause : 1) While fetching values from database to application wrong column name was specified. ie. NoofLives => NoofEmployee and members => NoofLives 2) On codemap, OES_SP_Job_SystemUserHomePageService service was not running, hence QA got this issue. Whereas in unit testing I have started this service hence it is not present on developer environment. Correction : 1) In business logic, changed assignments of column. ie. NoofLives to NoofLives and members to NoofEmployee 2) Need to run OES_SP_Job_SystemUserHomePageService service on codemap. thanks, Vishal Yadav CC : Nidhi Kaul , Vijayendra Shinde
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 7h [ 25200 ]
            Worklog Id 97440 [ 97440 ]
            vishal.yadav Vishal Yadav (Inactive) logged work - 22/Dec/17 06:18 AM
            • Time Spent:
              1h
               

              Discussion with Ashwin
              Jira updation

            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Hide
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment - - edited

            Hi Vishal Yadav,

            We have configured "System Home Page counter service" on codemap. Is running now.

            Please verify counters are reflecting proper now.

            CC: Samir

            Show
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment - - edited Hi Vishal Yadav , We have configured "System Home Page counter service" on codemap. Is running now. Please verify counters are reflecting proper now. CC: Samir
            ashwin.wankhede Ashwin Wankhede (Inactive) logged work - 22/Dec/17 01:52 PM
            • Time Spent:
              1h
               
              <No comment>
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Assignee Ashwin Wankhede [ ashwin.wankhede ] Prasad Patil [ prasad.patil ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Time Spent 7h [ 25200 ] 8h [ 28800 ]
            Worklog Id 97646 [ 97646 ]
            vishal.yadav Vishal Yadav (Inactive) logged work - 23/Dec/17 06:09 AM
            • Time Spent:
              0.5h
               

              3C's updated

            vishal.yadav Vishal Yadav (Inactive) made changes -
            Dev Due Date 22/Dec/2017
            Original Estimate 0h [ 0 ]
            vishal.yadav Vishal Yadav (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            prasad.patil Prasad Patil (Inactive) added a comment -

            Hi,

            Verified on Codemap. Working fine as expected.
            Thank you,
            -------------------------------------------------
            CC: Mandar Kulkarni, Satya

            Show
            prasad.patil Prasad Patil (Inactive) added a comment - Hi, Verified on Codemap. Working fine as expected. Thank you, ------------------------------------------------- CC: Mandar Kulkarni , Satya
            prasad.patil Prasad Patil (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            prasad.patil Prasad Patil (Inactive) logged work - 26/Dec/17 12:40 PM
            • Time Spent:
              0.5h
               

              discussion with Vishal

            prasad.patil Prasad Patil (Inactive) made changes -
            Time Spent 8h [ 28800 ] 8.5h [ 30600 ]
            Worklog Id 97838 [ 97838 ]
            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)
            prasad.patil Prasad Patil (Inactive) logged work - 02/Jan/18 04:56 PM
            • Time Spent:
              1h
               

              Issue Verifiction on Pre prod and discussion with Sachin

            prasad.patil Prasad Patil (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            prasad.patil Prasad Patil (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)
            prasad.patil Prasad Patil (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 9.5h [ 34200 ]
            Worklog Id 99253 [ 99253 ]
            prasad.patil Prasad Patil (Inactive) made changes -
            Assignee Prasad Patil [ prasad.patil ] Sachin Hingole [ sachin.hingole ]
            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
            Sheetal Bodhale (Inactive) made transition -
            Open In Development
            1d 59m 1
            Sanjana Jadhav (Inactive) made transition -
            In LB Testing Reopen in Local
            2h 1m 1
            Vishal Yadav (Inactive) made transition -
            Reopen in Local In Development
            18h 44m 1
            Vishal Yadav (Inactive) made transition -
            In Development In LB Testing
            13d 4h 35m 2
            Prasad Patil (Inactive) made transition -
            In LB Testing Stage Testing
            7d 17h 39m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            79d 2h 15m 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            4m 28s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              prasad.patil Prasad Patil (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 9.5h
                  9.5h