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
            rajendraj Rajendra Joshi (Inactive) created issue -
            rajendraj Rajendra Joshi (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-4804 [ WT-4804 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Component/s ACA [ 10004 ]
            Component/s BenAdmin [ 10000 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Issue Importance Must Have [ 11800 ]
            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
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Nandkumar [ satyap ] Shyam Sharma [ shyam sharma ]
            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
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Issue Type Bug [ 1 ] Support Activity [ 10301 ]
            Status In Development [ 10007 ] Open [ 1 ]
            Support Task Type ACA IRS Report [ 13680 ]
            Workflow WT_Defects [ 24708 ] WT_Support [ 29141 ]
            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
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Open In Development
            		79d 19h 55m 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            In Development Open
            		1m 16s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Open Resolved
            		16s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Resolved Closed
            		4s 1

              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: