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

On benefit type name change after invoice generation results into server error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT- Sprint 43

      Description

      Example :-
      Step 1: Select a benefit type named 'LTD' in an invoice template.
      Step 2: Generate invoice.
      Step 3: Now change the Benefit Type name 'LTD' to 'Long Term Disability'
      Step 4 : Generate next invoice or view invoice.

      Result : Server error

        Attachments

          Issue Links

            Activity

            jyoti.agrawal Jyoti Agrawal (Inactive) created issue -
            prasanna Prasanna Karlekar (Inactive) made changes -
            Field Original Value New Value
            Company All Clients/Multiple Clients [ 18434 ]
            Root Cause Scenario/Requirement Missed [ 18432 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Developer Harshada Borole [ harshada.borole ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Environment Production [ 10005 ]
            Environment_New Production [ 18442 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Invoice_Management
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Developer Harshada Borole [ harshada.borole ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 07/Nov/17 01:06 PM
            • Time Spent:
              4h
               

              Analysis, discussion with prasanna

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 89522 [ 89522 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 07/Nov/17 11:30 PM
            • Time Spent:
              0.75h
               

              Pair programming:
              Discussion and analysis for Benefitwise flag value when disabled

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 08/Nov/17 01:12 PM - edited
            • Time Spent:
              4h
               

              Coding, unit testing

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 10/Nov/2017
            Dev Estimates 28
            Original Estimate 0h [ 0 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 0.75h [ 2700 ] 4.75h [ 17100 ]
            Worklog Id 89923 [ 89923 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 4.75h [ 17100 ] 7.75h [ 27900 ]
            Worklog Id 89931 [ 89931 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 7.75h [ 27900 ] 8.75h [ 31500 ]
            Worklog Id 89931 [ 89931 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 09/Nov/17 01:23 PM
            • Time Spent:
              2h
               

              Unit testing

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 8.75h [ 31500 ] 10.75h [ 38700 ]
            Worklog Id 89945 [ 89945 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Prasanna Karlekar [ prasanna ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 10/Nov/17 12:30 PM
            • Time Spent:
              4h
               

              Unit testing, patch creation

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 10.75h [ 38700 ] 14.75h [ 53100 ]
            Worklog Id 90166 [ 90166 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 14.75h [ 53100 ] 15.5h [ 55800 ]
            Worklog Id 90510 [ 90510 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 13/Nov/17 04:23 PM
            • Time Spent:
              3h
               

              Code changes as suggested, unit testing, patch creation

            prasanna Prasanna Karlekar (Inactive) logged work - 13/Nov/17 08:00 PM
            • Time Spent:
              0.75h
               

              Code review - Changes suggested

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 15.5h [ 55800 ] 18.5h [ 66600 ]
            Worklog Id 90566 [ 90566 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            prasanna Prasanna Karlekar (Inactive) made changes -
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Code Review Date 14/Nov/2017
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 14/Nov/17 01:03 PM
            • Time Spent:
              0.5h
               

              patch check-in and revert in LB

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 18.5h [ 66600 ] 19h [ 68400 ]
            Worklog Id 90781 [ 90781 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 19h [ 68400 ] 20h [ 72000 ]
            Worklog Id 90807 [ 90807 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 14/Nov/17 08:00 PM
            • Time Spent:
              1h
               

              Code review after changes done
              Functionality review

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 10/Nov/2017 20/Nov/2017
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,

            Attaching development approval email to work on this ticket: FW Development approval for 9-Nov-2017.msg

            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching development approval email to work on this ticket: FW Development approval for 9-Nov-2017.msg Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for development [ 18453 ]
            Attachment FW Development approval for 9-Nov-2017.msg [ 68123 ]
            Attachment FW Development approval for 9-Nov-2017.msg [ 68124 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 20/Nov/2017 21/Nov/2017
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Below are 3C's :-
            Concern :- On benefit type name change after invoice generation, results into server error
            Cause :- Invoice table is created with fix column, named with benefit name. On benefit name change , during insertion in the table there was a mismatch of column name.
            Correction :- Instead of creating column with benefit name, we are using benefit ID to create column as benefit ID will never change.

            Affected File :-

            • Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_GetBenefitInvoiceMappingFields.sql
            • Database Objects/MasterCompanyDB/04_Stored Procedures/OES_SP_Invoice_Display_BenefitWiseBilling.sql

            Affected Area :-

            • Invoice Generation
            • Invoice View
            • Download Excel File
            • Invoice table structure

            Tested Scenario :-
            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            3) Change demographic fields name and then checked
            4) Change additional fields and checked
            4) Checked excel download
            5) Checked invoice summary

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Below are 3C's :- Concern :- On benefit type name change after invoice generation, results into server error Cause :- Invoice table is created with fix column, named with benefit name. On benefit name change , during insertion in the table there was a mismatch of column name. Correction :- Instead of creating column with benefit name, we are using benefit ID to create column as benefit ID will never change. Affected File :- Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_GetBenefitInvoiceMappingFields.sql Database Objects/MasterCompanyDB/04_Stored Procedures/OES_SP_Invoice_Display_BenefitWiseBilling.sql Affected Area :- Invoice Generation Invoice View Download Excel File Invoice table structure Tested Scenario :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 3) Change demographic fields name and then checked 4) Change additional fields and checked 4) Checked excel download 5) Checked invoice summary
            jyoti.agrawal Jyoti Agrawal (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)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] 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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Bug Type Functional [ 15402 ]
            Level Partner [ 15802 ]
            Production Due Date 29/Nov/2017
            Stage Due Date 27/Nov/17 [ 2017-11-27 ]
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Please check this.

            Prasad Pise Venkatesh Pujari

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Please check this. Prasad Pise Venkatesh Pujari
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Jayshree Nagpure [ jayshree.nagpure ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            As discussed with Rakesh Roy, assigning this jira to you

            CC : Sachin Hingole Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - As discussed with Rakesh Roy , assigning this jira to you CC : Sachin Hingole Prasad Pise
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited

            Hi Jyoti Agrawal,

            Tested this issue on LB on City of Durham for hspl. Working fine as expected. Verified the below listed scenarios :-

            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            4) Change demographic fields name and then checked
            5) Change additional fields and checked
            6) Checked excel download
            7) Checked invoice summary

            This is ready for Stage

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - - edited Hi Jyoti Agrawal , Tested this issue on LB on City of Durham for hspl. Working fine as expected. Verified the below listed scenarios :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 4) Change demographic fields name and then checked 5) Change additional fields and checked 6) Checked excel download 7) Checked invoice summary This is ready for Stage Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 20h [ 72000 ] 24h [ 86400 ]
            Worklog Id 92566 [ 92566 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 24/Nov/17 07:17 PM
            • Time Spent:
              4h
               

              Testing on LB

            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for development [ 18453 ] Need approval for stage [ 18454 ]
            Production Due Date 29/Nov/2017
            Stage Due Date 27/Nov/17 [ 2017-11-27 ] 2/Dec/17 [ 2017-12-02 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Stage Due Date 2/Dec/17 [ 2017-12-02 ]
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Keeping the ticket on hold, as it has not been approved for stage deployment
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Keeping the ticket on hold, as it has not been approved for stage deployment Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT- Sprint 43 [ 98 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            QA Venkatesh Pujari [ venkatesh.pujari ]
            QA Estimates 6
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 24/Jan/18 12:30 PM
            • Time Spent:
              2h
               

              Table name change script writing

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Attachment WT-11679.xls [ 72361 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 25/Jan/18 09:34 AM
            • Time Spent:
              0.5h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 24h [ 86400 ] 24.5h [ 88200 ]
            Worklog Id 102005 [ 102005 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 24.5h [ 88200 ] 26.5h [ 95400 ]
            Worklog Id 102057 [ 102057 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 25/Jan/18 12:33 PM
            • Time Spent:
              2.5h
               

              Table column name change script writing
              Testing the script

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 26.5h [ 95400 ] 29h [ 104400 ]
            Worklog Id 102061 [ 102061 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 25/Jan/18 10:30 PM
            • Time Spent:
              0.25h
               

              Discussion on scipt changes

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 29h [ 104400 ] 29.25h [ 105300 ]
            Worklog Id 102236 [ 102236 ]
            ashwin.wankhede Ashwin Wankhede (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (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)
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested this issue on Stage on AFI for hspl. Working fine as expected. Verified the below listed scenarios :-
            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            4) Change demographic fields name and then checked
            5) Change additional fields and checked
            6) Checked excel download
            7) Checked invoice summary

            This is ready for Production.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested this issue on Stage on AFI for hspl. Working fine as expected. Verified the below listed scenarios :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 4) Change demographic fields name and then checked 5) Change additional fields and checked 6) Checked excel download 7) Checked invoice summary This is ready for Production. Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (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)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue is cloned by WT-13268 [ WT-13268 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 05/Feb/18 12:27 PM
            • Time Spent:
              3h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 29.25h [ 105300 ] 32.25h [ 116100 ]
            Worklog Id 103391 [ 103391 ]
            khandu.kshirsagar Khandu Kshirsagar (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 13/Feb/18 09:10 AM
            • Time Spent:
              0.5h
               

              Testing on Prod

            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jyoti Agrawal,

            Tested this issue on Production on Community Development Commission For HSPL company. Working fine as expected. Verified the below listed scenarios :-

            1) On invoice generation, columns in invoice table for benefits should form with benefit ID
            2) Change any benefit name and check if next invoice is generated successfully
            3) Checked if new name is displayed in invoice,excel and summary
            4) Change demographic fields name and then checked
            5) Change additional fields and checked
            6) Checked excel download
            7) Checked invoice summary

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jyoti Agrawal , Tested this issue on Production on Community Development Commission For HSPL company. Working fine as expected. Verified the below listed scenarios :- 1) On invoice generation, columns in invoice table for benefits should form with benefit ID 2) Change any benefit name and check if next invoice is generated successfully 3) Checked if new name is displayed in invoice,excel and summary 4) Change demographic fields name and then checked 5) Change additional fields and checked 6) Checked excel download 7) Checked invoice summary Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 32.25h [ 116100 ] 32.75h [ 117900 ]
            Worklog Id 104305 [ 104305 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 13/Feb/18 05:12 PM - edited
            • Time Spent:
              3h
               

              Script testing
              Discussion
              Verification in few companies after script execution

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Time Spent 32.75h [ 117900 ] 35.75h [ 128700 ]
            Worklog Id 104878 [ 104878 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Worklog Id 104878 [ 104878 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Resolution Setting [ 11616 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Resolution Setting [ 11616 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Jyoti Agrawal (Inactive) made transition -
            Open In Development
            19d 21h 44m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            15d 21h 30m 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Stage Testing
            71d 8h 43m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            10d 19h 16m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            25m 49s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            13s 1
            Venkatesh Pujari (Inactive) made transition -
            Closed Resolution Setting
            82d 10h 34m 1
            Venkatesh Pujari (Inactive) made transition -
            Resolution Setting Closed
            9s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              jyoti.agrawal Jyoti Agrawal (Inactive)
              Developer:
              Jyoti Agrawal (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 35.75h
                  35.75h