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

Caiso- Server error on view history page

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Server error on view history page on Caiso.

        Attachments

        1. Company_List_Having_WellnessColumn.ods
          16 kB
        2. Pass.png
          Pass.png
          90 kB
        3. Pass 2.png
          Pass 2.png
          86 kB
        4. Stage_Pass.png
          Stage_Pass.png
          75 kB
        5. View History.png
          View History.png
          172 kB

          Activity

          Hide
          jyoti.mayne Jyoti Mayne added a comment -

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

          Show
          jyoti.mayne Jyoti Mayne added a comment - ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetEmployeeHistoryInformationCollection->EmployeeCollection.CreateDataForEmployeeHistory ErrorMessage: Invalid column name 'WellnessDiscount31107'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput) TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)
          Hide
          jyoti.mayne Jyoti Mayne added a comment -

          Hi surender kumar,

          Could you please scanned on all active companies at production for this column 'WellnessDiscount31107'.

          cc:Satya,Amruta Lohiya,Amnesh Goel

          Show
          jyoti.mayne Jyoti Mayne added a comment - Hi surender kumar , Could you please scanned on all active companies at production for this column 'WellnessDiscount31107'. cc: Satya , Amruta Lohiya , Amnesh Goel
          Hide
          surender.kumar surender kumar (Inactive) added a comment - - edited

          Hi,

          3C:
          Concern:
          Server error on view history page.

          Cause:
          There was invalid column named WellnessDiscount31107 on 246 companies

          Correction:
          We have scanned all active companies which have WellnessDiscount31107 column.There are 247 companies at production which have WellnessDiscount31107 column. Please refer attached file Company_List_Having_WellnessColumn.ods.

          As per discussion with Satya and Indraprakash Tiwari, We have deleted the WellnessDiscount31107 column from Employee_FormData,Employee_FormData_History and Employee_FormData_Intermediate tables
          on 246 companies excluding D C Taylor Co because this company has data in its WellnessDiscount31107 column.
          The query is executed on Stage as well as Production.

          Please Verify on Stage as well as on Production.

          Show
          surender.kumar surender kumar (Inactive) added a comment - - edited Hi, 3C: Concern: Server error on view history page. Cause: There was invalid column named WellnessDiscount31107 on 246 companies Correction: We have scanned all active companies which have WellnessDiscount31107 column.There are 247 companies at production which have WellnessDiscount31107 column. Please refer attached file Company_List_Having_WellnessColumn.ods . As per discussion with Satya and Indraprakash Tiwari , We have deleted the WellnessDiscount31107 column from Employee_FormData , Employee_FormData_History and Employee_FormData_Intermediate tables on 246 companies excluding D C Taylor Co because this company has data in its WellnessDiscount31107 column. The query is executed on Stage as well as Production. Please Verify on Stage as well as on Production.
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          No server error.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - No server error.

            People

            Assignee:
            rakeshr Rakesh Roy (Inactive)
            Reporter:
            jyoti.mayne Jyoti Mayne
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: