Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1467

SMB: Data migration

    Details

    • Type: Maintenance
    • Status: On Hold
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Integration with SMB
    • Labels:
      None
    • Company:
      All Clients/Multiple Clients

      Description

      Data to be provided by Dmitry for correction

       

      Attached data for test and prod.

       

      Scope of work:

      For Candidates assigned to `adid` change `sourceUserId` to value from `candidate_id` field.

      Use `cand_email` as candidate identifier.

        Attachments

        1. test_candidates.csv
          6 kB
          Dmitry
        2. prod_candidates.csv
          4 kB
          Dmitry
        3. prod_candidates_updated.csv
          3 kB
          Rushikesh Dattatray Bane
        4. test_candidates_updated.csv
          6 kB
          Rushikesh Dattatray Bane

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          samir Samir added a comment -

          Swapnil Pandhare Harshveer Singh

          Show
          samir Samir added a comment - Swapnil Pandhare Harshveer Singh
          Hide
          Permalink
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) added a comment -

          Hi Samir,

           

          As discussed, I verified the records against the query which you provided.
          There were very few records in the database which matched the records as in attached sheets.

           

          I have marked the status as done whichever I found as matching. PFA the updated sheets. test_candidates_updated.csv prod_candidates_updated.csv

          Also, I think we should review the data and the query for search as I found very fewer rows.

          Regards,

          Rushikesh

          Show
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) added a comment - Hi Samir ,   As discussed, I verified the records against the query which you provided. There were very few records in the database which matched the records as in attached sheets.   I have marked the status as done whichever I found as matching. PFA the updated sheets.  test_candidates_updated.csv   prod_candidates_updated.csv Also, I think we should review the data and the query for search as I found very fewer rows. Regards, Rushikesh
          Hide
          Permalink
          DmitryH Dmitry (Inactive) added a comment -

          Hi Samir Rushikesh Dattatray Bane

          This issue is still open for SMB. This is entry from our prod logs:

          15:00:20.677 i-040b8eff81de0efdb /docker/ecs-ats-mapo-tofu-produs-105-ats-mapo-tofu-produs.log time="2019-06-03T19:00:20Z" level=error msg="[code: 500 Error calling DMS API to preview offer letter for accountDID \"A7F0PT78MTMZ470WBBT\": Cannot call DMS API preview offer letter: Actual response status 409; Expected 200, Body \{ \"sourceUserId\": \"Given EmailId exist with another SourceUserId. Please give correct sourceuserid for this email.\" }]"

          1) Do you need any additional data from our side to fully close the issue?

          2) Can you please check and fix error above

          3) Can you please make message more descriptive so we can identify what exactly is wrong with data (email address, account did and etc)

          Thanks

          Dmitry

           

          Show
          DmitryH Dmitry (Inactive) added a comment - Hi Samir Rushikesh Dattatray Bane This issue is still open for SMB. This is entry from our prod logs: 15:00:20.677 i-040b8eff81de0efdb /docker/ecs-ats-mapo-tofu-produs-105-ats-mapo-tofu-produs.log time="2019-06-03T19:00:20Z" level=error msg=" [code: 500 Error calling DMS API to preview offer letter for accountDID \"A7F0PT78MTMZ470WBBT\": Cannot call DMS API preview offer letter: Actual response status 409; Expected 200, Body \{ \"sourceUserId\": \"Given EmailId exist with another SourceUserId. Please give correct sourceuserid for this email.\" }] " 1) Do you need any additional data from our side to fully close the issue? 2) Can you please check and fix error above 3) Can you please make message more descriptive so we can identify what exactly is wrong with data (email address, account did and etc) Thanks Dmitry  
          Hide
          Permalink
          samir Samir added a comment -

          Hi  Swapnil Pandhare,

          Can you please check this on priority

          Regards,

          Samir

          Show
          samir Samir added a comment - Hi  Swapnil Pandhare , Can you please check this on priority Regards, Samir
          Hide
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          CC: Samir

          Hi Dmitry,

          We found below request logged with HttpStatus :409

          "{\"generateDocumentDto\":{\"payload\":

          {\"SourceProduct\":\"SMBHire\",\"SourceUserId\":\"10\",\"FirstName\":\"test\",\"LastName\":\"test\",\"Email\":\"ritika.sharma@careerbuilder.com\",\"PrimaryPhone\":\"5555555477\",\"AddressLine1\":\"811 Vinings Parkway Southeast\",\"AddressLine2\":\"\",\"City\":\"Smyrna\",\"State\":\"GA\",\"ZipCode\":\"30080\",\"CountryCode\":\"US\",\"RequisitionId\":\"13\",\"SupervisorName\":\"John Johnson\",\"SupervisorTitle\":\"\",\"EmploymentType\":\"ETFE\",\"Department\":\"\",\"Location\":\"\",\"OfferDate\":\"04\/17\/2019\",\"Title\":\"TEST Software Developer\",\"CompensationType\":\"\",\"WageSchedule\":\"annual\",\"OfferPaySchedule\":\"weekly\",\"Rate\":50000.0,\"Currency\":\"USD\",\"WorkSchedule\":0,\"WorkScheduleUnit\":\"\",\"WorkScheduleFrequency\":\"\",\"CompensationDays\":10,\"EligiblePTODays\":20,\"AssignmentType\":\"Offer\",\"DateOfHire\":\"04\/17\/2019\",\"Responsibility\":\"Develop and implement new software programs\",\"BenefitsAndEligibility\":\"benefits_and_eligibility\",\"OfferId\":\"\"}

          ,\"templateId\":412,\"sendDocument\":false}}"

           

          In this request, emailaddress :"ritika.sharma@careerbuilder.com" is sent with "SourceUserId":"10". In DMS db, for this email address, sourceuserId stored is 11 previously. Also, in excel attached this email address has 3 different candidate ids. Please confirm, which one to keep. Accordingly, we will update in DMS.

           

          Thanks,

          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC: Samir Hi Dmitry , We found below request logged with HttpStatus :409 "{\"generateDocumentDto\":{\"payload\": {\"SourceProduct\":\"SMBHire\",\"SourceUserId\":\"10\",\"FirstName\":\"test\",\"LastName\":\"test\",\"Email\":\"ritika.sharma@careerbuilder.com\",\"PrimaryPhone\":\"5555555477\",\"AddressLine1\":\"811 Vinings Parkway Southeast\",\"AddressLine2\":\"\",\"City\":\"Smyrna\",\"State\":\"GA\",\"ZipCode\":\"30080\",\"CountryCode\":\"US\",\"RequisitionId\":\"13\",\"SupervisorName\":\"John Johnson\",\"SupervisorTitle\":\"\",\"EmploymentType\":\"ETFE\",\"Department\":\"\",\"Location\":\"\",\"OfferDate\":\"04\/17\/2019\",\"Title\":\"TEST Software Developer\",\"CompensationType\":\"\",\"WageSchedule\":\"annual\",\"OfferPaySchedule\":\"weekly\",\"Rate\":50000.0,\"Currency\":\"USD\",\"WorkSchedule\":0,\"WorkScheduleUnit\":\"\",\"WorkScheduleFrequency\":\"\",\"CompensationDays\":10,\"EligiblePTODays\":20,\"AssignmentType\":\"Offer\",\"DateOfHire\":\"04\/17\/2019\",\"Responsibility\":\"Develop and implement new software programs\",\"BenefitsAndEligibility\":\"benefits_and_eligibility\",\"OfferId\":\"\"} ,\"templateId\":412,\"sendDocument\":false}}"   In this request, emailaddress :"ritika.sharma@careerbuilder.com" is sent with "SourceUserId":"10". In DMS db, for this email address, sourceuserId stored is 11 previously. Also, in excel attached this email address has 3 different candidate ids. Please confirm, which one to keep. Accordingly, we will update in DMS.   Thanks, Swapnil P.
          Hide
          Permalink
          DmitryH Dmitry (Inactive) added a comment -

          Swapnil Pandhare I see no ritika.sharma@careerbuilder.com in production spreadsheet so it should not be a problem for Prod.

          For Test environment please use SourceUserId 11 for ritika.sharma@careerbuilder.com

           

          CC Samir

           

           

          Show
          DmitryH Dmitry (Inactive) added a comment - Swapnil Pandhare I see no ritika.sharma@careerbuilder.com  in production spreadsheet so it should not be a problem for Prod. For Test environment please use SourceUserId 11 for ritika.sharma@careerbuilder.com   CC Samir    
          Hide
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Dmitry,

          On DMS production, from your excelsheet only below two users are there with their Sourceuserid in DMS : 

          candidate@gmail.com 1
          shubham.dixit@careerbuilder.com 59

          Please let us know if you need more information on this.

           

          Thanks,

          Swapnil p.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Dmitry , On DMS production, from your excelsheet only below two users are there with their Sourceuserid in DMS :  candidate@gmail.com 1 shubham.dixit@careerbuilder.com 59 Please let us know if you need more information on this.   Thanks, Swapnil p.

            People

            Assignee:
            DmitryH Dmitry (Inactive)
            Reporter:
            samir Samir
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Time Tracking

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