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

            Activity

            Hide
            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.
            Hide
            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
            Hide
            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
            Hide
            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
            Hide
            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
            Hide
            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
            Hide
            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
            Hide
            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
            Hide
            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

              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