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

            rashmita.dudhe Rashmita Dudhe (Inactive) created issue -
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Field Original Value New Value
            Link This issue blocks WT-4816 [ WT-4816 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Aarati Sabnis [ aarati.sabnis ]
            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
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Assignee Aarati Sabnis [ aarati.sabnis ] Rashmita Dudhe [ rashmita.dudhe ]
            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
            komal.barde Komal Barde (Inactive) logged work - 20/Mar/17 05:17 PM - edited
            • Time Spent:
              0.5h
               

              Execute EmployeeSource script on LB and discussion with Aarati

            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            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.
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Developer Aarati Sabnis [ aarati.sabnis ]
            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
            komal.barde Komal Barde (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ]
            Original Estimate 1h [ 3600 ]
            komal.barde Komal Barde (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 32823 [ 32823 ]
            komal.barde Komal Barde (Inactive) made changes -
            Worklog Id 32823 [ 32823 ]
            komal.barde Komal Barde (Inactive) made changes -
            Worklog Id 32823 [ 32823 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            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.
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Aarati Sabnis (Inactive) made transition -
            Open In Development
            15m 23s 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            7h 27m 1
            Rashmita Dudhe (Inactive) made transition -
            In LB Testing Stage Testing
            6d 18h 8m 1
            Rashmita Dudhe (Inactive) made transition -
            Stage Testing In Production Testing
            3s 1
            Rashmita Dudhe (Inactive) made transition -
            In Production Testing Production Complete
            19s 1
            Rashmita Dudhe (Inactive) made transition -
            Production Complete Closed
            4s 1

              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