);
    END $do$
2020-06-08T07:49:59,261 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fiscal_year_code_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fiscal_year_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fiscal_year USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,268 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fiscal_year_code_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fiscal_year_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fiscal_year USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,268 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fiscal_year_series_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fiscal_year_series_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fiscal_year USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'series'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,271 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fiscal_year_series_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fiscal_year_series_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fiscal_year USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'series'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,272 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS update_fiscal_year_references ON finance_migration_test_tenant_mod_finance_storage.fiscal_year CASCADE
2020-06-08T07:49:59,273 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS update_fiscal_year_references ON finance_migration_test_tenant_mod_finance_storage.fiscal_year CASCADE
2020-06-08T07:49:59,273 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DROP FUNCTION IF EXISTS finance_migration_test_tenant_mod_finance_storage.update_fiscal_year_references()
2020-06-08T07:49:59,274 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DROP FUNCTION IF EXISTS finance_migration_test_tenant_mod_finance_storage.update_fiscal_year_references()
2020-06-08T07:49:59,274 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.fiscal_year_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-08T07:49:59,277 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.fiscal_year_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 ha
2020-06-08T07:49:59,277 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_fiscal_year_md_trigger ON finance_migration_test_tenant_mod_finance_storage.fiscal_year CASCADE
2020-06-08T07:49:59,281 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_fiscal_year_md_trigger ON finance_migration_test_tenant_mod_finance_storage.fiscal_year CASCADE
2020-06-08T07:49:59,281 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE TRIGGER set_fiscal_year_md_trigger BEFORE INSERT ON finance_migration_test_tenant_mod_finance_storage.fiscal_year    FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.fiscal_year_set_md()
2020-06-08T07:49:59,285 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE TRIGGER set_fiscal_year_md_trigger BEFORE INSERT ON finance_migration_test_tenant_mod_finance_storage.fiscal_year    FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.fiscal_year_set_md()
2020-06-08T07:49:59,285 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.set_fiscal_year_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-08T07:49:59,288 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.set_fiscal_year_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 =
2020-06-08T07:49:59,288 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_fiscal_year_md_json_trigger ON finance_migration_test_tenant_mod_finance_storage.fiscal_year CASCADE
2020-06-08T07:49:59,292 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_fiscal_year_md_json_trigger ON finance_migration_test_tenant_mod_finance_storage.fiscal_year CASCADE
2020-06-08T07:49:59,293 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE TRIGGER set_fiscal_year_md_json_trigger BEFORE UPDATE ON finance_migration_test_tenant_mod_finance_storage.fiscal_year   FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.set_fiscal_year_md_json()
2020-06-08T07:49:59,298 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE TRIGGER set_fiscal_year_md_json_trigger BEFORE UPDATE ON finance_migration_test_tenant_mod_finance_storage.fiscal_year   FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.set_fiscal_year_md_json()
2020-06-08T07:49:59,298 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      CREATE TABLE IF NOT EXISTS finance_migration_test_tenant_mod_finance_storage.ledger (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     )
2020-06-08T07:49:59,301 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      CREATE TABLE IF NOT EXISTS finance_migration_test_tenant_mod_finance_storage.ledger (       id UUID PRIMARY KEY,       jsonb JSONB NOT NULL     )
2020-06-08T07:49:59,301 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS set_id_injson_ledger ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,305 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS set_id_injson_ledger ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,305 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS set_id_in_jsonb ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,306 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS set_id_in_jsonb ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,306 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      CREATE TRIGGER set_id_in_jsonb BEFORE INSERT OR UPDATE ON finance_migration_test_tenant_mod_finance_storage.ledger       FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.set_id_in_jsonb()
2020-06-08T07:49:59,308 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      CREATE TRIGGER set_id_in_jsonb BEFORE INSERT OR UPDATE ON finance_migration_test_tenant_mod_finance_storage.ledger       FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.set_id_in_jsonb()
2020-06-08T07:49:59,308 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      ALTER TABLE finance_migration_test_tenant_mod_finance_storage.ledger       ADD COLUMN IF NOT EXISTS creation_date timestamp,       ADD COLUMN IF NOT EXISTS created_by text
2020-06-08T07:49:59,309 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      ALTER TABLE finance_migration_test_tenant_mod_finance_storage.ledger       ADD COLUMN IF NOT EXISTS creation_date timestamp,       ADD COLUMN IF NOT EXISTS created_by text
2020-06-08T07:49:59,309 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_ledgerStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_ledgerStatus_idx ON finance_migration_test_tenant_mod_finance_storage.ledger '
      || $rmb$(left(lower(f_unaccent(jsonb->>'ledgerStatus')),600))$rmb$
      );
    END $do$
2020-06-08T07:49:59,363 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_ledgerStatus_idx', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_ledgerStatus_idx ON finance_migration_test_tenant_mod_finance_storage.ledger '
      || $rmb$(left(lower(f_unaccent(jsonb->>'ledgerStatus')),600))$rmb$
      );
    END $do$
2020-06-08T07:49:59,363 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS ledger_name_idx_unique ON finance_migration_test_tenant_mod_finance_storage.ledger '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,365 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS ledger_name_idx_unique ON finance_migration_test_tenant_mod_finance_storage.ledger '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,365 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_code_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS ledger_code_idx_unique ON finance_migration_test_tenant_mod_finance_storage.ledger '
      || $rmb$(lower(f_unaccent(jsonb->>'code')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,367 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_code_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS ledger_code_idx_unique ON finance_migration_test_tenant_mod_finance_storage.ledger '
      || $rmb$(lower(f_unaccent(jsonb->>'code')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,368 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_name_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_name_idx_gin ON finance_migration_test_tenant_mod_finance_storage.ledger USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'name'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,369 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_name_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_name_idx_gin ON finance_migration_test_tenant_mod_finance_storage.ledger USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'name'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,369 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_code_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.ledger USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,370 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_code_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.ledger USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,370 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_acqUnitIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_acqUnitIds_idx_gin ON finance_migration_test_tenant_mod_finance_storage.ledger USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'acqUnitIds'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,374 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledger_acqUnitIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS ledger_acqUnitIds_idx_gin ON finance_migration_test_tenant_mod_finance_storage.ledger USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'acqUnitIds'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,374 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:          ALTER TABLE finance_migration_test_tenant_mod_finance_storage.ledger           ADD COLUMN IF NOT EXISTS fiscalYearOneId UUID REFERENCES finance_migration_test_tenant_mod_finance_storage.fiscal_year
2020-06-08T07:49:59,378 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:          ALTER TABLE finance_migration_test_tenant_mod_finance_storage.ledger           ADD COLUMN IF NOT EXISTS fiscalYearOneId UUID REFERENCES finance_migration_test_tenant_mod_finance_storage.fiscal_year
2020-06-08T07:49:59,378 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:          CREATE INDEX IF NOT EXISTS ledger_fiscalYearOneId_idx           ON finance_migration_test_tenant_mod_finance_storage.ledger (fiscalYearOneId)
2020-06-08T07:49:59,380 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:          CREATE INDEX IF NOT EXISTS ledger_fiscalYearOneId_idx           ON finance_migration_test_tenant_mod_finance_storage.ledger (fiscalYearOneId)
2020-06-08T07:49:59,381 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.update_ledger_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.fiscalYearOneId = (NEW.jsonb->>'fiscalYearOneId');
      RETURN NEW;
    END;
    $$ language 'plpgsql'
2020-06-08T07:49:59,382 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.update_ledger_references()     RETURNS TRIGGER AS $$
    BEGIN
      NEW.fiscalYearOneId = (NEW.jsonb->>'fiscalYearOneId');
      RETURN NEW;
    END;
    $$ language 'plpgsql'
2020-06-08T07:49:59,382 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DROP TRIGGER IF EXISTS update_ledger_references ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,383 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DROP TRIGGER IF EXISTS update_ledger_references ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,383 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      CREATE TRIGGER update_ledger_references       BEFORE INSERT OR UPDATE ON finance_migration_test_tenant_mod_finance_storage.ledger       FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.update_ledger_references()
2020-06-08T07:49:59,386 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      CREATE TRIGGER update_ledger_references       BEFORE INSERT OR UPDATE ON finance_migration_test_tenant_mod_finance_storage.ledger       FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.update_ledger_references()
2020-06-08T07:49:59,386 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.ledger_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-08T07:49:59,397 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.ledger_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
2020-06-08T07:49:59,397 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_ledger_md_trigger ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,398 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_ledger_md_trigger ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,398 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE TRIGGER set_ledger_md_trigger BEFORE INSERT ON finance_migration_test_tenant_mod_finance_storage.ledger    FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.ledger_set_md()
2020-06-08T07:49:59,409 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE TRIGGER set_ledger_md_trigger BEFORE INSERT ON finance_migration_test_tenant_mod_finance_storage.ledger    FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.ledger_set_md()
2020-06-08T07:49:59,409 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.set_ledger_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-08T07:49:59,414 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE OR REPLACE FUNCTION finance_migration_test_tenant_mod_finance_storage.set_ledger_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 = json
2020-06-08T07:49:59,414 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  DROP TRIGGER IF EXISTS set_ledger_md_json_trigger ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,415 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  DROP TRIGGER IF EXISTS set_ledger_md_json_trigger ON finance_migration_test_tenant_mod_finance_storage.ledger CASCADE
2020-06-08T07:49:59,415 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE TRIGGER set_ledger_md_json_trigger BEFORE UPDATE ON finance_migration_test_tenant_mod_finance_storage.ledger   FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.set_ledger_md_json()
2020-06-08T07:49:59,419 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE TRIGGER set_ledger_md_json_trigger BEFORE UPDATE ON finance_migration_test_tenant_mod_finance_storage.ledger   FOR EACH ROW EXECUTE PROCEDURE finance_migration_test_tenant_mod_finance_storage.set_ledger_md_json()
2020-06-08T07:49:59,420 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_type_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS fund_type_name_idx_unique ON finance_migration_test_tenant_mod_finance_storage.fund_type '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,420 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_type_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS fund_type_name_idx_unique ON finance_migration_test_tenant_mod_finance_storage.fund_type '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,420 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_code_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS fund_code_idx_unique ON finance_migration_test_tenant_mod_finance_storage.fund '
      || $rmb$(lower(f_unaccent(jsonb->>'code')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,421 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_code_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS fund_code_idx_unique ON finance_migration_test_tenant_mod_finance_storage.fund '
      || $rmb$(lower(f_unaccent(jsonb->>'code')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,421 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_name_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fund_name_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'name'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,424 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_name_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fund_name_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'name'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,424 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_acqUnitIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fund_acqUnitIds_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'acqUnitIds'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,426 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_acqUnitIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fund_acqUnitIds_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'acqUnitIds'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,426 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_fundStatus_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fund_fundStatus_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'fundStatus'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,430 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_fundStatus_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS fund_fundStatus_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'fundStatus'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,430 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_code_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fund_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,431 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_code_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fund_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,431 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_fund_status_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fund_fund_status_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'fund_status'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,433 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_fund_status_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fund_fund_status_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'fund_status'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,433 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_currency_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fund_currency_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'currency'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,434 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('fund_currency_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS fund_currency_idx_gin ON finance_migration_test_tenant_mod_finance_storage.fund USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'currency'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,434 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_fundId_fiscalYearId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS budget_fundId_fiscalYearId_idx_unique ON finance_migration_test_tenant_mod_finance_storage.budget '
      || $rmb$(lower(f_unaccent(jsonb->>'fundId')) , lower(f_unaccent(jsonb->>'fiscalYearId')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,435 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_fundId_fiscalYearId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS budget_fundId_fiscalYearId_idx_unique ON finance_migration_test_tenant_mod_finance_storage.budget '
      || $rmb$(lower(f_unaccent(jsonb->>'fundId')) , lower(f_unaccent(jsonb->>'fiscalYearId')))$rmb$

2020-06-08T07:49:59,435 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_name_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS budget_name_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'name'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,436 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_name_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS budget_name_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'name'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,436 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_code_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS budget_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,438 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_code_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS budget_code_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'code'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,448 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_budget_status_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS budget_budget_status_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'budget_status'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,449 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_budget_status_idx_gin', 'DELETE',
      'CREATE INDEX IF NOT EXISTS budget_budget_status_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'budget_status'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,449 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_budgetStatus_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS budget_budgetStatus_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'budgetStatus'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,449 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('budget_budgetStatus_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS budget_budgetStatus_idx_gin ON finance_migration_test_tenant_mod_finance_storage.budget USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'budgetStatus'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,450 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('transaction_amount_fromFundId_encumbrance_sourcePurchaseOrderId_encumbrance_sourcePoLineId_encumbrance_initialAmountEncumbered_encumbrance_status_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS transaction_amount_fromFundId_encumbrance_sourcePurchaseOrderId_encumbrance_sourcePoLineId_encumbrance_initialAmountEncumbered_encumbrance_status_idx_unique ON finance_migration_test_tenant_mod_finance_storage.transaction '
      || $rmb$(lower(f_unaccent(jsonb->>'amount')) , lower(f_unaccent(jsonb->>'fromFundId')) , lower(f_unaccent(jsonb->'encumbrance'->>'sourcePurchaseOrderId')) , lower(f_unaccent(jsonb->'encumbrance'->>'sourcePoLineId')) , lower(f_unaccent(jsonb->'encumbrance'->>'initialAmountEncumbered')) , lower(f_unaccent(jsonb->'encumbrance'->>'status')))$rmb$
      || $rmb$ WHERE (jsonb->>'transactionType')::text = 'Encumbrance'$rmb$);
    END $do$
2020-06-08T07:49:59,450 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('transaction_amount_fromFundId_encumbrance_sourcePurchaseOrderId_encumbrance_sourcePoLineId_encumbrance_initialAmountEncumbered_encumbrance_status_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS transaction_amount_fromFundId_encumbrance_sourcePurchaseOrderId_encumbrance_sourcePoLi
2020-06-08T07:49:59,451 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('transaction_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS transaction_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique ON finance_migration_test_tenant_mod_finance_storage.transaction '
      || $rmb$(lower(f_unaccent(jsonb->>'amount')) , lower(f_unaccent(jsonb->>'fromFundId')) , lower(f_unaccent(jsonb->>'sourceInvoiceId')) , lower(f_unaccent(jsonb->>'sourceInvoiceLineId')) , lower(f_unaccent(jsonb->>'toFundId')) , lower(f_unaccent(jsonb->>'transactionType')))$rmb$
      || $rmb$ WHERE (jsonb->>'transactionType')::text = 'Payment'OR (jsonb->>'transactionType')::text = 'Credit'$rmb$);
    END $do$
2020-06-08T07:49:59,451 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('transaction_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS transaction_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique ON finance_migration_test_tenant_mod_fi
2020-06-08T07:49:59,451 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('transaction_amount_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS transaction_amount_idx_gin ON finance_migration_test_tenant_mod_finance_storage.transaction USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'amount'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,452 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('transaction_amount_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS transaction_amount_idx_gin ON finance_migration_test_tenant_mod_finance_storage.transaction USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'amount'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,453 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_code_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS groups_code_idx_unique ON finance_migration_test_tenant_mod_finance_storage.groups '
      || $rmb$(lower(f_unaccent(jsonb->>'code')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,453 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_code_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS groups_code_idx_unique ON finance_migration_test_tenant_mod_finance_storage.groups '
      || $rmb$(lower(f_unaccent(jsonb->>'code')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,453 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS groups_name_idx_unique ON finance_migration_test_tenant_mod_finance_storage.groups '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,454 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_name_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS groups_name_idx_unique ON finance_migration_test_tenant_mod_finance_storage.groups '
      || $rmb$(lower(f_unaccent(jsonb->>'name')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,454 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_status_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS groups_status_idx_gin ON finance_migration_test_tenant_mod_finance_storage.groups USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'status'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,455 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_status_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS groups_status_idx_gin ON finance_migration_test_tenant_mod_finance_storage.groups USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'status'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,455 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_acqUnitIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS groups_acqUnitIds_idx_gin ON finance_migration_test_tenant_mod_finance_storage.groups USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'acqUnitIds'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,455 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('groups_acqUnitIds_idx_gin', 'ADD',
      'CREATE INDEX IF NOT EXISTS groups_acqUnitIds_idx_gin ON finance_migration_test_tenant_mod_finance_storage.groups USING GIN '
      || $rmb$((lower(f_unaccent(jsonb->>'acqUnitIds'))) gin_trgm_ops)$rmb$
      );
    END $do$
2020-06-08T07:49:59,455 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledgerFY_ledgerId_fiscalYearId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS ledgerFY_ledgerId_fiscalYearId_idx_unique ON finance_migration_test_tenant_mod_finance_storage.ledgerFY '
      || $rmb$(lower(f_unaccent(jsonb->>'ledgerId')) , lower(f_unaccent(jsonb->>'fiscalYearId')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,457 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('ledgerFY_ledgerId_fiscalYearId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS ledgerFY_ledgerId_fiscalYearId_idx_unique ON finance_migration_test_tenant_mod_finance_storage.ledgerFY '
      || $rmb$(lower(f_unaccent(jsonb->>'ledgerId')) , lower(f_unaccent(jsonb->>'fiscalYearId')
2020-06-08T07:49:59,457 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('group_fund_fiscal_year_groupId_fundId_fiscalYearId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS group_fund_fiscal_year_groupId_fundId_fiscalYearId_idx_unique ON finance_migration_test_tenant_mod_finance_storage.group_fund_fiscal_year '
      || $rmb$(lower(f_unaccent(jsonb->>'groupId')) , lower(f_unaccent(jsonb->>'fundId')) , lower(f_unaccent(jsonb->>'fiscalYearId')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,457 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('group_fund_fiscal_year_groupId_fundId_fiscalYearId_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS group_fund_fiscal_year_groupId_fundId_fiscalYearId_idx_unique ON finance_migration_test_tenant_mod_finance_storage.group_fund_fiscal_year '
      || $rmb$(lower(f_unaccent(jsonb->>'
2020-06-08T07:49:59,457 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('temporary_order_transactions_amount_fromFundId_encumbrance_sourcePurchaseOrderId_encumbrance_sourcePoLineId_encumbrance_initialAmountEncumbered_encumbrance_status_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS temporary_order_transactions_amount_fromFundId_encumbrance_sourcePurchaseOrderId_encumbrance_sourcePoLineId_encumbrance_initialAmountEncumbered_encumbrance_status_idx_unique ON finance_migration_test_tenant_mod_finance_storage.temporary_order_transactions '
      || $rmb$(lower(f_unaccent(jsonb->>'amount')) , lower(f_unaccent(jsonb->>'fromFundId')) , lower(f_unaccent(jsonb->'encumbrance'->>'sourcePurchaseOrderId')) , lower(f_unaccent(jsonb->'encumbrance'->>'sourcePoLineId')) , lower(f_unaccent(jsonb->'encumbrance'->>'initialAmountEncumbered')) , lower(f_unaccent(jsonb->'encumbrance'->>'status')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,458 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('temporary_order_transactions_amount_fromFundId_encumbrance_sourcePurchaseOrderId_encumbrance_sourcePoLineId_encumbrance_initialAmountEncumbered_encumbrance_status_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS temporary_order_transactions_amount_fromFundId_encumbrance_sourcePurc
2020-06-08T07:49:59,458 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('temporary_invoice_transactions_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS temporary_invoice_transactions_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique ON finance_migration_test_tenant_mod_finance_storage.temporary_invoice_transactions '
      || $rmb$(lower(f_unaccent(jsonb->>'amount')) , lower(f_unaccent(jsonb->>'fromFundId')) , lower(f_unaccent(jsonb->>'sourceInvoiceId')) , lower(f_unaccent(jsonb->>'sourceInvoiceLineId')) , lower(f_unaccent(jsonb->>'toFundId')) , lower(f_unaccent(jsonb->>'transactionType')))$rmb$
      );
    END $do$
2020-06-08T07:49:59,458 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:      DO $do$
    BEGIN
      PERFORM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index('temporary_invoice_transactions_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique', 'ADD',
      'CREATE UNIQUE INDEX IF NOT EXISTS temporary_invoice_transactions_amount_fromFundId_sourceInvoiceId_sourceInvoiceLineId_toFundId_transactionType_idx_unique O
2020-06-08T07:49:59,458 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  SET search_path TO finance_migration_test_tenant_mod_finance_storage,  public
2020-06-08T07:49:59,459 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  SET search_path TO finance_migration_test_tenant_mod_finance_storage,  public
2020-06-08T07:49:59,459 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  UPDATE finance_migration_test_tenant_mod_finance_storage.transaction SET   jsonb = jsonb || '{"source": "User"}' WHERE   jsonb ->> 'transactionType' IN ('Allocation', 'Transfer')
2020-06-08T07:49:59,461 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  UPDATE finance_migration_test_tenant_mod_finance_storage.transaction SET   jsonb = jsonb || '{"source": "User"}' WHERE   jsonb ->> 'transactionType' IN ('Allocation', 'Transfer')
2020-06-08T07:49:59,461 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  UPDATE finance_migration_test_tenant_mod_finance_storage.transaction SET   jsonb = jsonb || '{"source": "PoLine"}' WHERE   jsonb ->> 'transactionType' = 'Encumbrance'
2020-06-08T07:49:59,462 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  UPDATE finance_migration_test_tenant_mod_finance_storage.transaction SET   jsonb = jsonb || '{"source": "PoLine"}' WHERE   jsonb ->> 'transactionType' = 'Encumbrance'
2020-06-08T07:49:59,462 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  UPDATE finance_migration_test_tenant_mod_finance_storage.transaction SET   jsonb = jsonb || '{"source": "Invoice"}' WHERE   jsonb ->> 'transactionType' IN ('Credit', 'Payment')
2020-06-08T07:49:59,463 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  UPDATE finance_migration_test_tenant_mod_finance_storage.transaction SET   jsonb = jsonb || '{"source": "Invoice"}' WHERE   jsonb ->> 'transactionType' IN ('Credit', 'Payment')
2020-06-08T07:49:59,463 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
2020-06-08T07:49:59,484 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  CREATE EXTENSION IF NOT EXISTS "uuid-ossp"
2020-06-08T07:49:59,484 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  UPDATE finance_migration_test_tenant_mod_finance_storage.invoice_transaction_summaries     SET jsonb = jsonb - '{numEncumbrances}'::text[] || jsonb_build_object('numPendingPayments', -(jsonb->>'numPaymentsCredits')::integer) WHERE jsonb ? 'numEncumbrances'
2020-06-08T07:49:59,485 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  UPDATE finance_migration_test_tenant_mod_finance_storage.invoice_transaction_summaries         SET jsonb = jsonb - '{numEncumbrances}'::text[] || jsonb_build_object('numPendingPayments', -(jsonb->>'numPaymentsCredits')::integer) WHERE jsonb ? 'numEncumbrances'
2020-06-08T07:49:59,485 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  INSERT INTO finance_migration_test_tenant_mod_finance_storage.transaction SELECT uuid_generate_v4(), jsonb_strip_nulls(jsonb_build_object('transactionType', 'Pending payment', 'fromFundId', fd->>'fundId',                                               'amount', fdi.amount*(vouchers.jsonb->>'exchangeRate')::decimal, 'source', 'Invoice',                                               'sourceInvoiceId', invoices.id, 'sourceInvoiceLineId', fdi.il->>'id',                                               'fiscalYearId', budget.fiscalYearId, 'currency', fy.jsonb->>'currency',                                               'awaitingPayment',                                               CASE WHEN fdi.fd ?'encumbrance'                                               THEN jsonb_build_object('encumbranceId', fdi.fd->>'encumbrance', 'releaseEncumbrance', fdi.il->>'releaseEncumbrance')                                               ELSE null END)) FROM (SELECT fd,               (CASE WHEN fd->>'distributio
2020-06-08T07:49:59,532 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  INSERT INTO finance_migration_test_tenant_mod_finance_storage.transaction SELECT uuid_generate_v4(), jsonb_strip_nulls(jsonb_build_object('transactionType', 'Pending payment', 'fromFundId', fd->>'fundId',                                               'amount', fdi.amount*(vouchers.jsonb->>'exchangeRate')::decimal, 'source', 'Invoice',                                               'sourceInvoiceId
2020-06-08T07:49:59,532 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  INSERT INTO finance_migration_test_tenant_mod_finance_storage.transaction SELECT uuid_generate_v4(), jsonb_build_object('transactionType', 'Pending payment', 'fromFundId', fd->>'fundId',                                                                                        'amount', fdi.amount*(vouchers.jsonb->>'exchangeRate')::decimal, 'source', 'Invoice',                                                                                       'sourceInvoiceId', invoice_id,                                                                                           'fiscalYearId', budget.fiscalYearId, 'currency', fy.jsonb->>'currency') FROM (SELECT fd, (CASE WHEN fd->>'distributionType'='amount' THEN (fd->>'value')::decimal                     ELSE ((CASE WHEN adj->>'type'='Amount' THEN (adj->>'value')::decimal                           ELSE (adj->>'value')::decimal*(invoices.jsonb->>'subTotal')::decimal/100 END)*(fd->>'value')::decimal)/100 END) AS amount,             invoices.id AS invoice_id   FROM finance_migration_test_tenant_mod_invoice_storage.invoices AS invoices,    jsonb_array_elements(invoices.jsonb->'adjustments') AS adj,     jsonb_array_elements( adj->'fundDistributions') AS fd   WHERE invoices.jsonb-
2020-06-08T07:49:59,536 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  INSERT INTO finance_migration_test_tenant_mod_finance_storage.transaction SELECT uuid_generate_v4(), jsonb_build_object('transactionType', 'Pending payment', 'fromFundId', fd->>'fundId',                                                                                    'amount', fdi.amount*(vouchers.jsonb->>'exchangeRate')::decimal, 'source', 'Invoice',                                                                                       'sourceInvoiceId', invoice_id,                                                                                           'fiscalYearId', budget.fiscalYearId, 'currency', fy.json
2020-06-08T07:49:59,536 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  UPDATE finance_migration_test_tenant_mod_finance_storage.budget   SET     jsonb = jsonb || jsonb_build_object('available', (jsonb->>'available')::decimal - sub.total,                                         'unavailable', (jsonb->>'unavailable')::decimal + sub.total,                                         'awaitingPayment', (jsonb->>'awaitingPayment')::decimal + sub.total)   FROM (SELECT  budget.id AS budget_id, sum((transactions.jsonb->>'amount')::decimal) AS total         FROM finance_migration_test_tenant_mod_finance_storage.transaction AS transactions         LEFT JOIN finance_migration_test_tenant_mod_invoice_storage.invoices AS invoices ON transactions.jsonb->>'sourceInvoiceId'=invoices.id::text         LEFT JOIN finance_migration_test_tenant_mod_finance_storage.budget AS budget ON transactions.fromFundId = budget.fundId AND transactions.fiscalYearId = budget.fiscalYearId         WHERE transactions.jsonb->>'transactionType'='Pending payment'           AND NOT transactions.jsonb
2020-06-08T07:49:59,542 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  UPDATE finance_migration_test_tenant_mod_finance_storage.budget   SET     jsonb = jsonb || jsonb_build_object('available', (jsonb->>'available')::decimal - sub.total,                                         'unavailable', (jsonb->>'unavailable')::decimal + sub.total,                                         'awaitingPayment', (jsonb->>'awaitingPayment')::decimal + sub.total)   FROM (SELECT  budget
2020-06-08T07:49:59,542 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  UPDATE finance_migration_test_tenant_mod_finance_storage.ledgerfy as ledgerfy   SET     jsonb = jsonb || jsonb_build_object('available', (jsonb->>'available')::decimal - sub.total,                                         'unavailable', (jsonb->>'unavailable')::decimal + sub.total)   FROM (SELECT ledger.id AS ledgerId, transactions.fiscalYearId AS fiscalYearId, sum((transactions.jsonb->>'amount')::decimal) AS total         FROM finance_migration_test_tenant_mod_finance_storage.transaction AS transactions         LEFT JOIN finance_migration_test_tenant_mod_invoice_storage.invoices AS invoices ON transactions.jsonb->>'sourceInvoiceId'=invoices.id::text         LEFT JOIN finance_migration_test_tenant_mod_finance_storage.fund AS fund ON transactions.fromFundId = fund.id         LEFT JOIN finance_migration_test_tenant_mod_finance_storage.ledger AS ledger ON fund.ledgerId = ledger.id         WHERE invoices.jsonb->>'status' = 'Approved'           AND transactions.jsonb->>'transactionType'='Pe
2020-06-08T07:49:59,547 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  UPDATE finance_migration_test_tenant_mod_finance_storage.ledgerfy as ledgerfy   SET     jsonb = jsonb || jsonb_build_object('available', (jsonb->>'available')::decimal - sub.total,                                         'unavailable', (jsonb->>'unavailable')::decimal + sub.total)   FROM (SELECT ledger.id AS ledgerId, transactions.fiscalYearId AS fiscalYearId, sum((transactions.jsonb->>'amount'):
2020-06-08T07:49:59,547 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  DROP EXTENSION "uuid-ossp"
2020-06-08T07:49:59,550 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  DROP EXTENSION "uuid-ossp"
2020-06-08T07:49:59,550 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  DO $$
DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE format('DROP INDEX IF EXISTS %s', aname);
  END LOOP;
END $$
2020-06-08T07:49:59,551 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  DO $$
DECLARE
  aname TEXT;
BEGIN
  FOR aname IN SELECT name FROM finance_migration_test_tenant_mod_finance_storage.rmb_internal_index WHERE remove = TRUE
  LOOP
    EXECUTE format('DROP INDEX IF EXISTS %s', aname);
  END LOOP;
END $$
2020-06-08T07:49:59,551 INFO  [vert.x-worker-thread-1   ] PostgresClient trying to execute:  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA finance_migration_test_tenant_mod_finance_storage TO finance_migration_test_tenant_mod_finance_storage
2020-06-08T07:49:59,552 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully executed:  GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA finance_migration_test_tenant_mod_finance_storage TO finance_migration_test_tenant_mod_finance_storage
2020-06-08T07:49:59,556 INFO  [vert.x-worker-thread-1   ] PostgresClient Successfully committed: -1428326972
2020-06-08T07:49:59,598 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking postTenant
2020-06-08T07:49:59,606 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 POST /_/tenant null HTTP_1_1 200 2 2035 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2020-06-08T07:50:00,182 INFO  [vert.x-eventloop-thread-0] PostgresClient DB config read from environment variables
2020-06-08T07:50:00,184 INFO  [vert.x-eventloop-thread-0] PostgresClient Using schema: finance_migration_test_tenant
2020-06-08T07:50:00,185 INFO  [vert.x-eventloop-thread-0] PostgresClient postgreSQLClientConfig = {"maxPoolSize":5,"charset":"UTF-8","port":5432,"host":"10.0.2.15","queryTimeout":60000,"username":"finance_migration_test_tenant_mod_finance_storage","database":"okapi_modules","password":"...","connectionReleaseDelay":60000}
2020-06-08T07:50:00,187 INFO  [vert.x-eventloop-thread-0] PostgreSQLClientImpl Creating configuration for 10.0.2.15:5432
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
2020-06-08T07:50:00,266 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: sourceInvoiceLineId==74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 AND fromFundId==ebce4b7d-388a-4471-8b82-c1c093e02363 >>>WHERE (lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))) AND (fromFundId='ebce4b7d-388a-4471-8b82-c1c093e02363') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
2020-06-08T07:50:00,393 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:00,433 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=sourceInvoiceLineId==74c84aeb-6b3e-44c8-b028-ce5891a1a0e4%20AND%20fromFundId==ebce4b7d-388a-4471-8b82-c1c093e02363 HTTP_1_1 200 603 649 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
2020-06-08T07:50:00,617 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: sourceInvoiceLineId==74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 AND fromFundId==812a1521-360c-4e1e-a03e-e0e1d570ccc7 >>>WHERE (lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))) AND (fromFundId='812a1521-360c-4e1e-a03e-e0e1d570ccc7') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId == 74c84aeb-6b3e-44c8-b028-ce5891a1a0e4 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) LIKE lower(f_unaccent('74c84aeb-6b3e-44c8-b028-ce5891a1a0e4'))
2020-06-08T07:50:00,632 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:00,636 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=sourceInvoiceLineId==74c84aeb-6b3e-44c8-b028-ce5891a1a0e4%20AND%20fromFundId==812a1521-360c-4e1e-a03e-e0e1d570ccc7 HTTP_1_1 200 603 36 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
2020-06-08T07:50:00,820 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: cql.allRecords=1 NOT sourceInvoiceLineId="" AND sourceInvoiceId==c4f3ce28-a786-42b1-a7d4-1058f366df77 AND fromFundId==ebce4b7d-388a-4471-8b82-c1c093e02363 >>>WHERE (((true) AND ( (transaction.jsonb->>'sourceInvoiceLineId' ~ '') IS NOT TRUE)) AND (lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77')))) AND (fromFundId='ebce4b7d-388a-4471-8b82-c1c093e02363') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:00 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
2020-06-08T07:50:00,841 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:00,847 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=cql.allRecords=1%20NOT%20sourceInvoiceLineId=%22%22%20AND%20sourceInvoiceId==c4f3ce28-a786-42b1-a7d4-1058f366df77%20AND%20fromFundId==ebce4b7d-388a-4471-8b82-c1c093e02363 HTTP_1_1 200 401 50 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
2020-06-08T07:50:01,059 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: cql.allRecords=1 NOT sourceInvoiceLineId="" AND sourceInvoiceId==c4f3ce28-a786-42b1-a7d4-1058f366df77 AND fromFundId==812a1521-360c-4e1e-a03e-e0e1d570ccc7 >>>WHERE (((true) AND ( (transaction.jsonb->>'sourceInvoiceLineId' ~ '') IS NOT TRUE)) AND (lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77')))) AND (fromFundId='812a1521-360c-4e1e-a03e-e0e1d570ccc7') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
2020-06-08T07:50:01,079 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:01,087 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=cql.allRecords=1%20NOT%20sourceInvoiceLineId=%22%22%20AND%20sourceInvoiceId==c4f3ce28-a786-42b1-a7d4-1058f366df77%20AND%20fromFundId==812a1521-360c-4e1e-a03e-e0e1d570ccc7 HTTP_1_1 200 401 47 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
2020-06-08T07:50:01,247 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: cql.allRecords=1 NOT sourceInvoiceLineId="" AND sourceInvoiceId==c4f3ce28-a786-42b1-a7d4-1058f366df77 AND fromFundId==4819b170-4ac5-4593-88b4-d9048764dd21 >>>WHERE (((true) AND ( (transaction.jsonb->>'sourceInvoiceLineId' ~ '') IS NOT TRUE)) AND (lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77')))) AND (fromFundId='4819b170-4ac5-4593-88b4-d9048764dd21') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByLike
WARNING: Doing LIKE search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId == c4f3ce28-a786-42b1-a7d4-1058f366df77 >>> lower(f_unaccent(transaction.jsonb->>'sourceInvoiceId')) LIKE lower(f_unaccent('c4f3ce28-a786-42b1-a7d4-1058f366df77'))
2020-06-08T07:50:01,268 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:01,271 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=cql.allRecords=1%20NOT%20sourceInvoiceLineId=%22%22%20AND%20sourceInvoiceId==c4f3ce28-a786-42b1-a7d4-1058f366df77%20AND%20fromFundId==4819b170-4ac5-4593-88b4-d9048764dd21 HTTP_1_1 200 402 33 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = a545e5c0-d170-400b-8c6a-989d861e7571 >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('a545e5c0-d170-400b-8c6a-989d861e7571'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = a545e5c0-d170-400b-8c6a-989d861e7571 >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('a545e5c0-d170-400b-8c6a-989d861e7571'))
2020-06-08T07:50:01,451 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: sourceInvoiceLineId=a545e5c0-d170-400b-8c6a-989d861e7571  AND fromFundId==ebce4b7d-388a-4471-8b82-c1c093e02363 >>>WHERE (to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('a545e5c0-d170-400b-8c6a-989d861e7571'))) AND (fromFundId='ebce4b7d-388a-4471-8b82-c1c093e02363') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = a545e5c0-d170-400b-8c6a-989d861e7571 >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('a545e5c0-d170-400b-8c6a-989d861e7571'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = a545e5c0-d170-400b-8c6a-989d861e7571 >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('a545e5c0-d170-400b-8c6a-989d861e7571'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = a545e5c0-d170-400b-8c6a-989d861e7571 >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('a545e5c0-d170-400b-8c6a-989d861e7571'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = a545e5c0-d170-400b-8c6a-989d861e7571 >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('a545e5c0-d170-400b-8c6a-989d861e7571'))
2020-06-08T07:50:01,465 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:01,470 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=sourceInvoiceLineId=a545e5c0-d170-400b-8c6a-989d861e7571%20%20AND%20fromFundId==ebce4b7d-388a-4471-8b82-c1c093e02363 HTTP_1_1 200 472 31 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = 60a37221-497e-4b08-a7f1-b5d2b0ea288a >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('60a37221-497e-4b08-a7f1-b5d2b0ea288a'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = 60a37221-497e-4b08-a7f1-b5d2b0ea288a >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('60a37221-497e-4b08-a7f1-b5d2b0ea288a'))
2020-06-08T07:50:01,659 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: sourceInvoiceLineId=60a37221-497e-4b08-a7f1-b5d2b0ea288a  AND fromFundId==812a1521-360c-4e1e-a03e-e0e1d570ccc7 >>>WHERE (to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('60a37221-497e-4b08-a7f1-b5d2b0ea288a'))) AND (fromFundId='812a1521-360c-4e1e-a03e-e0e1d570ccc7') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = 60a37221-497e-4b08-a7f1-b5d2b0ea288a >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('60a37221-497e-4b08-a7f1-b5d2b0ea288a'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = 60a37221-497e-4b08-a7f1-b5d2b0ea288a >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('60a37221-497e-4b08-a7f1-b5d2b0ea288a'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = 60a37221-497e-4b08-a7f1-b5d2b0ea288a >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('60a37221-497e-4b08-a7f1-b5d2b0ea288a'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = 60a37221-497e-4b08-a7f1-b5d2b0ea288a >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('60a37221-497e-4b08-a7f1-b5d2b0ea288a'))
2020-06-08T07:50:01,671 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:01,673 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=sourceInvoiceLineId=60a37221-497e-4b08-a7f1-b5d2b0ea288a%20%20AND%20fromFundId==812a1521-360c-4e1e-a03e-e0e1d570ccc7 HTTP_1_1 200 470 27 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId = f07358f4-1df2-4e63-9d05-0facb3219d9b >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceId')) @@ tsquery_phrase(f_unaccent('f07358f4-1df2-4e63-9d05-0facb3219d9b'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId = f07358f4-1df2-4e63-9d05-0facb3219d9b >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceId')) @@ tsquery_phrase(f_unaccent('f07358f4-1df2-4e63-9d05-0facb3219d9b'))
2020-06-08T07:50:01,860 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: cql.allRecords=1 NOT sourceInvoiceLineId="" AND sourceInvoiceId=f07358f4-1df2-4e63-9d05-0facb3219d9b  AND fromFundId==4819b170-4ac5-4593-88b4-d9048764dd21 >>>WHERE (((true) AND ( (transaction.jsonb->>'sourceInvoiceLineId' ~ '') IS NOT TRUE)) AND (to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceId')) @@ tsquery_phrase(f_unaccent('f07358f4-1df2-4e63-9d05-0facb3219d9b')))) AND (fromFundId='4819b170-4ac5-4593-88b4-d9048764dd21') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId = f07358f4-1df2-4e63-9d05-0facb3219d9b >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceId')) @@ tsquery_phrase(f_unaccent('f07358f4-1df2-4e63-9d05-0facb3219d9b'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId = f07358f4-1df2-4e63-9d05-0facb3219d9b >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceId')) @@ tsquery_phrase(f_unaccent('f07358f4-1df2-4e63-9d05-0facb3219d9b'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId = f07358f4-1df2-4e63-9d05-0facb3219d9b >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceId')) @@ tsquery_phrase(f_unaccent('f07358f4-1df2-4e63-9d05-0facb3219d9b'))
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = "" >>> transaction.jsonb->>'sourceInvoiceLineId' ~ ''
Jun 08, 2020 7:50:01 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceId', CQL >>> SQL: sourceInvoiceId = f07358f4-1df2-4e63-9d05-0facb3219d9b >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceId')) @@ tsquery_phrase(f_unaccent('f07358f4-1df2-4e63-9d05-0facb3219d9b'))
2020-06-08T07:50:01,889 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:01,893 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=cql.allRecords=1%20NOT%20sourceInvoiceLineId=%22%22%20AND%20sourceInvoiceId=f07358f4-1df2-4e63-9d05-0facb3219d9b%20%20AND%20fromFundId==4819b170-4ac5-4593-88b4-d9048764dd21 HTTP_1_1 200 409 46 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:02 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
Jun 08, 2020 7:50:02 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = c0205139-1847-428c-80f5-99143a9632df >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('c0205139-1847-428c-80f5-99143a9632df'))
Jun 08, 2020 7:50:02 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = c0205139-1847-428c-80f5-99143a9632df >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('c0205139-1847-428c-80f5-99143a9632df'))
2020-06-08T07:50:02,064 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: sourceInvoiceLineId=c0205139-1847-428c-80f5-99143a9632df  AND fromFundId==4819b170-4ac5-4593-88b4-d9048764dd21 >>>WHERE (to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('c0205139-1847-428c-80f5-99143a9632df'))) AND (fromFundId='4819b170-4ac5-4593-88b4-d9048764dd21') LIMIT 10 OFFSET 0
Jun 08, 2020 7:50:02 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = c0205139-1847-428c-80f5-99143a9632df >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('c0205139-1847-428c-80f5-99143a9632df'))
Jun 08, 2020 7:50:02 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = c0205139-1847-428c-80f5-99143a9632df >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('c0205139-1847-428c-80f5-99143a9632df'))
Jun 08, 2020 7:50:02 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = c0205139-1847-428c-80f5-99143a9632df >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('c0205139-1847-428c-80f5-99143a9632df'))
Jun 08, 2020 7:50:02 AM org.folio.cql2pgjson.CQL2PgJSON queryByFt
WARNING: Doing FT search without index for transaction.jsonb->>'sourceInvoiceLineId', CQL >>> SQL: sourceInvoiceLineId = c0205139-1847-428c-80f5-99143a9632df >>> to_tsvector('simple', f_unaccent(transaction.jsonb->>'sourceInvoiceLineId')) @@ tsquery_phrase(f_unaccent('c0205139-1847-428c-80f5-99143a9632df'))
2020-06-08T07:50:02,078 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageTransactions
2020-06-08T07:50:02,081 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/transactions query=sourceInvoiceLineId=c0205139-1847-428c-80f5-99143a9632df%20%20AND%20fromFundId==4819b170-4ac5-4593-88b4-d9048764dd21 HTTP_1_1 200 474 24 tid=finance_migration_test_tenant OK
2020-06-08T07:50:02,480 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageBudgetsById
2020-06-08T07:50:02,489 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/budgets/9798d9e4-1f9f-4219-a1b0-3e8ee7e7e0e2 null HTTP_1_1 200 614 252 tid=finance_migration_test_tenant OK
2020-06-08T07:50:02,651 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageBudgetsById
2020-06-08T07:50:02,654 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/budgets/68950da9-823f-4b87-afb2-035470ebc024 null HTTP_1_1 200 617 7 tid=finance_migration_test_tenant OK
2020-06-08T07:50:02,819 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageBudgetsById
2020-06-08T07:50:02,822 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/budgets/a795bdcb-590a-479f-9aaa-e23c07773f78 null HTTP_1_1 200 640 9 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:03 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2020-06-08T07:50:03,212 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: ledgerId==f13391e0-e64f-4c95-af45-f3cecf839ae0 AND fiscalYearId==5729d950-d917-446d-815e-cf0df88f9406 >>>WHERE (ledgerId='f13391e0-e64f-4c95-af45-f3cecf839ae0') AND (fiscalYearId='5729d950-d917-446d-815e-cf0df88f9406') LIMIT 10 OFFSET 0
2020-06-08T07:50:03,219 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageLedgerFiscalYears
2020-06-08T07:50:03,223 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/ledger-fiscal-years query=ledgerId==f13391e0-e64f-4c95-af45-f3cecf839ae0%20AND%20fiscalYearId==5729d950-d917-446d-815e-cf0df88f9406 HTTP_1_1 200 316 246 tid=finance_migration_test_tenant OK
Jun 08, 2020 7:50:03 AM org.folio.cql2pgjson.CQL2PgJSON loadDbSchema
INFO: loadDbSchema: Loaded templates/db_scripts/schema.json OK
2020-06-08T07:50:03,388 INFO  [vert.x-eventloop-thread-0] CQLWrapper CQL >>> SQL: ledgerId==98426345-d4d1-4484-ad8f-0e17b660f952 AND fiscalYearId==5729d950-d917-446d-815e-cf0df88f9406 >>>WHERE (ledgerId='98426345-d4d1-4484-ad8f-0e17b660f952') AND (fiscalYearId='5729d950-d917-446d-815e-cf0df88f9406') LIMIT 10 OFFSET 0
2020-06-08T07:50:03,392 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageLedgerFiscalYears
2020-06-08T07:50:03,394 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/ledger-fiscal-years query=ledgerId==98426345-d4d1-4484-ad8f-0e17b660f952%20AND%20fiscalYearId==5729d950-d917-446d-815e-cf0df88f9406 HTTP_1_1 200 332 9 tid=finance_migration_test_tenant OK
2020-06-08T07:50:03,696 INFO  [vert.x-eventloop-thread-0] LogUtil org.folio.rest.RestVerticle start  invoking getFinanceStorageInvoiceTransactionSummariesById
2020-06-08T07:50:03,698 INFO  [vert.x-eventloop-thread-0] LogUtil 10.0.2.15:46534 GET /finance-storage/invoice-transaction-summaries/de5356ab-d5c4-431b-af26-5c9467f3b4a7 null HTTP_1_1 200 108 140 tid=finance_migration_test_tenant OK