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

          Activity

          Ascending order - Click to sort in descending order
          samir Samir created issue -
          samir Samir made changes -
          Field Original Value New Value
          Sprint DMS - Fall Sprint 4 [ 163 ]
          DmitryH Dmitry (Inactive) made changes -
          Attachment test_candidates.csv [ 108766 ]
          DmitryH Dmitry (Inactive) made changes -
          Attachment prod_candidates.csv [ 108767 ]
          DmitryH Dmitry (Inactive) made changes -
          Description Data to be provided by [~DmitryH] for correction Data to be provided by [~DmitryH] 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.
          Hide
          Permalink
          samir Samir added a comment -

          Swapnil Pandhare Harshveer Singh

          Show
          samir Samir added a comment - Swapnil Pandhare Harshveer Singh
          samir Samir made changes -
          Assignee Samir [ samir ] Rushikesh Dattatray Bane [ rushikesh.bane ]
          Permalink
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) logged work - 30/May/19 10:01 PM
          • Time Spent:
            2.5h
             

            Discussion with Samir and analysis 

          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2.5h [ 9000 ]
          Worklog Id 181282 [ 181282 ]
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Attachment prod_candidates_updated.csv [ 109174 ]
          Attachment test_candidates_updated.csv [ 109175 ]
          Permalink
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) logged work - 03/Jun/19 10:31 AM
          • Time Spent:
            4h
             
            <No comment>
          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
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Time Spent 2.5h [ 9000 ] 6.5h [ 23400 ]
          Worklog Id 181429 [ 181429 ]
          rushikesh.bane Rushikesh Dattatray Bane (Inactive) made changes -
          Assignee Rushikesh Dattatray Bane [ rushikesh.bane ] Samir [ samir ]
          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  
          samir Samir made changes -
          Assignee Samir [ samir ] Swapnil Pandhare [ swapnil.pandhare ]
          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.
          samir Samir made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Dmitry [ dmitryh ]
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 04/Jun/19 05:51 AM
          • Time Spent:
            2h
             

            Analysis

          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Time Spent 6.5h [ 23400 ] 8.5h [ 30600 ]
          Worklog Id 181567 [ 181567 ]
          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    
          Permalink
          priya.dhamande Priya Dhamande (Inactive) logged work - 06/Jun/19 05:26 AM
          • Time Spent:
            1h
             

            Analysis

            Discuss

            Verification

          priya.dhamande Priya Dhamande (Inactive) made changes -
          Time Spent 8.5h [ 30600 ] 9.5h [ 34200 ]
          Worklog Id 181874 [ 181874 ]
          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.
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 4 [ 163 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5 [ 163, 164 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 4, DMS - Fall Sprint 5 [ 163, 164 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 163, 164, 165 ]
          samir Samir made changes -
          Fix Version/s Integration with SMB [ 10453 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 163, 164, 165 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7 [ 163, 164, 165, 166 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7 [ 163, 164, 165, 166 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8 [ 163, 164, 165, 166, 167 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8 [ 163, 164, 165, 166, 167 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1 [ 163, 164, 165, 166, 167, 173 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1 [ 163, 164, 165, 166, 167, 173 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 163, 164, 165, 166, 167, 173, 174 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 163, 164, 165, 166, 167, 173, 174 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3 [ 163, 164, 165, 166, 167, 173, 174, 177 ]
          samir Samir made changes -
          Status In Progress [ 3 ] On Hold [ 10507 ]
          samir Samir made changes -
          Sprint DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3 [ 163, 164, 165, 166, 167, 173, 174, 177 ] DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 163, 164, 165, 166, 167, 173, 174 ]
          Original Estimate 0h [ 0 ]
          Transition Time In Source Status Execution Times
          Rushikesh Dattatray Bane (Inactive) made transition -
          To Do In Progress
          		5d 50m 1
          Samir made transition -
          In Progress On Hold
          		91d 14h 27m 1

            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