Replication Steps :

2017 Prime Healthcare Company
Stage Environment

1) Partner Login
2) Navigate to Report - > Static Reports -> Select Employee Plan Eligibility Report

Actual: Getting error on running report

Exception : The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.
App Error Log : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->StaticReports.SaveAndGetData->AdminUser.GetData->EligibilityReason.FetchEmployeePlanEligibility->EligibilityReason.GetEnrollmentDataForReport->EligibilityReason.FetchMetaData
Employee ID : 0
Action Name : PreviewReport
Model : System.Web.Mvc.HandleErrorInfo
Controller : Report
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.SaveAndGetData(ObjectType I_objectType, Object objInputObject, Object I_context, Hashtable I_criteria, Boolean I_mode, Boolean I_needCollection)
at WORKTERRA.BenAdmin.Areas.Report.Models.StaticReports.PreviewReport()
at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.PreviewReport(StaticReports objStaticReports)
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.ControllerActionInvoker.<>c_DisplayClass15.b_12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.<>c_DisplayClass15.<>cDisplayClass17.b_14()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.<>c_DisplayClass15.<>cDisplayClass17.b_14()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

PFA:

CC:Sachin Hingole,Prasad Pise,Rakesh Roy