For more information, please refer to this announcement explaining best practices for getting answers to questions.
Error loading Candidate job application.dat
Hello, everyone,
we are encountering a problem when loading job applications via hdl.
We have tried the following loading, it works fine until the QuestionResponse is inserted, METADATA|CandidateJobApplication|CandidateNumber|RequisitionNumber|CurrentPhaseCode|CurrentStateCode|ConfirmedByCandidateNumber|SubmissionConfirmedDate|SubmissionDate|SubmissionLanguageCode|SourceSystemOwner|SourceSystemId
MERGE|CandidateJobApplication|B_1637569064891|518|300000965053927|300000863018948|B_1637569064891|2021/11/22 00:00:00|2021/11/22 00:00:00|I|HRV|SUBMISSION_B_1637569064891_518
METADATA|QuestionnaireParticipant|CandidateNumber|RequisitionNumber|QuestionnaireId|SourceSystemOwner|SourceSystemId
MERGE|QuestionnaireParticipant|B_1637569064891|518|300000972717804|HRV|QUESTIONNAIRE_B_1637569064891_518
METADATA|QuestionnaireResponse|CandidateNumber|RequisitionNumber|QstnrParticipantId(SourceSystemId)|AttemptNum|SourceSystemOwner|SourceSystemId|SubmittedDateTime
MERGE|QuestionnaireResponse|B_1637569064891|518|QUESTIONNAIRE_B_1637569064891_518|1|HRV|QUESTIONNAIRE_RESP_B_1637569064891_518|2021/11/22 00:00:00
METADATA|QuestionResponse|CandidateNumber|RequisitionNumber|QstnrResponseId(SourceSystemId)|AttemptNum|QstnrQuestionId|AnswerCode|SourceSystemOwner|SourceSystemId
MERGE|QuestionResponse|B_1637569064891|518|QUESTIONNAIRE_RESP_B_1637569064891_518|1|300000854228627|300000854228629|HRV|QUESTION_RESP_B_1637569064891_518_300000854228627