Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-1300

Bullhorn Integration->Different validation messages are displaying while reassigning tours.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Integrations
    • Labels:
      None
    • Bug Type:
      Functional
    • Module:
      Bullhorn
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Q2

      Description

      1] Access the tour details page using below URL:
      https://10.0.2.120/api/app/TourListing/ListTours?requestFrom=wRnQ7Y%2fZWlCOXjmz9IS4jw%3d%3d&userName=%2bsj2KXYNrgm8O4Va%2bHPUTQ%3d%3d&password=T6NiPfpN8kLQSGDeUamNAw%3d%3d&corporationID=9587&entityType=Placement&entityID=3
      2] Assign Onboard and Onboard Second tour.
      3] Try to assign same tours again by clicking "Assign Tour" button.

      Actual Result:
      While reassigning "Onboard" tour again below message is displaying:
      "Employee Tour record with supplied Job Id & Tour Id already exists"
      While reassigning "Onboard" tour again below message is displaying:
      Employee record added with EmployeeID: E1247 but tour assignment failed
      Refer attached screenshot for more details.

      Cc: Saurabh Sablaka, Prasad Pise, Ramya Tantry

        Attachments

          Issue Links

            Activity

            kunal.kedari Kunal Kedari (Inactive) created issue -
            seema.gaikwad Seema Gaikwad (Inactive) logged work - 04/May/17 11:30 AM
            • Time Spent:
              1h
               

              Debugging.

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Field Original Value New Value
            Assignee Seema Gaikwad [ seema.gaikwad ] Ramya Tantry [ ramya.tantry ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected:

            WORKTERRAweb/Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_ValidateEmployeeTourRecord.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: WORKTERRAweb/Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_ValidateEmployeeTourRecord.sql
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern:Different validation messages are displaying while reassigning tours.
            Cause: As only one entry of this candidate of a particular tour id is present in Employee Source, when next tour id is assigned to employee,validation check fails and this caused different messages to be displayed.
            Correction: Condition of checking tour id is removed from employee source and only employee tour mapping is considered.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern :Different validation messages are displaying while reassigning tours. Cause : As only one entry of this candidate of a particular tour id is present in Employee Source, when next tour id is assigned to employee,validation check fails and this caused different messages to be displayed. Correction : Condition of checking tour id is removed from employee source and only employee tour mapping is considered.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Remaining Estimate 6h [ 21600 ]
            Original Estimate 6h [ 21600 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 04/May/17 12:28 PM - edited
            • Time Spent:
              2.5h
               

              Issue debugging and fixing
              Unit testing

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 4h [ 14400 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 43159 [ 43159 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            seema.gaikwad Seema Gaikwad (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 3h [ 10800 ]
            Time Spent 2h [ 7200 ] 3h [ 10800 ]
            Worklog Id 43267 [ 43267 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 2.5h [ 9000 ]
            Time Spent 3h [ 10800 ] 3.5h [ 12600 ]
            Worklog Id 43159 [ 43159 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Code Review Date 04/May/2017
            Code Reviewed By Saurabh Sablaka [ 11909 ]
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Kunal Kedari,

            Please verify the issue.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Kunal Kedari , Please verify the issue.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Kunal Kedari [ kunal.kedari ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            We have verified the issue, now same message is displaying after reassigning different tours. Can move fix to Stage.

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - We have verified the issue, now same message is displaying after reassigning different tours. Can move fix to Stage.
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Now message with same text is displaying while reassigning different tours on Stage. Below is the message text:
            "Employee Tour record with supplied Job Id & Tour Id already exists"

            Marking it is "Production Deployment On Hold"

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Now message with same text is displaying while reassigning different tours on Stage. Below is the message text: "Employee Tour record with supplied Job Id & Tour Id already exists" Marking it is "Production Deployment On Hold"
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Link This issue relates to NF-946 [ NF-946 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            Hide
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Verified fix on Production:
            Message with same text is displaying while reassigning different tours on Stage. Below is the message text:
            "Employee Tour record with supplied Job Id & Tour Id already exists"

            Closing ticket.
            Cc: Prasad Pise, Saurabh Sablaka

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Verified fix on Production: Message with same text is displaying while reassigning different tours on Stage. Below is the message text: "Employee Tour record with supplied Job Id & Tour Id already exists" Closing ticket. Cc: Prasad Pise , Saurabh Sablaka
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            kunal.kedari Kunal Kedari (Inactive) logged work - 23/Jun/17 05:21 PM
            • Time Spent:
              0.25h
               

              Testing on Production

            kunal.kedari Kunal Kedari (Inactive) made changes -
            Remaining Estimate 2.5h [ 9000 ] 2.25h [ 8100 ]
            Time Spent 3.5h [ 12600 ] 3.75h [ 13500 ]
            Worklog Id 59043 [ 59043 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            2h 45m 1
            Ramya Tantry (Inactive) made transition -
            In Development In LB Testing
            3d 19h 12m 1
            Kunal Kedari (Inactive) made transition -
            In LB Testing Stage Testing
            11d 4h 50m 1
            Kunal Kedari (Inactive) made transition -
            Stage Testing In Production Testing
            34d 16h 27m 1
            Kunal Kedari (Inactive) made transition -
            In Production Testing Production Complete
            6s 1
            Kunal Kedari (Inactive) made transition -
            Production Complete Closed
            3s 1

              People

              Assignee:
              kunal.kedari Kunal Kedari (Inactive)
              Reporter:
              kunal.kedari Kunal Kedari (Inactive)
              QA:
              Kunal Kedari (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 - 6h
                  6h
                  Remaining:
                  Time Spent - 3.75h Remaining Estimate - 2.25h
                  2.25h
                  Logged:
                  Time Spent - 3.75h Remaining Estimate - 2.25h
                  3.75h