WORKTERRAProject Type: software

WORKTERRA

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

ACA 2017 Need to delete all unused data from Production DB & File Server except the latest finalized run.

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Severity:
      Complex

      Attachments

        Activity

        Ascending order - Click to sort in descending order
        kumar.chhajed Kumar Chhajed (Inactive) created issue -
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 26/Sep/17 12:40 PM
        • Time Spent:
          1.5h
           

          Discussion
          Script coding

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Field Original Value New Value
        Remaining Estimate 16h [ 57600 ]
        Original Estimate 16h [ 57600 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 16h [ 57600 ] 14.5h [ 52200 ]
        Time Spent 1.5h [ 5400 ]
        Worklog Id 81621 [ 81621 ]
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 26/Sep/17 01:02 PM
        • Time Spent:
          2h
           

          Writing Batch file

        Hide
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) added a comment -

        Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole

        Show
        kumar.chhajed Kumar Chhajed (Inactive) added a comment - Nandkumar Prabhakar Karlekar Smita Pawar Sachin Hingole
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 14.5h [ 52200 ] 12.5h [ 45000 ]
        Time Spent 1.5h [ 5400 ] 3.5h [ 12600 ]
        Worklog Id 81663 [ 81663 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status New Request [ 10029 ] Pending for Approval [ 10002 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 27/Sep/17 12:38 PM
        • Time Spent:
          6h
           

          Writing Batch File to delete the files and the folders
          Internal discussion with ramya

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 12.5h [ 45000 ] 6.5h [ 23400 ]
        Time Spent 3.5h [ 12600 ] 9.5h [ 34200 ]
        Worklog Id 81934 [ 81934 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 27/Sep/17 04:05 PM
        • Time Spent:
          2h
           

          Query testing and discussion with Kumar

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 6.5h [ 23400 ] 4.5h [ 16200 ]
        Time Spent 9.5h [ 34200 ] 11.5h [ 41400 ]
        Worklog Id 82031 [ 82031 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Approved for Development [ 10003 ] In Development [ 10007 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 28/Sep/17 12:09 PM
        • Time Spent:
          4h
           

          Discussion with Nandkumar
          Changes to Query
          Production company list
          Testing

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Remaining Estimate 4.5h [ 16200 ] 0.5h [ 1800 ]
        Time Spent 11.5h [ 41400 ] 15.5h [ 55800 ]
        Worklog Id 82219 [ 82219 ]
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 28/Sep/17 12:24 PM
        • Time Spent:
          2.5h
           

          Test Batch File and Discussion with Ramya

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
        Time Spent 15.5h [ 55800 ] 18h [ 64800 ]
        Worklog Id 82238 [ 82238 ]
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 29/Sep/17 12:20 PM
        • Time Spent:
          2.5h
           

          Unit testing the batch file

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Time Spent 18h [ 64800 ] 20.5h [ 73800 ]
        Worklog Id 82780 [ 82780 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 29/Sep/17 12:30 PM
        • Time Spent:
          1h
           

          Discussion with Kumar
          Testing on Local server

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 20.5h [ 73800 ] 21.5h [ 77400 ]
        Worklog Id 82791 [ 82791 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 03/Oct/17 04:02 PM
        • Time Spent:
          1h
           

          Query Testing

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 21.5h [ 77400 ] 22.5h [ 81000 ]
        Worklog Id 83075 [ 83075 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
        Hide
        Permalink
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Hi Nandkumar Prabhakar Karlekar,

        As per our discussion,we have written a script to fetch all the runs except those which are finalized,latest run ,runs used in IRS submission and batch file to delete zip files of those run.
        Please let us know when you are free so that we can review the same.

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , As per our discussion,we have written a script to fetch all the runs except those which are finalized,latest run ,runs used in IRS submission and batch file to delete zip files of those run. Please let us know when you are free so that we can review the same.
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 23/Oct/17 12:52 PM
        • Time Spent:
          0.5h
           

          Discussion and 1094C report run list script

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 22.5h [ 81000 ] 23h [ 82800 ]
        Worklog Id 85853 [ 85853 ]
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 26/Oct/17 01:02 PM
        • Time Spent:
          1h
           

          Internal Discussion

        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Time Spent 23h [ 82800 ] 24h [ 86400 ]
        Worklog Id 86763 [ 86763 ]
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Time Spent 24h [ 86400 ] 24.5h [ 88200 ]
        Worklog Id 88316 [ 88316 ]
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 31/Oct/17 01:59 PM
        • Time Spent:
          0.5h
           

          Internal Discussion

        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 31/Oct/17 04:02 PM
        • Time Spent:
          1h
           

          Internal discussion
          Code review
          console application analysis

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 24.5h [ 88200 ] 25.5h [ 91800 ]
        Worklog Id 88453 [ 88453 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 01/Nov/17 04:28 PM
        • Time Spent:
          5h
           

          Console application Coding and testing

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 25.5h [ 91800 ] 30.5h [ 109800 ]
        Worklog Id 88682 [ 88682 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 02/Nov/17 04:01 PM
        • Time Spent:
          3h
           

          Console app coding and Testing

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 30.5h [ 109800 ] 33.5h [ 120600 ]
        Worklog Id 88901 [ 88901 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 03/Nov/17 11:47 AM
        • Time Spent:
          4.5h
           

          Coding changes
          Unit testing on Local and LB

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 33.5h [ 120600 ] 38h [ 136800 ]
        Worklog Id 89040 [ 89040 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 06/Nov/17 01:11 PM
        • Time Spent:
          3h
           

          Testing on local and LB

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 38h [ 136800 ] 41h [ 147600 ]
        Worklog Id 89325 [ 89325 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 08/Nov/17 03:52 PM
        • Time Spent:
          2.5h
           

          Debugging issue in release mode.
          Testing

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 41h [ 147600 ] 43.5h [ 156600 ]
        Worklog Id 89763 [ 89763 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: On Hold(10207)
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Attachment PDFDeletion.pdf [ 68482 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 24/Nov/17 09:09 AM
        • Time Spent:
          1h
           

          Verification of deletion on Production

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 43.5h [ 156600 ] 44.5h [ 160200 ]
        Worklog Id 92603 [ 92603 ]
        kumar.chhajed Kumar Chhajed (Inactive) made changes -
        Time Spent 44.5h [ 160200 ] 48.5h [ 174600 ]
        Worklog Id 94533 [ 94533 ]
        Permalink
        ramya.tantry Ramya Tantry (Inactive) logged work - 04/Dec/17 12:08 PM
        • Time Spent:
          4h
           

          Internal discussion with Kumar
          HSPL copies file deletion
          Verification

        ramya.tantry Ramya Tantry (Inactive) made changes -
        Time Spent 48.5h [ 174600 ] 52.5h [ 189000 ]
        Worklog Id 94562 [ 94562 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status In Development [ 10007 ] Local Testing [ 10200 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Status Approved for production [ 10034 ] Production Testing [ 10202 ]
        Hide
        Permalink
        ramya.tantry Ramya Tantry (Inactive) added a comment -

        Completed deletion of unused IRS files to free up space on production file server of company list provided by Jennifer L using utility

        Show
        ramya.tantry Ramya Tantry (Inactive) added a comment - Completed deletion of unused IRS files to free up space on production file server of company list provided by Jennifer L using utility
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Resolution Done [ 10000 ]
        Status Production Testing [ 10202 ] Production Complete [ 10028 ]
        ramya.tantry Ramya Tantry (Inactive) made changes -
        Resolution Done [ 10000 ] Fixed [ 1 ]
        Status Production Complete [ 10028 ] Closed [ 6 ]
        Permalink
        kumar.chhajed Kumar Chhajed (Inactive) logged work - 04/Dec/17 02:25 PM
        • Time Spent:
          4h
           

          Deleting all unused data of main company from file server on production

        Transition Time In Source Status Execution Times
        Ramya Tantry (Inactive) made transition -
        New Request Pending for Approval
        		20h 39m 1
        Ramya Tantry (Inactive) made transition -
        Pending for Approval Approved for Development
        		7s 1
        Ramya Tantry (Inactive) made transition -
        Approved for Development In Development
        		21h 23m 1
        Ramya Tantry (Inactive) made transition -
        In Development In LB Testing
        		67d 9h 7m 1
        Ramya Tantry (Inactive) made transition -
        In LB Testing Pending for Stage Approval
        		4s 1
        Ramya Tantry (Inactive) made transition -
        Pending for Stage Approval Approved for Stage
        		4s 1
        Ramya Tantry (Inactive) made transition -
        Approved for Stage Stage Testing
        		5s 1
        Ramya Tantry (Inactive) made transition -
        Stage Testing Pending for Production Approval
        		3s 1
        Ramya Tantry (Inactive) made transition -
        Pending for Production Approval Approved for production
        		2s 1
        Ramya Tantry (Inactive) made transition -
        Approved for production In Production Testing
        		3s 1
        Ramya Tantry (Inactive) made transition -
        In Production Testing Production Complete
        		1m 56s 1
        Ramya Tantry (Inactive) made transition -
        Production Complete Closed
        		5s 1

          People

          Assignee:
          ramya.tantry Ramya Tantry (Inactive)
          Reporter:
          kumar.chhajed Kumar Chhajed (Inactive)
          Developer:
          Ramya Tantry (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          2 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 16h Original Estimate - 16h
              16h
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 52.5h
              52.5h