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

CLONE 2020R2.1 - 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 2020R2.1
    • 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

        1. screenshot-1.png
          9 kB
          Will Englefield
        2. screenshot-2.png
          121 kB
          Stacy Privalova

          Issue Links

            Activity

              People

              • Assignee:
                stacy.privalova Stacy Privalova
                Reporter:
                stacy.privalova Stacy Privalova
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h Time Not Required
                  1h

                    PagerDuty

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