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

WT -> BCC Invoice Enhancement -> Server Error after searching employee name with single quote.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • 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 - Symphony_Production_10272016
      1] Login to the application, navigate to Report>Invoice Management.
      2] Navigate to any invoice>Invoice Details. search any term with single quote. (e.g. o'really)

      Actual Result:
      Server error is displaying.
      Expected Result:
      Server error should not be display, record should be get searched.

      Error Log:
      Exception : Input string was not in a correct format.
      App Error Log : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->InvoiceDetails.GetData->InvoiceDetails.GetTemplateNameWithSimilarSelection
      Employee ID : 0
      Action Name : CreateInvoicePVPost
      Model : System.Web.Mvc.HandleErrorInfo
      Controller : Report
      Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.GetData(ObjectType I_objectType, Hashtable I_criteria, Object I_context, Boolean I_mode, Boolean I_needCollection) in d:\WT\branches\LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 122
      at WORKTERRA.BenAdmin.Areas.Report.Models.InvoiceManagement.CreateInvoiceModel.CheckTemplateWithSimilarSelection(AddInvoiceDetails objInvoiceDetails) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Report\Models\InvoiceManagement\CreateInvoiceModel.cs:line 394
      at WORKTERRA.BenAdmin.Areas.Report.Models.InvoiceManagement.CreateInvoiceModel.SaveinvoiceDetails() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Report\Models\InvoiceManagement\CreateInvoiceModel.cs:line 257
      at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.CreateInvoicePVPost(CreateInvoiceModel objCreateInvoiceModel) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Report\Controllers\InvoiceManagement\InvoiceController.cs:line 68
      at lambda_method(Closure , ControllerBase , Object[] )
      at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
      at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
      at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass42.<BeginInvokeSynchronousActionMethod>b_41()
      at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass37.<>cDisplayClass39.<BeginInvokeActionMethodWithFilters>b_33()
      at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b_49()
      at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b_49()
      at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass37.<BeginInvokeActionMethodWithFilters>b_36(IAsyncResult asyncResult)
      at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass25.<>cDisplayClass2a.<BeginInvokeAction>b_20()
      at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass25.<BeginInvokeAction>b_22(IAsyncResult asyncResult)

        Attachments

          Issue Links

            Activity

            kunal.kedari Kunal Kedari (Inactive) created issue -
            kunal.kedari Kunal Kedari (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 -

            Tested with special characters like ` ' space etc
            Records are getting searched successfully with above special characters on generated invoices

            Ready for Stage

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested with special characters like ` ' space etc Records are getting searched successfully with above special characters on generated invoices 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: In Testing(10210)
            alankar.chavan Alankar Chavan (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)
            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)
            kunal.kedari Kunal Kedari (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
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            Verified mentioned scenario on Stage environment for "Marquette For HSPL", now error is not displaying after searching employee name with single quote.

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - Verified mentioned scenario on Stage environment for "Marquette For HSPL", now error is not displaying after searching employee name with single quote.
            kunal.kedari Kunal Kedari (Inactive) logged work - 24/Nov/16 01:10 PM
            • Time Spent:
              0.25h
               

              Done testing on Stage.

            kunal.kedari Kunal Kedari (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ]
            Original Estimate 0.5h [ 1800 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0.25h [ 900 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 10438 [ 10438 ]
            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: In Testing(10214) 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 -

            Tested with special characters like ` ' space etc on Production - 14th Dec 2016
            Records are getting searched successfully with above special characters on generated invoices

            CC - Deepali Tidke Hrishikesh Deshpande Rakesh RoyVenkatesh Pujari

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Tested with special characters like ` ' space etc on Production - 14th Dec 2016 Records are getting searched successfully with above special characters on generated invoices CC - Deepali Tidke Hrishikesh Deshpande Rakesh Roy Venkatesh Pujari
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            alankar.chavan Alankar Chavan (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)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            alankar.chavan Alankar Chavan (Inactive) logged work - 14/Dec/16 12:42 PM
            • Time Spent:
              0.5h
               

              Prod Testing

            alankar.chavan Alankar Chavan (Inactive) made changes -
            Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
            Time Spent 0.25h [ 900 ] 0.75h [ 2700 ]
            Worklog Id 13072 [ 13072 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            5d 18h 10m 1
            Prasanna Karlekar (Inactive) made transition -
            In Development In LB Testing
            2s 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            26d 2h 42m 1
            Alankar Chavan (Inactive) made transition -
            Stage Testing In Production Testing
            2d 52m 1
            Alankar Chavan (Inactive) made transition -
            In Production Testing Production Complete
            4s 1
            Alankar Chavan (Inactive) made transition -
            Production Complete Closed
            2s 1

              People

              Assignee:
              alankar.chavan Alankar Chavan (Inactive)
              Reporter:
              kunal.kedari Kunal Kedari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0.5h Original Estimate - 0.5h
                  0.5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.75h
                  0.75h