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
          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
          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
          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
          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
          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.

            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: