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

ACA 1095C Report - lock must be released if error occurred while processing the report & also report run must be deleted.

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Admin, Partner
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      When we run any 1095-C report, we lock the report by setting a flag IsLocked to true under ACA_1095CLockReportRun table and then release it after the process is completed.
      But in-case if any error occurred in between of the processing then the lock is not released and user is not able to re-run that particular report again. (It shows no-records found message )

      CC Smita Pawar Nandkumar Prabhakar Karlekar

        Attachments

          Activity

          kumar.chhajed Kumar Chhajed (Inactive) created issue -
          umesh.kolhe Umesh Kolhe (Inactive) logged work - 13/Jul/17 01:03 PM
          • Time Spent:
            8h
             
            <No comment>
          umesh.kolhe Umesh Kolhe (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 16h [ 57600 ] 8h [ 28800 ]
          Time Spent 8h [ 28800 ]
          Worklog Id 63126 [ 63126 ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 13/Jul/17 02:24 PM
          • Time Spent:
            1h
             

            Discussion with Umesh
            LOG JIRA

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 7h [ 25200 ]
          Time Spent 8h [ 28800 ] 9h [ 32400 ]
          Worklog Id 63186 [ 63186 ]
          umesh.kolhe Umesh Kolhe (Inactive) logged work - 14/Jul/17 11:18 AM
          • Time Spent:
            6h
             
            <No comment>
          umesh.kolhe Umesh Kolhe (Inactive) made changes -
          Remaining Estimate 7h [ 25200 ] 1h [ 3600 ]
          Time Spent 9h [ 32400 ] 15h [ 54000 ]
          Worklog Id 63380 [ 63380 ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 14/Jul/17 02:09 PM
          • Time Spent:
            3h
             

            Discusison with umesh
            Coding

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
          Time Spent 15h [ 54000 ] 18h [ 64800 ]
          Worklog Id 63541 [ 63541 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Umesh Kolhe [ umesh.kolhe ] Kumar Chhajed [ kumar.chhajed ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Summary ACA 1095C Report - lock must be released if error occurred while processing the report. ACA 1095C Report - lock must be released if error occurred while processing the report & also report run must be deleted.
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Code Reviewed By Harshawardhan Phalake [ 15301 ] Ramya Tantry [ 13001 ]
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 18/Jul/17 01:27 PM
          • Time Spent:
            1h
             

            Code Review
            Internal discussion
            Coding
            Unit testing

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 18h [ 64800 ] 19h [ 68400 ]
          Worklog Id 64337 [ 64337 ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Description When we run any 1095-C report, we lock the report by setting a flag *IsLocked* to true under *ACA_1095CLockReportRun* table and then release it after the process is completed.
          But in-case if any error occurred in between of the processing then the lock is not released and user is not able to re-run that particular report again.

          CC [~smita.pawar] [~nandkumar]
          When we run any 1095-C report, we lock the report by setting a flag *IsLocked* to true under *ACA_1095CLockReportRun* table and then release it after the process is completed.
          But in-case if any error occurred in between of the processing then the lock is not released and user is not able to re-run that particular report again. (It shows no-records found message )

          CC [~smita.pawar] [~nandkumar]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Assignee Kumar Chhajed [ kumar.chhajed ] Smita Pawar [ smita.pawar ]
          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited

          Hi Smita Pawar,

          I have committed code for this JIRA to LB (old) & Ui-Refresh also , so please make sure that you test this on both the environment as we need to push this JIRA to production also.
          The fix will be deployed after tomorrow's build.
          Please revert in-case you have any queries.

          Thanks,
          Kumar Chhajed

          CC Nandkumar Prabhakar Karlekar

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited Hi Smita Pawar , I have committed code for this JIRA to LB (old) & Ui-Refresh also , so please make sure that you test this on both the environment as we need to push this JIRA to production also. The fix will be deployed after tomorrow's build. Please revert in-case you have any queries. Thanks, Kumar Chhajed CC Nandkumar Prabhakar Karlekar
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 19/Jul/17 01:01 PM
          • Time Spent:
            1h
             

            Code Check-ins
            Internal disscusion

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 19h [ 68400 ] 20h [ 72000 ]
          Worklog Id 64727 [ 64727 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          smita.pawar Smita Pawar (Inactive) made changes -
          Production Due Date 23/Aug/2017
          Stage Due Date 18/Aug/17 [ 2017-08-18 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Stage Due Date 18/Aug/17 [ 2017-08-18 ] 21/Aug/17 [ 2017-08-21 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Production Due Date 23/Aug/2017 29/Aug/2017
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          smita.pawar Smita Pawar (Inactive) logged work - 18/Aug/17 12:11 PM
          • Time Spent:
            3h
             

            LB testing

          kumar.chhajed Kumar Chhajed (Inactive) logged work - 18/Aug/17 01:58 PM
          • Time Spent:
            1h
             

            Discussion with QA

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 20h [ 72000 ] 21h [ 75600 ]
          Worklog Id 72779 [ 72779 ]
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on LB and Azure environment.
          Its working fine.
          Tested scenarios are as follows.

          1.Checked whether no error received while downloading the report when error occurred while processing previous run.
          2.Checked there is no entry of previous run for which report was locked.
          3.There was message of 'No records found' when report was locked.

          This fix is ready for stage.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB and Azure environment. Its working fine. Tested scenarios are as follows. 1.Checked whether no error received while downloading the report when error occurred while processing previous run. 2.Checked there is no entry of previous run for which report was locked. 3.There was message of 'No records found' when report was locked. This fix is ready for stage.
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 21h [ 75600 ] 24h [ 86400 ]
          Worklog Id 73403 [ 73403 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on stage [ASML for Hspl].
          Its working fine.

          Tested scenarios are as follows.
          1.Checked whether no error received while downloading the report when error occurred while processing previous run.
          2.Checked there is no entry of previous run for which report was locked.
          3.There was message of 'No records found' when report was locked.
          This fix is ready for stage.

          Fix is ready for production.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on stage [ASML for Hspl] . Its working fine. Tested scenarios are as follows. 1.Checked whether no error received while downloading the report when error occurred while processing previous run. 2.Checked there is no entry of previous run for which report was locked. 3.There was message of 'No records found' when report was locked. This fix is ready for stage. Fix is ready for production.
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          kumar.chhajed Kumar Chhajed (Inactive) logged work - 23/Aug/17 02:34 PM
          • Time Spent:
            1h
             

            Testing with smita

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 24h [ 86400 ] 25h [ 90000 ]
          Worklog Id 73899 [ 73899 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          smita.pawar Smita Pawar (Inactive) logged work - 24/Aug/17 11:14 AM
          • Time Spent:
            2.5h
             

            Testing
            Internal discussion

          kumar.chhajed Kumar Chhajed (Inactive) logged work - 24/Aug/17 01:17 PM
          • Time Spent:
            2h
             

            Testing on production
            Internal discussion

          kumar.chhajed Kumar Chhajed (Inactive) made changes -
          Time Spent 25h [ 90000 ] 27h [ 97200 ]
          Worklog Id 74125 [ 74125 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on Production. [Asml for hspl]

          1.Checked whether no error received while downloading the report when error occurred while processing previous run.
          2.Checked there is no entry of previous run for which report was locked.
          3.There was message of 'No records found' when report was locked.

          Its working fine.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production. [Asml for hspl] 1.Checked whether no error received while downloading the report when error occurred while processing previous run. 2.Checked there is no entry of previous run for which report was locked. 3.There was message of 'No records found' when report was locked. Its working fine.
          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 27h [ 97200 ] 29.5h [ 106200 ]
          Worklog Id 75210 [ 75210 ]
          smita.pawar Smita Pawar (Inactive) logged work - 30/Aug/17 11:17 AM
          • Time Spent:
            0.25h
             

            Jira updates

          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 29.5h [ 106200 ] 29.75h [ 107100 ]
          Worklog Id 75212 [ 75212 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Kumar Chhajed (Inactive) made transition -
          Open In Development
          5d 4h 55m 1
          Kumar Chhajed (Inactive) made transition -
          In Development In LB Testing
          21h 29m 1
          Smita Pawar (Inactive) made transition -
          In LB Testing Stage Testing
          35d 2h 1
          Smita Pawar (Inactive) made transition -
          Stage Testing In Production Testing
          6d 23h 57m 1
          Smita Pawar (Inactive) made transition -
          In Production Testing Production Complete
          50s 1

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            kumar.chhajed Kumar Chhajed (Inactive)
            QA:
            Smita Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Pre-Prod Due Date:
              Production Due Date:

                Time Tracking

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