-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Duplicate
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Environment:Stage
-
Module:BenAdmin
-
Reported by:Harbinger
-
Issue Importance:Can Wait
In Partner login, with company Softchoice, while downloading 1095-C 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_IRS1095C
Employee ID : 0
Action Name : GridPreviewReport
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.GridPreviewReport(Int32 id, Int32 id1, Int32 id2, Int32 id3, Int32 id4)
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
-
WT-4804 Softchoice - Copy of Production to Stage
-
- 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 Hi Ramya Tantry
Please close this if fixed.
Hi Nandkumar Prabhakar Karlekar,
As per my earlier comment, the error is caused due to "SSN/SIN" field.
We have not worked on this fix.We have just replaced "SSN/SIN" field with Social_Security_no. in SP's.
Same issue is with MATT company too. Their first name field is different.
Please provide input on how to resolve this.
Ramya Tantry (Inactive)
added a comment - Hi Nandkumar Prabhakar Karlekar ,
As per my earlier comment, the error is caused due to "SSN/SIN" field.
We have not worked on this fix.We have just replaced "SSN/SIN" field with Social_Security_no. in SP's.
Same issue is with MATT company too. Their first name field is different.
Please provide input on how to resolve this. closing this Jira as we have create new JIRA WT-7225 to track it.
Ramya Tantry (Inactive)
added a comment - closing this Jira as we have create new JIRA WT-7225 to track it. Closing this Jira as we have created new enhancement JIRA WT-7225 to track it.
Ramya Tantry (Inactive)
added a comment - Closing this Jira as we have created new enhancement JIRA WT-7225 to track it. 
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