WORKTERRAProject Type: software

WORKTERRA

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

Billing details report shows blank screen

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Good To Have
    • Sprint:
      WT Sprint 41

      Description

      When we ran billing details reports it does not pulling anything and showing blank screen

        Attachments

          Issue Links

          is cloned by

          Bug - A problem which impairs or prevents the functions of the product. NF-5560 Billing details report shows blank screen

          • Medium - Has the potential to affect progress.
          • Resolution Setting
          relates to

          Support Activity - Support Activity WT-12295 Bio Rad - Move from stage to production - Smoke Test

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

            Activity

            Ascending order - Click to sort in descending order
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) created issue -
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue relates to WT-12295 [ WT-12295 ]
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            We have resolved issue for Bio-Rad company but it needs to deploy on all environments for companies.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - We have resolved issue for Bio-Rad company but it needs to deploy on all environments for companies.
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Development Approval No [ 18473 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment WT-12751- Issue and implementation Approach.xls [ 70365 ]
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            Hi Gaurav Sodani,

            Have attached WT-12751- Issue and implementation Approach.xls file for deployment approval. This file include all details (i.e. issues, current implementation, Bug Resolution Approach and etc.).

            Please check and let us know if need more details.

            CC: Prasanna Karlekar Satya Samir

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited Hi Gaurav Sodani , Have attached WT-12751- Issue and implementation Approach.xls file for deployment approval. This file include all details (i.e. issues, current implementation, Bug Resolution Approach and etc.). Please check and let us know if need more details. CC: Prasanna Karlekar Satya Samir
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Attachment FW Hot Fix and Development Approval Request.msg [ 70440 ]
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the development approval email for reference: Unable to embed resource: FW Hot Fix and Development Approval Request.msg of type application/octet-stream

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the development approval email for reference: Unable to embed resource: FW Hot Fix and Development Approval Request.msg of type application/octet-stream Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Development Approval No [ 18473 ] Yes [ 18474 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Billing
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Sprint WT Sprint 41 [ 95 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            3C's:
            Concern: When we ran billing report for a month with all plans but nothing pulls on report and it shows report as blank screen even there is records for selected criteria.
            Cause: The query was taking more than 4 minutes to execute for all selected criteria and due to this report was showing blank screen.
            Correction: With existing implementation while generate billing report we form a query to join two temporary tables (i.e. Billing and Enrollment) based on common criteria. But the join conditions was taking more time to execute query. We have created index on both temporary tables so it will get execute less than a minute based on the selected criteria.

            CC: Prasanna Karlekar Gaurav Sodani

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - 3C's : Concern : When we ran billing report for a month with all plans but nothing pulls on report and it shows report as blank screen even there is records for selected criteria. Cause : The query was taking more than 4 minutes to execute for all selected criteria and due to this report was showing blank screen. Correction : With existing implementation while generate billing report we form a query to join two temporary tables (i.e. Billing and Enrollment) based on common criteria. But the join conditions was taking more time to execute query. We have created index on both temporary tables so it will get execute less than a minute based on the selected criteria. CC: Prasanna Karlekar Gaurav Sodani
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Root Cause Performance [ 18429 ]
            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)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] 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 ] Venkatesh Pujari [ venkatesh.pujari ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Sanjana Jadhav [ sanjana.jadhav ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue is cloned by WT-12855 [ WT-12855 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 22/Dec/17 [ 2017-12-22 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment wt-12751.png [ 70568 ]
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on LB.
            Company: City of Durham
            Verified billing details report for a month with all benefit/plan.
            Report generated properly.
            PFA,

            Working properly. Ready for stage.

            Thanks,
            Sanjana Jadhav

            CC: Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on LB. Company: City of Durham Verified billing details report for a month with all benefit/plan. Report generated properly. PFA, Working properly. Ready for stage. Thanks, Sanjana Jadhav CC: Prasad Pise Hrishikesh Deshpande 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)
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 21/Dec/17 09:17 AM
            • Time Spent:
              1h
               

              Verified on LB
              Internal discussion

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 1h [ 3600 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 97326 [ 97326 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment Scenarios for benefit details report.xls [ 70607 ]
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 21/Dec/17 12:58 PM
            • Time Spent:
              0.5h
               

              scenario writing
              Internal discussion

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
            Time Spent 1h [ 3600 ] 1.5h [ 5400 ]
            Worklog Id 97392 [ 97392 ]
            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)
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Attachment Billing_Details.jpg [ 70684 ]
            Hide
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have verified this issue on Stage - City of Durham and observed that Billing details report generated successfully

            Hence marking ready for Production.

            Mahendra

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have verified this issue on Stage - City of Durham and observed that Billing details report generated successfully Hence marking ready for Production. Mahendra
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 22/Dec/17 11:27 AM
            • Time Spent:
              0.5h
               

              Verification on stage

            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            This ticket has been approved for stage deployment on 12/21/17.

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, This ticket has been approved for stage deployment on 12/21/17. Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Deployment Approval Approved for stage deployment [ 18455 ]
            Production Due Date 29/Dec/2017
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Comments Hi All,

            Following point has been approved for production deployment on 12/29

            Regards
            Gaurav
            Deployment Approval Approved for stage deployment [ 18455 ] Approved for production deployment [ 18457 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Verified this issue on Production on AFI For Hspl company. Report being generated with correct records.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Verified this issue on Production on AFI For Hspl company. Report being generated with correct records. Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 1.5h [ 5400 ] 2h [ 7200 ]
            Worklog Id 98523 [ 98523 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Time Spent 2h [ 7200 ] 2.5h [ 9000 ]
            Worklog Id 98775 [ 98775 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 29/Dec/17 07:09 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching the production deployment approval email for reference

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching the production deployment approval email for reference Regards Gaurav
            Transition Time In Source Status Execution Times
            Parmeshwar Jumbad (Inactive) made transition -
            Open In Development
            		7d 21h 45m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		2h 41m 1
            Mahendra Mungase (Inactive) made transition -
            In LB Testing Stage Testing
            		1d 23h 26m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            		6d 21h 17m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		18m 17s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		2s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              parmeshwar.jumbad Parmeshwar Jumbad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2.5h
                  2.5h