Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-709

Document unique statistical codes in release notes

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: P2
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      Prokopovych - Sprint 110, Prokopovych - Sprint 111
    • Story Points:
      1
    • Development Team:
      Prokopovych
    • Release:
      R1 2021 Bug Fix

      Description

      Overview:
      Encountered the following error when upgrading from mod-inventory-storage-19.4.4 to 20.0.1

      Response Code: HTTP/1.1 500 Internal Server Error
      Success code from [100‥599]
      [Pipeline] echo
      500
      Tenant operation failed for module mod-inventory-storage-20.0.1: SQL error
           DO $do$
          BEGIN
            PERFORM rmb_internal_index(
            'statistical_code', 'statistical_code_name_idx_unique', 'ADD',
            'CREATE UNIQUE INDEX IF NOT EXISTS statistical_code_name_idx_unique ON fs09000000_mod_inventory_storage.statistical_code '
            || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
            );
          END $do$;
      

      due to duplicate names in

      select jsonb->'name' as name from fs09000000_mod_inventory_storage.statistical_code order by name

      Possible suggestion to document need to remove duplicates before upgrading in release notes

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                marcjohnson Marc Johnson
                Reporter:
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases