New Features 2017Project Type: software

New Features 2017

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

PreProd: Error while processing reports

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Pre Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin
    • Reported by:
      Harbinger
    • Company:
      Virgin Atlantic
    • Item State:
      Stage QA - Production Deployment on Hold
    • UAT For:
      UI Refresh

      Description

      Getting error while processing Following reports:
      1.Enrollment Report
      2. EE census Report
      3. Dependent Census Report
      4.Payroll deduction
      5.Newly enrolled dependents report

      Refer screen shots below

      ------------------------------------------------------

      CC: Mandar Kulkarni, Satya, Hrishikesh Deshpande, Sachin Hingole, Rakesh Roy

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          7 older comments
          Hide
          Permalink
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Hi Nidhi Kaul,

          While discussing this issue, we had discussed following 2 points:
          1. Scan data to check the discrepancy between company ID and connection string. - Complete
          We scanned report server data for already created reports in Pre Production environment. There were following 5 companies for which reports are created :

          Company Name
          CareerBuilder Account
          CHMC
          Beta Company 1
          BioRad
          Miller Sierra

          All of them have proper connection string defined. No issues for existing data.

          2. To check, if anytime Online enrollment connection string is getting created from code. - Root cause found. Code fix pending.
          Thank you! for asking us to check this. We did found a scenario when Online Enrollment connection string can get created while executing a company level report. We will be fixing this issue. Have extended dev due date to 02-Jan-2017.

          [~parmeshwar.jumbade] -
          Please take this on priority tomorrow 28-Dec-2017.

          Thank you!

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Hi Nidhi Kaul , While discussing this issue, we had discussed following 2 points: 1. Scan data to check the discrepancy between company ID and connection string. - Complete We scanned report server data for already created reports in Pre Production environment. There were following 5 companies for which reports are created : Company Name CareerBuilder Account CHMC Beta Company 1 BioRad Miller Sierra All of them have proper connection string defined. No issues for existing data. 2. To check, if anytime Online enrollment connection string is getting created from code. - Root cause found. Code fix pending. Thank you! for asking us to check this . We did found a scenario when Online Enrollment connection string can get created while executing a company level report. We will be fixing this issue. Have extended dev due date to 02-Jan-2017. [~parmeshwar.jumbade] - Please take this on priority tomorrow 28-Dec-2017. Thank you!
          Hide
          Permalink
          nidhi.kaul Nidhi Kaul (Inactive) added a comment -

          That's a good news that we got the root cause. As long as issue is fixed for now, we should be okay to extend the date.

          Thanks,
          Nidhi.

          Show
          nidhi.kaul Nidhi Kaul (Inactive) added a comment - That's a good news that we got the root cause. As long as issue is fixed for now, we should be okay to extend the date. Thanks, Nidhi.
          Hide
          Permalink
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

          3Cs:
          Concern: Error while processing reports
          Cause: When we execute standard system utilization report as first report for a company, connection string with OnlineEnrollment was getting created for respective company's datasource. This issue was only when, system utilization was the first report to be executed for a company. No other report had such issue.
          Correction: Now we have removed code which was used to generate report datasource with Online Enrollment connection string for company level report. Due to this it will create datasource with company specific connection string for standard/dynamic reports.

          Affected Files: App\BusinessLogic\Reports\RDLGenerator.vb

          Affected Areas: Reports (All types and All levels)

          Tested Scenarios:
          1. Verified multiple types of report and it's datasource
          2. Verified company level, Global level reports

          CC: Prasanna Karlekar Gaurav Sodani

          Show
          parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - 3Cs : Concern : Error while processing reports Cause : When we execute standard system utilization report as first report for a company, connection string with OnlineEnrollment was getting created for respective company's datasource. This issue was only when, system utilization was the first report to be executed for a company. No other report had such issue. Correction : Now we have removed code which was used to generate report datasource with Online Enrollment connection string for company level report. Due to this it will create datasource with company specific connection string for standard/dynamic reports. Affected Files : App\BusinessLogic\Reports\RDLGenerator.vb Affected Areas : Reports (All types and All levels) Tested Scenarios : 1. Verified multiple types of report and it's datasource 2. Verified company level, Global level reports CC: Prasanna Karlekar Gaurav Sodani
          Hide
          Permalink
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Codemap
          Company: or QA Kindercare for hspl
          Login: Partner

          Reports are checked for the serevr error. No server error found during testing. So, making jira ready for Pre-pro.

          Sachin Hingole Hrishikesh Deshpande

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Codemap Company: or QA Kindercare for hspl Login: Partner Reports are checked for the serevr error. No server error found during testing. So, making jira ready for Pre-pro. Sachin Hingole Hrishikesh Deshpande
          Hide
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          Testing done on Codemap.

          Verified all report on Random basis. Report working as expected.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Testing done on Codemap. Verified all report on Random basis. Report working as expected.

            People

            Assignee:
            priya.dhamande Priya Dhamande (Inactive)
            Reporter:
            sumeet.kolge Sumeet.Kolge (Inactive)
            Developer:
            Harshada Borole (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 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 - 12h
                12h