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

            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-2295 [ WT-2295 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            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.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            ramya.tantry Ramya Tantry (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)
            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.
            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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Production Due Date 14/Sep/2016
            Stage Due Date 12/Sep/16 [ 2016-09-12 ]
            gokul.sonawane Gokul Sonawane (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)
            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: In Testing(10214)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            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.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            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)
            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)
            sachin.hingole Sachin Hingole (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)
            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.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            3h 54m 1
            Ramya Tantry (Inactive) made transition -
            In Development In LB Testing
            3s 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            3d 21h 50m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            3d 21h 31m 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            2h 26m 1
            Sachin Hingole (Inactive) made transition -
            Production Complete Closed
            3s 1

              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: