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.
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)