WORKTERRAProject Type: software

WORKTERRA

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

Company Down : Softchoice >> Server error occured while downloading 1095-C form

    Details

    • 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

      Description

      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)

        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 -

            Hi Ramya Tantry

            Please close this if fixed.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Ramya Tantry Please close this if fixed.
            Hide
            Permalink
            ramya.tantry 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.

            Show
            ramya.tantry 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.
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            closing this Jira as we have create new JIRA WT-7225 to track it.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - closing this Jira as we have create new JIRA WT-7225 to track it.
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Closing this Jira as we have created new enhancement JIRA WT-7225 to track it.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Closing this Jira as we have created new enhancement JIRA WT-7225 to track it.

              People

              Assignee:
              ramya.tantry Ramya Tantry (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: