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

Elite Staffing - Server error on view history for two options like Your enrollment starts here and preliminary questionnaire

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Company:
      Elite Staffing
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 39 - Bugs

      Description

      Employee details:-
      VICTOR FUENTES

        Attachments

        1. image-2017-10-05-15-38-14-770.png
          image-2017-10-05-15-38-14-770.png
          111 kB
        2. image-2017-10-05-15-38-34-517.png
          image-2017-10-05-15-38-34-517.png
          113 kB
        3. Re Request for Production deployment - 25 Nov 2017.msg
          77 kB
        4. WR-92_1.png
          WR-92_1.png
          65 kB
        5. WR-92_2.png
          WR-92_2.png
          162 kB
        6. WT-11448.png
          WT-11448.png
          64 kB
        7. WT-11448-1.png
          WT-11448-1.png
          151 kB
        8. WT-11448-2.png
          WT-11448-2.png
          132 kB

          Issue Links

            Activity

            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Company Elite Staffing [ 13522 ]
            Environment Production [ 10005 ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.CreateDataForEmployeeHistory
            ErrorMessage: Invalid column name 'WellnessDiscount31107'.
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.CreateDataForEmployeeHistory ErrorMessage: Invalid column name 'WellnessDiscount31107'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            2. University health--company has same error

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.CreateDataForEmployeeHistory
            ErrorMessage: Invalid column name 'WellnessDiscount31107'.
            StackTrace: at

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - 2. University health--company has same error ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.CreateDataForEmployeeHistory ErrorMessage: Invalid column name 'WellnessDiscount31107'. StackTrace: at
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            3. Quincy

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.CreateDataForEmployeeHistory
            ErrorMessage: Invalid column name 'WellnessDiscount31107'.
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - 3. Quincy ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.CreateDataForEmployeeHistory ErrorMessage: Invalid column name 'WellnessDiscount31107'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 39 - Bugs [ 90 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Link This issue duplicates WR-92 [ WR-92 ]
            Hide
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment -

            I found that it is a duplicate JIRA WR-92.
            The issue is already fixed.
            The JIRA WR-92 in LB testing phase.
            Once we applied same script, above issue will resolve.

            Show
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment - I found that it is a duplicate JIRA WR-92 . The issue is already fixed. The JIRA WR-92 in LB testing phase. Once we applied same script, above issue will resolve.
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Sudhir Kalikate [ sudhir.kalikate ]
            sudhir.kalikate Sudhir Kalikate (Inactive) logged work - 10/Oct/17 01:16 PM - edited
            • Time Spent:
              1h
               

              Analysis and debugging code.
              Found its duplicate JIRA.

            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ]
            Original Estimate 16h [ 57600 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 14h [ 50400 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 84174 [ 84174 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Remaining Estimate 14h [ 50400 ] 15h [ 54000 ]
            Time Spent 2h [ 7200 ] 1h [ 3600 ]
            Worklog Id 84174 [ 84174 ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Code Reviewed By Swapnil Pandhare [ 11900 ]
            Developer Sudhir Kalikate [ sudhir.kalikate ]
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment -

            LB Deployed.

            Show
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment - LB Deployed.
            sudhir.kalikate Sudhir Kalikate (Inactive) made changes -
            Assignee Sudhir Kalikate [ sudhir.kalikate ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Sanjana Jadhav [ sanjana.jadhav ]
            rakeshr Rakesh Roy (Inactive) made changes -
            QA Prasad Pise [ prasadp ] Sanjana Jadhav [ sanjana.jadhav ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sanjana.jadhav Sanjana Jadhav (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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment WR-92_1.png [ 64726 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment WR-92_2.png [ 64727 ]
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on LB.
            Company:City of Durham For HSPL
            Browser: Chrome

            Scanerios:
            1.Added new additional form "Your enrollment start here" and "spouse eligibility verification" - added form shown in document sub type->Pass
            2.enter mandatory field and verified view history for : "Your enrollment start here" , "spouse eligibility verification" and "preliminary questionnaire " ->Pass
            3.Select all additional fields and all users and verified search button functionality->Pass
            4.Verified print view history button functionality->Pass
            5.Verified reset button functionality->Pass
            Working properly.

            Ready for stage.
            PFA,

            CC: Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole

            Thanks,
            Sanjana Jadhav

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on LB. Company:City of Durham For HSPL Browser: Chrome Scanerios: 1.Added new additional form "Your enrollment start here" and "spouse eligibility verification" - added form shown in document sub type->Pass 2.enter mandatory field and verified view history for : "Your enrollment start here" , "spouse eligibility verification" and "preliminary questionnaire " ->Pass 3.Select all additional fields and all users and verified search button functionality->Pass 4.Verified print view history button functionality->Pass 5.Verified reset button functionality->Pass Working properly. Ready for stage. PFA, CC: Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole Thanks, Sanjana Jadhav
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 17/Oct/17 09:02 AM
            • Time Spent:
              0.5h
               

              Verified on LB

            sanjana.jadhav Sanjana Jadhav (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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Remaining Estimate 15h [ 54000 ] 14.5h [ 52200 ]
            Time Spent 1h [ 3600 ] 1.5h [ 5400 ]
            Worklog Id 85395 [ 85395 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Production Due Date 25/Oct/2017
            Stage Due Date 23/Oct/17 [ 2017-10-23 ]
            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)
            sanjana.jadhav Sanjana Jadhav (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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment WT-11448.png [ 65289 ]
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on stage.
            Company: Elite Staffing For HSPL
            Browser: Chrome

            Scanerios:
            1.enter mandatory field and verified view history for : "Your enrollment start here" and "preliminary questionnaire " ->Pass
            2.Select all additional fields and all users and verified search button functionality->Pass
            3.Verified print view history button functionality->Pass
            4.Verified reset button functionality->Pass

            Working properly.
            Ready for Production.
            PFA,

            CC : Rakesh Roy Hrishikesh Deshpande Prasad Pise Sachin Hingole

            Thanks,
            Sanjana Jadhav

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on stage. Company: Elite Staffing For HSPL Browser: Chrome Scanerios: 1.enter mandatory field and verified view history for : "Your enrollment start here" and "preliminary questionnaire " ->Pass 2.Select all additional fields and all users and verified search button functionality->Pass 3.Verified print view history button functionality->Pass 4.Verified reset button functionality->Pass Working properly. Ready for Production. PFA, CC : Rakesh Roy Hrishikesh Deshpande Prasad Pise Sachin Hingole Thanks, Sanjana Jadhav
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 23/Oct/17 11:45 AM
            • Time Spent:
              0.7h
               

              Verified on stage

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Remaining Estimate 14.5h [ 52200 ] 13.8h [ 49680 ]
            Time Spent 1.5h [ 5400 ] 2.2h [ 7920 ]
            Worklog Id 85796 [ 85796 ]
            satyap Satya made changes -
            Labels View_History
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Production Due Date 25/Oct/2017 25/Nov/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Attaching production deployment approval email for reference:
            !Re Request for Production deployment - 25 Nov 2017.msg
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching production deployment approval email for reference: !Re Request for Production deployment - 25 Nov 2017.msg Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for production deployment [ 18457 ]
            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)
            sanjana.jadhav Sanjana Jadhav (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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment WT-11448-2.png [ 68770 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment WT-11448-1.png [ 68771 ]
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on Production.
            Company: Elite Staffing For HSPL
            Browser: Chrome

            Scanerios:
            1.enter mandatory field and verified view history for : "Your enrollment start here" and "preliminary questionnaire " ->Pass
            2.Select all additional fields and all users and verified search button functionality->Pass
            3.Verified print view history button functionality->Pass
            4.Verified reset button functionality->Pass

            Working properly.

            PFA,

            Thanks,
            Sanjana Jadhav

            CC: Prasad Pise Rakesh Roy Hrishikesh Deshpande Sachin Hingole

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on Production. Company: Elite Staffing For HSPL Browser: Chrome Scanerios: 1.enter mandatory field and verified view history for : "Your enrollment start here" and "preliminary questionnaire " ->Pass 2.Select all additional fields and all users and verified search button functionality->Pass 3.Verified print view history button functionality->Pass 4.Verified reset button functionality->Pass Working properly. PFA, Thanks, Sanjana Jadhav CC: Prasad Pise Rakesh Roy Hrishikesh Deshpande Sachin Hingole
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 29/Nov/17 09:49 AM
            • Time Spent:
              0.5h
               

              verified on production

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sanjana.jadhav Sanjana Jadhav (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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Remaining Estimate 13.8h [ 49680 ] 13.3h [ 47880 ]
            Time Spent 2.2h [ 7920 ] 2.7h [ 9720 ]
            Worklog Id 93421 [ 93421 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Sudhir Kalikate (Inactive) made transition -
            Open In Development
            4d 20h 24m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            3d 9h 42m 1
            Sanjana Jadhav (Inactive) made transition -
            In LB Testing Stage Testing
            9d 17h 1m 1
            Sanjana Jadhav (Inactive) made transition -
            Stage Testing In Production Testing
            37d 1h 30m 1
            Sanjana Jadhav (Inactive) made transition -
            In Production Testing Production Complete
            4m 47s 1
            Sanjana Jadhav (Inactive) made transition -
            Production Complete Closed
            2h 10m 1

              People

              Assignee:
              sanjana.jadhav Sanjana Jadhav (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Developer:
              Sudhir Kalikate (Inactive)
              QA:
              Sanjana Jadhav (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 16h
                  16h
                  Remaining:
                  Time Spent - 2.7h Remaining Estimate - 13.3h
                  13.3h
                  Logged:
                  Time Spent - 2.7h Remaining Estimate - 13.3h
                  2.7h