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

Prime Healthcare: Unable to run Neither Enrolled Nor Waived Report

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Audit
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      Prime Healthcare
    • Module:
      BenAdmin - Report
    • Severity:
      Simple

      Description

      Hello,

      Prime Healthcare is attempting to run a "Neither Enrolled Nor Waived Report" for several facilities. Once the Server Errors were fixed today, I also tried to run this report, added all classes, changed the dates to 1/1/17 to 1/1/18, and Previewed the report. No report generates.

      This is the custom report that Jamie Gomez from Prime created. Please see screenshot:

      I also ran a report called: For Dev. review_TEST and it did not create. Please advise

      Yashau

        Attachments

          Activity

          Yashau.Macshate Yashau MacShate (Inactive) created issue -
          Yashau.Macshate Yashau MacShate (Inactive) made changes -
          Field Original Value New Value
          Link This issue causes CT-3492 [ CT-3492 ]
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Hi Yashau MacShate,

          We do not found Jamie Gomez -Neither Enrolled Nor Waived Report on prime Healthcare. However, there is another report with name 'Neither Enrolled Nor Waived Report' is present. We tried that and found no records reported. Are we considering right report?

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Hi Yashau MacShate , We do not found Jamie Gomez -Neither Enrolled Nor Waived Report on prime Healthcare. However, there is another report with name 'Neither Enrolled Nor Waived Report' is present. We tried that and found no records reported. Are we considering right report?
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Satya [ ID10004 ] Yashau MacShate [ yashau.macshate ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 30/Nov/17 12:15 AM
          • Time Spent:
            0.5h
             
            <No comment>
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Component/s BenAdmin [ 10000 ]
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
          Remaining Estimate 4h [ 14400 ]
          Original Estimate 4h [ 14400 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 3.5h [ 12600 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 93742 [ 93742 ]
          Hide
          darryn.carter darryn.carter added a comment -

          Hello Dev
          Yes this would be the correct report
          I have attempted to re-run a new report for the same dates listed above and received a blank screen

          Show
          darryn.carter darryn.carter added a comment - Hello Dev Yes this would be the correct report I have attempted to re-run a new report for the same dates listed above and received a blank screen
          darryn.carter darryn.carter made changes -
          Assignee Yashau MacShate [ yashau.macshate ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Prasanna Karlekar [ prasanna ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi darryn.carter,

          We are analyzing this issue and will provide an update by 1-Dec-2017.

          Thank you!

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi darryn.carter , We are analyzing this issue and will provide an update by 1-Dec-2017. Thank you!
          prasanna Prasanna Karlekar (Inactive) logged work - 30/Nov/17 05:30 PM
          • Time Spent:
            0.25h
             

            Issue go through
            JIRA update

          prasanna Prasanna Karlekar (Inactive) made changes -
          Attachment WT-12450_SelectionCriteria.png [ 68988 ]
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi darryn.carter,

          We verified report "2017 Neither waive nor enrolled for Medical" under Standard Reports.
          We tried executing it with attached selection, where we selected less criteria. Report executed successfully. For current selection blank report is getting generated.
          We need to check if there is any report time out issue due to which blank screen is appearing.

          As of now, could you please check this report by selecting less criteria.

          Thank you!

          cc: Gaurav Sodani, [~parmeshwar.jumbade]

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi darryn.carter , We verified report "2017 Neither waive nor enrolled for Medical" under Standard Reports. We tried executing it with attached selection, where we selected less criteria. Report executed successfully. For current selection blank report is getting generated. We need to check if there is any report time out issue due to which blank screen is appearing. As of now, could you please check this report by selecting less criteria. Thank you! cc: Gaurav Sodani , [~parmeshwar.jumbade]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] darryn.carter [ darryn.carter ]
          Resolution System Behaviour [ 10100 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 3.5h [ 12600 ] 3.25h [ 11700 ]
          Time Spent 0.5h [ 1800 ] 0.75h [ 2700 ]
          Worklog Id 94336 [ 94336 ]
          prasanna Prasanna Karlekar (Inactive) logged work - 02/Dec/17 12:00 AM
          • Time Spent:
            1h
             

            Issue analysis
            Tired searching the exact report
            Issue verification with different customizations
            JIRA update

          Yashau.Macshate Yashau MacShate (Inactive) made changes -
          Resolution System Behaviour [ 10100 ]
          Status Resolved [ 5 ] Reopen [ 4 ]
          Yashau.Macshate Yashau MacShate (Inactive) made changes -
          Assignee darryn.carter [ darryn.carter ] Prasanna Karlekar [ prasanna ]
          Hide
          Yashau.Macshate Yashau MacShate (Inactive) added a comment -

          Hello,
          This is still not working when I select less criteria, the report is blank. Please advise.

          CC; Amit Thorve
          Jennifer Johnson
          darryn.carter

          Show
          Yashau.Macshate Yashau MacShate (Inactive) added a comment - Hello, This is still not working when I select less criteria, the report is blank. Please advise. CC; Amit Thorve Jennifer Johnson darryn.carter
          prasanna Prasanna Karlekar (Inactive) made changes -
          Status Reopen [ 4 ] In Progress [ 3 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Attachment WT-12450_CostFieldsRemoval.png [ 69475 ]
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi Yashau MacShate,

          Apologies that earlier suggested fix did not work.
          From existing field selection, could you please remove cost related fields. Please refer below screen shot:

          Selection of these fields is causing a performance issue due to which blank report is appearing. Also, we have customized this report to find list of employees who neither waive nor were enrolled in selected benefit type, for which cost related details are not required.
          Have tried mentioned customization on "2017 Neither waive nor enrolled for Medical" under Standard Reports, after which it is executing successfully.

          Thank you!

          cc: Gaurav Sodani, [~parmeshwar.jumbade]

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi Yashau MacShate , Apologies that earlier suggested fix did not work. From existing field selection, could you please remove cost related fields . Please refer below screen shot: Selection of these fields is causing a performance issue due to which blank report is appearing. Also, we have customized this report to find list of employees who neither waive nor were enrolled in selected benefit type, for which cost related details are not required. Have tried mentioned customization on "2017 Neither waive nor enrolled for Medical" under Standard Reports, after which it is executing successfully. Thank you! cc: Gaurav Sodani , [~parmeshwar.jumbade]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Yashau MacShate [ yashau.macshate ]
          prasanna Prasanna Karlekar (Inactive) logged work - 06/Dec/17 07:30 PM
          • Time Spent:
            1h
             

            Analysis
            JIRA update

          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 3.25h [ 11700 ] 2.25h [ 8100 ]
          Time Spent 0.75h [ 2700 ] 1.75h [ 6300 ]
          Worklog Id 97892 [ 97892 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Remaining Estimate 2.25h [ 8100 ] 1.25h [ 4500 ]
          Time Spent 1.75h [ 6300 ] 2.75h [ 9900 ]
          Worklog Id 97905 [ 97905 ]
          Transition Time In Source Status Execution Times
          Jaideep Vinchurkar (Inactive) made transition -
          Open Waiting for Customer Input
          1h 21m 1
          Prasanna Karlekar (Inactive) made transition -
          Waiting for Customer Input In Progress
          2h 26m 1
          Yashau MacShate (Inactive) made transition -
          Resolved Reopen
          4d 8h 3m 1
          Prasanna Karlekar (Inactive) made transition -
          Reopen In Progress
          18h 46m 1
          Prasanna Karlekar (Inactive) made transition -
          In Progress Resolved
          1d 8h 52m 2

            People

            Assignee:
            Yashau.Macshate Yashau MacShate (Inactive)
            Reporter:
            Yashau.Macshate Yashau MacShate (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4h
                4h
                Remaining:
                Time Spent - 2.75h Remaining Estimate - 1.25h
                1.25h
                Logged:
                Time Spent - 2.75h Remaining Estimate - 1.25h
                2.75h