WORKTERRAProject Type: software

WORKTERRA

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

ACA - Getting server error on exporting any ACA template

    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

      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.

        Attachments

          Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. WT-7697 ACA 2017: Percentage of salary calculation should depend on benefit salary flag on rates.

          • Medium - Has the potential to affect progress.
          • Closed
          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-7701 Implementation of ACA export file in case of not provided the start and end date

          • High - Serious problem that could block progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            sachin.hingole Sachin Hingole (Inactive) created issue -
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-7701 [ WT-7701 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            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.
            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 13/Jan/17 11:42 AM
            • Time Spent:
              0.25h
               
              <No comment>
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ]
            Original Estimate 16h [ 57600 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 15.75h [ 56700 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 19045 [ 19045 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            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'.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited 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'.
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Ramya Tantry [ ramya.tantry ]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected:

            MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_EligibilityForExport.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_EligibilityForExport.sql
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue is caused by WT-7697 [ WT-7697 ]
            Hide
            Permalink
            ramya.tantry 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.

            Show
            ramya.tantry 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.
            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 16/Jan/17 11:50 AM
            • Time Spent:
              2h
               

              analysis
              coding
              fixing
              testing

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 15.75h [ 56700 ] 13.75h [ 49500 ]
            Time Spent 0.25h [ 900 ] 2.25h [ 8100 ]
            Worklog Id 19280 [ 19280 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            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 Ramya Tantry (Inactive) made changes -
            Code Reviewed By Nandkumar Karlekar [ 11904 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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 Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 16/Jan/17 01:17 PM
            • Time Spent:
              0.5h
               

              LB testting

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 13.75h [ 49500 ] 13.25h [ 47700 ]
            Time Spent 2.25h [ 8100 ] 2.75h [ 9900 ]
            Worklog Id 19362 [ 19362 ]
            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 16/Jan/17 01:28 PM
            • Time Spent:
              20m
               
              <No comment>
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            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.

            Show
            sachin.hingole 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.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 13.25h [ 47700 ] 12h 55m [ 46500 ]
            Time Spent 2.75h [ 9900 ] 3h 5m [ 11100 ]
            Worklog Id 19370 [ 19370 ]
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 16/Jan/17 10:00 PM
            • Time Spent:
              2h
               

              Analysis & Internal disucssion with Ramya & Sachin

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 12h 55m [ 46500 ] 10h 55m [ 39300 ]
            Time Spent 3h 5m [ 11100 ] 5h 5m [ 18300 ]
            Worklog Id 19454 [ 19454 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            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 Revansiddha Gaur (Inactive) made changes -
            Developer Revansiddha Gaur [ revansiddha.gaur ] Ramya Tantry [ ramya.tantry ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Production Due Date 31/Jan/2017
            Stage Due Date 25/Jan/17 [ 2017-01-25 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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)
            Permalink
            sachin.hingole Sachin Hingole (Inactive) logged work - 25/Jan/17 09:40 AM
            • Time Spent:
              1h
               

              Verified on stage working fine.

            sachin.hingole Sachin Hingole (Inactive) made changes -
            Remaining Estimate 10h 55m [ 39300 ] 9h 55m [ 35700 ]
            Time Spent 5h 5m [ 18300 ] 6h 5m [ 21900 ]
            Worklog Id 21001 [ 21001 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            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)
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on Stage, working fine.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage, working fine.
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            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 Sachin Hingole (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            		3d 24m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		43m 17s 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		8d 21h 6m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            		6d 1h 23m 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            		6h 27m 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              sachin.hingole 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:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 16h
                  16h
                  Remaining:
                  Time Spent - 6h 5m Remaining Estimate - 9h 55m
                  9h 55m
                  Logged:
                  Time Spent - 6h 5m Remaining Estimate - 9h 55m
                  6h 5m