WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-5173

Company Down : Softchoice >> Server error occurred while downloading 1095-B form

    Details

    • 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

      Description

      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)

        Attachments

          Issue Links

          relates to

          Support Activity - Support Activity WT-4804 Softchoice - Copy of Production to Stage

          • Critical - This problem will block progress.
          • Resolved

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            rajendraj Rajendra Joshi (Inactive) added a comment - - edited

            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

            Show
            rajendraj Rajendra Joshi (Inactive) added a comment - - edited 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
            Hide
            Permalink
            ramya.tantry 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

            Show
            ramya.tantry 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
            Hide
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            duplicate WT-5172

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - duplicate WT-5172

              People

              Assignee:
              shyam.sharma shyam sharma (Inactive)
              Reporter:
              rajendraj Rajendra Joshi (Inactive)
              QA:
              Rajendra Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: