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

Functional - JE Dunn - CA - OE Changes report takes long to show the report

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Level:
      Admin
    • Module:
      BenAdmin - Report
    • Reported by:
      Support
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold
    • Browser:
      IE 11, Google Chrome
    • UAT For:
      UI Refresh

      Description

      Log in as CA to Azure
      (AdminJed/Password@11)
      Go to BenAdmin - Reports - Open Enrollment Changes Report
      Edit "2017 OE" report
      Click on preview button

      actual result - Takes to long to show the report
      expected result - It should open report instantly

      NOTE - on Stage same report does not fetch the data but on Azure it fetches the data.

        Attachments

        1. 2017OE_JEDUNN_Stage.png
          2017OE_JEDUNN_Stage.png
          20 kB
        2. 2017OE_JEDUNN.png
          2017OE_JEDUNN.png
          21 kB
        3. NF-4536.png
          NF-4536.png
          151 kB
        4. OEReport1.png
          OEReport1.png
          27 kB
        5. OEReport2.png
          OEReport2.png
          22 kB
        6. OpenEnrollmentChangeReport_Pass_Codemap.JPG
          OpenEnrollmentChangeReport_Pass_Codemap.JPG
          116 kB
        7. Screenshot (160).png
          Screenshot (160).png
          164 kB

          Activity

          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi Sachin Hingole,

          We will provide an update on this by 9-Oct-2017.

          Thank you!

          cc: Gaurav Sodani

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi Sachin Hingole , We will provide an update on this by 9-Oct-2017. Thank you! cc: Gaurav Sodani
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi Sachin Hingole,

          Observed that for Azure, loader is disappearing after some time. Actually, it should not disappear until the Report Viewer screen appears. We will check this for new UI.

          Have checked this report on stage on UI TEST - JE Dunn company with Partner login and on Azure with mentioned login. On both sites records are appearing on report.

          Loader issue for new UI needs to be worked up on.

          Thank you!

          cc: Gaurav Sodani

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi Sachin Hingole , Observed that for Azure, loader is disappearing after some time. Actually, it should not disappear until the Report Viewer screen appears. We will check this for new UI. Have checked this report on stage on UI TEST - JE Dunn company with Partner login and on Azure with mentioned login. On both sites records are appearing on report. Loader issue for new UI needs to be worked up on. Thank you! cc: Gaurav Sodani
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Currently, keeping this is On Hold.
          We will work on this once, NF-4538 is complete.

          Thank you!

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Currently, keeping this is On Hold. We will work on this once, NF-4538 is complete. Thank you!
          Hide
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

          3C's:

          Concern: Progress bar would not appear till the report view window open.

          Cause: While implementation of NF-2893 it was explicitly hide after 3 seconds. If report viewer not opened into 3 seconds then it will stop showing of progress bar on report screen. This issue was for all static report it was not specific of OE changes reports. But it was observed on this report because sometime it takes time.

          Correction: Now we have removed code to stop progress bar explicitly after 3 seconds. Now progress bar will be appear till the successful execution of preview or on error. It will get disappear after report viewer window will get opened.

          Affected Areas: Static reports, OE changes reports

          Affected Files:
          StaticReports.cshtml

          Tested Scenarios:
          1. Static reports (Company Level and Global level) preview and Save.
          2. OE changes report preview and save.

          CC: Prasanna Karlekar Gaurav Sodani

          Show
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - 3C's: Concern : Progress bar would not appear till the report view window open. Cause : While implementation of NF-2893 it was explicitly hide after 3 seconds. If report viewer not opened into 3 seconds then it will stop showing of progress bar on report screen. This issue was for all static report it was not specific of OE changes reports. But it was observed on this report because sometime it takes time. Correction : Now we have removed code to stop progress bar explicitly after 3 seconds. Now progress bar will be appear till the successful execution of preview or on error. It will get disappear after report viewer window will get opened. Affected Areas : Static reports, OE changes reports Affected Files : StaticReports.cshtml Tested Scenarios : 1. Static reports (Company Level and Global level) preview and Save. 2. OE changes report preview and save. CC: Prasanna Karlekar Gaurav Sodani
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Changes seems to be fine.
          Code review is complete.

          Thank you!

          cc: [~parmeshwar.jumbade]

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Changes seems to be fine. Code review is complete. Thank you! cc: [~parmeshwar.jumbade]
          Hide
          kunal.kedari Kunal Kedari (Inactive) added a comment -

          We have verified the fix on Codemap, it is working as expected. Now "Open Enrollment Changes" report is getting loaded withing 10-15 seconds.

          Refer attached screenshot for more details:

          Cc: [~parmeshwar.jumbade], Prasanna Karlekar, Sachin Hingole, Prasad Pise, Vijayendra Shinde

          Show
          kunal.kedari Kunal Kedari (Inactive) added a comment - We have verified the fix on Codemap, it is working as expected. Now "Open Enrollment Changes" report is getting loaded withing 10-15 seconds. Refer attached screenshot for more details: Cc: [~parmeshwar.jumbade] , Prasanna Karlekar , Sachin Hingole , Prasad Pise , Vijayendra Shinde
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          11/28 (Diana) - Side Note: Just tried again and while it did not trigger server error, it took me 2mins before a blank report load (showed the loading icon the whole time) and not the 10-15secs as stated in NF-4536. Can look into (1) if it is indeed supposed to be a blank report or was there a time-out and (2) if all working properly, how the load time can be improved?

          Diana Wong Prasanna Karlekar Nidhi Kaul Vijayendra Shinde

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - 11/28 (Diana) - Side Note: Just tried again and while it did not trigger server error, it took me 2mins before a blank report load (showed the loading icon the whole time) and not the 10-15secs as stated in NF-4536 . Can look into (1) if it is indeed supposed to be a blank report or was there a time-out and (2) if all working properly, how the load time can be improved? Diana Wong Prasanna Karlekar Nidhi Kaul Vijayendra Shinde
          Hide
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

          Hi Sachin Hingole,

          The report time may vary by report to report because it's totally depend on the selected criteria & number of records available while run/preview report. As i mentioned in my comment we worked on progress bar get disappear before Report viewer window gets opened.

          For point #1 & #2: If selected criteria return large number of data then there is a possibility to time out issue. For performance points will need to check but for now this is working as of now.

          CC: Prasanna Karlekar Gaurav Sodani Nidhi Kaul Satya

          Show
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited Hi Sachin Hingole , The report time may vary by report to report because it's totally depend on the selected criteria & number of records available while run/preview report. As i mentioned in my comment we worked on progress bar get disappear before Report viewer window gets opened. For point #1 & #2: If selected criteria return large number of data then there is a possibility to time out issue. For performance points will need to check but for now this is working as of now. CC: Prasanna Karlekar Gaurav Sodani Nidhi Kaul Satya
          Hide
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

          Verified on codemap.
          "Open Enrollment Changes" report is getting loaded withing 10-15 seconds.
          Working properly.
          PFA,

          Thanks,
          Sanjana Jadhav.

          CC: Prasad Pise Rakesh Roy Sachin Hingole

          Show
          sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on codemap. "Open Enrollment Changes" report is getting loaded withing 10-15 seconds. Working properly. PFA, Thanks, Sanjana Jadhav. CC: Prasad Pise Rakesh Roy Sachin Hingole
          Hide
          diana Diana Wong (Inactive) added a comment -

          Sanjana Jadhav I don't get the same experience as you. Are you testing with '2017 OE' report using AdminJed Password@1 credentials? The other report 'STBTobaccoReport' was quick and showed no records but '2017 OE' report took 91 seconds (1.5 mins).

          Additionally when it is done, there is no records but it is not showing 'No records found' but just a blank report page. Recording at https://screencast-o-matic.com/watch/cblIn32J6z . I get Parmeshwar's comments that it might take longer with more criteria/records but it does not explain why the page is blank instead of showing 'No records found'. Can please review and see if you can reproduce? I can share my screen with it should it help with investigation.

          STBTobacco Report

          2017 OE Report

          Show
          diana Diana Wong (Inactive) added a comment - Sanjana Jadhav I don't get the same experience as you. Are you testing with '2017 OE' report using AdminJed Password@1 credentials? The other report 'STBTobaccoReport' was quick and showed no records but '2017 OE' report took 91 seconds (1.5 mins). Additionally when it is done, there is no records but it is not showing 'No records found' but just a blank report page. Recording at https://screencast-o-matic.com/watch/cblIn32J6z . I get Parmeshwar's comments that it might take longer with more criteria/records but it does not explain why the page is blank instead of showing 'No records found'. Can please review and see if you can reproduce? I can share my screen with it should it help with investigation. STBTobacco Report 2017 OE Report
          Hide
          mahendra.mungase Mahendra Mungase (Inactive) added a comment -

          HI Diana Wong

          Changes deploy on Codemap so we did verify on CodeMapnot. Once we deploy this change on Azure, we will update JIRA accordingly.

          Mahendra

          Show
          mahendra.mungase Mahendra Mungase (Inactive) added a comment - HI Diana Wong Changes deploy on Codemap so we did verify on CodeMapnot. Once we deploy this change on Azure, we will update JIRA accordingly. Mahendra
          Hide
          sachin.hingole Sachin Hingole (Inactive) added a comment - - edited

          Hi Diana Wong,

          This report takes time on stage as well as on azure.
          The report shows "No records found" in report viewer, To view this message user need to maximize the report view and scroll to right, same on stage. Refer images

          Let us know if you need any other details on this.

          Thanks,
          Sachin Hingole

          Nidhi Kaul Rakesh Roy Vijayendra Shinde Hrishikesh Deshpande Prasad Pise Prasanna Karlekar

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - - edited Hi Diana Wong , This report takes time on stage as well as on azure. The report shows "No records found" in report viewer, To view this message user need to maximize the report view and scroll to right, same on stage. Refer images Let us know if you need any other details on this. Thanks, Sachin Hingole Nidhi Kaul Rakesh Roy Vijayendra Shinde Hrishikesh Deshpande Prasad Pise Prasanna Karlekar
          Hide
          diana Diana Wong (Inactive) added a comment -

          Hi Sanjana, I tested this in Preprod and it is now loading ok. As such, can please assist to close this ticket? Thank you,

          Show
          diana Diana Wong (Inactive) added a comment - Hi Sanjana, I tested this in Preprod and it is now loading ok. As such, can please assist to close this ticket? Thank you,
          Hide
          diana Diana Wong (Inactive) added a comment -

          Ops reflected in google sheet that this is verified to be working as needed in Preprod.

          Show
          diana Diana Wong (Inactive) added a comment - Ops reflected in google sheet that this is verified to be working as needed in Preprod.
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

          Environment: production
          Login: CA

          The Open Enrollment Changes Report is checked for long time to open is verified. The time taken is around 8-10 sec to open.

          So, closing jira on Production.

          Sachin Hingole Hrishikesh Deshpande

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - - edited Environment: production Login: CA The Open Enrollment Changes Report is checked for long time to open is verified. The time taken is around 8-10 sec to open. So, closing jira on Production. Sachin Hingole Hrishikesh Deshpande

            People

            Assignee:
            sanjana.jadhav Sanjana Jadhav (Inactive)
            Reporter:
            sachin.hingole Sachin Hingole (Inactive)
            Developer:
            Prasanna Karlekar (Inactive)
            QA:
            Sachin Hingole (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date:

                Time Tracking

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