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

WT -> BCC Invoice Enhancement -> Server Error on Invoice [ErrorMessage: Incorrect syntax near 'BasicLifePlanName']

    Details

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

      Description

      • ASML
      • created Template
      • all classes selected
      • all types of CIGNA benefit provider selected
      • save
      • generated invoice for 2016 Nov
      • clicked on Invoice

      Server Error

      Error Log - ErrorID : 0
      ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData-
      >InvoiceDetails.GetData->ManipulateInvoice.SelectInvoiceDetails->ManipulateInvoice.Overload_SelectInvoiceDetails
      ErrorMessage: Incorrect syntax near 'BasicLifePlanName'.

      CC - Deepali Tidke Hrishikesh Deshpande Rakesh Roy Venkatesh Pujari

      THIS IS BLOCKING IN TESTING - 10th Nov 2016

        Attachments

          Issue Links

            Activity

            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 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Alankar Chavan [ alankar.chavan ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on WT Stage - 17th Nov 2016
            Working well

            No server error after clicking on generated invoice

            Ready for Stage

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on WT Stage - 17th Nov 2016 Working well No server error after clicking on 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)
            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
            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
            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
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on Production on ASML For Hspl company.

            No server error after clicking on generated invoice

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on Production on ASML For Hspl company. No server error after clicking on 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) logged work - 14/Dec/16 12:01 PM
            • Time Spent:
              0.25h
               
              <No comment>
            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 13045 [ 13045 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            6d 2h 34m 1
            Prasanna Karlekar (Inactive) made transition -
            In Development In LB Testing
            2s 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            25d 18h 10m 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            2d 35m 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            12s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            3s 1

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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