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

ACA - Getting server error on editing employee from ACA 1095C Correction page from Austin for HSPL

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Production
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Log in to production
      Select Austin for HSPL/ Austin
      Go to BenAdmin -> ACA -> ACA Customization -> ACA 1095C Correction
      Edit existing employee to correct from grid

      Actual Result - Getting server error
      Expected Result - Should open employee details without error
      NOTE - This is not happening on other companies

        Attachments

          Issue Links

            Activity

            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Concern: Getting server error on editing employee from ACA 1095C Correction page from Austin for HSPL
            Cause: Existing corrections of 2015 are main cause of this issue.Usually employee details in correction table consists of 12 rows,each for a month. On this company,12 rows are not present,details of one or two months are present.So while fetching details,it gives server error.
            Correction: We have added code to make each employee correction details for 12 months.

            Files Affected:
            Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_Get1095CCorrectionData.sql

            Sachin Hingole
            Please verify.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Concern : Getting server error on editing employee from ACA 1095C Correction page from Austin for HSPL Cause : Existing corrections of 2015 are main cause of this issue.Usually employee details in correction table consists of 12 rows,each for a month. On this company,12 rows are not present,details of one or two months are present.So while fetching details,it gives server error. Correction : We have added code to make each employee correction details for 12 months. Files Affected: Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_Get1095CCorrectionData.sql Sachin Hingole Please verify.
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on LB, working fine.

            Now if employee 1095C details are corrected only for 1 month and admin try to edit employee from ACA 1095C page, it opens employee without error.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on LB, working fine. Now if employee 1095C details are corrected only for 1 month and admin try to edit employee from ACA 1095C page, it opens employee without error.
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on stage, working fine.
            If employee 1095C is corrected only for 1 Month and employee edit is working fine from ACA 1095C Correction page.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on stage, working fine. If employee 1095C is corrected only for 1 Month and employee edit is working fine from ACA 1095C Correction page.
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on production, working fine.
            Employee record can be edited without problem.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production, working fine. Employee record can be edited without problem.

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              sachin.hingole Sachin Hingole (Inactive)
              Developer:
              Ramya Tantry (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date: