Project SimpleProject Type: software

Project Simple

Uploaded image for project: 'Project Simple'
  1. Project Simple
  2. ST-229

Error on Confirmation Statement - GetRecentActivities

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      This error occurs on load of Employee recent activity. Employee recent activity should be configured to display on Confirmation Statement.

      ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->EmployeeCollection.GetRecentActivities
      ErrorMessage: Ambiguous column name 'USERID'.
      Ambiguous column name 'UserID'.
      Ambiguous column name 'USERID'.
      Ambiguous column name 'UserID'.

      Changes Done: This error was occurring in Stored Procedure execution as Table alias was not specified for UserID column. We have added respective table alias name for required columns.
      Stored Procedure name: OES_SP_GetRecentlyUpdatedEmployeeTable

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Tested this on LB and Stage.

          Last recent functionality working fine on confirmation statement.

          Ready for Production.

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on LB and Stage. Last recent functionality working fine on confirmation statement. Ready for Production.
          Hide
          Permalink
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Tested this on Production on Alecto Healthcare For HSPL company.

          Last recent functionality working fine on confirmation statement.

          Closing the ticket.

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on Production on Alecto Healthcare For HSPL company. Last recent functionality working fine on confirmation statement. Closing the ticket.
          Hide
          Permalink
          kunal.kedari Kunal Kedari (Inactive) added a comment -

          By mistake it gets assigned to me, reassigning again to Venkatesh.

          Show
          kunal.kedari Kunal Kedari (Inactive) added a comment - By mistake it gets assigned to me, reassigning again to Venkatesh.

            People

            Assignee:
            venkatesh.pujari Venkatesh Pujari (Inactive)
            Reporter:
            saurabh.sablaka Saurabh Sablaka (Inactive)
            Developer:
            Saurabh Sablaka (Inactive)
            QA:
            Venkatesh Pujari (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: