WORKTERRAProject Type: software

WORKTERRA

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
          105 kB
          Priya Handepatil
        2. WT_10438.png
          129 kB
          Priya Handepatil
        3. WT-10438.png
          130 kB
          Priya Handepatil

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-10419 TotalWorks Demo Site

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            priya.handepatil Priya Handepatil (Inactive) created issue -
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Field Original Value New Value
            Link This issue causes WT-10419 [ WT-10419 ]
            Hide
            Permalink
            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)
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Sheetal Bodhale [ sheetal.bodhale ]
            Hide
            Permalink
            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
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Issue Type Bug [ 1 ] Support Activity [ 10301 ]
            Support Task Type Data Correction [ 11203 ]
            Workflow WT_Defects [ 48509 ] WT_Support [ 48576 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Priya Handepatil [ priya.handepatil ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 69679 [ 69679 ]
            Hide
            Permalink
            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
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 07/Aug/17 09:37 PM
            • Time Spent:
              1.5h
               

              data correction on hspl and main
              updated comments
              stage testing

            priya.handepatil Priya Handepatil (Inactive) made changes -
            Attachment WT_10438.png [ 57947 ]
            Attachment WT-10438.png [ 57948 ]
            Hide
            Permalink
            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
            priya.handepatil Priya Handepatil (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Sheetal Bodhale (Inactive) made transition -
            Open In Progress
            		2d 23h 9m 1
            Sheetal Bodhale (Inactive) made transition -
            In Progress Open
            		8s 1
            Sheetal Bodhale (Inactive) made transition -
            Open Resolved
            		16s 1
            Priya Handepatil (Inactive) made transition -
            Resolved Closed
            		1d 2h 44m 1

              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