WORKTERRAProject Type: software

WORKTERRA

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

Export > Dead elections are not exporting on file when do not send pending term indicator is mapped

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have
    • Browser:
      Google Chrome
    • Sprint:
      WT Sprint 40 - Bugs

      Description

      Below is the observation for Dead elections scenarios tried out while checking WT-10469

      Dead elections exported on file when Do not send pending terms in case of multiple records indicator is not mapped on template and dead elections are not getting exported when this indicator is mapped

      Below are the Template details on LB

      Company Name : For QA CAISO For HSPL
      Template Names : WT_10469 _rowsie
      WT_10469_Without indicator
      Employee Name : Cu,Thai

      CC:Vinayak Kulkarni

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          aniruddha.dev Aniruddha Dev (Inactive) created issue -
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Field Original Value New Value
          Link This issue is caused by WT-10469 [ WT-10469 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Sprint WT Sprint 40 - Bugs [ 94 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Assignee Rajendra Pawar [ rajendra.pawar ] Vinayak Kulkarni [ vinayak.kulkarni ]
          Hide
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Concern: Dead enrollment is not populating on file when do not send pending term indicator is mapped.

          Cause: When we map this indicator, We get latest active enrollment and allow it to write on file, However valid dead enrollments are missed due to this check.

          Correction: We have added check to consider valid dead enrollment.

          Affected files: dbo.OES_UDF_Export_IsMultipleRecordsAllowed.UserDefinedFunction.sql

          Impacted Areas: Templates Multiple Records settings flag.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Concern: Dead enrollment is not populating on file when do not send pending term indicator is mapped. Cause: When we map this indicator, We get latest active enrollment and allow it to write on file, However valid dead enrollments are missed due to this check. Correction: We have added check to consider valid dead enrollment. Affected files: dbo.OES_UDF_Export_IsMultipleRecordsAllowed.UserDefinedFunction.sql Impacted Areas: Templates Multiple Records settings flag.
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Code Review Date 23/Oct/2017
          Code Reviewed By Rajendra Pawar [ 16501 ]
          Dev Due Date 24/Oct/2017
          Dev Estimates 12
          Developer Vinayak Kulkarni [ vinayak.kulkarni ]
          Remaining Estimate 24h [ 86400 ]
          Original Estimate 24h [ 86400 ]
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 23/Oct/17 03:15 PM
          • Time Spent:
            1h
             
            <No comment>
          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)
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Aniruddha Dev [ aniruddha.dev ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          aniruddha.dev Aniruddha Dev (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)
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) logged work - 25/Oct/17 11:50 AM
          • Time Spent:
            3h
             
            <No comment>
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Hi Vinayak,

          Verified this fix on For QA CAISO For HSPL company on LB . Issue still persists . Please check at your end and update accordingly and Reassign to me once it is fixed . Below are the details of scenario tested

          Test Employee Name : Linda,Wright
          Template Name :WT_11600_Rowise

          CC:Hrishikesh Deshpande

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Vinayak, Verified this fix on For QA CAISO For HSPL company on LB . Issue still persists . Please check at your end and update accordingly and Reassign to me once it is fixed . Below are the details of scenario tested Test Employee Name : Linda,Wright Template Name :WT_11600_Rowise CC: Hrishikesh Deshpande
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Assignee Aniruddha Dev [ aniruddha.dev ] Vinayak Kulkarni [ vinayak.kulkarni ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          Permalink
          punam.satpute Punam Satpute (Inactive) logged work - 27/Oct/17 07:27 AM
          • Time Spent:
            8.25h
             
            <No comment>
          punam.satpute Punam Satpute (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Punam Satpute [ punam.satpute ]
          punam.satpute Punam Satpute (Inactive) made changes -
          Remaining Estimate 24h [ 86400 ] 15.75h [ 56700 ]
          Time Spent 8.25h [ 29700 ]
          Worklog Id 87332 [ 87332 ]
          punam.satpute Punam Satpute (Inactive) made changes -
          Attachment WT-11600_AffectedFiles.txt [ 66151 ]
          punam.satpute Punam Satpute (Inactive) made changes -
          Code Review Date 23/Oct/2017 30/Oct/2017
          Company All Clients/Multiple Clients [ 18434 ]
          Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          Hide
          Permalink
          punam.satpute Punam Satpute (Inactive) added a comment - - edited

          Concern: WT-11600 Export > Dead elections are not exporting on file when do not send pending term indicator is mapped is reopened on LB.

          Cause : One condition is missed for dead elections in UDF.

          Correction: Now we have added condition for those employee.

          Affected files :
          1.ACAExportProcessRowwise.vb
          2.ExportProcessRowwise.vb
          3.02_UDFs/dbo.OES_UDF_Export_IsMultipleRecordsAllowed.UserDefinedFunction.sql

          Impacted Areas : Any Company --> Manual Import/Export

          Show
          punam.satpute Punam Satpute (Inactive) added a comment - - edited Concern : WT-11600 Export > Dead elections are not exporting on file when do not send pending term indicator is mapped is reopened on LB. Cause : One condition is missed for dead elections in UDF. Correction : Now we have added condition for those employee. Affected files : 1.ACAExportProcessRowwise.vb 2.ExportProcessRowwise.vb 3.02_UDFs/dbo.OES_UDF_Export_IsMultipleRecordsAllowed.UserDefinedFunction.sql Impacted Areas : Any Company --> Manual Import/Export
          punam.satpute Punam Satpute (Inactive) made changes -
          Remaining Estimate 15.75h [ 56700 ] 9.65h [ 34740 ]
          Time Spent 8.25h [ 29700 ] 14.35h [ 51660 ]
          Worklog Id 87577 [ 87577 ]
          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)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Remaining Estimate 9.65h [ 34740 ] 6.65h [ 23940 ]
          Time Spent 14.35h [ 51660 ] 17.35h [ 62460 ]
          Worklog Id 87682 [ 87682 ]
          punam.satpute Punam Satpute (Inactive) made changes -
          Assignee Punam Satpute [ punam.satpute ] Aniruddha Dev [ aniruddha.dev ]
          Permalink
          punam.satpute Punam Satpute (Inactive) logged work - 30/Oct/17 12:00 PM
          • Time Spent:
            6.1h
             
            <No comment>
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Remaining Estimate 6.65h [ 23940 ] 5.65h [ 20340 ]
          Time Spent 17.35h [ 62460 ] 18.35h [ 66060 ]
          Worklog Id 87921 [ 87921 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          aniruddha.dev Aniruddha Dev (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)
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) logged work - 31/Oct/17 01:06 PM
          • Time Spent:
            2h
             
            <No comment>
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Testing is in progress on LB. Will continue tomorrow

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Testing is in progress on LB. Will continue tomorrow
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Remaining Estimate 5.65h [ 20340 ] 3.65h [ 13140 ]
          Time Spent 18.35h [ 66060 ] 20.35h [ 73260 ]
          Worklog Id 88337 [ 88337 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Labels Manual_Export
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) logged work - 01/Nov/17 10:20 AM
          • Time Spent:
            3h
             
            <No comment>
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Verified this Fix on LB for dead elections. Working as expected. Keeping this on hold till its parent JIRA gets ready for stage

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this Fix on LB for dead elections. Working as expected. Keeping this on hold till its parent JIRA gets ready for stage
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          satyap Satya made changes -
          Environment_New LB [ 18444 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Remaining Estimate 3.65h [ 13140 ] 0.65h [ 2340 ]
          Time Spent 20.35h [ 73260 ] 23.35h [ 84060 ]
          Worklog Id 92653 [ 92653 ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Aniruddha Dev [ aniruddha.dev ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In LB Testing [ 10200 ] Resolution Setting [ 11616 ]
          Transition Time In Source Status Execution Times
          Rajendra Pawar (Inactive) made transition -
          Open In Development
          		2d 20h 1m 1
          Aniruddha Dev (Inactive) made transition -
          In LB Testing Reopen in Local
          		7h 48m 1
          Vinayak Kulkarni (Inactive) made transition -
          Reopen in Local In Development
          		15h 49m 1
          Aniruddha Dev (Inactive) made transition -
          In Development In LB Testing
          		14d 1h 13m 2
          Sachin Hingole (Inactive) made transition -
          In LB Testing Resolution Setting
          		196d 18h 19m 1

            People

            Assignee:
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
            Reporter:
            aniruddha.dev Aniruddha Dev (Inactive)
            Developer:
            Vinayak Kulkarni (Inactive)
            QA:
            Aniruddha Dev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Time Spent - 23.35h Remaining Estimate - 0.65h
                0.65h
                Logged:
                Time Spent - 23.35h Remaining Estimate - 0.65h
                23.35h