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

Document unique statistical codes in release notes

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • None
    • None
    • Prokopovych - Sprint 110, Prokopovych - Sprint 111
    • 1
    • Prokopovych
    • 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

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases