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

Getting server Error when adding employee

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      QA
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Getting server error when adding new employee on Company refer attached screen shots tied on more than 10 companies on lb:
      below error log:

      1]ErrorID : 0
      ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeProfileView.InsertInEmployeeSource
      ErrorMessage: Invalid object name 'dbo.EmployeeSource'.

      2]ErrorID : 0
      ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->EmployeeData.Save->EmployeeData.UpdateEmployeeProfile->EmployeeData.CreateUserForEmployee->DefinedFieldRuleEngine.UpdateDefinedFieldByApplyingRuleEngine->DefinedFieldRuleEngine.UpdateTableFieldsForDataRuleEngine->DefinedFieldRuleEngine.UpdateConditionalValue->DefinedFieldRuleEngine.GetQueryForThenRule
      ErrorMessage: Incorrect syntax near ')'.

        Attachments

          Issue Links

            Activity

            Hide
            aarati.sabnis Aarati Sabnis (Inactive) added a comment -

            Hello Rashmita Dudhe,

            Please test this again as I am getting server error only because of Invalid object name 'dbo.EmployeeSource' as it is mentioned in error log 1].

            As per our discussion with Komal Barde, please confirm this with her. So that add employee will work properly.

            Thanks,
            Aarati R. Sabnis
            CC Sheetal Bodhale,Satya

            Show
            aarati.sabnis Aarati Sabnis (Inactive) added a comment - Hello Rashmita Dudhe , Please test this again as I am getting server error only because of Invalid object name 'dbo.EmployeeSource' as it is mentioned in error log 1]. As per our discussion with Komal Barde , please confirm this with her. So that add employee will work properly. Thanks, Aarati R. Sabnis CC Sheetal Bodhale , Satya
            Hide
            komal.barde Komal Barde (Inactive) added a comment -

            Hi Rashmita Dudhe,

            Please refer NF-549 for more details.

            Concern: Getting server Error when adding employee
            Cause: The script of EmployeeSource did not getting updated at time of deployment.
            Due to this the table "EmployeeSource" is not getting added at company level.
            Correction: We have executed "EmployeeSource" table related script to all company.

            Regards,
            Komal.
            CC:Sheetal Bodhale,Satya,Saurabh Sablaka,Aarati Sabnis

            Show
            komal.barde Komal Barde (Inactive) added a comment - Hi Rashmita Dudhe , Please refer NF-549 for more details. Concern : Getting server Error when adding employee Cause : The script of EmployeeSource did not getting updated at time of deployment. Due to this the table "EmployeeSource" is not getting added at company level. Correction : We have executed "EmployeeSource" table related script to all company. Regards, Komal. CC: Sheetal Bodhale , Satya , Saurabh Sablaka , Aarati Sabnis
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Verified on LB Environment working fine as expected.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on LB Environment working fine as expected.
            Hide
            komal.barde Komal Barde (Inactive) added a comment -

            Hi,

            This issue is related to NF-392 LOCAL TESTING ticket and this ticket related data is not deployed on stage.
            So we will be move this ticket related changes once we move NF-392 LOCAL TESTING related changes on stage.

            Regards,
            Komal.

            CC:Saurabh Sablaka,Sheetal Bodhale,Satya,Aarati Sabnis,Rashmita Dudhe

            Show
            komal.barde Komal Barde (Inactive) added a comment - Hi, This issue is related to NF-392 LOCAL TESTING ticket and this ticket related data is not deployed on stage. So we will be move this ticket related changes once we move NF-392 LOCAL TESTING related changes on stage. Regards, Komal. CC: Saurabh Sablaka , Sheetal Bodhale , Satya , Aarati Sabnis , Rashmita Dudhe
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            verified on production.
            working fine as expected.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - verified on production. working fine as expected.

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Developer:
              Aarati Sabnis (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h
                  1h
                  Remaining:
                  Time Spent - 0.5h Remaining Estimate - 0.5h
                  0.5h
                  Logged:
                  Time Spent - 0.5h Remaining Estimate - 0.5h
                  0.5h