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

Many companies - Employee login - confirmation statement - getting server error first time

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Level:
      Employee
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients

      Description

      Companies with error log--
      1.Je Dunn

      Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
      App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
      Employee ID : 4431
      Action Name : EnrollmentSummary
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : UserDetails
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.EnrollmentSummary(String id)
      at lambda_method(Closure , ControllerBase , Object[] )
      at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
      at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
      2.FDAC EBA
      Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
      App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
      Employee ID : 1124
      Action Name : EnrollmentSummary
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : UserDetails
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
      3.County of del norte
      Exception : Invalid column name `Female`.
      App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
      Employee ID : 966
      Action Name : EnrollmentSummary
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : UserDetails
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.EnrollmentSummary(String id)
      at lambda_method(Closure , ControllerBase , Object[] )
      4.HCM DEMO
      Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
      App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
      Employee ID : 405
      Action Name : EnrollmentSummary
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : UserDetails
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.EnrollmentSummary(String id)
      at lambda_method(Closure , ControllerBase , Object[] )
      5.EL Dorado
      Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
      App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
      Employee ID : 10328
      Action Name : EnrollmentSummary
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : UserDetails
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.EnrollmentSummary(String id)
      at lambda_method(Closure , ControllerBase , Object[] )
      6.Demo_company MIke

      Exception : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
      App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
      Employee ID : 294
      Action Name : EnrollmentSummary
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : UserDetails
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
      at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)

        Attachments

        1. City_of_denton_Conf_stmt_server_error.png
          City_of_denton_Conf_stmt_server_error.png
          212 kB
        2. Employbridge.png
          Employbridge.png
          146 kB
        3. FDAC_EBA_Conf_stmt_server_error.png
          FDAC_EBA_Conf_stmt_server_error.png
          114 kB
        4. Je Dunn_Conf_stmt_server_error.png
          Je Dunn_Conf_stmt_server_error.png
          112 kB
        5. Ohio.png
          Ohio.png
          140 kB

          Issue Links

            Activity

            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Attachment FDAC_EBA_Conf_stmt_server_error.png [ 65234 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Attachment Je Dunn_Conf_stmt_server_error.png [ 65235 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            6. CCSF
            Exception : Invalid column name `Male`.
            App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
            Employee ID : 2067
            Action Name : EnrollmentSummary
            Model : System.Web.Mvc.HandleErrorInfo
            Controller : UserDetails
            Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
            at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - 6. CCSF Exception : Invalid column name `Male`. App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation Employee ID : 2067 Action Name : EnrollmentSummary Model : System.Web.Mvc.HandleErrorInfo Controller : UserDetails Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection) at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
            rakeshr Rakesh Roy (Inactive) made changes -
            Attachment Ohio.png [ 65237 ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            7.Ohio northern university
            Exception : Invalid column name `Male`.
            App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
            Employee ID : 926
            Action Name : EnrollmentSummary
            Model : System.Web.Mvc.HandleErrorInfo
            Controller : UserDetails
            Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
            at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - 7.Ohio northern university Exception : Invalid column name `Male`. App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation Employee ID : 926 Action Name : EnrollmentSummary Model : System.Web.Mvc.HandleErrorInfo Controller : UserDetails Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection) at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
            rakeshr Rakesh Roy (Inactive) made changes -
            Attachment Employbridge.png [ 65240 ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            8. Emplybridge
            Exception : Invalid column name `Female`.
            App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
            Employee ID : 315287
            Action Name : EnrollmentSummary
            Model : System.Web.Mvc.HandleErrorInfo
            Controller : UserDetails
            Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection)
            at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - 8. Emplybridge Exception : Invalid column name `Female`. App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation Employee ID : 315287 Action Name : EnrollmentSummary Model : System.Web.Mvc.HandleErrorInfo Controller : UserDetails Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection) at WORKTERRA.BenAdmin.Areas.UserDetails.Models.EnrollmentSummaryModel.FillArrayForGridsVisibility(PageName pageName, Boolean IsEnrollNowConsolidated)
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Rohan J Khandave [ rohan.khandave ]
            rohan.khandave Rohan J Khandave (Inactive) made changes -
            Assignee Rohan J Khandave [ rohan.khandave ] Vijayendra Shinde [ ID10506 ]
            Show
            vijayendra Vijayendra Shinde (Inactive) added a comment - CC: Swapnil Pandhare , Nidhi Kaul
            vijayendra Vijayendra Shinde (Inactive) made changes -
            Assignee Vijayendra Shinde [ ID10506 ] Sheetal Bodhale [ sheetal.bodhale ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue is caused by WT-10577 [ WT-10577 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Amit Kumawat [ amit.kumawat ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Link This issue duplicates NF-4877 [ NF-4877 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Amit Kumawat [ amit.kumawat ] Sachin Hingole [ sachin.hingole ]
            Hide
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

            Hi Sachin Hingole ,

            For details , please refer NF-4877 which is duplciate of this.

            Thanks,
            Swapnil P.

            Show
            swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Sachin Hingole , For details , please refer NF-4877 which is duplciate of this. Thanks, Swapnil P.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ]
            Environment Others [ 18445 ]
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Its duplicate of NF-4877, hence rejecting this JIRA.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Its duplicate of NF-4877 , hence rejecting this JIRA.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Duplicate [ 3 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Transition Time In Source Status Execution Times
            Swapnil Pandhare (Inactive) made transition -
            Open In Development
            19d 5h 26m 1
            Swapnil Pandhare (Inactive) made transition -
            In Development In LB Testing
            2s 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Reopen in Local
            13d 13h 34m 1
            Sachin Hingole (Inactive) made transition -
            Reopen in Local In Development
            5s 1
            Sachin Hingole (Inactive) made transition -
            In Development Rejected
            38s 1
            Sachin Hingole (Inactive) made transition -
            Rejected Closed
            13s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: