Script for setting the SRS record "order" field so that Inventory Single Record Imports do not display blank log information

Owned by Aivar Iusupov
Last updated: Jun 14, 2022 by Ann-Marie Breaux (Deactivated)
1 min read

Before MODSOURMAN-422 was released, single record imports provided record with no "order" field . It led to the problem with log display (no log shown) for single record create/update, which is documented in UIDATIMP-1136 bug

After MODSOURMAN-422 release for the new single record imports (create) new records with empty "order" field were not created, but records that were imported before MODSOURMAN-422 still have "order" field empty.

To prevent the occurrence of this problem for the single record update operations on the already existent records with empty "order" field we need to run these updates at any time:

UPDATE {tenant}_mod_source_record_storage.records_lb SET "order"=0 WHERE "order" IS NULL;

UPDATE {tenant}_mod_source_record_manager.journal_records SET source_record_order=0 WHERE source_record_order IS NULL;

Where {tenant} - the owner (tenant) for which you want to run the update.