New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5456

Pre-Prod: Standard Report>> Billing Details Report Error

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Pre Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin
    • Reported by:
      Harbinger
    • Company:
      Union School District
    • Item State:
      Stage QA - Production Deployment on Hold
    • UAT For:
      UI Refresh

      Description

      In standard report >>billing details>> error while processing report
      (Please see the attached screen shot)

      --------------------------------------------------------------------------------
      CC: Mandar Kulkarni, Satya, Rakesh Roy, Sachin Hingole

        Attachments

          Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. NF-5494 PreProd | FDU | Partner | Report | Giving error

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

          Support Activity - Support Activity NF-5195 Preprod build deployment

          • Medium - Has the potential to affect progress.
          • Open

            Activity

            Ascending order - Click to sort in descending order
            sumeet.kolge Sumeet.Kolge (Inactive) created issue -
            sumeet.kolge Sumeet.Kolge (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to NF-5195 [ NF-5195 ]
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Harshada Borole [ harshada.borole ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Prasanna Karlekar [ prasanna ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Permalink
            harshada.borole Harshada Borole (Inactive) logged work - 13/Dec/17 08:47 AM
            • Time Spent:
              3h
               

              Analysis,
              Discussion with Prasanna and Sumeet.
              Sent code for review.

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 3h [ 10800 ]
            Worklog Id 95897 [ 95897 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 13/Dec/17 07:30 PM
            • Time Spent:
              2.5h
               

              Test Scenarios
              Code check in

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 13/Dec/17 08:30 PM
            • Time Spent:
              0.5h
               

              Issue discussion
              Discussion on Family rates code block

            harshada.borole Harshada Borole (Inactive) made changes -
            Link This issue duplicates NF-5494 [ NF-5494 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 19/Dec/17 04:22 AM
            • Time Spent:
              1.5h
               

              Internal discussion with Harshada
              Check changes

            harshada.borole Harshada Borole (Inactive) made changes -
            Developer Harshada Borole [ harshada.borole ]
            Original Estimate 0h [ 0 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 21/Dec/17 12:15 PM - edited
            • Time Spent:
              2.5h
               

              Code and functionality review
              Review request update

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Harshada Borole [ harshada.borole ]
            parmeshwar.jumbad Parmeshwar Jumbad (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)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 21/Dec/2017
            Code Reviewed By Parmeshwar Jumbad [ 17800 ]
            Root Cause Bug [ 18430 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 3h [ 10800 ] 5.5h [ 19800 ]
            Worklog Id 97575 [ 97575 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Worklog Id 97575 [ 97575 ]
            Hide
            Permalink
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are the 3C's:

            Concern: Pre-Prod: Standard Report>> Billing Details Report Error

            Cause: Some part of code block of WT-9409 was checked-in under NF-5136. Stored Procedure contained a block which dropped the table. This code block was deployed under NF-5136.

            Correction: Commented the code block which dropped the table. This will get uncommented once WT-9409 gets deployed in UiRefresh branch.

            Affected files:
            dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql

            Test scenario's:
            Pulled Billing reports with Approved coverage selected from Benefit related Fields.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Concern: Pre-Prod: Standard Report>> Billing Details Report Error Cause: Some part of code block of WT-9409 was checked-in under NF-5136 . Stored Procedure contained a block which dropped the table. This code block was deployed under NF-5136 . Correction: Commented the code block which dropped the table. This will get uncommented once WT-9409 gets deployed in UiRefresh branch. Affected files: dbo.OES_SP_GetBillingDetailsMonthly.StoredProcedure.sql Test scenario's: Pulled Billing reports with Approved coverage selected from Benefit related Fields.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Sachin Hingole [ sachin.hingole ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 7h [ 25200 ]
            Worklog Id 97920 [ 97920 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            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)
            Hide
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This issue is Fixed on Codemap.
            Billing details Report running and Previewing as expected on Codemap.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This issue is Fixed on Codemap. Billing details Report running and Previewing as expected on Codemap. Thanks, Hrishikesh.
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 28/Dec/17 11:38 AM
            • Time Spent:
              0.5h
               
              <No comment>
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 7h [ 25200 ] 7.5h [ 27000 ]
            Worklog Id 98291 [ 98291 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 8h [ 28800 ]
            Worklog Id 99079 [ 99079 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 8h [ 28800 ] 10.5h [ 37800 ]
            Worklog Id 99082 [ 99082 ]
            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: Production Deployment on Hold(10224)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            		1d 20h 28m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		13d 22h 54m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		20d 12h 25m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            		65d 14h 3m 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            		4m 28s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              sumeet.kolge Sumeet.Kolge (Inactive)
              Developer:
              Harshada Borole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

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