-
Type:
Support Activity
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Support Task Type:ACA IRS Report
-
Reported by:Harbinger
-
Module:BenAdmin
-
Issue Importance:Must Have
In Partner login, with company Softchoice, while downloading 1095-B form, server error occurred. PFA screen shot and error log
Exception : Incorrect syntax near the keyword `AS`.
App Error Log : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->IRSReport.SaveAndGetData->IRSReport.ProcessIRSReport->bsIRSReport.GenerateDataForPDFService_IRS1095B
Employee ID : 0
Action Name : PreviewReport
Model : System.Web.Mvc.HandleErrorInfo
Controller : ACAIRSReport
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.DownloadReport(Int32 id, Int32 id1, Int32 id2, String[] SelectedTransmittalForCollection, String[] SelectedAuthoritativeTranmittalForCollection)
at WORKTERRA.BenAdmin.Areas.Report.Controllers.ACAIRSReportController.PreviewReport(StaticReports objStaticReports)
at lambda_method(Closure , ControllerBase , Object[] )
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_DisplayClass13.b_10()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
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)
- relates to
-
-
- Resolved
-
As per discussion with Nandkumar, remove the SSN/SIN from Order by and re -run the report.
This "SSN/SIN" field is causing the error as SSN/SIN does not exist in Employee Table.
This error is only on this company as its field name is different. Usually field name is Social_Security_no.
We will give proper fix for this in regular patches.
Ramya Tantry (Inactive)
added a comment - Rajendra Joshi shyam sharma
As per discussion with Nandkumar, remove the SSN/SIN from Order by and re -run the report.
This "SSN/SIN" field is causing the error as SSN/SIN does not exist in Employee Table.
This error is only on this company as its field name is different. Usually field name is Social_Security_no.
We will give proper fix for this in regular patches.
CC Nandkumar Prabhakar Karlekar Satya duplicate WT-5172
Satya Nandkumar Prabhakar Karlekar shyam sharma
Hi Nandkumar, Please resolve and update the issue as early as possible since client is asking whether company is ready for testing.
With Best Regards
Rajendra Joshi