-
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
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.
Files Affected:
MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_EligibilityForExport.sql
Ramya Tantry (Inactive)
added a comment - Files Affected:
MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_EligibilityForExport.sql Concern:ACA - Getting server error on exporting any ACA template
Cause: As per implementation,salary that has been selected on ACA parameters is considered for calculation of rates. Benefit salary flag on rates is not considered.
Correction: We have changed the implementation to consider benefit salary flag.
If the benefit salary flag on rates is set to yes,then EE cost calculation should be calculated as per Percentage of benefit salary else it should consider gross annual salary.
Note:Rate of pay not considered as there is no concept of rate of pay in BenAdmin.
Please verify percentage of salary scenario for files also. Refer WT-7697 for more details.
Revansiddha Gaur ,Sachin Hingole,Smita Pawar: I have just resolved the error reported on OES_SP_ACA_EligibilityForExport. I have not checked error reported by Smita.
Ramya Tantry (Inactive)
added a comment - Concern :ACA - Getting server error on exporting any ACA template
Cause : As per implementation,salary that has been selected on ACA parameters is considered for calculation of rates. Benefit salary flag on rates is not considered.
Correction : We have changed the implementation to consider benefit salary flag.
If the benefit salary flag on rates is set to yes,then EE cost calculation should be calculated as per Percentage of benefit salary else it should consider gross annual salary.
Note :Rate of pay not considered as there is no concept of rate of pay in BenAdmin.
Please verify percentage of salary scenario for files also. Refer WT-7697 for more details.
Revansiddha Gaur , Sachin Hingole , Smita Pawar : I have just resolved the error reported on OES_SP_ACA_EligibilityForExport. I have not checked error reported by Smita.
Verified for below templates, and its working fine.
1] Tango ACA Employee and 2] Sachin - BSG Export
Smita PawarCan you please verify for "Sachin BSG including waive template" template including TC for WT-7697 too.
refer Ramyas comment for this WT-7697.
If issue not resolved related to "Sachin BSG including waive template" then create separate JIRA for it.
Sachin Hingole (Inactive)
added a comment - Verified for below templates, and its working fine.
1] Tango ACA Employee and 2] Sachin - BSG Export
Smita Pawar Can you please verify for "Sachin BSG including waive template" template including TC for WT-7697 too.
refer Ramyas comment for this WT-7697 .
If issue not resolved related to "Sachin BSG including waive template" then create separate JIRA for it. Verified on Stage, working fine.
Sachin Hingole (Inactive)
added a comment - Verified on Stage, working fine. 
Getting similar error on export of Sachin BSG including waive template on ACA Automation LB company.
Error log is as follows
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ExportProcess.ExportData->ExportProcess.FillDataIntoDataTable
ErrorMessage: Invalid column name 'OldPlanDesignIdentifier'.
Invalid column name 'SendOnlyOneRecordPerMemberonRowwise'.
Invalid column name 'ChangeInElectionTrack'.
Invalid column name 'ChangeInElectionTrack'.
Invalid column name 'OldPlanDesignIdentifier'.
Invalid column name 'SendOnlyOneRecordPerMemberonRowwise'.
Invalid column name 'ChangeInElectionTrack'.
Invalid column name 'ChangeInElectionTrack'.