WORKTERRAProject Type: software

WORKTERRA

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

Functional | Any company |ACA |Measurement stability period | An error is occurring during report process

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Company:
      JE Dunn
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Q2
    • Browser:
      Google Chrome, Mozilla Firefox

      Description

      Environment : Azure
      Company name: JE Dunn For HSPL

      • Login as partner
      • Select company
      • Select Measurement stability period under ACA
      • Click on cost of coverage icon of listed measurement stability period
      • Observe the result

      Actual result : An error is occurring during report process.
      Expected result : Report should process without fetching any error.

      Please find attached screenshot .

      NOTE : Same issue Exist for Stage environment , For cost & coverage Hence we are moving this point to WT .

      CC- Rakesh Roy Sachin Hingole Smita Pawar

        Attachments

          Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. NF-5533 Superheat - Billing Summary Report - Premium is not calculating correctly

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

          Bug - A problem which impairs or prevents the functions of the product. WT-11470 Superheat - Billing Summary Report - Premium is not calculating correctly

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

            Activity

            Ascending order - Click to sort in descending order
            rutuja.chilwar Rutuja Chilwar (Inactive) created issue -
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Field Original Value New Value
            Description *Environment : Azure*
            - Login as partner
            - Select company
            - Select Measurement stability period under ACA
            - Click on cost of coverage icon of listed measurement stability period
            - Observe the result

            *Actual result* : An error is occurring during report process.
            *Expected result* : Report should process without fetching any error.

            Please find attached screenshot .

             !measurement stability period.png|thumbnail!

            CC- [~rakeshr] [~sachin.hingole] [~smita.pawar]

            		 *Environment : Azure*
            *Company name: JE Dunn For HSPL*
            - Login as partner
            - Select company
            - Select Measurement stability period under ACA
            - Click on cost of coverage icon of listed measurement stability period
            - Observe the result

            *Actual result* : An error is occurring during report process.
            *Expected result* : Report should process without fetching any error.

            Please find attached screenshot .

             !measurement stability period.png|thumbnail!

            CC- [~rakeshr] [~sachin.hingole] [~smita.pawar]
            Permalink
            rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 07/Nov/17 12:38 PM
            • Time Spent:
              0.25h
               
              <No comment>
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 89493 [ 89493 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: ACA(10104)
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Attachment cost of coverage_error _stage.png [ 67486 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Description *Environment : Azure*
            *Company name: JE Dunn For HSPL*
            - Login as partner
            - Select company
            - Select Measurement stability period under ACA
            - Click on cost of coverage icon of listed measurement stability period
            - Observe the result

            *Actual result* : An error is occurring during report process.
            *Expected result* : Report should process without fetching any error.

            Please find attached screenshot .

             !measurement stability period.png|thumbnail!

            CC- [~rakeshr] [~sachin.hingole] [~smita.pawar]

            		 *Environment : Azure*
            *Company name: JE Dunn For HSPL*
            - Login as partner
            - Select company
            - Select Measurement stability period under ACA
            - Click on cost of coverage icon of listed measurement stability period
            - Observe the result

            *Actual result* : An error is occurring during report process.
            *Expected result* : Report should process without fetching any error.

            Please find attached screenshot .

             !measurement stability period.png|thumbnail!

            *NOTE : Same issue Exist for Stage environment , For cost & coverage* . !cost of coverage_error _stage.png|thumbnail!

            CC- [~rakeshr] [~sachin.hingole] [~smita.pawar]
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Component/s UI Refresh [ 10902 ]
            Key NF-4987 WT-12096
            Project New Features 2017 [ 11000 ] WORKTERRA [ 10000 ]
            rutuja.chilwar Rutuja Chilwar (Inactive) made changes -
            Description *Environment : Azure*
            *Company name: JE Dunn For HSPL*
            - Login as partner
            - Select company
            - Select Measurement stability period under ACA
            - Click on cost of coverage icon of listed measurement stability period
            - Observe the result

            *Actual result* : An error is occurring during report process.
            *Expected result* : Report should process without fetching any error.

            Please find attached screenshot .

             !measurement stability period.png|thumbnail!

            *NOTE : Same issue Exist for Stage environment , For cost & coverage* . !cost of coverage_error _stage.png|thumbnail!

            CC- [~rakeshr] [~sachin.hingole] [~smita.pawar]

            		 *Environment : Azure*
            *Company name: JE Dunn For HSPL*
            - Login as partner
            - Select company
            - Select Measurement stability period under ACA
            - Click on cost of coverage icon of listed measurement stability period
            - Observe the result

            *Actual result* : An error is occurring during report process.
            *Expected result* : Report should process without fetching any error.

            Please find attached screenshot .

             !measurement stability period.png|thumbnail!

            *NOTE : Same issue Exist for Stage environment , For cost & coverage Hence we are moving this point to WT* . !cost of coverage_error _stage.png|thumbnail!

            CC- [~rakeshr] [~sachin.hingole] [~smita.pawar]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern: Measurement stability period | An error is occurring during report process of Cost of coverage
            Cause: This issue occurred due to changes done for WT-11470-Superheat - Billing Summary Report - Premium is not calculating correctly.
            In SP "dbo.OES_SP_GetBillingDetails.StoredProcedure", datatypes of the table columns were changed.This same SP is used in Cost of Coverage for ACA.
            Correction: Changed the datatypes of the columns of the table used in SP OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql to match with column datatypes set in OES_SP_GetBillingDetails.StoredProcedure.sql

            Affected files : dbo.OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : Measurement stability period | An error is occurring during report process of Cost of coverage Cause : This issue occurred due to changes done for WT-11470 -Superheat - Billing Summary Report - Premium is not calculating correctly. In SP "dbo.OES_SP_GetBillingDetails.StoredProcedure", datatypes of the table columns were changed.This same SP is used in Cost of Coverage for ACA. Correction : Changed the datatypes of the columns of the table used in SP OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql to match with column datatypes set in OES_SP_GetBillingDetails.StoredProcedure.sql Affected files : dbo.OES_SP_Get_CostOfCoverageForACA.StoredProcedure.sql
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue is caused by WT-11470 [ WT-11470 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Code Reviewed By Nandkumar Karlekar [ 11904 ]
            Original Estimate 4h [ 14400 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            smita.pawar Smita Pawar (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
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB [For QA CAISO For HSPL].
            Its working fine.Its ready for stage.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB [For QA CAISO For HSPL] . Its working fine.Its ready for stage.
            smita.pawar Smita Pawar (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)
            Permalink
            ramya.tantry Ramya Tantry (Inactive) logged work - 11/Nov/17 09:59 AM
            • Time Spent:
              1.5h
               

              Issue analysis
              Code fixing
              Discussion
              Checkin to LB,Stage,UIRefresh and Local

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 0.25h [ 900 ] 1.75h [ 6300 ]
            Worklog Id 90300 [ 90300 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (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)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on stage [Caiso for Hspl & JE Dunn for Hspl].
            Its working fine.
            Ready for production.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on stage [Caiso for Hspl & JE Dunn for Hspl] . Its working fine. Ready for production.
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 11/Nov/17 10:15 AM
            • Time Spent:
              0.5h
               

              LB & Stage testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 1.75h [ 6300 ] 2.25h [ 8100 ]
            Worklog Id 90301 [ 90301 ]
            Hide
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have verified this issue on Production and observed that it does not exist.Hence closing the same.

            Thanks,
            Mahendra

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have verified this issue on Production and observed that it does not exist.Hence closing the same. Thanks, Mahendra
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 29/Nov/17 04:16 AM
            • Time Spent:
              0.25h
               

              Issue verification on Production

            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Time Spent 2.25h [ 8100 ] 2.5h [ 9000 ]
            Worklog Id 93789 [ 93789 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue is caused by WT-12815 [ WT-12815 ]
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 29/Dec/17 11:42 AM
            • Time Spent:
              0.5h
               

              Bug retesting on Preprod

            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Time Spent 2.5h [ 9000 ] 3h [ 10800 ]
            Worklog Id 98799 [ 98799 ]
            Transition Time In Source Status Execution Times
            Smita Pawar (Inactive) made transition -
            Open In Development
            		3d 20h 59m 1
            Ramya Tantry (Inactive) made transition -
            In Development In LB Testing
            		31m 6s 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Stage Testing
            		10m 10s 1
            Mahendra Mungase (Inactive) made transition -
            Stage Testing In Production Testing
            		17d 46m 1
            Mahendra Mungase (Inactive) made transition -
            In Production Testing Production Complete
            		17s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              rutuja.chilwar Rutuja Chilwar (Inactive)
              Developer:
              Ramya Tantry (Inactive)
              QA:
              Rutuja Chilwar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h Time Not Required
                  3h