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

Superior Court of Califorinia - County of Riverside - Error when adding employee

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Client
    • Company:
      Superior Court of California - County of Riverside
    • Item State:
      Production Complete - Closed
    • Reported by Customer:
      BCC
    • Sprint:
      WT Sprint 39 - Bugs

      Description

      Please see the error below when adding an employee. Please correct

        Attachments

          Issue Links

            Activity

            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited

            Hi Debbie Kulling,

            We have resolved this issue by doing some workaround, you can now add employees.

            Swapnil Pandhare

            There was below error thrown in SP OES_SP_UpdateEmployeeAttribute

            Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.03423Oct 2 2017 12:00AM0400

            We have modified SP and added check of @PageID in line number 903. Please do the needful.

            Niteen Surwase

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - - edited Hi Debbie Kulling , We have resolved this issue by doing some workaround, you can now add employees. Swapnil Pandhare There was below error thrown in SP OES_SP_UpdateEmployeeAttribute Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.03423Oct 2 2017 12:00AM0400 We have modified SP and added check of @PageID in line number 903. Please do the needful. Niteen Surwase
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - - edited

            CC : Satya

            Hi Jyotibala Pardeshi

            As discussed , Please checkin in code fix on stage and LB. Also, please update 3Cs.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - - edited CC : Satya Hi Jyotibala Pardeshi As discussed , Please checkin in code fix on stage and LB. Also, please update 3Cs. Thanks, Swapnil P.
            Hide
            jyotibala Jyotibala Pardeshi (Inactive) added a comment - - edited

            Hello Hrishikesh Deshpande,

            Concern : Superior Court of Califorinia - County of Riverside - Error when adding employee

            Cause : While saving Add employee page, additional field details for add employee were not getting fetched correctly.

            Correction : We have applied condition to fetch Additional field details for add employee page correctly.

            Impacted Areas: Demographics and Add Employee

            Affected files: OES_SP_UpdateEmployeeAttribute.sql

            Thanks,
            Jyotibala P

            CC: Satya Swapnil Pandhare Sheetal Bodhale

            Show
            jyotibala Jyotibala Pardeshi (Inactive) added a comment - - edited Hello Hrishikesh Deshpande , Concern : Superior Court of Califorinia - County of Riverside - Error when adding employee Cause : While saving Add employee page, additional field details for add employee were not getting fetched correctly. Correction : We have applied condition to fetch Additional field details for add employee page correctly. Impacted Areas: Demographics and Add Employee Affected files: OES_SP_UpdateEmployeeAttribute.sql Thanks, Jyotibala P CC: Satya Swapnil Pandhare Sheetal Bodhale
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Take it on priority for testing.

            [~meghana joshi]

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Take it on priority for testing. [~meghana joshi]
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This issue is Fixed on LB. Ready for Stage,

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issue is Fixed on LB. Ready for Stage,
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This issue is Fixed on Stage. Ready for Production.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issue is Fixed on Stage. Ready for Production.
            Hide
            dkulling Debbie Kulling added a comment -

            This error is still occurring on groups but it now appears to be intermittent. When is this issue going to be resolved? Most recently BCC could not add an employee to COB. When the user switch from Chrome to IE they were able to add the employee

            Show
            dkulling Debbie Kulling added a comment - This error is still occurring on groups but it now appears to be intermittent. When is this issue going to be resolved? Most recently BCC could not add an employee to COB. When the user switch from Chrome to IE they were able to add the employee
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            HI Sheetal Bodhale ,

            Please check this on priority.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - HI Sheetal Bodhale , Please check this on priority. Thanks, Swapnil P.
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Please test this on Priority.If it is reproduced then assign back to me.

            CC:SatyaSwapnil Pandhare

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Hrishikesh Deshpande , Please test this on Priority.If it is reproduced then assign back to me. CC: Satya Swapnil Pandhare Thanks, Sheetal Bodhale
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on Stage, its working fine.
            Verified using IE 11 and chrome for "COB" and "Superior Court of California - County of Riverside" on stage main company.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage, its working fine. Verified using IE 11 and chrome for "COB" and "Superior Court of California - County of Riverside" on stage main company.
            Hide
            jyotibala Jyotibala Pardeshi (Inactive) added a comment - - edited

            Hi Sachin Hingole,

            This issue has been deployed with WT-11437, please verify and mark jira accordingly.

            Thanks and Regards,
            Jyotibala P.

            CC: Satya, Swapnil Pandhare, Sheetal Bodhale, Hrishikesh Deshpande

            Show
            jyotibala Jyotibala Pardeshi (Inactive) added a comment - - edited Hi Sachin Hingole , This issue has been deployed with WT-11437 , please verify and mark jira accordingly. Thanks and Regards, Jyotibala P. CC: Satya , Swapnil Pandhare , Sheetal Bodhale , Hrishikesh Deshpande
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on production on OCSD and COB HSPL copies.
            We are able to create employee without issue.

            Can you please verify and confirm the same.

            Rakesh Roy Hrishikesh Deshpande Prasad Pise

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production on OCSD and COB HSPL copies. We are able to create employee without issue. Can you please verify and confirm the same. Rakesh Roy Hrishikesh Deshpande Prasad Pise

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Developer:
              Jyotibala Pardeshi (Inactive)
              QA:
              Priya Handepatil (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

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