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

ACA_Production_Server Error while updating Receipt ID

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      1.Login to Production.
      2.Edit company say "Village of Northbrook For HSPL"
      3.Create Ui submissions as
      A: with one 1095-B forms
      B: with two 1095-B forms
      4.Verify submission
      5.Transmit the submission and update the Receipt ID

      Actual: System is giving error while updating Receipt ID and status.
      Expected: System should not throw error/

      Error log is as follows

      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->ACAIRSSubmission.SaveAndGetData->ACAIRSSubmission.UpateIRSSubmissionTransmissionStatus
      ErrorMessage: Conversion failed when converting the varchar value '5,' to data type int.

      PFA for additional information

        Attachments

          Activity

          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment -

          Currently working on 1095C Data Correction enhancement WT-2295, therefore keeping this on hold. Will update after completing the in-hand task.

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - Currently working on 1095C Data Correction enhancement WT-2295 , therefore keeping this on hold. Will update after completing the in-hand task.
          Hide
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited

          Below are the 3C's -

          Concern - Server Error while updating Receipt ID for 1094B Submission
          Cause - The Column used for concatenate was having datatype int, hence it throws error ( Conversion failed when converting the varchar value '5,' to data type int.)
          Correction - Specified a cast for the int column to varchar.

          Show
          kumar.chhajed Kumar Chhajed (Inactive) added a comment - - edited Below are the 3C's - Concern - Server Error while updating Receipt ID for 1094B Submission Cause - The Column used for concatenate was having datatype int, hence it throws error ( Conversion failed when converting the varchar value '5,' to data type int.) Correction - Specified a cast for the int column to varchar.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment - - edited

          Testing of this Jira is blocked due to J query issue.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - - edited Testing of this Jira is blocked due to J query issue.
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Smita Pawar Please update Stage due date.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Smita Pawar Please update Stage due date.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          FYI Sachin Hingole
          Stage due date of this Jira is Jul 11 2016

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - FYI Sachin Hingole Stage due date of this Jira is Jul 11 2016
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on LB [Worktesttwo Test] company.
          Its working fine currently there is no error while updating receipt Id,

          Fix is ready to move to stage.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB [Worktesttwo Test] company. Its working fine currently there is no error while updating receipt Id, Fix is ready to move to stage.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on Stage [ACA_QA_Testing].
          Its working fine. We didn't received any server error while updating Receipt ID.
          Fix is ready for Production.

          Note: Attaching screen for additional information.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage [ACA_QA_Testing] . Its working fine. We didn't received any server error while updating Receipt ID. Fix is ready for Production. Note: Attaching screen for additional information.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on Production.
          Its working fine.

          Cases verified are as follows.
          1.Checked whether there is no server error while updating the Receipt ID.
          2.Checked whether user is able to download Ack file.
          3.Checked whether xml is generated properly and its getting downloaded properly.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production. Its working fine. Cases verified are as follows. 1.Checked whether there is no server error while updating the Receipt ID. 2.Checked whether user is able to download Ack file. 3.Checked whether xml is generated properly and its getting downloaded properly.

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            smita.pawar Smita Pawar (Inactive)
            Developer:
            Kumar Chhajed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Pre-Prod Due Date:
              Production Due Date: