WORKTERRAProject Type: software

WORKTERRA

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

          Ascending order - Click to sort in descending order
          jyoti.mayne Jyoti Mayne created issue -
          Hide
          Permalink
          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)
          jyoti.mayne Jyoti Mayne made changes -
          Field Original Value New Value
          Component/s BenAdmin [ 10000 ]
          Issue Category EBS [ 10350 ] Harbinger [ 10700 ]
          Issue Importance Must Have [ 11800 ]
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
          Priority Medium [ 3 ] High [ 2 ]
          Hide
          Permalink
          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
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Vijay Siddha [ vijays ] Surender Kumar [ surender.kumar ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          surender.kumar surender kumar (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          surender.kumar surender kumar (Inactive) made changes -
          Attachment Company_List_Having_WellnessColumn.ods [ 26311 ]
          surender.kumar surender kumar (Inactive) made changes -
          Attachment Company_List_Having_WellnessColumn.ods [ 26311 ]
          surender.kumar surender kumar (Inactive) made changes -
          Attachment Company_List_Having_WellnessColumn.ods [ 26317 ]
          Hide
          Permalink
          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.
          surender.kumar surender kumar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          surender.kumar surender kumar (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          surender.kumar surender kumar (Inactive) made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          surender.kumar surender kumar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          surender.kumar surender kumar (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          surender.kumar surender kumar (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          surender.kumar surender kumar (Inactive) made changes -
          Assignee Surender Kumar [ surender.kumar ] Rakesh Roy [ rakeshr ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment Pass.png [ 26321 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment Pass 2.png [ 26324 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment Stage_Pass.png [ 26325 ]
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          No server error.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - No server error.
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          surender kumar (Inactive) made transition -
          Open In Development
          		1d 47m 1
          surender kumar (Inactive) made transition -
          In LB Testing Reopen in Local
          		1s 1
          surender kumar (Inactive) made transition -
          Reopen in Local In Development
          		2s 1
          surender kumar (Inactive) made transition -
          In Development In LB Testing
          		15m 59s 2
          surender kumar (Inactive) made transition -
          In LB Testing Stage Testing
          		4s 1
          surender kumar (Inactive) made transition -
          Stage Testing In Production Testing
          		5s 1
          Rakesh Roy (Inactive) made transition -
          In Production Testing Production Complete
          		1h 23m 1

            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: