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

Functional-Totalworks-Partner Login-Employee View history- Server error

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Harbinger
    • Module:
      BenAdmin
    • Severity:
      Simple

      Description

      Replication Steps:
      1.Login with partner
      2.Go to Company "totalworks"
      3.Go to Benadmin Home > Employee Benadmin home
      4.click on View History
      5.Put From Date and To date 01/01/2016 and Present date respectively
      6.Select document type As "Employee"
      7.Select All Document sub types and All users
      8.Now click on "Search"
      Actual result: Server Error occurred
      Expected: It should show Employee documented History

        Attachments

        1. View history Sever error.png
          View history Sever error.png
          105 kB
        2. WT_10438.png
          WT_10438.png
          129 kB
        3. WT-10438.png
          WT-10438.png
          130 kB

          Issue Links

            Activity

            Hide
            satyap Satya added a comment -

            Hi Sheetal,
            THis issue is for 'Spouse Tobacco Affidavit'. Below is the log: Can you please correct missing column name?

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.GetAffidavitAdditionalFieldInformation
            ErrorMessage: Invalid column name 'MySpouse231'.
            Invalid column name 'MySpouse231'.
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput)
            TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

            Show
            satyap Satya added a comment - Hi Sheetal, THis issue is for 'Spouse Tobacco Affidavit'. Below is the log: Can you please correct missing column name? ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.GetAffidavitAdditionalFieldInformation ErrorMessage: Invalid column name 'MySpouse231'. Invalid column name 'MySpouse231'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput) TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)
            Hide
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

            Hi Satya,

            Please find below 3C's of the issue,
            Concern: Functional-Totalworks-Partner Login-Employee View history- Server error

            Cause: There is one column added and deleted on Spouse Tobacco Affidavit - 'MySpouse231', After adding and deleting that Save button has not been clicked at Form Builder - Design form layout page. So, column name was not generated properly in database.

            Correction: We have deleted entries from back end.Now it is not throwing server.

            Thanks,
            Sheetal Bodhale

            Show
            sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Satya , Please find below 3C's of the issue, Concern: Functional-Totalworks-Partner Login-Employee View history- Server error Cause: There is one column added and deleted on Spouse Tobacco Affidavit - 'MySpouse231', After adding and deleting that Save button has not been clicked at Form Builder - Design form layout page. So, column name was not generated properly in database. Correction: We have deleted entries from back end.Now it is not throwing server. Thanks, Sheetal Bodhale
            Hide
            satyap Satya added a comment -

            Thanks Sheetal Bodhale for sharing details.

            Priya Handepatil / Prasad Pise: Can you please verify this once?

            Regards,
            Satya Prakash

            Cc: Rakesh Roy Jaideep Vinchurkar Vijay Siddha

            Show
            satyap Satya added a comment - Thanks Sheetal Bodhale for sharing details. Priya Handepatil / Prasad Pise : Can you please verify this once? Regards, Satya Prakash Cc: Rakesh Roy Jaideep Vinchurkar Vijay Siddha
            Hide
            priya.handepatil Priya Handepatil (Inactive) added a comment -

            Hi

            Verified this issue on Stage

            Verified with Partner and Company Admin Login

            No Server error has occurred

            Its working Fine

            CC:Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Satya

            Thanks,
            Priya Handepatil

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - Hi Verified this issue on Stage Verified with Partner and Company Admin Login No Server error has occurred Its working Fine CC: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande Satya Thanks, Priya Handepatil

              People

              Assignee:
              priya.handepatil Priya Handepatil (Inactive)
              Reporter:
              priya.handepatil Priya Handepatil (Inactive)
              QA:
              Priya Handepatil (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1.5h
                  1.5h