Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-10838

CFA Vendor short name update requires more than 30 characters

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2020R2, CFA 2020R3
    • Fix Version/s: CFA 2020R4
    • Component/s: OrderGuide
    • Labels:
      None
    • SCRUM Team:
      Brotherhood of Mutants
    • Root cause - Reason:
      Requirements incorrect
    • Source Code ID(s):
    • Sprint:
      CFAMX 2020R4 Sprint 2

      Description

      CFA Vendor short name update requires more than 30 characters
      Chick-Fil-A is in the process of updating Distributor and Distribution Centers names. With these changes vendor's short name will be the same as vendor's name. For 'Food Authority of Massachusetts' its short name will be 'Food Authority of Massachusetts'. When I am trying to update it, it gives me this error: 'Msg 8152, Level 16, State 14, Line 21
      String or binary data would be truncated.
      The statement has been terminated.'
      I've checked tbVendorshortName table parameters and it appears ShortName column max length is varchar 30
      'Food Authority of Massachusetts' is 31. There is a need to support more than 30 characters.

      Based on the way that CFA are sending these names, it would be prudent to match the field to be the same size as the VendorName in tbVendor.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                stacy.privalova Stacy Privalova
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 3h
                  3h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.