Hi Pratap Patil

Please find error log below,

ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetReviewChangesForEmployee
ErrorMessage: Incorrect syntax near the keyword 'UNION'.

-------------------------------------------------------------------------------------------------------------

Exception : Incorrect syntax near the keyword `UNION`.
App Error Log : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetReviewChangesForEmployee
Employee ID : 0
Action Name : ReviewTransactionFields
Model : System.Web.Mvc.HandleErrorInfo
Controller : UserDetails
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetCollection(ObjectType I_objectType, Hashtable I_criteria, String I_AdditionalCriteriaString, Object I_context, Boolean I_mode, Boolean I_needCollection) in c:\WT\branches\UiRefresh\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 160
at WORKTERRA.BenAdmin.Areas.UserDetails.Models.ReviewTransactionFieldsModelPV.PopulateReviewChangesForIntermedaite() in c:\WT\branches\UiRefresh\Web\Web Projects\BenAdmin\Areas\UserDetails\Models\PendingQueue\ReviewTransactionFieldsModelPV.cs:line 54
at WORKTERRA.BenAdmin.Areas.UserDetails.Controllers.UserDetailsController.ReviewTransactionFields(String SelectionCriteria, String SearchKeyword) in c:\WT\branches\UiRefresh\Web\Web Projects\BenAdmin\Areas\UserDetails\Controllers\PendingQueue\PendingQueueController.cs:line 78
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass42.<BeginInvokeSynchronousActionMethod>b_41()
at System.Web.Mvc.Async.AsyncResultWrapper.<>c_DisplayClass8`1.<BeginSynchronous>b_7(IAsyncResult _)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass37.<>cDisplayClass39.<BeginInvokeActionMethodWithFilters>b_33()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b_49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b_49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass37.<BeginInvokeActionMethodWithFilters>b_36(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass25.<>cDisplayClass2a.<BeginInvokeAction>b_20()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass25.<BeginInvokeAction>b_22(IAsyncResult asyncResult)

---------------------------------------------------------------------------------------------------------------------

Hello Pratap Patil

Server error is populating for review changes pages
Please verify at your end

Thank you

Rutuja

This issue is also for Pending Queue under BenAdmin

Steps to Repro

1) Click on BenAdmin
2) Click on Pending Queue
3) Select anything from Selection Criteria
4) Click on Search

Result: Server Error

please look into this as well

Hi Rutuja Chilwar ,
This issue is resolved , please verify it .

Thanks ,
Pratap