|| $rmb$(left(lower(f_unaccent(jsonb->>'collection')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,173 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptStatus')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,180 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptStatus')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,180 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_paymentStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_paymentStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'paymentStatus')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,185 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_paymentStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_paymentStatus_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'paymentStatus')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,185 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_orderFormat_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_orderFormat_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'orderFormat')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,193 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_orderFormat_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_orderFormat_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'orderFormat')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,193 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptDate')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,200 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_receiptDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_receiptDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receiptDate')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,200 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_metadata_createdDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_metadata_createdDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdDate')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,208 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_metadata_createdDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_metadata_createdDate_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->'metadata'->>'createdDate')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,208 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_rush_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_rush_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'rush')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,219 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_rush_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_rush_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'rush')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,219 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_source_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_source_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'source')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,227 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_source_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_source_idx ON diku_mod_orders_storage.po_line '
      || $rmb$(left(lower(f_unaccent(jsonb->>'source')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,227 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_fundDistribution_code_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_fundDistribution_code_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'fundDistribution'->>'code'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,238 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_fundDistribution_code_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_fundDistribution_code_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'fundDistribution'->>'code'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,238 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_productIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_productIds_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'details'->>'productIds'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,249 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_details_productIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_details_productIds_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'details'->>'productIds'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,249 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_title_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS po_line_title_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'title'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,253 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_title_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS po_line_title_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'title'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,253 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_titleOrPackage_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_titleOrPackage_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'titleOrPackage'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,259 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_titleOrPackage_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_titleOrPackage_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'titleOrPackage'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,259 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_vendorAccount_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_vendorAccount_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'vendorAccount'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,263 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_vendorAccount_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_vendorAccount_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'vendorAccount'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,263 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_refNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_refNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'refNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,268 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_vendor_refNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_vendor_refNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->'vendor'->>'refNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,268 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_tags_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_tags_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'tags'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,273 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_tags_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_tags_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'tags'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,273 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_contributors_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_contributors_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'contributors'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,284 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_contributors_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_contributors_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'contributors'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,284 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_requester_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_requester_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'requester'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,290 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_requester_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_requester_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'requester'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,291 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_poLineNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_poLineNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'poLineNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,297 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_poLineNumber_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_poLineNumber_idx_gin ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'poLineNumber'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,297 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_publisher_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_publisher_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'publisher')) )$rmb$);
    END $do$
2020-06-11T08:38:00,305 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_publisher_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_publisher_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'publisher')) )$rmb$);
    END $do$
2020-06-11T08:38:00,306 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_donor_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_donor_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'donor')) )$rmb$);
    END $do$
2020-06-11T08:38:00,310 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_donor_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_donor_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'donor')) )$rmb$);
    END $do$
2020-06-11T08:38:00,310 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_selector_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_selector_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'selector')) )$rmb$);
    END $do$
2020-06-11T08:38:00,316 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'po_line', 'po_line_selector_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS po_line_selector_idx_ft ON diku_mod_orders_storage.po_line USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'selector')) )$rmb$);
    END $do$
2020-06-11T08:38:00,316 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.titles (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     )
2020-06-11T08:38:00,323 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.titles (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     )
2020-06-11T08:38:00,324 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS set_id_injson_titles ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,327 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS set_id_injson_titles ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,328 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS set_id_in_jsonb ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,331 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS set_id_in_jsonb ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,331 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE TRIGGER set_id_in_jsonb BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.titles       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_id_in_jsonb()
2020-06-11T08:38:00,349 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE TRIGGER set_id_in_jsonb BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.titles       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_id_in_jsonb()
2020-06-11T08:38:00,349 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      ALTER TABLE diku_mod_orders_storage.titles       ADD COLUMN IF NOT EXISTS creation_date timestamp,       ADD COLUMN IF NOT EXISTS created_by text
2020-06-11T08:38:00,355 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      ALTER TABLE diku_mod_orders_storage.titles       ADD COLUMN IF NOT EXISTS creation_date timestamp,       ADD COLUMN IF NOT EXISTS created_by text
2020-06-11T08:38:00,355 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          ALTER TABLE diku_mod_orders_storage.titles           ADD COLUMN IF NOT EXISTS poLineId UUID REFERENCES diku_mod_orders_storage.po_line
2020-06-11T08:38:00,370 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          ALTER TABLE diku_mod_orders_storage.titles           ADD COLUMN IF NOT EXISTS poLineId UUID REFERENCES diku_mod_orders_storage.po_line
2020-06-11T08:38:00,370 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          CREATE INDEX IF NOT EXISTS titles_poLineId_idx           ON diku_mod_orders_storage.titles (poLineId)
2020-06-11T08:38:00,371 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          CREATE INDEX IF NOT EXISTS titles_poLineId_idx           ON diku_mod_orders_storage.titles (poLineId)
2020-06-11T08:38:00,372 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          INSERT INTO rmb_internal_analyze VALUES ('titles')
2020-06-11T08:38:00,373 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          INSERT INTO rmb_internal_analyze VALUES ('titles')
2020-06-11T08:38:00,374 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_titles_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      RETURN NEW;
    END;
    $$ language 'plpgsql'
2020-06-11T08:38:00,379 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_titles_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      RETURN NEW;
    END;
    $$ language 'plpgsql'
2020-06-11T08:38:00,380 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,385 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,385 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE TRIGGER update_titles_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.titles       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_titles_references()
2020-06-11T08:38:00,387 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE TRIGGER update_titles_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.titles       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_titles_references()
2020-06-11T08:38:00,388 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.titles_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(createdDate));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql'
2020-06-11T08:38:00,394 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.titles_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using
2020-06-11T08:38:00,394 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_titles_md_trigger ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,395 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_titles_md_trigger ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,395 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE TRIGGER set_titles_md_trigger BEFORE INSERT ON diku_mod_orders_storage.titles    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.titles_set_md()
2020-06-11T08:38:00,398 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE TRIGGER set_titles_md_trigger BEFORE INSERT ON diku_mod_orders_storage.titles    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.titles_set_md()
2020-06-11T08:38:00,399 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_titles_md_json() RETURNS TRIGGER AS $$
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(NEW.creation_date));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql'
2020-06-11T08:38:00,402 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_titles_md_json() RETURNS TRIGGER AS $$
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(NEW.creation_date));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadat
2020-06-11T08:38:00,403 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_titles_md_json_trigger ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,407 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_titles_md_json_trigger ON diku_mod_orders_storage.titles CASCADE
2020-06-11T08:38:00,407 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE TRIGGER set_titles_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.titles   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_titles_md_json()
2020-06-11T08:38:00,411 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE TRIGGER set_titles_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.titles   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_titles_md_json()
2020-06-11T08:38:00,411 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.pieces (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     )
2020-06-11T08:38:00,415 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE TABLE IF NOT EXISTS diku_mod_orders_storage.pieces (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     )
2020-06-11T08:38:00,416 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS set_id_injson_pieces ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,418 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS set_id_injson_pieces ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,418 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS set_id_in_jsonb ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,420 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS set_id_in_jsonb ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,420 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE TRIGGER set_id_in_jsonb BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_id_in_jsonb()
2020-06-11T08:38:00,423 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE TRIGGER set_id_in_jsonb BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_id_in_jsonb()
2020-06-11T08:38:00,424 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      ALTER TABLE diku_mod_orders_storage.pieces       ADD COLUMN IF NOT EXISTS creation_date timestamp,       ADD COLUMN IF NOT EXISTS created_by text
2020-06-11T08:38:00,425 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      ALTER TABLE diku_mod_orders_storage.pieces       ADD COLUMN IF NOT EXISTS creation_date timestamp,       ADD COLUMN IF NOT EXISTS created_by text
2020-06-11T08:38:00,434 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_format_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_format_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'format')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,454 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_format_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_format_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'format')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,454 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_itemId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_itemId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'itemId')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,458 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_itemId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_itemId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'itemId')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,458 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_locationId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_locationId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'locationId')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,467 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_locationId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_locationId_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'locationId')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,467 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivingStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivingStatus_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivingStatus')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,477 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivingStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivingStatus_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivingStatus')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,478 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivedDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivedDate_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivedDate')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,486 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_receivedDate_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_receivedDate_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'receivedDate')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,486 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_supplement_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_supplement_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'supplement')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,491 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_supplement_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_supplement_idx ON diku_mod_orders_storage.pieces '
      || $rmb$(left(lower(f_unaccent(jsonb->>'supplement')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,491 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_caption_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_caption_idx_gin ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'caption'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,497 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_caption_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_caption_idx_gin ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'caption'))) public.gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-11T08:38:00,497 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_comment_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_comment_idx_ft ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'comment')) )$rmb$);
    END $do$
2020-06-11T08:38:00,502 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'pieces', 'pieces_comment_idx_ft', 'ADD',
      'CREATE INDEX IF NOT EXISTS pieces_comment_idx_ft ON diku_mod_orders_storage.pieces USING GIN '
      || $rmb$( to_tsvector('simple', f_unaccent(jsonb->>'comment')) )$rmb$);
    END $do$
2020-06-11T08:38:00,503 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS poLineId UUID REFERENCES diku_mod_orders_storage.po_line
2020-06-11T08:38:00,509 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS poLineId UUID REFERENCES diku_mod_orders_storage.po_line
2020-06-11T08:38:00,510 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          CREATE INDEX IF NOT EXISTS pieces_poLineId_idx           ON diku_mod_orders_storage.pieces (poLineId)
2020-06-11T08:38:00,511 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          CREATE INDEX IF NOT EXISTS pieces_poLineId_idx           ON diku_mod_orders_storage.pieces (poLineId)
2020-06-11T08:38:00,511 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          INSERT INTO rmb_internal_analyze VALUES ('pieces')
2020-06-11T08:38:00,513 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          INSERT INTO rmb_internal_analyze VALUES ('pieces')
2020-06-11T08:38:00,513 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS titleId UUID REFERENCES diku_mod_orders_storage.titles
2020-06-11T08:38:00,516 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          ALTER TABLE diku_mod_orders_storage.pieces           ADD COLUMN IF NOT EXISTS titleId UUID REFERENCES diku_mod_orders_storage.titles
2020-06-11T08:38:00,516 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          CREATE INDEX IF NOT EXISTS pieces_titleId_idx           ON diku_mod_orders_storage.pieces (titleId)
2020-06-11T08:38:00,529 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          CREATE INDEX IF NOT EXISTS pieces_titleId_idx           ON diku_mod_orders_storage.pieces (titleId)
2020-06-11T08:38:00,529 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:          INSERT INTO rmb_internal_analyze VALUES ('pieces')
2020-06-11T08:38:00,530 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:          INSERT INTO rmb_internal_analyze VALUES ('pieces')
2020-06-11T08:38:00,530 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_pieces_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      NEW.titleId = (NEW.jsonb->>'titleId');
      RETURN NEW;
    END;
    $$ language 'plpgsql'
2020-06-11T08:38:00,532 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE OR REPLACE FUNCTION diku_mod_orders_storage.update_pieces_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.poLineId = (NEW.jsonb->>'poLineId');
      NEW.titleId = (NEW.jsonb->>'titleId');
      RETURN NEW;
    END;
    $$ language 'plpgsql'
2020-06-11T08:38:00,533 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS update_pieces_references ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,535 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS update_pieces_references ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,535 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      CREATE TRIGGER update_pieces_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_pieces_references()
2020-06-11T08:38:00,536 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      CREATE TRIGGER update_pieces_references       BEFORE INSERT OR UPDATE ON diku_mod_orders_storage.pieces       FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.update_pieces_references()
2020-06-11T08:38:00,538 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.pieces_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using ::timestamp
    createdDate = input::timestamp;
  ELSE
    -- createdDate has a time zone string
    -- normalize using ::timestamptz, convert to '+00' time zone and remove time zone string
    createdDate = input::timestamptz AT TIME ZONE '+00';
  END IF;
  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(createdDate));
  NEW.creation_date = createdDate;
  NEW.created_by = NEW.jsonb->'metadata'->>'createdByUserId';
  RETURN NEW;
END;
$$ language 'plpgsql'
2020-06-11T08:38:00,540 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.pieces_set_md() RETURNS TRIGGER AS $$
DECLARE
  input text;
  createdDate timestamp;
BEGIN
  input = NEW.jsonb->'metadata'->>'createdDate';
  IF input IS NULL THEN
    RETURN NEW;
  END IF;
  -- time stamp without time zone?
  IF (input::timestamp::timestamptz = input::timestamptz) THEN
    -- createdDate already has no time zone, normalize using
2020-06-11T08:38:00,540 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_pieces_md_trigger ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,540 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_pieces_md_trigger ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,540 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE TRIGGER set_pieces_md_trigger BEFORE INSERT ON diku_mod_orders_storage.pieces    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.pieces_set_md()
2020-06-11T08:38:00,540 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE TRIGGER set_pieces_md_trigger BEFORE INSERT ON diku_mod_orders_storage.pieces    FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.pieces_set_md()
2020-06-11T08:38:00,541 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_pieces_md_json() RETURNS TRIGGER AS $$
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(NEW.creation_date));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdByUserId}', to_jsonb(NEW.created_by));
  end if;
  RETURN NEW;
END;
$$ language 'plpgsql'
2020-06-11T08:38:00,541 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION diku_mod_orders_storage.set_pieces_md_json() RETURNS TRIGGER AS $$
BEGIN
  if NEW.creation_date IS NULL then
    RETURN NEW;
  end if;

  NEW.jsonb = jsonb_set(NEW.jsonb, '{metadata,createdDate}', to_jsonb(NEW.creation_date));
  if NEW.created_by IS NULL then
    NEW.jsonb = NEW.jsonb #- '{metadata,createdByUserId}';
  else
    NEW.jsonb = jsonb_set(NEW.jsonb, '{metadat
2020-06-11T08:38:00,541 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_pieces_md_json_trigger ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,541 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_pieces_md_json_trigger ON diku_mod_orders_storage.pieces CASCADE
2020-06-11T08:38:00,541 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  CREATE TRIGGER set_pieces_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.pieces   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_pieces_md_json()
2020-06-11T08:38:00,542 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  CREATE TRIGGER set_pieces_md_json_trigger BEFORE UPDATE ON diku_mod_orders_storage.pieces   FOR EACH ROW EXECUTE PROCEDURE diku_mod_orders_storage.set_pieces_md_json()
2020-06-11T08:38:00,542 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisitions_unit_name_idx_unique ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,554 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit', 'acquisitions_unit_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS acquisitions_unit_name_idx_unique ON diku_mod_orders_storage.acquisitions_unit '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,554 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit_membership', 'acquisitions_unit_membership_userId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_userId_idx ON diku_mod_orders_storage.acquisitions_unit_membership '
      || $rmb$(left(lower(f_unaccent(jsonb->>'userId')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,561 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'acquisitions_unit_membership', 'acquisitions_unit_membership_userId_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS acquisitions_unit_membership_userId_idx ON diku_mod_orders_storage.acquisitions_unit_membership '
      || $rmb$(left(lower(f_unaccent(jsonb->>'userId')),600))$rmb$
      );
    END $do$
2020-06-11T08:38:00,561 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_templates', 'order_templates_templateName_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_templates_templateName_idx_unique ON diku_mod_orders_storage.order_templates '
      || $rmb$(lower(f_unaccent(jsonb->>'templateName')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,569 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'order_templates', 'order_templates_templateName_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS order_templates_templateName_idx_unique ON diku_mod_orders_storage.order_templates '
      || $rmb$(lower(f_unaccent(jsonb->>'templateName')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,569 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'reasons_for_closure', 'reasons_for_closure_reason_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS reasons_for_closure_reason_idx_unique ON diku_mod_orders_storage.reasons_for_closure '
      || $rmb$(lower(f_unaccent(jsonb->>'reason')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,574 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'reasons_for_closure', 'reasons_for_closure_reason_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS reasons_for_closure_reason_idx_unique ON diku_mod_orders_storage.reasons_for_closure '
      || $rmb$(lower(f_unaccent(jsonb->>'reason')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,575 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'prefixes', 'prefixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS prefixes_name_idx_unique ON diku_mod_orders_storage.prefixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,585 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'prefixes', 'prefixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS prefixes_name_idx_unique ON diku_mod_orders_storage.prefixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,585 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'suffixes', 'suffixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS suffixes_name_idx_unique ON diku_mod_orders_storage.suffixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,593 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM rmb_internal_index(
      'suffixes', 'suffixes_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS suffixes_name_idx_unique ON diku_mod_orders_storage.suffixes '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-11T08:38:00,595 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  UPDATE diku_mod_orders_storage.purchase_order o SET jsonb = jsonb || jsonb_strip_nulls(jsonb_build_object('poNumberSuffix', (     select s.jsonb -> 'name'     from diku_mod_orders_storage.suffixes s     where o.jsonb ->> 'poNumber' like '%' || (s.jsonb ->> 'name')         limit 1     )))
2020-06-11T08:38:00,725 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  UPDATE diku_mod_orders_storage.purchase_order o SET jsonb = jsonb || jsonb_strip_nulls(jsonb_build_object('poNumberSuffix', (     select s.jsonb -> 'name'     from diku_mod_orders_storage.suffixes s     where o.jsonb ->> 'poNumber' like '%' || (s.jsonb ->> 'name')         limit 1     )))
2020-06-11T08:38:00,725 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  UPDATE diku_mod_orders_storage.purchase_order o SET jsonb = jsonb || jsonb_strip_nulls(jsonb_build_object('poNumberPrefix', (     select p.jsonb -> 'name'     from diku_mod_orders_storage.prefixes p     where o.jsonb ->> 'poNumber' like (p.jsonb ->> 'name') || '%'         limit 1     )))
2020-06-11T08:38:00,734 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  UPDATE diku_mod_orders_storage.purchase_order o SET jsonb = jsonb || jsonb_strip_nulls(jsonb_build_object('poNumberPrefix', (     select p.jsonb -> 'name'     from diku_mod_orders_storage.prefixes p     where o.jsonb ->> 'poNumber' like (p.jsonb ->> 'name') || '%'         limit 1     )))
2020-06-11T08:38:00,734 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  UPDATE diku_mod_orders_storage.titles as titles SET jsonb = jsonb ||     (       SELECT jsonb_strip_nulls(jsonb_build_object('poLineNumber', po_line.jsonb -> 'poLineNumber',
                                                'receivingNote', po_line.jsonb -> 'details' -> 'receivingNote',                                                                 'expectedReceiptDate', po_line.jsonb -> 'physical' -> 'expectedReceiptDate',
                                'packageName', po_line.jsonb -> 'titleOrPackage'))       FROM  diku_mod_orders_storage.po_line as po_line WHERE po_line.id = titles.poLineId     )
2020-06-11T08:38:00,745 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  UPDATE diku_mod_orders_storage.titles as titles SET jsonb = jsonb ||     (       SELECT jsonb_strip_nulls(jsonb_build_object('poLineNumber', po_line.jsonb -> 'poLineNumber',                                                               'receivingNote', po_line.jsonb -> 'details' -> 'receivingNote',                                                                 'expectedReceiptDate', po_line.jsonb -> 'physical' -> 'expectedReceiptDate',                                                         'packageName', po_line.jsonb -> 'titleOrPackage'))       FRO
2020-06-11T08:38:00,745 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  UPDATE diku_mod_orders_storage.pieces p SET jsonb = jsonb || jsonb_strip_nulls(jsonb_build_object('titleId', (     select t.jsonb -> 'id'     from diku_mod_orders_storage.titles t     where p.jsonb->>'poLineId' = t.jsonb->>'poLineId'     limit 1 )))
2020-06-11T08:38:00,756 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  UPDATE diku_mod_orders_storage.pieces p SET jsonb = jsonb || jsonb_strip_nulls(jsonb_build_object('titleId', (     select t.jsonb -> 'id'     from diku_mod_orders_storage.titles t     where p.jsonb->>'poLineId' = t.jsonb->>'poLineId'     limit 1 )))
2020-06-11T08:38:00,757 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  DO $$
DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM diku_mod_orders_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE format('DROP INDEX IF EXISTS %s', aname);
  END LOOP;
END $$
2020-06-11T08:38:00,758 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  DO $$
DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM diku_mod_orders_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE format('DROP INDEX IF EXISTS %s', aname);
  END LOOP;
END $$
2020-06-11T08:38:00,758 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  DO $$
DECLARE
  version TEXT;
  i RECORD;
  newindexdef TEXT;
BEGIN
  SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_orders_storage.rmb_internal;
  IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN
    -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x
    RETURN;
  END IF;
  FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_orders_storage'
  LOOP
    newindexdef := regexp_replace(i.indexdef,
      -- \m = beginning of a word, \M = end of a word
      '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M',
      'diku_mod_orders_storage.\1',
      'g');
    IF newindexdef <> i.indexdef THEN
      EXECUTE format('DROP INDEX %I.%I', i.schemaname, i.indexname);
      EXECUTE newindexdef;
      EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename;
    END IF;
  END LOOP;
END $$
2020-06-11T08:38:00,780 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  DO $$
DECLARE
  version TEXT;
  i RECORD;
  newindexdef TEXT;
BEGIN
  SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_orders_storage.rmb_internal;
  IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN
    -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x
    RETURN;
  END IF;
  FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_orders_storage
2020-06-11T08:38:00,780 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  DO $$
DECLARE
  t TEXT;
BEGIN
  FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze
  LOOP
    EXECUTE format('ANALYZE %I', t);
  END LOOP;
END $$
2020-06-11T08:38:00,816 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  DO $$
DECLARE
  t TEXT;
BEGIN
  FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze
  LOOP
    EXECUTE format('ANALYZE %I', t);
  END LOOP;
END $$
2020-06-11T08:38:00,816 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  TRUNCATE rmb_internal_analyze
2020-06-11T08:38:00,818 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  TRUNCATE rmb_internal_analyze
2020-06-11T08:38:00,819 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_orders_storage TO diku_mod_orders_storage
2020-06-11T08:38:00,822 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_orders_storage TO diku_mod_orders_storage
2020-06-11T08:38:00,822 INFO  [vert.x-worker-thread-0   ] PostgresClient trying to execute:  UPDATE diku_mod_orders_storage.rmb_internal   SET jsonb = jsonb || jsonb_build_object(     'rmbVersion', '30.0.2',     'moduleVersion', 'mod-orders-storage-11.0.0',     'schemaJson', $mainftl${
  "scripts": [
    {
      "run": "after",
      "snippetPath": "views/receiving_history_view.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetPath": "views/order_view.sql",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippetPath": "views/order_lines_view.sql",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippet": "DROP VIEW IF EXISTS purchase_orders_view;",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippetPath": "views/po_lines_view.sql",
      "fromModuleVersion": "mod-orders-storage-7.0.0"
    },
    {
      "run": "after",
      "snippetPath": "data-migration/9.0.0/po_line_ta
2020-06-11T08:38:00,827 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully executed:  UPDATE diku_mod_orders_storage.rmb_internal   SET jsonb = jsonb || jsonb_build_object(     'rmbVersion', '30.0.2',     'moduleVersion', 'mod-orders-storage-11.0.0',     'schemaJson', $mainftl${
  "scripts": [
    {
      "run": "after",
      "snippetPath": "views/receiving_history_view.sql",
      "fromModuleVersion": "mod-orders-storage-10.0.0"
    },
    {
      "run": "after",
      "snippetP
2020-06-11T08:38:00,845 INFO  [vert.x-worker-thread-0   ] PostgresClient Successfully committed: -463970349
2020-06-11T08:38:01,316 INFO  [vert.x-eventloop-thread-0] PostgresClient DB config read from environment variables
2020-06-11T08:38:01,316 INFO  [vert.x-eventloop-thread-0] PostgresClient Using schema: diku
2020-06-11T08:38:01,316 INFO  [vert.x-eventloop-thread-0] PostgresClient postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"host":"10.0.2.15","username":"diku_mod_orders_storage","database":"okapi_modules","password":"..."}
2020-06-11T08:38:01,355 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,363 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/fa4ab110-bf7c-4c1c-9014-fa3f95e1d07c null HTTP_1_1 204 0 328 tid=diku No Content
2020-06-11T08:38:01,381 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,383 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/af55e63f-10f9-4919-add9-6feaf7097a6c null HTTP_1_1 204 0 7 tid=diku No Content
2020-06-11T08:38:01,393 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,395 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/cae85c3d-a839-420a-868d-283cedb1fd2f null HTTP_1_1 204 0 7 tid=diku No Content
2020-06-11T08:38:01,407 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,409 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/71a233f8-edac-4e8e-9600-d55222d64273 null HTTP_1_1 204 0 8 tid=diku No Content
2020-06-11T08:38:01,421 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,422 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/a47051ec-7a4f-499f-9541-a5fc5deb2f41 null HTTP_1_1 204 0 8 tid=diku No Content
2020-06-11T08:38:01,434 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,436 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/b72e8ea6-67b3-4238-9257-5d8e29b95694 null HTTP_1_1 204 0 9 tid=diku No Content
2020-06-11T08:38:01,451 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,452 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/71a83ae9-6af0-479e-b579-4904b24a3300 null HTTP_1_1 204 0 9 tid=diku No Content
2020-06-11T08:38:01,463 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,465 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/8f11f23a-e101-4861-8df2-152da9ce4889 null HTTP_1_1 204 0 8 tid=diku No Content
2020-06-11T08:38:01,474 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,479 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/8ab21f8d-1343-4228-ac5c-2979ba99412b null HTTP_1_1 204 0 9 tid=diku No Content
2020-06-11T08:38:01,489 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,490 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/27d10e3b-66cc-490b-bee6-7c1b2b07394c null HTTP_1_1 204 0 6 tid=diku No Content
2020-06-11T08:38:01,500 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,501 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/ebe73dd1-fa30-4c36-aad9-6c95ea5207ae null HTTP_1_1 204 0 7 tid=diku No Content
2020-06-11T08:38:01,509 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,510 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/7c11e86e-4776-4f4f-9aa4-13e83b4ef44d null HTTP_1_1 204 0 5 tid=diku No Content
2020-06-11T08:38:01,519 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,520 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/29936d21-93e4-4ab3-9ac4-2d11fa40e942 null HTTP_1_1 204 0 6 tid=diku No Content
2020-06-11T08:38:01,533 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,534 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/d17f9d15-4520-49ad-9ffa-123e7739ae53 null HTTP_1_1 204 0 7 tid=diku No Content
2020-06-11T08:38:01,543 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,544 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/65a75ad7-fbbe-4139-9c69-79fbba805ce9 null HTTP_1_1 204 0 6 tid=diku No Content
2020-06-11T08:38:01,556 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,558 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/89389f7b-54e9-4b95-b5d0-f89c29b71147 null HTTP_1_1 204 0 9 tid=diku No Content
2020-06-11T08:38:01,566 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,567 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/22bddeeb-6cbe-45bd-b73d-7343e28c0626 null HTTP_1_1 204 0 6 tid=diku No Content
2020-06-11T08:38:01,574 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:01,575 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/dcbb7f40-f2ae-4ad3-a367-27bff67ff6e6 null HTTP_1_1 204 0 5 tid=diku No Content
2020-06-11T08:38:01,715 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageAlertsById
2020-06-11T08:38:01,716 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/alerts/dc08f15e-a3ec-423a-bd1c-86a8ce6c5872 null HTTP_1_1 204 0 98 tid=diku No Content
2020-06-11T08:38:01,824 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageReportingCodesById
2020-06-11T08:38:01,825 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/reporting-codes/5926dcd7-85f5-4504-8283-712595ebc38b null HTTP_1_1 204 0 76 tid=diku No Content
2020-06-11T08:38:01,987 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePurchaseOrdersById
2020-06-11T08:38:01,988 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/purchase-orders/0610be6d-0ddd-494b-b867-19f63d8b5d6d null HTTP_1_1 204 0 123 tid=diku No Content
2020-06-11T08:38:02,004 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePurchaseOrdersById
2020-06-11T08:38:02,005 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/purchase-orders/55b97a4a-6601-4488-84e1-8b0d47a3f523 null HTTP_1_1 204 0 13 tid=diku No Content
2020-06-11T08:38:02,015 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePurchaseOrdersById
2020-06-11T08:38:02,016 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/purchase-orders/cf4bfd64-e609-4ecb-b3e6-7a5a1ced1645 null HTTP_1_1 204 0 8 tid=diku No Content
2020-06-11T08:38:02,031 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePurchaseOrdersById
2020-06-11T08:38:02,032 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/purchase-orders/589a6016-3463-49f6-8aa2-dc315d0665fd null HTTP_1_1 204 0 12 tid=diku No Content
2020-06-11T08:38:02,043 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePurchaseOrdersById
2020-06-11T08:38:02,044 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/purchase-orders/9447d062-89ec-486e-a14b-572f3efb9f8c null HTTP_1_1 204 0 7 tid=diku No Content
2020-06-11T08:38:02,057 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePurchaseOrdersById
2020-06-11T08:38:02,058 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/purchase-orders/c27e60f9-6361-44c1-976e-0c4821a33a7d null HTTP_1_1 204 0 10 tid=diku No Content
2020-06-11T08:38:02,298 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine record org.folio.rest.jaxrs.model.PoLine@83156b48 was successfully updated
2020-06-11T08:38:02,301 INFO  [vert.x-eventloop-thread-0] CQLWrapper CRITERION >>> SQL: WHERE poLineId = '647c1dca-b9bf-47af-8456-bfb6dfef9eee'    >>>WHERE poLineId = '647c1dca-b9bf-47af-8456-bfb6dfef9eee'
2020-06-11T08:38:02,348 INFO  [vert.x-eventloop-thread-0] PoLinesAPI Title record org.folio.rest.jaxrs.model.Title@e2ffdd4c was successfully updated
2020-06-11T08:38:02,351 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine org.folio.rest.jaxrs.model.PoLine@83156b48 and associated data were successfully updated
2020-06-11T08:38:02,352 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePoLinesById
2020-06-11T08:38:02,353 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/po-lines/647c1dca-b9bf-47af-8456-bfb6dfef9eee null HTTP_1_1 204 0 247 tid=diku No Content
2020-06-11T08:38:02,370 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine record org.folio.rest.jaxrs.model.PoLine@79f0ae6f was successfully updated
2020-06-11T08:38:02,371 INFO  [vert.x-eventloop-thread-0] CQLWrapper CRITERION >>> SQL: WHERE poLineId = 'ee0b9edb-5508-5f3e-a33b-0adb42fdcdc5'    >>>WHERE poLineId = 'ee0b9edb-5508-5f3e-a33b-0adb42fdcdc5'
2020-06-11T08:38:02,376 INFO  [vert.x-eventloop-thread-0] PoLinesAPI Title record org.folio.rest.jaxrs.model.Title@cfe2202c was successfully updated
2020-06-11T08:38:02,378 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine org.folio.rest.jaxrs.model.PoLine@79f0ae6f and associated data were successfully updated
2020-06-11T08:38:02,379 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePoLinesById
2020-06-11T08:38:02,380 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/po-lines/ee0b9edb-5508-5f3e-a33b-0adb42fdcdc5 null HTTP_1_1 204 0 24 tid=diku No Content
2020-06-11T08:38:02,398 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine record org.folio.rest.jaxrs.model.PoLine@12f490ac was successfully updated
2020-06-11T08:38:02,399 INFO  [vert.x-eventloop-thread-0] CQLWrapper CRITERION >>> SQL: WHERE poLineId = '556abc25-ebbf-3fb2-b478-1bfaff0af4dc'    >>>WHERE poLineId = '556abc25-ebbf-3fb2-b478-1bfaff0af4dc'
2020-06-11T08:38:02,416 INFO  [vert.x-eventloop-thread-0] PoLinesAPI Title record org.folio.rest.jaxrs.model.Title@acc03f97 was successfully updated
2020-06-11T08:38:02,419 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine org.folio.rest.jaxrs.model.PoLine@12f490ac and associated data were successfully updated
2020-06-11T08:38:02,423 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePoLinesById
2020-06-11T08:38:02,428 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/po-lines/556abc25-ebbf-3fb2-b478-1bfaff0af4dc null HTTP_1_1 204 0 43 tid=diku No Content
2020-06-11T08:38:02,448 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine record org.folio.rest.jaxrs.model.PoLine@c9258931 was successfully updated
2020-06-11T08:38:02,449 INFO  [vert.x-eventloop-thread-0] CQLWrapper CRITERION >>> SQL: WHERE poLineId = 'b9cc5473-bb40-1d61-afc0-d3a5ba0ed0a8'    >>>WHERE poLineId = 'b9cc5473-bb40-1d61-afc0-d3a5ba0ed0a8'
2020-06-11T08:38:02,455 INFO  [vert.x-eventloop-thread-0] PoLinesAPI Title record org.folio.rest.jaxrs.model.Title@99ff4a9c was successfully updated
2020-06-11T08:38:02,457 INFO  [vert.x-eventloop-thread-0] PoLinesAPI POLine org.folio.rest.jaxrs.model.PoLine@c9258931 and associated data were successfully updated
2020-06-11T08:38:02,458 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePoLinesById
2020-06-11T08:38:02,459 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/po-lines/b9cc5473-bb40-1d61-afc0-d3a5ba0ed0a8 null HTTP_1_1 204 0 26 tid=diku No Content
2020-06-11T08:38:02,482 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStoragePoLinesById
2020-06-11T08:38:02,483 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/po-lines/baec48dd-1594-2712-be8f-de336bc83fcc null HTTP_1_1 204 0 20 tid=diku No Content
2020-06-11T08:38:02,599 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageTitlesById
2020-06-11T08:38:02,600 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/titles/7cef39f1-4fb1-49d5-9a6b-a072e632144d null HTTP_1_1 204 0 85 tid=diku No Content
2020-06-11T08:38:02,719 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageOrderTemplatesById
2020-06-11T08:38:02,720 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/order-templates/4dee318b-f5b3-40dc-be93-cc89b8c45b6f null HTTP_1_1 204 0 88 tid=diku No Content
2020-06-11T08:38:02,727 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageOrderTemplatesById
2020-06-11T08:38:02,728 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/order-templates/2cec3275-a5c7-4ba1-afab-905ada8c5b65 null HTTP_1_1 204 0 5 tid=diku No Content
2020-06-11T08:38:02,736 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageOrderTemplatesById
2020-06-11T08:38:02,737 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/order-templates/43bb8a31-4e4b-463c-95c5-e163760f0092 null HTTP_1_1 204 0 5 tid=diku No Content
2020-06-11T08:38:02,746 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageOrderTemplatesById
2020-06-11T08:38:02,748 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/order-templates/5c56e4f6-1296-4b5f-a6dc-8309d9983a16 null HTTP_1_1 204 0 8 tid=diku No Content
2020-06-11T08:38:02,757 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageOrderTemplatesById
2020-06-11T08:38:02,758 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/order-templates/cc637c23-d1fb-47b9-bcda-1d6f0812dc01 null HTTP_1_1 204 0 5 tid=diku No Content
2020-06-11T08:38:02,868 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putAcquisitionsUnitsStorageUnitsById
2020-06-11T08:38:02,869 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /acquisitions-units-storage/units/0ebb1f7d-983f-3026-8a4c-5318e0ebc041 null HTTP_1_1 204 0 80 tid=diku No Content
2020-06-11T08:38:02,909 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putAcquisitionsUnitsStorageMembershipsById
2020-06-11T08:38:02,910 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /acquisitions-units-storage/memberships/6bad4244-0922-450a-bcef-cfa4233a0f7f null HTTP_1_1 204 0 10 tid=diku No Content
2020-06-11T08:38:02,946 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationReasonsForClosureById
2020-06-11T08:38:02,947 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/reasons-for-closure/41153a11-6bb8-4217-93b8-0c83c8b019f5 null HTTP_1_1 204 0 3 tid=diku No Content
2020-06-11T08:38:02,988 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationPrefixesById
2020-06-11T08:38:02,990 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/prefixes/db9f5d17-0ca3-4d14-ae49-16b63c8fc083 null HTTP_1_1 204 0 11 tid=diku No Content
2020-06-11T08:38:03,029 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking putOrdersStorageConfigurationSuffixesById
2020-06-11T08:38:03,030 INFO  [vert.x-eventloop-thread-0] LogUtil 172.17.0.1:43074 PUT /orders-storage/configuration/suffixes/0c966bd2-0ca6-43a2-9388-3a4403f19e6f null HTTP_1_1 204 0 9 tid=diku No Content
2020-06-11T08:38:03,033 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking postTenant
2020-06-11T08:38:03,039 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:59236 POST /_/tenant null HTTP_1_1 201 0 4746 tid=diku Created
2020-06-11T08:38:15,892 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:59256 GET / null HTTP_1_1 400 28 -1 tid=null Bad Request Invalid URL path requested /