WORKTERRAProject Type: software

WORKTERRA

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

Getting server error on saving site branding configuration for word like Yoke's

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Platform
    • Labels:
      None
    • Environment:
      Stage
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Getting server error on saving site branding configuration for word like Yoke's

      ErrorID : 0
      ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->WORKTERRACommon.Save=>WORKTERRACommon.SaveSiteBrandingOtherConfiguration
      ErrorMessage: Incorrect syntax near 's'.
      Unclosed quotation mark after the character string ', TotalCostAndCreditonSummary1 = ', TotalCostAndCreditonSummary2 = ', TotalCostAndCreditonSummary3 = ', DisplayHSAPaycheckValues = 0, DatetimeStamp=Getdate() , UserID =1 Delete from BenefitType_EmployerCostSettings Where CostSettingsCategoryId IN (1,2,3,4)'.
      StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)

      Got during one of demo set up of http://www.yokesfreshmarkets.com/

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          rakeshr Rakesh Roy (Inactive) created issue -
          rakeshr Rakesh Roy (Inactive) made changes -
          Field Original Value New Value
          Issue Importance Can Wait [ 11801 ] Must Have [ 11800 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Priority High [ 2 ] Highest [ 1 ]
          satyap Satya made changes -
          Component/s Platform [ 10006 ]
          Component/s BenAdmin [ 10000 ]
          Hide
          Permalink
          satyap Satya added a comment -

          Hi Sheetal,

          Can we please have this validation check implemented?

          Thanks & Regards,
          Satya Prakash

          Show
          satyap Satya added a comment - Hi Sheetal, Can we please have this validation check implemented? Thanks & Regards, Satya Prakash
          satyap Satya made changes -
          Assignee Satya [ ID10004 ] Sheetal Bodhale [ sheetal.bodhale ]
          Hide
          Permalink
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment -

          Hi Satya,

          Yes we can implement this.
          Due to short bandwidth, cant assign this task today.Will assign to Chaitali tomorrow.

          CC:Swapnil Pandhare
          Thanks,
          Sheetal Bodhale

          Show
          sheetal.bodhale Sheetal Bodhale (Inactive) added a comment - Hi Satya , Yes we can implement this. Due to short bandwidth, cant assign this task today.Will assign to Chaitali tomorrow. CC: Swapnil Pandhare Thanks, Sheetal Bodhale
          sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
          Assignee Sheetal Bodhale [ sheetal.bodhale ] Chaitali Acharya [ chaitali.acharya ]
          Hide
          Permalink
          chaitali.acharya Chaitali Acharya (Inactive) added a comment -

          Hi Rakesh Roy
          As per discussion with Satya
          Validation is to be implemented for :
          1)Copyright Text.
          2)Copyright Text in Spanish.
          3)Copyright Text in French.
          4)Spending Credit Label.
          5)Total Costs & Credit On Summary.
          6)Total Costs & Credit On Summary(Spanish).
          7)Total Costs & Credit On Summary(French).

          As per discussion with Rakesh Roy
          1)Characters not allowed are ; ' – xp_
          2)Validation error message to be shown ->Special characters like ; ' – xp_ are not allowed.

          Development is in progress on this and will update you on this by tomorrow.

          CC:Swapnil Pandhare Sheetal Bodhale
          Thanks,
          Chaitali

          Show
          chaitali.acharya Chaitali Acharya (Inactive) added a comment - Hi Rakesh Roy As per discussion with Satya Validation is to be implemented for : 1)Copyright Text. 2)Copyright Text in Spanish. 3)Copyright Text in French. 4)Spending Credit Label. 5)Total Costs & Credit On Summary. 6)Total Costs & Credit On Summary(Spanish). 7)Total Costs & Credit On Summary(French). As per discussion with Rakesh Roy 1)Characters not allowed are ; ' – xp_ 2)Validation error message to be shown ->Special characters like ; ' – xp_ are not allowed. Development is in progress on this and will update you on this by tomorrow. CC: Swapnil Pandhare Sheetal Bodhale Thanks, Chaitali
          Hide
          Permalink
          chaitali.acharya Chaitali Acharya (Inactive) added a comment -

          Concern:
          Getting server error on saving site branding configuration for word like Yoke's

          Cause:
          Characters like ' cause SQL Query to form wrongly so system throws Server Error.

          Correction:
          We have now provided validation for special characters ; ' – xp_.

          Risk Mitigation:
          Now user will be prevented from entering special characters like ; ' – xp_ and system will not throw server error.

          Show
          chaitali.acharya Chaitali Acharya (Inactive) added a comment - Concern: Getting server error on saving site branding configuration for word like Yoke's Cause: Characters like ' cause SQL Query to form wrongly so system throws Server Error. Correction: We have now provided validation for special characters ; ' – xp_. Risk Mitigation: Now user will be prevented from entering special characters like ; ' – xp_ and system will not throw server error.
          Hide
          Permalink
          chaitali.acharya Chaitali Acharya (Inactive) added a comment -

          Files affected:
          SiteBrandingOtherConfiguration.cshtml

          Show
          chaitali.acharya Chaitali Acharya (Inactive) added a comment - Files affected: SiteBrandingOtherConfiguration.cshtml
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          chaitali.acharya Chaitali Acharya (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          chaitali.acharya Chaitali Acharya (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          chaitali.acharya Chaitali Acharya (Inactive) made changes -
          Assignee Chaitali Acharya [ chaitali.acharya ] Deepali Tidke [ deepalit ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment LB_Validation_Message_Pass.png [ 26872 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment LB_Accepts other than apostrophe_Pass.png [ 26873 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment LB_Pass.png [ 26874 ]
          rakeshr Rakesh Roy (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)
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          Working fine--Refer attached image

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Working fine--Refer attached image
          rakeshr Rakesh Roy (Inactive) made changes -
          Developer Chaitali Acharya [ chaitali.acharya ]
          gokul.sonawane Gokul Sonawane (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
          deepalit Deepali Tidke (Inactive) added a comment -

          working fine on stage as well.

          Show
          deepalit Deepali Tidke (Inactive) added a comment - working fine on stage as well.
          deepalit Deepali Tidke (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          deepalit Deepali Tidke (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          ashwin.wankhede Ashwin Wankhede (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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rakeshr Rakesh Roy (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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          Transition Time In Source Status Execution Times
          Chaitali Acharya (Inactive) made transition -
          Open In Development
          		3d 19h 49m 1
          Chaitali Acharya (Inactive) made transition -
          In Development In LB Testing
          		13s 1
          Deepali Tidke (Inactive) made transition -
          In LB Testing Stage Testing
          		2d 23h 55m 1
          Rakesh Roy (Inactive) made transition -
          Stage Testing In Production Testing
          		3d 15h 49m 1
          Rakesh Roy (Inactive) made transition -
          In Production Testing Production Complete
          		7s 1
          Rakesh Roy (Inactive) made transition -
          Production Complete Closed
          		10s 1

            People

            Assignee:
            deepalit Deepali Tidke (Inactive)
            Reporter:
            rakeshr Rakesh Roy (Inactive)
            Developer:
            Chaitali Acharya (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: