WORKTERRAProject Type: software

WORKTERRA

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

WT -> BCC Invoice Enhancement -> Server Error on clicking of generated invoice

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      • company - Rashmita_Symphony_12478
      • created an invoice template for selected class - all plans
      • generated an invoice for 2017 Jan
      • clicked no generated invoice for viewing the data

      Server Error

      Error Log -

      ErrorID : 0
      ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->InvoiceDetails.GetData->
      ManipulateInvoice.SelectInvoiceDetails->ManipulateInvoice.Overload_SelectInvoiceDetails
      ErrorMessage: Invalid column name 'BenefitTypeDisplayCost_23'.
      Invalid column name 'MedicalPlanName'.
      Invalid column name 'MedicalCoverageTier'.
      Invalid column name 'BenefitTypeDisplayCost_24'.
      Invalid column name 'DentalPlanName'.
      Invalid column name 'DentalCoverageTier'.
      Invalid column name 'BenefitTypeDisplayCost_26'.
      Invalid column name 'AccidentPlanName'.
      Invalid column name 'AccidentCoverageTier'.
      Invalid column name 'BenefitTypeDisplayCost_28'.
      Invalid column name 'BasicLifePlanName'.

      CC - Deepali Tidke Rakesh Roy Venkatesh Pujari Hrishikesh Deshpande

      I am blocked to test few scenarios with this

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-3862 BCC - Client Bill Upload Functionality

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            alankar.chavan Alankar Chavan (Inactive) created issue -
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-3862 [ WT-3862 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Permalink
            deepalit Deepali Tidke (Inactive) added a comment -

            server error is coming even also only 1 class and 1 plan is selected.

            Show
            deepalit Deepali Tidke (Inactive) added a comment - server error is coming even also only 1 class and 1 plan is selected.
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Alankar Chavan [ alankar.chavan ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Tested on WT Stage - 17th Nov 2016
            Working Well

            Tested on ASML - Symphony

            No Server Error on any generated invoice

            Ready for Stage

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested on WT Stage - 17th Nov 2016 Working Well Tested on ASML - Symphony No Server Error on any generated invoice Ready for Stage
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            prasanna Prasanna Karlekar (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)
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Tested on Stage - Ready for Production
            keeping this on HOLD as we will move these items on Production with main enhancement (which is at Stage currently)

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested on Stage - Ready for Production keeping this on HOLD as we will move these items on Production with main enhancement (which is at Stage currently)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Venkatesh Pujari - please test it on Production, Make it close if this is working as per the expectations or else reopen it with comments

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Venkatesh Pujari - please test it on Production, Make it close if this is working as per the expectations or else reopen it with comments
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Venkatesh Pujari [ venkatesh.pujari ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on Production on CEI for hspl company.

            No server error on any click of any generated invoice

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on Production on CEI for hspl company. No server error on any click of any generated invoice
            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: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 0.25h [ 900 ]
            Original Estimate 0.25h [ 900 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 13044 [ 13044 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Worklog Id 13044 [ 13044 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 14/Dec/16 01:00 PM - edited
            • Time Spent:
              0.25h
               
              <No comment>
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Jyoti Agrawal (Inactive) made transition -
            Open In Development
            		3h 15m 1
            Prasanna Karlekar (Inactive) made transition -
            In Development In LB Testing
            		12d 5h 48m 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            		25d 18h 17m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            		2d 25m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		10s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		2s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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