Approved by Dave through Mail.

Status is in development so returning back to dev

Verified newly added fields Effective Date & Last login datetime for Employee census report for different companies.following are the findings:

1] on CVHP and DC both the new fields can be seen however for LHP Effective Date field cannot be seen.kindly check

2] For CVHP selected both the new fields with other fields such as First name and SSN >> preview the report or run it after saving >> nothing happens.Kindly check

3] For already existing employee census report >> both the new fields can be seen. working fine

Dhanashree SherkarPlease check and mark status accordingly.

Amnesh Goel Pleass check and confirm.

Rakesh Roy I do not see these fields on Employee Census Report. Were these added in past on any environment? Any email communication that you can add here for reference.

Amnesh GoelAbhijeet KhandagalePlease refer Ticket #13427 from trac

Verified on Wt stage system displayed server error on Employee census report.
Checked on following companies
1.For QA LB UND
2.For QA LB Austin Ind
3.For QA LB Linium
4.For QA LB Prime Healhcare

Error log :- Exception : Could not find server `HGSQLSERVER1\HGSQLSERVER1` in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
App Error Log : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetAllFieldsForEmployeeOrDependentSpouseOrDependentChildCollection
Employee ID : 0
Action Name : StandardReports
Model : System.Web.Mvc.HandleErrorInfo
Controller : Report
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 d:\WT\branches\LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 160
at WORKTERRA.BenAdmin.Areas.Report.Models.ReportFieldsMappingPVModel.GetAllFieldsForEmployeeOrDependentSpouseOrDependentChild(String TableRefID)
at WORKTERRA.BenAdmin.Areas.Report.Models.ReportFieldsMappingPVModel.PopulateListBox()
at WORKTERRA.BenAdmin.Areas.Report.Models.StandardReportsFormPVModel.InitilizeReportFieldMappingInformation()
at WORKTERRA.BenAdmin.Areas.Report.Models.StandardReportsFormPVModel.EditFormModel(ReportDetails objReportDetails)
at WORKTERRA.BenAdmin.Areas.Report.Models.StandardReportsModel.EditReportDetails()
at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.StandardReports(Int32 id, Int32 id1, Int32 id2, Int32 id3, Int32 id4, Int32 id5)
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)

Dhanashree Sherkar Deepali Tidke Rakesh Roy

Reports are not working on LB and we are working on that. Please update QA team.

Hi Amnesh,
On employee Census report fields name are not displayed.
It displayed Value cannot be null Parameter name: Connection String
Refer attached screenshot.
Company name- Austin
Partner :- qatesting

Did you get a chance to check again?

Amnesh GoelRakesh Roy

This ticket needs a discussion , let us meet and discuss this on Monday.

After discussion assigned to Aditya for fix.

Hi Deepali Tidke

"This issue of report fields name are not displayed.
It displayed Value cannot be null Parameter name: Connection String"
should be gone. can you please retest it once again?

Tested this on LB on LBSanityCOD company.

Report field names are displayed properly so closing the ticket.

Thanks,
Venkatesh