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
            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
            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
            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
            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
            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
            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

              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