WORKTERRAProject Type: software

WORKTERRA

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

Need to scan missing columns in history to avoid CDC error

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Harbinger
    • Module:
      BenAdmin - EDS
    • Severity:
      Simple

      Description

      Hi Sheetal Bodhale

      As we know, we sometimes get error on EDS if CDC is activated, this is specifically for stage but could be on production as well.

      We have checked this and found issue is causing due to missing columns in history table.
      On JE Dunn stage, in payroll table there are two additional fields which are not present in history table. We have added those in HSPL copy and activated CDC and no error is thrown on EDS.

      We need to scan all companies on stage and production and add missing columns. Going forward we will not create separate companies on stage or production to activate CDC.

      Let us know if you have any questions on this, Thanks.

      Satya Ganesh Sadawarte

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-9141 Remove CDC dependency from Employee Data Screens

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) created issue -
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            Hide
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Vinayak Kulkarni/Satya,

            Regenerated employee payroll history table on JE dunn stage company.
            Scanning across all over company is in progress

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Vinayak Kulkarni / Satya , Regenerated employee payroll history table on JE dunn stage company. Scanning across all over company is in progress Thanks, Sheetal Bodhale
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 53029 [ 53029 ]
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 08/Jun/17 02:20 AM
            • Time Spent:
              0.25h
               

              corrected the payroll history table
              updated the comment

            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Status In Progress [ 3 ] On Hold [ 10507 ]
            Hide
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Due to other priority task ,not able to work on it.so marking it as on Hold.

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Due to other priority task ,not able to work on it.so marking it as on Hold.
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Link This issue relates to WT-9141 [ WT-9141 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Status On Hold [ 10507 ] In Progress [ 3 ]
            akshay.mukkawar Akshay Mukkawar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            Hide
            Permalink
            akshay.mukkawar Akshay Mukkawar (Inactive) added a comment -

            There is no separate patch required for this. It has been deployed along with WT-9141 JIRA ticket, So mark this Support Activity as Closed

            Thanks,
            Akshay Mukkawar
            -----------------------------
            CC:Sheetal Bodhale,Swapnil Pandhare,Satya,Vinayak Kulkarni

            Show
            akshay.mukkawar Akshay Mukkawar (Inactive) added a comment - There is no separate patch required for this. It has been deployed along with WT-9141 JIRA ticket, So mark this Support Activity as Closed Thanks, Akshay Mukkawar ----------------------------- CC: Sheetal Bodhale , Swapnil Pandhare , Satya , Vinayak Kulkarni
            Transition Time In Source Status Execution Times
            Sheetal Bodhale (Inactive) made transition -
            Open In Progress
            		22h 35m 1
            Sheetal Bodhale (Inactive) made transition -
            In Progress On Hold
            		5d 18h 43m 1
            Akshay Mukkawar (Inactive) made transition -
            On Hold In Progress
            		105d 21h 56m 1
            Akshay Mukkawar (Inactive) made transition -
            In Progress Closed
            		35s 1

              People

              Assignee:
              sheetal.bodhale Sheetal Bodhale (Inactive)
              Reporter:
              Vinayak.Kulkarni Vinayak Kulkarni (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 - 0.25h
                  0.25h