[WT-3057] ACA_Production_Server Error while updating Receipt ID - Workterra Jira

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

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

Receipt Id.png
56 kB
12/Jul/16 09:12 AM

Activity

Ascending order - Click to sort in descending order

Smita Pawar (Inactive) created issue - 16/Jun/16 11:57 AM

Smita Pawar (Inactive) made changes - 16/Jun/16 11:58 AM

Field	Original Value	New Value
Assignee	Satya [ ID10004 ]	Kumar Chhajed [ kumar.chhajed ]

Kumar Chhajed (Inactive) made changes - 16/Jun/16 12:26 PM

Status

Open [ 1 ]

In Development [ 10007 ]

Hide

Permalink

Kumar Chhajed (Inactive) added a comment - 20/Jun/16 09:41 AM

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 (Inactive) added a comment - 20/Jun/16 09:41 AM Currently working on 1095C Data Correction enhancement WT-2295 , therefore keeping this on hold. Will update after completing the in-hand task.

Kumar Chhajed (Inactive) made changes - 20/Jun/16 09:41 AM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Kumar Chhajed (Inactive) made changes - 23/Jun/16 06:21 AM

Item State

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Kumar Chhajed (Inactive) made changes - 23/Jun/16 06:43 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Hide

Permalink

Kumar Chhajed (Inactive) added a comment - 23/Jun/16 06:46 AM - 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 (Inactive) added a comment - 23/Jun/16 06:46 AM - 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.

Kumar Chhajed (Inactive) made changes - 27/Jun/16 06:18 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Kumar Chhajed (Inactive) made changes - 27/Jun/16 06:19 AM

Assignee

Kumar Chhajed [ kumar.chhajed ]

Smita Pawar [ smita.pawar ]

Hide

Permalink

Smita Pawar (Inactive) added a comment - 28/Jun/16 10:24 AM - edited

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

Show

Smita Pawar (Inactive) added a comment - 28/Jun/16 10:24 AM - edited Testing of this Jira is blocked due to J query issue.

Rakesh Roy (Inactive) made changes - 01/Jul/16 09:11 AM

Issue Importance

Must Have [ 11800 ]

Sachin Hingole (Inactive) made changes - 04/Jul/16 06:23 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 04/Jul/16 01:38 PM

Smita Pawar Please update Stage due date.

Show

Rakesh Roy (Inactive) added a comment - 04/Jul/16 01:38 PM Smita Pawar Please update Stage due date.

Hide

Permalink

Smita Pawar (Inactive) added a comment - 05/Jul/16 05:39 AM

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

Show

Smita Pawar (Inactive) added a comment - 05/Jul/16 05:39 AM FYI Sachin Hingole Stage due date of this Jira is Jul 11 2016

Hide

Permalink

Smita Pawar (Inactive) added a comment - 08/Jul/16 11:46 AM

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 (Inactive) added a comment - 08/Jul/16 11:46 AM 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.

Smita Pawar (Inactive) made changes - 08/Jul/16 11:46 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Rakesh Roy (Inactive) made changes - 11/Jul/16 03:26 AM

Developer

Kumar Chhajed [ kumar.chhajed ]

Rakesh Roy (Inactive) made changes - 11/Jul/16 03:27 AM

Production Due Date		12/Jul/2016
Stage Due Date		11/Jul/16 [ 2016-07-11 ]

Kumar Chhajed (Inactive) made changes - 11/Jul/16 07:14 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Kumar Chhajed (Inactive) made changes - 11/Jul/16 07:14 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Smita Pawar (Inactive) made changes - 11/Jul/16 01:11 PM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Hide

Permalink

Smita Pawar (Inactive) added a comment - 12/Jul/16 09:11 AM

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 (Inactive) added a comment - 12/Jul/16 09:11 AM 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.

Smita Pawar (Inactive) made changes - 12/Jul/16 09:11 AM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Smita Pawar (Inactive) made changes - 12/Jul/16 09:12 AM

Attachment

Receipt Id.png [ 21802 ]

Ashwin Wankhede (Inactive) made changes - 19/Jul/16 06:21 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Smita Pawar (Inactive) made changes - 20/Jul/16 05:57 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Hide

Permalink

Smita Pawar (Inactive) added a comment - 20/Jul/16 06:05 AM

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 (Inactive) added a comment - 20/Jul/16 06:05 AM 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.

Smita Pawar (Inactive) made changes - 20/Jul/16 06:05 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Smita Pawar (Inactive) made changes - 20/Jul/16 06:06 AM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Smita Pawar (Inactive) made changes - 20/Jul/16 06:06 AM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Smita Pawar (Inactive) made changes - 20/Jul/16 06:06 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Satya made changes - 04/Nov/17 06:36 AM

Environment_New

Production [ 18442 ]

Transition	Time In Source Status	Execution Times

Kumar Chhajed (Inactive) made transition - 16/Jun/16 12:26 PM

Open

In Development

28m 16s

Sachin Hingole (Inactive) made transition - 04/Jul/16 06:23 AM

In Development

In LB Testing

17d 17h 57m

Kumar Chhajed (Inactive) made transition - 11/Jul/16 07:14 AM

In LB Testing

Stage Testing

7d 51m

Smita Pawar (Inactive) made transition - 20/Jul/16 05:57 AM

Stage Testing

In Production Testing

8d 22h 42m

Smita Pawar (Inactive) made transition - 20/Jul/16 06:06 AM

In Production Testing

Production Complete

9m 32s

Smita Pawar (Inactive) made transition - 20/Jul/16 06:06 AM

Production Complete

Closed

People

Assignee:: Smita Pawar (Inactive)

Reporter:: Smita Pawar (Inactive)

Developer:: Kumar Chhajed (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 16/Jun/16 11:57 AM

Updated:: 04/Nov/17 06:36 AM

Resolved:: 20/Jul/16 06:06 AM

Pre-Prod Due Date:: 11/Jul/2016

Production Due Date:: 12/Jul/2016