-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Environment:QA
-
Module:ACA
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
Sachin Hingole Nandkumar Prabhakar Karlekar Rakesh Roy
Server error while 1095C processing So Block for UI submission testing on LB.
Company Name - City of Redding For HSPL
Step -
1.Login to application
2.Navigate to BenAdmin > ACA > IRS Submission
3.Click on Add New button.
4.Select 1095C from drop down
5.Fill all mandatory data and click on Save Preview
6.It started processing
7.At middle of processing step , it through server error
Actual- Server Error
Expected - 1095C created
Error Log -
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->IRSReport.SaveAndGetData->IRSReport.ProcessIRSReport->bsIRSReport.GenerateDataForPDFService_IRS1095C
ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
A
Warning: Null value is eliminated by an aggregate or other SET operation.
Warning: Null value is eliminated by an aggregate or other SET operation.
| Field | Original Value | New Value |
|---|---|---|
| Description |
[~sachin.hingole] [~nandkumar] Server error while 1095C processing So Block for UI submission testing on LB. Company Name - City of Redding For HSPL Step - 1.Login to application 2.Navigate to BenAdmin > ACA > IRS Submission 3.Click on Add New button. 4.Select 1095C from drop down 5.Fill all mandatory data and click on Save Preview 6.It started processing 7.At middle of processing step , it through server error Actual- Server Error Expected - 1095C created Error Log - ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->IRSReport.SaveAndGetData->IRSReport.ProcessIRSReport->bsIRSReport.GenerateDataForPDFService_IRS1095C ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. A Warning: Null value is eliminated by an aggregate or other SET operation. Warning: Null value is eliminated by an aggregate or other SET operation. |
[~sachin.hingole] [~nandkumar] [~rakeshr] Server error while 1095C processing So Block for UI submission testing on LB. Company Name - City of Redding For HSPL Step - 1.Login to application 2.Navigate to BenAdmin > ACA > IRS Submission 3.Click on Add New button. 4.Select 1095C from drop down 5.Fill all mandatory data and click on Save Preview 6.It started processing 7.At middle of processing step , it through server error Actual- Server Error Expected - 1095C created Error Log - ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->IRSReport.SaveAndGetData->IRSReport.ProcessIRSReport->bsIRSReport.GenerateDataForPDFService_IRS1095C ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. A Warning: Null value is eliminated by an aggregate or other SET operation. Warning: Null value is eliminated by an aggregate or other SET operation. |
Ramya Tantry (Inactive)
made changes -
| Assignee | Ramya Tantry [ ramya.tantry ] | Kumar Chhajed [ kumar.chhajed ] |
| Developer | Ramya Tantry [ ramya.tantry ] | Kumar Chhajed [ kumar.chhajed ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Assignee | Kumar Chhajed [ kumar.chhajed ] | Mahendra Mungase [ mahendra.mungase ] |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
We have regressed this issue on LB - City of Redding For HSPL and observed that issue does not exist on LB.
| 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) |
| Issue Category | EBS [ 10350 ] | Harbinger [ 10700 ] |
| 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) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) |
We are working on other Support task.So keep this ticket on hold
| Item State | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| QA Due Date | 13/Jun/2016 |
We have regressed this issue on Stage- ACA Demo For HSPL and observed that issue does not exist on Stage.
| 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) |
| Production Due Date | 14/Jun/2016 |
| 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) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
We are working on Production support task.Hence keeping this ticket on hold
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: On Hold(10219) |
| Item State | Parent values: Production QA(10203)Level 1 values: On Hold(10219) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
We have regressed this issue on Production - County of Del Norte For HSPL and observed that issue does not exist on Production.Hence closing the ticket.
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Done [ 10000 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Resolution | Done [ 10000 ] | Fixed [ 1 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
20h 18m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
4d 3h 23m | 1 |
|
7d 18h 1m | 1 |
|
7d 5h 3m | 1 |
|
6d 19h 50m | 1 |
|
3s | 1 |
Concern : Server error populated during the processing of 1095C IRS Report
Cause : As the company had two same entries of Generic Eligibility Rule in EIN Classes Mapping, therefore the query returned more than value of name.
Correction : Now the query will return only Top one value. This will not cause server error in future.