[WT-7768] ACA - Getting server error on exporting any ACA template - Workterra Jira

Details

Type: Bug
Status: Production Complete
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: ACA
Labels:
None

Environment:

QA
Bug Severity:
Medium
Module:
ACA - 2017
Reported by:
Harbinger
Item State:
Production Complete - Closed

Description

Actual Result - gives server error pop up

ERROR LOG
___________________________
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ACAExportProcessRowwise.ExportData
ErrorMessage: SP : OES_SP_ACA_EligibilityForExport Error : Column name or number of supplied values does not match table definition.

Attachments

Issue Links

is caused by

WT-7697 ACA 2017: Percentage of salary calculation should depend on benefit salary flag on rates.

Closed

relates to

WT-7701 Implementation of ACA export file in case of not provided the start and end date

Production Complete

Activity

Ascending order - Click to sort in descending order

Sachin Hingole (Inactive) created issue - 13/Jan/17 11:26 AM

Sachin Hingole (Inactive) made changes - 13/Jan/17 11:26 AM

Field	Original Value	New Value
Link		This issue relates to ~~WT-7701~~ [ ~~WT-7701~~ ]

Sachin Hingole (Inactive) made changes - 13/Jan/17 11:31 AM

Description

Log into LB
select ACAAutomation company
go to Import Export -> Manual Import Export
Select any ACA Template
provide date range 1/1/2016 to 1/31/2016
Click on export

Actual Result - gives server error pop up

ERROR LOG
___________________________
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ACAExportProcessRowwise.ExportData
ErrorMessage: SP : OES_SP_ACA_EligibilityForExport Error : Column name or number of supplied values does not match table definition.

Log into LB
select ACAAutomation company
go to Import Export -> Manual Import Export
Select ACA Template (Verified for 1] Tango ACA Employee and 2] Sachin - BSG Export
templates from LB)
provide date range 1/1/2016 to 1/31/2016
Click on export

Actual Result - gives server error pop up

ERROR LOG
___________________________
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ACAExportProcessRowwise.ExportData
ErrorMessage: SP : OES_SP_ACA_EligibilityForExport Error : Column name or number of supplied values does not match table definition.

Sachin Hingole (Inactive) made changes - 13/Jan/17 11:42 AM

Remaining Estimate		16h [ 57600 ]
Original Estimate		16h [ 57600 ]

Sachin Hingole (Inactive) made changes - 13/Jan/17 11:42 AM

Remaining Estimate	16h [ 57600 ]	15.75h [ 56700 ]
Time Spent		0.25h [ 900 ]
Worklog Id	19045 [ 19045 ]

Revansiddha Gaur (Inactive) made changes - 16/Jan/17 09:19 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Revansiddha Gaur (Inactive) made changes - 16/Jan/17 10:25 AM

Assignee

Revansiddha Gaur [ revansiddha.gaur ]

Ramya Tantry [ ramya.tantry ]

Ramya Tantry (Inactive) made changes - 16/Jan/17 11:34 AM

Link

This issue is caused by ~~WT-7697~~ [ ~~WT-7697~~ ]

Ramya Tantry (Inactive) made changes - 16/Jan/17 11:50 AM

Remaining Estimate	15.75h [ 56700 ]	13.75h [ 49500 ]
Time Spent	0.25h [ 900 ]	2.25h [ 8100 ]
Worklog Id	19280 [ 19280 ]

Ramya Tantry (Inactive) made changes - 16/Jan/17 11:50 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Ramya Tantry (Inactive) made changes - 16/Jan/17 12:08 PM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

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

Ramya Tantry (Inactive) made changes - 16/Jan/17 12:08 PM

Code Reviewed By

Nandkumar Karlekar [ 11904 ]

Khandu Kshirsagar (Inactive) made changes - 16/Jan/17 12:20 PM

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)

Ramya Tantry (Inactive) made changes - 16/Jan/17 12:31 PM

Assignee

Ramya Tantry [ ramya.tantry ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 16/Jan/17 12:34 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 16/Jan/17 12:34 PM

Item State

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

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Smita Pawar (Inactive) made changes - 16/Jan/17 01:18 PM

Remaining Estimate	13.75h [ 49500 ]	13.25h [ 47700 ]
Time Spent	2.25h [ 8100 ]	2.75h [ 9900 ]
Worklog Id	19362 [ 19362 ]

Sachin Hingole (Inactive) made changes - 16/Jan/17 01:28 PM

Remaining Estimate	13.25h [ 47700 ]	12h 55m [ 46500 ]
Time Spent	2.75h [ 9900 ]	3h 5m [ 11100 ]
Worklog Id	19370 [ 19370 ]

Revansiddha Gaur (Inactive) made changes - 17/Jan/17 05:21 AM

Remaining Estimate	12h 55m [ 46500 ]	10h 55m [ 39300 ]
Time Spent	3h 5m [ 11100 ]	5h 5m [ 18300 ]
Worklog Id	19454 [ 19454 ]

Sachin Hingole (Inactive) made changes - 20/Jan/17 07:47 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

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

Revansiddha Gaur (Inactive) made changes - 23/Jan/17 04:38 AM

Developer

Revansiddha Gaur [ revansiddha.gaur ]

Ramya Tantry [ ramya.tantry ]

Sachin Hingole (Inactive) made changes - 23/Jan/17 06:55 AM

Production Due Date		31/Jan/2017
Stage Due Date		25/Jan/17 [ 2017-01-25 ]

Khandu Kshirsagar (Inactive) made changes - 25/Jan/17 08:17 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)

Sachin Hingole (Inactive) made changes - 25/Jan/17 09:40 AM

Remaining Estimate	10h 55m [ 39300 ]	9h 55m [ 35700 ]
Time Spent	5h 5m [ 18300 ]	6h 5m [ 21900 ]
Worklog Id	21001 [ 21001 ]

Sachin Hingole (Inactive) made changes - 25/Jan/17 09:40 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 25/Jan/17 09:40 AM

Item State

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

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

Ashwin Wankhede (Inactive) made changes - 31/Jan/17 07:39 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)

Sachin Hingole (Inactive) made changes - 31/Jan/17 11:03 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Sachin Hingole (Inactive) made changes - 31/Jan/17 11:03 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)

Rakesh Roy (Inactive) made changes - 31/Jan/17 05:30 PM

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

Rakesh Roy (Inactive) made changes - 31/Jan/17 05:31 PM

Item State

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

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

Rakesh Roy (Inactive) made changes - 30/Aug/17 04:59 AM

Bug Severity

Medium [ 16702 ]

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

Environment_New

LB [ 18444 ]

People

Assignee:: Sachin Hingole (Inactive)

Reporter:: Sachin Hingole (Inactive)

Developer:: Ramya Tantry (Inactive)

QA:: Smita Pawar (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 13/Jan/17 11:26 AM

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

Resolved:: 31/Jan/17 05:30 PM

Pre-Prod Due Date:: 25/Jan/2017

Production Due Date:: 31/Jan/2017

Time Tracking

Estimated:

16h

Remaining:

9h 55m

Logged:

6h 5m