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

LB:- Change class/status throwing server error on For QA LB Austin Ind company.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      Bugs-Must Fix- Pilot July2016

      Description

      Steps:-
      1]Log into the system using valid credentials.
      2]Search and select For QA LB Austin Ind company on LB.
      3]Search and select any employee.
      4]Try to change status of the employee.

      Actual Result:-
      Server error being displayed on click of save button

      Expected Result:-
      Server error should not be displayed on click of save button

        Attachments

          Issue Links

            Activity

            venkatesh.pujari Venkatesh Pujari (Inactive) created issue -
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Field Original Value New Value
            Link This issue blocks WT-1719 [ WT-1719 ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Swapnil,

            Any updates on this. This is blocking my testing for WT-1719 JIRA.

            Thanks,
            Venkatesh

            CC:-Vijay SiddhaDeepali Tidkeshyam sharma

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Swapnil, Any updates on this. This is blocking my testing for WT-1719 JIRA. Thanks, Venkatesh CC:- Vijay Siddha Deepali Tidke shyam sharma
            vijays Vijay Siddha (Inactive) made changes -
            Issue Importance Must Have [ 11800 ]
            satyap Satya made changes -
            Sprint Bugs-Must Fix- Pilot July2016 [ 16 ]
            satyap Satya made changes -
            Rank Ranked higher
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Swapnil Pandhare : Can you please look in to this issue ? as because of this issue WT-1719 is not moving ahead from sprint 4
            Satya : can we plan this in bug fixing ?

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Swapnil Pandhare : Can you please look in to this issue ? as because of this issue WT-1719 is not moving ahead from sprint 4 Satya : can we plan this in bug fixing ?
            satyap Satya made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ] Satya [ ID10004 ]
            satyap Satya made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            satyap Satya made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            satyap Satya made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            satyap Satya added a comment -

            Hi Venkatesh,

            There were two address components added on Demographics after which Design Form layout was not saved.

            Now it's working correctly on LB. Please verify once.

            Thanks & Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Hi Venkatesh, There were two address components added on Demographics after which Design Form layout was not saved. Now it's working correctly on LB. Please verify once. Thanks & Regards, Satya Prakash
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Venkatesh Pujari [ venkatesh.pujari ]
            satyap Satya made changes -
            Dev Due Date 04/Jul/2016
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Description Steps:-
            1]Log into the system using valid credentials.
            2]Search and select For QA LB Austin Ind company on LB.
            3]Click on Form Builder option from Employee Screens Configuration.
            4]Search and select demographics form.
            5]Click on Design Form Layout and observe

            Actual Result:-
            Server error being displayed on the screen

            Expected Result:-
            Server error should not be displayed on the screen.
            Steps:-
            1]Log into the system using valid credentials.
            2]Search and select For QA LB Austin Ind company on LB.
            3]Search and select any employee.
            4]Try to change status of the employee.

            Actual Result:-
            Server error being displayed on click of save button

            Expected Result:-
            Server error should not be displayed on click of save button
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Satya,

            This issue was for class or status change.

            Error Log is as below:-

            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->Employee.Save->Employee.UpdateEmployeeChangeStatus
            ErrorMessage: Invalid column name 'OEDemographicchangesthatneedtobeupdatedinpayroll2242'.
            Invalid column name 'OEDemographicchangesthatneedtobeupdatedinpayroll2242'.
            Invalid column name 'OEDemographicchangesthatneedtobeupdatedinpayroll2242'.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Satya, This issue was for class or status change. Error Log is as below:- ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->Employee.Save->Employee.UpdateEmployeeChangeStatus ErrorMessage: Invalid column name 'OEDemographicchangesthatneedtobeupdatedinpayroll2242'. Invalid column name 'OEDemographicchangesthatneedtobeupdatedinpayroll2242'. Invalid column name 'OEDemographicchangesthatneedtobeupdatedinpayroll2242'. Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Satya [ ID10004 ]
            Hide
            satyap Satya added a comment -

            Hi Venkatesh,

            On this company eligibility migration was not done properly. Please find the snapshot after resolving error.

            In case of Eligibility related issue, please check with Amruta/Ashwin.

            Thanks & Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Hi Venkatesh, On this company eligibility migration was not done properly. Please find the snapshot after resolving error. In case of Eligibility related issue, please check with Amruta/Ashwin. Thanks & Regards, Satya Prakash
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Satya,

            Tested this on LB on QA LB Austin Ind company,Change class/status working fine as expected.

            Closing the ticket

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Satya, Tested this on LB on QA LB Austin Ind company,Change class/status working fine as expected. Closing the ticket
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Satya made transition -
            Open In Development
            14d 7h 28m 1
            Satya made transition -
            In Development In LB Testing
            8m 34s 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Stage Testing
            7d 16h 8m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            1s 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            8s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            1s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date: