-
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
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
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Saurabh Sablaka [ saurabh.sablaka ] | Venkatesh Pujari [ venkatesh.pujari ] |
| 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. |
| 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 ] |
| 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 |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| 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) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production Complete(10222) |
| Item State | Parent values: Production Complete(10222) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Kunal Kedari (Inactive)
made changes -
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Kunal Kedari [ kunal.kedari ] |
Kunal Kedari (Inactive)
made changes -
| Assignee | Kunal Kedari [ kunal.kedari ] | Venkatesh Pujari [ venkatesh.pujari ] |