New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5470

Effective Date format issue for Employee Import

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold

      Description

      *Scenario - *
      1) On Template Settings set date format as 'YYYYMMDD'.
      2) Add Employee's effective date field in sub template and map it to 'Employee Effective Date'.
      3) Manual or Scheduled import gets failed.
      Cause -
      When system tries to convert date value string to date format, it throws an exception. Ex. ''20100101' string can not convert to Date'. Since, string value don't have any separator, CType function can not convert it to appropriate date format.
      Correction -
      Code change is needed

      This ticket is for tracking NF checkin for WT-12252

        Attachments

        1. 5470.jpg
          5470.jpg
          204 kB
        2. 5470Error.txt
          0.2 kB
        3. FinalUpdatedTestcases.xls
          28 kB

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-12252 Effective Date format issue for Employee Import

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) created issue -
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (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)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Snehal Katkar [ snehal.katkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Code Review Date 12/Dec/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Dev Due Date 12/Dec/2017
            Development Approval Yes [ 18474 ]
            Root Cause Scenario/Requirement Missed [ 18432 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Link This issue relates to WT-12252 [ WT-12252 ]
            jayshree.nagpure Jayshree Nagpure (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
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 13/Dec/17 12:13 PM
            • Time Spent:
              1h
               

              Discussion and verification on codemap

            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            hi Snehal Katkar,

            Verified on codemap
            Company - ASML
            Getting exception for employee import
            PFA : 5470Error.txt

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - hi Snehal Katkar , Verified on codemap Company - ASML Getting exception for employee import PFA : 5470Error.txt
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment 5470.jpg [ 69987 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment 5470Error.txt [ 69988 ]
            jayshree.nagpure Jayshree Nagpure (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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Snehal Katkar [ snehal.katkar ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 95939 [ 95939 ]
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Jayshree Nagpure

            Should this be reopned?
            Rakesh Roy
            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Jayshree Nagpure Should this be reopned? Rakesh Roy Nidhi.
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Hi Nidhi Kaul,

            It's the same issue which we fixed yesterday.
            Jayshree Nagpure, could you please test this scenario again.

            cc: Jaideep Vinchurkar

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Hi Nidhi Kaul , It's the same issue which we fixed yesterday. Jayshree Nagpure , could you please test this scenario again. cc: Jaideep Vinchurkar
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Hi Rashmita Dudhe,

            As discussed with Prasad Pise Could you please take this jira.
            For test scenarios you can refer test cases attached WT-12252 jira.

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise Hrishikesh Deshpande

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Hi Rashmita Dudhe , As discussed with Prasad Pise Could you please take this jira. For test scenarios you can refer test cases attached WT-12252 jira. Thanks, Jayshree cc : Rakesh Roy Prasad Pise Hrishikesh Deshpande
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Rashmita Dudhe [ rashmita.dudhe ]
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Verified on Code map consider below scenarios:
            1]Employee Initial load YES/No with effective date: Pass
            2]Employee Inial load Yes/No without Mapping effective date: Failed refer below error log
            3]Employee Initial load YES/No with effective date: blank and null replacement character: Pass
            4]Spouse Infomation Initial load YES/No with effective date: Pass
            5]Spouse Infomation Initial load YES/No with effective date: blank and null replacement character: Pass
            6]Child Infomation Initial load YES/No with effective date: Pass
            7]Child Infomation Initial load YES/No with effective date: blank and null replacement character: Pass

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.ProcessEmployee->ImportValidation.ExecuteEmployeeQueries
            ErrorMessage: The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.
            The statement has been terminated.

            Company List

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Verified on Code map consider below scenarios: 1]Employee Initial load YES/No with effective date: Pass 2]Employee Inial load Yes/No without Mapping effective date: Failed refer below error log 3]Employee Initial load YES/No with effective date: blank and null replacement character: Pass 4]Spouse Infomation Initial load YES/No with effective date: Pass 5]Spouse Infomation Initial load YES/No with effective date: blank and null replacement character: Pass 6]Child Infomation Initial load YES/No with effective date: Pass 7]Child Infomation Initial load YES/No with effective date: blank and null replacement character: Pass ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ValidateAndInsertData->ImportValidation.ProcessEmployee->ImportValidation.ExecuteEmployeeQueries ErrorMessage: The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. Company List
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 14/Dec/17 10:00 AM
            • Time Spent:
              2h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 1h [ 3600 ] 3h [ 10800 ]
            Worklog Id 96117 [ 96117 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Import getting fail for date format YYYYMMDD
            for election
            Waive
            Paycheck

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Import getting fail for date format YYYYMMDD for election Waive Paycheck
            jayshree.nagpure Jayshree Nagpure (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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Snehal Katkar [ snehal.katkar ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            This deployed on Codemap today

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - This deployed on Codemap today
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            jayshree.nagpure Jayshree Nagpure (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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on codemap
            Company - ASML

            Verified scenarios are attached in testcases
            PFA :
            Only verified demographics import - Working fine
            Other import types are not considered, as mentioned in WT-12252
            FinalUpdatedTestcases.xls

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise Suraj Sokasane Jaideep Vinchurkar

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on codemap Company - ASML Verified scenarios are attached in testcases PFA : Only verified demographics import - Working fine Other import types are not considered, as mentioned in WT-12252 FinalUpdatedTestcases.xls Thanks, Jayshree cc : Rakesh Roy Prasad Pise Suraj Sokasane Jaideep Vinchurkar
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment FinalUpdatedTestcases.xls [ 70681 ]
            jayshree.nagpure Jayshree Nagpure (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)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 22/Dec/17 02:02 PM
            • Time Spent:
              2h
               

              Testing on codemap

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 3h [ 10800 ] 5h [ 18000 ]
            Worklog Id 97653 [ 97653 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Stage Testing [ 10201 ] Resolution Setting [ 11616 ]
            Transition Time In Source Status Execution Times
            Jaideep Vinchurkar (Inactive) made transition -
            Open In Development
            		7s 1
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Reopen in Local
            		23h 39m 1
            Jaideep Vinchurkar (Inactive) made transition -
            Reopen in Local In Development
            		6d 23h 2m 1
            Jayshree Nagpure (Inactive) made transition -
            In Development In LB Testing
            		1d 20h 4m 2
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		25d 7h 53m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing Resolution Setting
            		99d 10h 59m 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Developer:
              Snehal Katkar (Inactive)
              QA:
              Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5h
                  5h