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
          saurabh.sablaka Saurabh Sablaka (Inactive) created issue -
          deepalit Deepali Tidke (Inactive) made changes -
          Field Original Value New Value
          Assignee Saurabh Sablaka [ saurabh.sablaka ] Venkatesh Pujari [ venkatesh.pujari ]
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Description This error occurs if Employee recent activity

          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'.
          		 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.
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Code Reviewed By Vijayendra Shinde [ 11901 ]
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          QA Venkatesh Pujari [ venkatesh.pujari ]
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          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.


          		 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
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          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.
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          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.
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production Complete(10222)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: Production Complete(10222) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Assignee Venkatesh Pujari [ venkatesh.pujari ] Kunal Kedari [ kunal.kedari ]
          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.
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Assignee Kunal Kedari [ kunal.kedari ] Venkatesh Pujari [ venkatesh.pujari ]
          Transition Time In Source Status Execution Times
          Saurabh Sablaka (Inactive) made transition -
          Open In Development
          		16h 54m 1
          Saurabh Sablaka (Inactive) made transition -
          In Development In LB Testing
          		2s 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Stage Testing
          		21h 34m 1
          Venkatesh Pujari (Inactive) made transition -
          Stage Testing In Production Testing
          		7h 2m 1
          Venkatesh Pujari (Inactive) made transition -
          In Production Testing Production Complete
          		13s 1

            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: