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

Import Recruit-DTS not showing for JOB data type import

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      Production Complete

      Description

      1]created JOB Data type import and candidate data type import template
      2]Mapped Filed with data base values properly.
      3]On DT screen it not showing single value also on SUB template page.
      Refer below screen shots

      4]On Stage it showing Properly for job data import

        Attachments

          Issue Links

            Activity

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - CC: Rakesh Roy , Hrishikesh Deshpande , Jaideep Vinchurkar
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi Rashmita Dudhe ,

            This issues has been resolved and it will deployed on LB with next deployment patch. as this issues is reported on Production, will move script from LB,stage and then production resp to maintain script consistence.

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Rashmita Dudhe , This issues has been resolved and it will deployed on LB with next deployment patch. as this issues is reported on Production, will move script from LB,stage and then production resp to maintain script consistence. Thanks !
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified On Lb Environment.
            For Job Data Import It is working properly.

            But for Candidate data Import Is getting Failed refer below error log:

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportRecruitData.ImportData->ImportRecruitData.ProcessImportDataFile->ImportRecruitData.ValidateAndInsertData->ImportRecruitData.ProcessCandidate->ImportRecruitData.GenerateCandidateInsertQuery->ImportRecruitData.ExecuteSqlQueries
            ErrorMessage: Column name or number of supplied values does not match table definition.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified On Lb Environment. For Job Data Import It is working properly. But for Candidate data Import Is getting Failed refer below error log: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportRecruitData.ImportData->ImportRecruitData.ProcessImportDataFile->ImportRecruitData.ValidateAndInsertData->ImportRecruitData.ProcessCandidate->ImportRecruitData.GenerateCandidateInsertQuery->ImportRecruitData.ExecuteSqlQueries ErrorMessage: Column name or number of supplied values does not match table definition.
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi Rashmita Dudhe ,

            This issue has been resolved. it will deployed on LB with next deployment patch.

            We found another issues that Import candidate could not login with credential :
            With current implementation , Import save plain text password and validate with plain text password but WT-7726 is done for Password Encryption so imported candidate could not able to login. we have provided code fix for the same please test this scenario also.

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi Rashmita Dudhe , This issue has been resolved. it will deployed on LB with next deployment patch. We found another issues that Import candidate could not login with credential : With current implementation , Import save plain text password and validate with plain text password but WT-7726 is done for Password Encryption so imported candidate could not able to login. we have provided code fix for the same please test this scenario also. Thanks !
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified On LB Environment consider below scenarios:
            1]Job Data Import cross check on UI
            2]Candidate data import Cross verified on Ui
            3]Also By Login to the system With Employee Email Id and Imported Password
            4]Application data Import.

            With Initial Load Ye s and No Flag

            Working fine as Expected.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified On LB Environment consider below scenarios: 1]Job Data Import cross check on UI 2]Candidate data import Cross verified on Ui 3]Also By Login to the system With Employee Email Id and Imported Password 4]Application data Import. With Initial Load Ye s and No Flag Working fine as Expected.
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified On Stage Environment consider below scenarios:
            1]Job Data Import cross check on UI
            2]Candidate data import Cross verified on Ui
            3]Also By Login to the system With Employee Email Id and Imported Password
            4]Application data Import.
            With Initial Load Ye s and No Flag
            Working fine as Expected.

            But though Scheduler it is not working created another Jira for WT-8416.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified On Stage Environment consider below scenarios: 1]Job Data Import cross check on UI 2]Candidate data import Cross verified on Ui 3]Also By Login to the system With Employee Email Id and Imported Password 4]Application data Import. With Initial Load Ye s and No Flag Working fine as Expected. But though Scheduler it is not working created another Jira for WT-8416 .

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Developer:
              Vishal Bajad (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 12h Original Estimate - 12h
                  12h
                  Remaining:
                  Time Spent - 13.5h Remaining Estimate - 3.5h
                  3.5h
                  Logged:
                  Time Spent - 13.5h Remaining Estimate - 3.5h
                  13.5h