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

Employee SS mode -> Server error on confirmation statement page

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Customization
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - On Hold
    • Sprint:
      WT Sprint 39 - Bugs

      Description

      Company -> Elite staffing, Wacker Neuson corporation
      1)Login with partner
      2)Select company -> Add Employee
      3)Traverse EE workflow
      4)Go to beneficiary page -> Assign beneficiary
      5)Click on continue -> System throws server error

      Please note : For above mentioned companies this issue occur only once. Checked with 2,3 employee workflow its worked fine

        Attachments

        1. Ben.jpg
          Ben.jpg
          214 kB
        2. Confirmation.jpg
          Confirmation.jpg
          223 kB
        3. Error.jpg
          Error.jpg
          163 kB
        4. StageError.jpg
          StageError.jpg
          117 kB

          Issue Links

            Activity

            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Error Log :

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
            ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
            StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
            TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Error Log : ErrorID : 0 ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput) TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)
            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - CC; Rakesh Roy Prasad Pise Satya Sachin Hingole Hrishikesh Deshpande
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            CC : Sheetal Bodhale
            Hi Jyotibala Pardeshi ,

            Please check this on prioirty.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - CC : Sheetal Bodhale Hi Jyotibala Pardeshi , Please check this on prioirty. Thanks, Swapnil P.
            Hide
            jyotibala Jyotibala Pardeshi (Inactive) added a comment -

            Hi Jayshree Nagpure,

            We are not able to reproduced the issue on Elit Staffing after restoring it on the local environment.
            We have tried Classwies OE and OE workflow.

            We will try it for another companies and will update the status accordingly.
            Let us know if you will get this issue for another companies.

            Thanks and Regards,
            Jyotibala P.

            CC: Satya,Swapnil Pandhare, Sheetal Bodhale

            Show
            jyotibala Jyotibala Pardeshi (Inactive) added a comment - Hi Jayshree Nagpure , We are not able to reproduced the issue on Elit Staffing after restoring it on the local environment. We have tried Classwies OE and OE workflow. We will try it for another companies and will update the status accordingly. Let us know if you will get this issue for another companies. Thanks and Regards, Jyotibala P. CC: Satya , Swapnil Pandhare , Sheetal Bodhale
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Jyotibala Pardeshi,

            We got again this issue on stage (Date- 19 oct 2017)
            Company - ASML for hspl

            Error log is same as above

            cc : Rakesh Roy Prasad Pise Satya Swapnil Pandhare Sheetal Bodhale

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Jyotibala Pardeshi , We got again this issue on stage (Date- 19 oct 2017) Company - ASML for hspl Error log is same as above cc : Rakesh Roy Prasad Pise Satya Swapnil Pandhare Sheetal Bodhale
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Sudhir Kalikate,

            Could you please share 3c and and assign to me once its deloyed

            Thanks,

            cc : Rakesh Roy Prasad Pise Swapnil Pandhare

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Sudhir Kalikate , Could you please share 3c and and assign to me once its deloyed Thanks, cc : Rakesh Roy Prasad Pise Swapnil Pandhare
            Hide
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment - - edited

            3C's for Issue
            Concern :
            Employee SS mode -> Server error on confirmation statement page.
            Cause :
            Caused by EDS Optimization changes. Data was fetching twice in Cache tables.
            Correction :
            We have made changes in stored procedure to fetch data from cache table correctly

            Show
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment - - edited 3C's for Issue Concern : Employee SS mode -> Server error on confirmation statement page. Cause : Caused by EDS Optimization changes. Data was fetching twice in Cache tables. Correction : We have made changes in stored procedure to fetch data from cache table correctly
            Hide
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment -

            LB deployed.

            Show
            sudhir.kalikate Sudhir Kalikate (Inactive) added a comment - LB deployed.
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on LB
            Company - For QA Caiso for hspl

            Verified EE selfserve mode
            Verified beneficiary and confirmation statement page.
            No server error Found

            Marking item state as Ready for Stage

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on LB Company - For QA Caiso for hspl Verified EE selfserve mode Verified beneficiary and confirmation statement page. No server error Found Marking item state as Ready for Stage Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Stage
            Company - Southland for hspl

            Verified EE selfserve mode
            Verified beneficiary and confirmation statement page.
            No server error Found
            Marking item state as Ready for Production

            Thanks,
            Jayshree

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage Company - Southland for hspl Verified EE selfserve mode Verified beneficiary and confirmation statement page. No server error Found Marking item state as Ready for Production Thanks, Jayshree
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on production.
            Company: Elite Staffing For HSPL
            Verified Employee workflow (OE Workflow).
            Verified beneficiary and confirmation statement page.
            Working as expected.

            Thanks,
            Sanjana Jadhav

            CC: Prasad Pise Sachin Hingole Rakesh Roy

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on production. Company: Elite Staffing For HSPL Verified Employee workflow (OE Workflow). Verified beneficiary and confirmation statement page. Working as expected. Thanks, Sanjana Jadhav CC: Prasad Pise Sachin Hingole Rakesh Roy

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Developer:
              Sudhir Kalikate (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

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

                  Time Tracking

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