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

Cannot update TBC Invoice number alpha, numeric or special chars

    Details

    • Type: Sprint Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2019R4
    • Fix Version/s: CFA 2019R4
    • Component/s: customerSales
    • Labels:
      None

      Description

      Cannot update Invoice with special chars. Receiving a Requested Operation Failed Error:
      NHibernate.Exceptions.GenericADOException: could not execute native bulk manipulation query:
      UPDATE tboas
      SET
      tboas.CustomerId = :CustomerId,
      tboas.InvoiceNumber = :InvoiceNumber,
      tboas.[Description] = :Description
      FROM tbonaccountsale tboas WITH (nolock)
      WHERE tboas.OnAccountSaleId = :OnAccountSaleId
      AND tboas.TransactionSummaryID = :TransactionSummaryId
      AND tboas.entityid = :EntityId

      [SQL:
      UPDATE tboas
      SET
      tboas.CustomerId = @p0,
      tboas.InvoiceNumber = @p1,
      tboas.[Description] = @p2
      FROM tbonaccountsale tboas WITH (nolock)
      WHERE tboas.OnAccountSaleId = @p3
      AND tboas.TransactionSummaryID = @p4
      AND tboas.entityid = @p5

      AC #6. Confirm that the Invoice Number can be updated with alpha, numeric and special characters, with a max length of 30

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                soma.dixon Soma Dixon (Inactive)
              • 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 - 2h
                  2h

                    PagerDuty

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