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

            santosh.balid Santosh Balid (Inactive) logged work - 04/Dec/17 11:14 AM
            • Time Spent:
              3h
               
              <No comment>
            Raywill Raymond Williams (Inactive) created issue -
            Raywill Raymond Williams (Inactive) made changes -
            Field Original Value New Value
            Link This issue causes CT-3544 [ CT-3544 ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Assignee Satya [ ID10004 ] Santosh Balid [ santosh.balid ]
            santosh.balid Santosh Balid (Inactive) made changes -
            Status New [ 10508 ] In Analysis [ 10008 ]
            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
            santosh.balid Santosh Balid (Inactive) made changes -
            Assignee Santosh Balid [ santosh.balid ] Raymond Williams [ raywill ]
            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.
            Raywill Raymond Williams (Inactive) made changes -
            Assignee Raymond Williams [ raywill ] Santosh Balid [ santosh.balid ]
            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
            santosh.balid Santosh Balid (Inactive) made changes -
            Assignee Santosh Balid [ santosh.balid ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-12622 [ WT-12622 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 05/Dec/17 02:24 PM
            • Time Spent:
              1h
               

              Internal discussion and check existing schedules failed reason

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 94766 [ 94766 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Comment [ Hi [~Raywill],

            We are in between our analysis and will provide details update tomorrow EOD.

            CC: [~prasanna] [~gaurav.sodani] ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            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
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Raymond Williams [ raywill ]
            Resolution Fixed [ 1 ]
            Status In Analysis [ 10008 ] Closed [ 6 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 05/Dec/17 06:00 PM
            • Time Spent:
              4h
               

              Issue analysis
              Pair programming : Discussion on error logged in Report Scheduler table
              Issue discussion with Export, ACA and deployment team
              Data scan script
              JIRA update

            Hide
            Raywill Raymond Williams (Inactive) added a comment -
            Show
            Raywill Raymond Williams (Inactive) added a comment - Thanks Prasanna Karlekar !
            santosh.balid Santosh Balid (Inactive) made changes -
            Time Spent 1h [ 3600 ] 4h [ 14400 ]
            Worklog Id 95582 [ 95582 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 4h [ 14400 ] 8h [ 28800 ]
            Worklog Id 99100 [ 99100 ]
            Transition Time In Source Status Execution Times
            Santosh Balid (Inactive) made transition -
            NEW In Analysis
            19m 43s 1
            Prasanna Karlekar (Inactive) made transition -
            In Analysis Closed
            22h 8m 1

              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