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

WORKterra - Service Schedular Error Notification

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Company:
      City of Oceanside
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 38 - Bugs

      Description

      Enable employee login service :
      Error Source : EnableEmployeesLogin.EnableLogin
      Error Description : Conversion from type 'DBNull' to type 'Date' is not valid.

        Attachments

          Activity

          swapnil.pandhare Swapnil Pandhare (Inactive) created issue -
          satyap Satya made changes -
          Field Original Value New Value
          Assignee Vijay Siddha [ vijays ] Swapnil Pandhare [ swapnil.pandhare ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Error email:-
          Dear Admin,

          Service Schedular - Enable Employees Login for New Hire execution failed for following companies:
          Company : City of Oceanside
          .
          Kindly refer the detailed log datewise in folder ServiceSchedularErrorLog.

          Thank You,

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Error email:- Dear Admin, Service Schedular - Enable Employees Login for New Hire execution failed for following companies: Company : City of Oceanside . Kindly refer the detailed log datewise in folder ServiceSchedularErrorLog. Thank You,
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Sheetal Bodhale [ sheetal.bodhale ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Sprint WT Sprint 38 - Bugs [ 89 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)Level 1 values: In Analysis(10204)
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 29/Sep/17 06:08 AM
          • Time Spent:
            3.4h
             

            Service code latest,resolved code issue
            discussion with Vinanti
            Tried to reproduce the scenario

          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 3.4h [ 12240 ]
          Worklog Id 82509 [ 82509 ]
          sheetal.bodhale Sheetal Bodhale (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
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi Rakesh Roy,

          Please find below 3C's of the issue,
          Concern: WORKterra - Service Schedular Error Notification

          Cause: Null condition is not handled in case enrollment opening and closing date.

          Correction: Handled null condition.

          CC:Swapnil PandhareSatya

          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Rakesh Roy , Please find below 3C's of the issue, Concern: WORKterra - Service Schedular Error Notification Cause: Null condition is not handled in case enrollment opening and closing date. Correction: Handled null condition. CC: Swapnil Pandhare Satya Thanks, Sheetal Bodhale
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 3.4h [ 12240 ] 7.9h [ 28440 ]
          Worklog Id 82856 [ 82856 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 30/Sep/17 01:22 AM
          • Time Spent:
            4.5h
             

            reproducing the issue
            code debugging
            coding
            review request

          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 03/Oct/17 11:20 AM
          • Time Spent:
            0.5h
             

            Discussion and Code review

          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 7.9h [ 28440 ] 8.4h [ 30240 ]
          Worklog Id 82978 [ 82978 ]
          sheetal.bodhale Sheetal Bodhale (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)
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 8.4h [ 30240 ] 9.4h [ 33840 ]
          Worklog Id 83031 [ 83031 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 04/Oct/17 01:40 AM
          • Time Spent:
            1h
             

            Unit testing with null and correct dates
            Code check in in trunk and LB
            Discussion with Swapnil

          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Developer Sheetal Bodhale [ sheetal.bodhale ]
          Original Estimate 0h [ 0 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Code Reviewed By Swapnil Pandhare [ 11900 ]
          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)
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Assignee Sheetal Bodhale [ sheetal.bodhale ] Rakesh Roy [ rakeshr ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Prasad Pise [ prasadp ]
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Meghana Joshi [ meghana.kulkarni ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Production Due Date 11/Oct/2017
          Stage Due Date 9/Oct/17 [ 2017-10-09 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Dev Due Date 29/Sep/2017
          QA Meghana Joshi [ meghana.kulkarni ]
          meghana.joshi Meghana Joshi (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)
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 9.4h [ 33840 ] 9.65h [ 34740 ]
          Worklog Id 83371 [ 83371 ]
          Hide
          meghana.joshi Meghana Joshi (Inactive) added a comment -

          Verified above issue on LB.
          Service is executed Properly.

          As it is company specific issue , Will verify on Stage - City of Oceanside.

          CC - Sachin Hingole

          Show
          meghana.joshi Meghana Joshi (Inactive) added a comment - Verified above issue on LB. Service is executed Properly. As it is company specific issue , Will verify on Stage - City of Oceanside. CC - Sachin Hingole
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Time Spent 9.65h [ 34740 ] 12.65h [ 45540 ]
          Worklog Id 83393 [ 83393 ]
          meghana.joshi Meghana Joshi (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)
          Hide
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Affected File: EnableEmployeesLogin.vb (service scheduler)

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Affected File: EnableEmployeesLogin.vb (service scheduler)
          meghana.joshi Meghana Joshi (Inactive) logged work - 05/Oct/17 12:44 PM
          • Time Spent:
            3h
             

            LB testing

          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 05/Oct/17 08:56 PM
          • Time Spent:
            0.25h
             

            Discussion with Meghana

          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)
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Production Due Date 11/Oct/2017 18/Oct/2017
          Stage Due Date 9/Oct/17 [ 2017-10-09 ] 10/Oct/17 [ 2017-10-10 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          Hide
          meghana.joshi Meghana Joshi (Inactive) added a comment -

          Verified on Stage.

          Working Fine.

          CC - Sachin Hingole

          Show
          meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on Stage. Working Fine. CC - Sachin Hingole
          meghana.joshi Meghana Joshi (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)
          meghana.joshi Meghana Joshi (Inactive) logged work - 12/Oct/17 12:36 PM
          • Time Spent:
            2h
             

            Stage Testing

          meghana.joshi Meghana Joshi (Inactive) made changes -
          Time Spent 12.65h [ 45540 ] 14.65h [ 52740 ]
          Worklog Id 84567 [ 84567 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Time Spent 14.65h [ 52740 ] 14.9h [ 53640 ]
          Worklog Id 84784 [ 84784 ]
          sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 13/Oct/17 07:53 PM
          • Time Spent:
            0.25h
             

            Production code check in

          ashwin.wankhede Ashwin Wankhede (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)
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          meghana.joshi Meghana Joshi (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)
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Production Due Date 18/Oct/2017 14/Oct/2017
          meghana.joshi Meghana Joshi (Inactive) logged work - 16/Oct/17 11:06 AM
          • Time Spent:
            1h
             

            Production Testing

          meghana.joshi Meghana Joshi (Inactive) made changes -
          Time Spent 14.9h [ 53640 ] 15.9h [ 57240 ]
          Worklog Id 85256 [ 85256 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          meghana.joshi Meghana Joshi (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          meghana.joshi Meghana Joshi (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)
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Sheetal Bodhale (Inactive) made transition -
          Open In Development
          2d 7h 47m 1
          Rakesh Roy (Inactive) made transition -
          In Development In LB Testing
          5d 23h 53m 1
          Meghana Joshi (Inactive) made transition -
          In LB Testing Stage Testing
          6d 20h 57m 1
          Meghana Joshi (Inactive) made transition -
          Stage Testing In Production Testing
          4d 20h 53m 1
          Meghana Joshi (Inactive) made transition -
          In Production Testing Production Complete
          6h 26m 1
          Meghana Joshi (Inactive) made transition -
          Production Complete Closed
          5s 1

            People

            Assignee:
            meghana.joshi Meghana Joshi (Inactive)
            Reporter:
            swapnil.pandhare Swapnil Pandhare (Inactive)
            Developer:
            Sheetal Bodhale (Inactive)
            QA:
            Meghana Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

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

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 15.9h
                15.9h