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

Scheduled Reports have failed last 2 weeks

    Details

    • Type: Analysis
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Report
    • Reported by:
      CareerBuilder
    • Company:
      Prime Healthcare
    • Severity:
      Simple

      Description

      I have been receiving weekly reports since March for Prime Healtcare locations showing anyone who had benefit changes/terminations. I have made no changes to the reports since initiating them. However, I have not received any Age/Change/Term Reports for the last 2 weeks. Attached is report showing that the report has failed each time. Please advise as to what is suddenly creating these failures.

      I should receive weekly Add/Change/Term Reports from the following 13 locations (but stopped receiving all of them 2 weeks ago):
      AH
      CHMC
      Coschocton
      EastLiverpool
      EHMC
      HMC
      Hospitality
      KMC
      MHIN
      MRTX
      PMC
      Prime Healthcare
      PrimeHealthcare

        Attachments

          Issue Links

            Activity

            Hide
            santosh.balid Santosh Balid (Inactive) added a comment -

            Hi Raymond Williams,

            We are looking into this, but could you please provide us name of any particular report , which can help us in analysis.

            Regards,
            Santosh

            Cc: Ganesh Sadawarte, Umesh Kadam, Samir,Satya

            Show
            santosh.balid Santosh Balid (Inactive) added a comment - Hi Raymond Williams , We are looking into this, but could you please provide us name of any particular report , which can help us in analysis. Regards, Santosh Cc: Ganesh Sadawarte , Umesh Kadam , Samir , Satya
            Hide
            Raywill Raymond Williams (Inactive) added a comment -

            Hi Santosh Balid-

            The Add/Change/Term Reports.

            Show
            Raywill Raymond Williams (Inactive) added a comment - Hi Santosh Balid - The Add/Change/Term Reports.
            Hide
            santosh.balid Santosh Balid (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Could you please look into this issue.

            Regards,
            Santosh

            Cc: Ganesh Sadawarte, Umesh Kadam, Satya, Samir

            Show
            santosh.balid Santosh Balid (Inactive) added a comment - Hi Prasanna Karlekar , Could you please look into this issue. Regards, Santosh Cc: Ganesh Sadawarte , Umesh Kadam , Satya , Samir
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment - - edited

            Hi Raymond Williams,

            Following are the 3Cs:
            Concern:
            Scheduled Reports have failed last 2 weeks

            Cause:
            Reports related patch was deployed in Production environment on 25-Nov-2017. In this patch, there were database as well as business logic changes related to Static Reports. Latest report dll was not deployed for Report Scheduler service but database related changes were updated for all companies. Due to this there was mismatch in code and database which caused error while processing report. This has only impacted the schedules related to Static Reports. WT-12614_ImpactedReportSchedules.xlsx contains list of failed schedules.

            Correction:
            Latest reports dll is now deployed for Report Scheduler Service. Scheduled reports will get delivered as per their upcoming schedules.

            Please let us know if any more details are required.

            Thank you!

            cc: Gaurav Sodani, Satya, [~parmeshwar.jumbade], Ashwin Wankhede

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - - edited Hi Raymond Williams , Following are the 3Cs: Concern: Scheduled Reports have failed last 2 weeks Cause: Reports related patch was deployed in Production environment on 25-Nov-2017. In this patch, there were database as well as business logic changes related to Static Reports. Latest report dll was not deployed for Report Scheduler service but database related changes were updated for all companies. Due to this there was mismatch in code and database which caused error while processing report. This has only impacted the schedules related to Static Reports. WT-12614_ImpactedReportSchedules.xlsx contains list of failed schedules. Correction: Latest reports dll is now deployed for Report Scheduler Service. Scheduled reports will get delivered as per their upcoming schedules. Please let us know if any more details are required. Thank you! cc: Gaurav Sodani , Satya , [~parmeshwar.jumbade] , Ashwin Wankhede
            Hide
            Raywill Raymond Williams (Inactive) added a comment -
            Show
            Raywill Raymond Williams (Inactive) added a comment - Thanks Prasanna Karlekar !

              People

              Assignee:
              Raywill Raymond Williams (Inactive)
              Reporter:
              Raywill Raymond Williams (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 8h
                  8h