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
- relates to
-
MODINVSTOR-596 Settings > Inventory > Statistical codes. Statistical code name is being case sensitive
-
- Closed
-
- mentioned in
-
Page Loading...