exec java -Dport=8081 -Xmx256m -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=9573 -XX:+ExitOnOutOfMemoryError -cp . -jar /usr/verticles/mod-kb-ebsco-java-fat.jar Listening for transport dt_socket at address: 9573 starting rest verticle service.......... 16:13:48 [] [] [] [] INFO Version HV000001: Hibernate Validator null 16:13:48 [] [] [] [] INFO Messages Loading messages from /infra-messages/APIMessages_en.properties ................................ 16:13:48 [] [] [] [] INFO Messages Loading messages from /infra-messages/APIMessages_de.properties ................................ 16:13:48 [] [] [] [] INFO RestVerticle git: https://github.com/folio-org/raml-module-builder.git a70c65db2f827dbe12c93e9447a625c772749ebc 16:13:48 [] [] [] [] INFO PomReader Reading from jar 16:13:48 [] [] [] [] INFO PomReader module name: mod_kb_ebsco_java, version: 3.6.6 16:13:48 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start metrics enabled: false 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/status 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/providers 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/root-proxy 16:13:49 [] [] [] [] INFO RestVerticle ^/_/ramls 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/titles/{titleId}/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/loading/kb-credentials 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/custom-labels 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/access-types 16:13:49 [] [] [] [] INFO RestVerticle ^/admin 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/users 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages/{packageId}/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/custom-labels 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/proxy-types 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/cache 16:13:49 [] [] [] [] INFO RestVerticle ^/_/jsonSchemas 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/resources/{resourceId}/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/currencies 16:13:49 [] [] [] [] INFO RestVerticle ^/_/tenant 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages/{packageId}/resources/costperuse 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/user-kb-credential 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/resources 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/tags 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/uc 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/root-proxy 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/uc 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/packages/{packageId}/resources/costperuse/export 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/kb-credentials/{id}/proxy-types 16:13:49 [] [] [] [] INFO RestVerticle ^/configurations 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/access-types 16:13:49 [] [] [] [] INFO RestVerticle ^/rmbtests 16:13:49 [] [] [] [] INFO RestVerticle ^/eholdings/titles 16:13:49 [] [] [] [] INFO RestVerticle 1 verticles deployed 16:13:49 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle runHook One time hook called with implemented class named org.folio.rest.impl.InitAPIImpl 16:13:51 [] [] [] [] INFO eanMethodInterceptor @Bean method ApplicationConfig.placeholderConfigurer is non-static and returns an object assignable to Spring's BeanFactoryPostProcessor interface. This will result in a failure to process annotations such as @Autowired, @Resource and @PostConstruct within the method's declaring @Configuration class. Add the 'static' modifier to this method to avoid these container lifecycle issues; see @Bean javadoc for complete details. 16:13:52 [] [] [] [] INFO RestVerticle init succeeded....... 16:13:52 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle runPeriodicHook no periodic implementation found, continuing with deployment 16:13:53 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle runPostDeployHook no Post Deploy Hook implementation found, continuing with deployment 16:13:53 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start http server for apis and docs started on port 8081. 16:13:53 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start Documentation available at: http://localhost:8081/apidocs/ 16:13:53 [] [] [] [] INFO ? Succeeded in deploying verticle 16:13:54 [] [] [] [] INFO LogUtil 10.0.2.15:55690 GET / null HTTP_1_1 400 28 -1 tid=null Bad Request Invalid URL path requested / 16:13:59 [] [] [] [] INFO PostgresClient DB config read from environment variables 16:13:59 [] [] [] [] INFO PostgresClient postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"folio_admin","host":"10.0.2.15","database":"okapi_modules","password":"..."} 16:14:00 [] [] [] [] INFO PostgresClient Executing multiple statements with id -1669000529 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user"; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user"; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ BEGIN BEGIN -- This only succeeds if show_trgm, a pg_trgm function, -- has been loaded into public schema. PERFORM public.show_trgm('a'); EXCEPTION WHEN undefined_function THEN BEGIN ALTER EXTENSION pg_trgm SET SCHEMA public; EXCEPTION WHEN undefined_object THEN NULL; END; END; END $$; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed DO $$ BEGIN BEGIN -- This only succeeds if show_trgm, a pg_trgm function, -- has been loaded into public schema. PERFORM public.show_trgm('a'); EXCEPTION WHEN undefined_function THEN BEGIN ALTER EXTENSION pg_trgm SET SCHEMA public; EXCEPTION WHEN undefined_object THEN NULL; END; END; END $$; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public; 16:14:00 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='42710', message='extension "unaccent" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='extension.c', line='1758', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; 16:14:00 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='42710', message='extension "pg_trgm" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='extension.c', line='1758', routine='CreateExtension', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL ); 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_job ( id UUID PRIMARY KEY, jsonb JSONB NOT NULL ); 16:14:00 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking postTenant 16:14:00 [] [] [] [] INFO LogUtil 10.0.2.15:55700 POST /_/tenant null HTTP_1_1 201 289 2078 tid=diku Created 16:14:00 [] [] [] [] INFO PostgresClient Executing multiple statements with id 545831479 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} SET search_path TO diku_mod_kb_ebsco_java; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed SET search_path TO diku_mod_kb_ebsco_java; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL ); 16:14:00 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_index" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE TABLE IF NOT EXISTS diku_mod_kb_ebsco_java.rmb_internal_index ( name text PRIMARY KEY, def text NOT NULL, remove boolean NOT NULL ); 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE; 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE; 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ); 16:14:00 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='42P07', message='relation "rmb_internal_analyze" already exists, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='parse_utilcmd.c', line='209', routine='transformCreateStmt', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:00 [] [] [] [] INFO PostgresClient Successfully executed CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ); 16:14:00 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text); 16:14:01 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:01 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 289 91 tid=diku OK 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE FUNCTION diku_mod_kb_ebsco_java.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$ DECLARE rec record; cnt bigint; BEGIN IF rows = lim THEN FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP cnt := substring(rec."QUERY PLAN" FROM ' rows=([[:digit:]]+)'); EXIT WHEN cnt IS NOT NULL; END LOOP; RETURN cnt; END IF; RETURN rows; END; $$ LANGUAGE plpgsql VOLATILE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE FUNCTION diku_mod_kb_ebsco_java.count_estimate_smart2(rows bigint, lim bigint, query text) RETURNS bigint AS $$ DECLARE rec record; cnt bigint; BEGIN IF rows = lim THEN FOR rec IN EXECUTE 'EXPLAIN ' || query LOOP cnt := substring(rec."QUERY PLAN" FROM ' rows=([[:digit:]]+)'); EXIT WHEN cnt IS NOT NULL; END LOOP; RETURN cnt; END IF; RETURN rows; END; $$ LANGUAGE plpgsql VOLATILE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.count_estimate_default(query text) RETURNS bigint AS $$ DECLARE rows bigint; q text; BEGIN q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO rows; IF rows < 1000 THEN return rows; END IF; rows = diku_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF rows < 1000 THEN return 1000; END IF; RETURN rows; END; $$ LANGUAGE plpgsql IMMUTABLE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.count_estimate_default(query text) RETURNS bigint AS $$ DECLARE rows bigint; q text; BEGIN q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO rows; IF rows < 1000 THEN return rows; END IF; rows = diku_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF rows < 1000 THEN return 1000; END IF; RETURN rows; END; $$ LANGUAGE plpgsql IMMUTABLE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.count_estimate(query text) RETURNS bigint AS $$ DECLARE count bigint; est_count bigint; q text; BEGIN est_count = diku_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF est_count > 4*1000 THEN RETURN est_count; END IF; q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO count; IF count < 1000 THEN RETURN count; END IF; IF est_count < 1000 THEN RETURN 1000; END IF; RETURN est_count; END; $$ LANGUAGE plpgsql STABLE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.count_estimate(query text) RETURNS bigint AS $$ DECLARE count bigint; est_count bigint; q text; BEGIN est_count = diku_mod_kb_ebsco_java.count_estimate_smart2(1000, 1000, query); IF est_count > 4*1000 THEN RETURN est_count; END IF; q = 'SELECT COUNT(*) FROM (' || query || ' LIMIT 1000) x'; EXECUTE q INTO count; IF count < 1000 THEN RETURN count; END IF; IF est_count < 1000 THEN RETURN 1000; END IF; RETURN est_count; END; $$ LANGUAGE plpgsql STABLE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE ver integer; BEGIN SELECT current_setting('server_version_num') INTO ver; IF (ver >= 120000) THEN CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; ELSE CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT regexp_replace(public.unaccent('public.unaccent', $1), E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' || E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' || E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' || E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' || E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' || E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' || E'\u0360\u0361\u0362' || E'\u20dd\u20de\u20df\u20e0' || E'\u20e2\u20e3\u20e4]', '', 'g') $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; END IF; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE ver integer; BEGIN SELECT current_setting('server_version_num') INTO ver; IF (ver >= 120000) THEN CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT public.unaccent('public.unaccent', $1) -- schema-qualify function and dictionary $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; ELSE CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.f_unaccent(text) RETURNS text AS $f_unaccent$ SELECT regexp_replace(public.unaccent('public.unaccent', $1), E'[\u0300\u0301\u0302\u0303\u0304\u0305\u0306\u0307\u0308\u0309\u030a\u030b\u030c\u030d\u030e\u030f' || E'\u0310\u0311\u0312\u0313\u0314\u0315\u0316\u0317\u0318\u0319\u031a\u031b\u031c\u031d\u031e\u031f' || E'\u0320\u0321\u0322\u0323\u0324\u0325\u0326\u0327\u0328\u0329\u032a\u032b\u032c\u032d\u032e\u032f' || E'\u0330\u0331\u0332\u0333\u0334\u0335\u0336\u0337\u0338\u0339\u033a\u033b\u033c\u033d\u033e\u033f' || E'\u0340\u0341\u0342\u0343\u0344\u0345\u0346\u0347\u0348\u0349\u034a\u034b\u034c\u034d\u034e\u034f' || E'\u0350\u0351\u0352\u0353\u0354\u0355\u0356\u0357\u0358\u0359\u035a\u035b\u035c\u035d\u035e\u035f' || E'\u0360\u0361\u0362' || E'\u20dd\u20de\u20df\u20e0' || E'\u20e2\u20e3\u20e4]', '', 'g') $f_unaccent$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; END IF; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.get_tsvector(text) RETURNS tsvector AS $$ SELECT to_tsvector('simple', translate($1, '&', ',')); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.get_tsvector(text) RETURNS tsvector AS $$ SELECT to_tsvector('simple', translate($1, '&', ',')); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_and(text) RETURNS tsquery AS $$ SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN '' WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*' ELSE '''' || v || '''' END, '&')) FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_and(text) RETURNS tsquery AS $$ SELECT to_tsquery('simple', string_agg(CASE WHEN length(v) = 0 OR v = '*' THEN '' WHEN right(v, 1) = '*' THEN '''' || left(v, -1) || ''':*' ELSE '''' || v || '''' END, '&')) FROM (SELECT regexp_split_to_table(translate($1, '&''', ',,'), ' +')) AS x(v); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_or(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '|')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_or(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '|')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_phrase(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '<->')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.tsquery_phrase(text) RETURNS tsquery AS $$ SELECT replace(diku_mod_kb_ebsco_java.tsquery_and($1)::text, '&', '<->')::tsquery; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.normalize_digits(text) RETURNS text AS $$ SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '') || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN '' WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN '' ELSE ' ' END || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2]; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.normalize_digits(text) RETURNS text AS $$ SELECT translate((regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1], E' \t-', '') || CASE WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[1] = '' THEN '' WHEN (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2] = '' THEN '' ELSE ' ' END || (regexp_match($1, '^([0-9 \t-]*(?:\*[ \t]*)?)(.*)'))[2]; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.set_id_in_jsonb() RETURNS TRIGGER AS $$ BEGIN NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id)); RETURN NEW; END; $$ language 'plpgsql'; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.set_id_in_jsonb() RETURNS TRIGGER AS $$ BEGIN NEW.jsonb = jsonb_set(NEW.jsonb, '{id}', to_jsonb(NEW.id)); RETURN NEW; END; $$ language 'plpgsql'; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_space_sql(VARIADIC text[]) RETURNS text AS $$ select concat_ws(' ', VARIADIC $1); $$ LANGUAGE SQL IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_array_object_values(jsonb_array jsonb, field text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_array_object_values( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT string_agg(value->>$2, ' ') FROM jsonb_array_elements($1) WHERE value->>$3 = $4; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.first_array_object_value( jsonb_array jsonb, field text, filterkey text, filtervalue text) RETURNS text AS $$ SELECT value->>$2 FROM jsonb_array_elements($1) WHERE value->>$3 = $4 LIMIT 1; $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} create or replace function diku_mod_kb_ebsco_java.concat_array_object(jsonb_array jsonb) RETURNS text AS $$ SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed create or replace function diku_mod_kb_ebsco_java.concat_array_object(jsonb_array jsonb) RETURNS text AS $$ SELECT string_agg(value::text, ' ') FROM jsonb_array_elements_text($1); $$ LANGUAGE sql IMMUTABLE PARALLEL SAFE STRICT; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function rmb_internal_index(text,text,text) does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$ DECLARE olddef text; namep CONSTANT text = concat(aname, '_p'); prepareddef text; BEGIN IF tops = 'DELETE' THEN -- use case insensitive %s, not case sensitive %I -- no SQL injection because the names are hard-coded in schema.json EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE 'DELETE FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = $1' USING aname; RETURN; END IF; SELECT def INTO olddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = aname; SELECT def INTO prepareddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = namep; prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON ')); IF prepareddef = newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname); EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; ELSIF olddef IS DISTINCT FROM newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE newdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; END IF; EXECUTE 'INSERT INTO diku_mod_kb_ebsco_java.rmb_internal_index VALUES ($1, $2, FALSE) ' 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION rmb_internal_index( atable text, aname text, tops text, newdef text) RETURNS void AS $$ DECLARE olddef text; namep CONSTANT text = concat(aname, '_p'); prepareddef text; BEGIN IF tops = 'DELETE' THEN -- use case insensitive %s, not case sensitive %I -- no SQL injection because the names are hard-coded in schema.json EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE 'DELETE FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = $1' USING aname; RETURN; END IF; SELECT def INTO olddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = aname; SELECT def INTO prepareddef FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE name = namep; prepareddef = replace(prepareddef, concat(' ', namep, ' ON '), concat(' ', aname, ' ON ')); IF prepareddef = newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE format('ALTER INDEX IF EXISTS %s RENAME TO %s', namep, aname); EXECUTE 'DELETE FROM rmb_internal_index WHERE name = $1' USING namep; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; ELSIF olddef IS DISTINCT FROM newdef THEN EXECUTE format('DROP INDEX IF EXISTS %s', aname); EXECUTE newdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING atable; END IF; EXECUTE 'INSERT INTO diku_mod_kb_ebsco_java.rmb_internal_index VALUES ($1, $2, FALSE) ' 'ON CONFLICT (name) DO UPDATE SET def = EXCLUDED.def, remove = EXCLUDED.remove' USING aname, newdef; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ BEGIN -- use advisory lock to prevent "tuple concurrently updated" -- https://issues.folio.org/browse/RMB-744 PERFORM pg_advisory_xact_lock(20201101, 1234567890); REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java; REVOKE CREATE ON SCHEMA public FROM PUBLIC; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ BEGIN -- use advisory lock to prevent "tuple concurrently updated" -- https://issues.folio.org/browse/RMB-744 PERFORM pg_advisory_xact_lock(20201101, 1234567890); REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java; REVOKE CREATE ON SCHEMA public FROM PUBLIC; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_tags_references" for relation "diku_mod_kb_ebsco_java.tags" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_tags_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_tags_ol_version_trigger ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_tags_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.tags" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_tags_ol_version_trigger ON diku_mod_kb_ebsco_java.tags CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.tags_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.tags_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.tags_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_packages_references" for relation "diku_mod_kb_ebsco_java.packages" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_packages_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_packages_ol_version_trigger ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_packages_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.packages" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_packages_ol_version_trigger ON diku_mod_kb_ebsco_java.packages CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.packages_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.packages_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.packages_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_providers_references" for relation "diku_mod_kb_ebsco_java.providers" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_providers_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_providers_ol_version_trigger ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_providers_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.providers" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_providers_ol_version_trigger ON diku_mod_kb_ebsco_java.providers CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.providers_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.providers_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.providers_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_resources_references" for relation "diku_mod_kb_ebsco_java.resources" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_resources_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_resources_ol_version_trigger ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_resources_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.resources" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_resources_ol_version_trigger ON diku_mod_kb_ebsco_java.resources CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.resources_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.resources_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.resources_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_titles_references" for relation "diku_mod_kb_ebsco_java.titles" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_titles_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_titles_ol_version_trigger ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_titles_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.titles" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_titles_ol_version_trigger ON diku_mod_kb_ebsco_java.titles CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.titles_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.titles_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.titles_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_access_types_references" for relation "diku_mod_kb_ebsco_java.access_types" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_access_types_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_access_types_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_access_types_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.access_types" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_access_types_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.access_types_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_access_types_mappings_references" for relation "diku_mod_kb_ebsco_java.access_types_mappings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_access_types_mappings_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_access_types_mappings_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_access_types_mappings_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.access_types_mappings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_access_types_mappings_ol_version_trigger ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_mappings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:01 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 289 45 tid=diku OK 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.access_types_mappings_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.access_types_mappings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_holdings_references" for relation "diku_mod_kb_ebsco_java.holdings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_holdings_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_holdings_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_holdings_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.holdings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_holdings_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.holdings_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_holdings_status_references" for relation "diku_mod_kb_ebsco_java.holdings_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_holdings_status_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_holdings_status_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_holdings_status_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.holdings_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_holdings_status_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.holdings_status_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_holdings_status_audit_references" for relation "diku_mod_kb_ebsco_java.holdings_status_audit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_holdings_status_audit_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_holdings_status_audit_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_holdings_status_audit_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.holdings_status_audit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_holdings_status_audit_ol_version_trigger ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_audit_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.holdings_status_audit_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.holdings_status_audit_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_retry_status_references" for relation "diku_mod_kb_ebsco_java.retry_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_retry_status_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_retry_status_ol_version_trigger ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_retry_status_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.retry_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_retry_status_ol_version_trigger ON diku_mod_kb_ebsco_java.retry_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.retry_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.retry_status_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.retry_status_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "update_transaction_ids_references" for relation "diku_mod_kb_ebsco_java.transaction_ids" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references(); 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.update_transaction_ids_references() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references(); 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_transaction_ids_ol_version_trigger ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_transaction_ids_ol_version_trigger" for relation "diku_mod_kb_ebsco_java.transaction_ids" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_transaction_ids_ol_version_trigger ON diku_mod_kb_ebsco_java.transaction_ids CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.transaction_ids_set_ol_version() CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='function diku_mod_kb_ebsco_java.transaction_ids_set_ol_version() does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.transaction_ids_set_ol_version() CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "tags" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "packages" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "providers" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "resources" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "titles" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "holdings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "retry_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "holdings_status" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "holdings_status_audit" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "transaction_ids" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "access_types" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "access_types_mappings" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "kb_credentials" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE; 16:14:01 [] [] [] [] WARN ? Backend notice: severity='NOTICE', code='00000', message='trigger "set_id_in_jsonb" for relation "assigned_users" does not exist, skipping', detail='null', hint='null', position='null', internalPosition='null', internalQuery='null', where='null', file='dropcmds.c', line='473', routine='does_not_exist_skipping', schema='null', table='null', column='null', dataType='null', constraint='null' 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION change_owner (table_name varchar, owner varchar) RETURNS VOID AS $$ BEGIN EXECUTE format('ALTER TABLE %s OWNER TO %s', table_name, owner); END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION change_owner (table_name varchar, owner varchar) RETURNS VOID AS $$ BEGIN EXECUTE format('ALTER TABLE %s OWNER TO %s', table_name, owner); END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} CREATE OR REPLACE FUNCTION change_owner_all () RETURNS VOID AS $$ DECLARE rec RECORD; BEGIN FOR rec IN (SELECT table_schema || '.' || table_name table_name, 'diku_mod_kb_ebsco_java' as owner FROM information_schema.tables WHERE table_schema = 'diku_mod_kb_ebsco_java') LOOP EXECUTE change_owner(rec.table_name, rec.owner); END LOOP; END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed CREATE OR REPLACE FUNCTION change_owner_all () RETURNS VOID AS $$ DECLARE rec RECORD; BEGIN FOR rec IN (SELECT table_schema || '.' || table_name table_name, 'diku_mod_kb_ebsco_java' as owner FROM information_schema.tables WHERE table_schema = 'diku_mod_kb_ebsco_java') LOOP EXECUTE change_owner(rec.table_name, rec.owner); END LOOP; END; $$ LANGUAGE plpgsql volatile; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION change_owner_all; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION change_owner_all; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DROP FUNCTION change_owner; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DROP FUNCTION change_owner; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE rec RECORD; BEGIN FOR rec IN ( SELECT 'ALTER FUNCTION ' || quote_ident(n.nspname) || '.' || quote_ident(p.proname) || '(' || pg_catalog.pg_get_function_identity_arguments(p.oid) || ') OWNER TO ' || n.nspname || ';' AS sql_statement FROM pg_catalog.pg_proc p JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace WHERE n.nspname = 'diku_mod_kb_ebsco_java' ) LOOP EXECUTE rec.sql_statement; END LOOP; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE rec RECORD; BEGIN FOR rec IN ( SELECT 'ALTER FUNCTION ' || quote_ident(n.nspname) || '.' || quote_ident(p.proname) || '(' || pg_catalog.pg_get_function_identity_arguments(p.oid) || ') OWNER TO ' || n.nspname || ';' AS sql_statement FROM pg_catalog.pg_proc p JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace WHERE n.nspname = 'diku_mod_kb_ebsco_java' ) LOOP EXECUTE rec.sql_statement; END LOOP; END $$ LANGUAGE plpgsql; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE aname TEXT; BEGIN FOR aname IN SELECT name FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE remove = TRUE LOOP EXECUTE 'DROP INDEX IF EXISTS ' || aname; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE aname TEXT; BEGIN FOR aname IN SELECT name FROM diku_mod_kb_ebsco_java.rmb_internal_index WHERE remove = TRUE LOOP EXECUTE 'DROP INDEX IF EXISTS ' || aname; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE version TEXT; i RECORD; newindexdef TEXT; BEGIN SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_kb_ebsco_java.rmb_internal; IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x RETURN; END IF; FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_kb_ebsco_java' LOOP newindexdef := regexp_replace(i.indexdef, -- \m = beginning of a word, \M = end of a word '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M', 'diku_mod_kb_ebsco_java.\1', 'g'); IF newindexdef <> i.indexdef THEN EXECUTE 'DROP INDEX ' || i.indexname; EXECUTE newindexdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename; END IF; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE version TEXT; i RECORD; newindexdef TEXT; BEGIN SELECT jsonb->>'rmbVersion' INTO version FROM diku_mod_kb_ebsco_java.rmb_internal; IF version !~ '^(\d\.|1\d\.|2[0-8]\.|29\.[0-3]\.)' THEN -- skip this upgrade if last install/upgrade was made by RMB >= 29.4.x RETURN; END IF; FOR i IN SELECT * FROM pg_catalog.pg_indexes WHERE schemaname = 'diku_mod_kb_ebsco_java' LOOP newindexdef := regexp_replace(i.indexdef, -- \m = beginning of a word, \M = end of a word '\mpublic\.(f_unaccent|concat_space_sql|concat_array_object_values|concat_array_object)\M', 'diku_mod_kb_ebsco_java.\1', 'g'); IF newindexdef <> i.indexdef THEN EXECUTE 'DROP INDEX ' || i.indexname; EXECUTE newindexdef; EXECUTE 'INSERT INTO rmb_internal_analyze VALUES ($1)' USING i.tablename; END IF; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} DO $$ DECLARE t TEXT; BEGIN FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze LOOP EXECUTE 'ANALYZE ' || t; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed DO $$ DECLARE t TEXT; BEGIN FOR t IN SELECT DISTINCT tablename FROM rmb_internal_analyze LOOP EXECUTE 'ANALYZE ' || t; END LOOP; END $$; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} TRUNCATE rmb_internal_analyze; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed TRUNCATE rmb_internal_analyze; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java; 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java; 16:14:01 [] [] [] [] INFO PostgresClient trying to execute: {} UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '32.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.6.6-SNAPSHOT', 'schemaJson', $mainftl${ "tables": [ { "tableName": "tags", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-tags-table.sql" }, { "tableName": "packages", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-packages-table.sql" }, { "tableName": "providers", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-providers-table.sql" }, { "tableName": "resources", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-resources-table.sql" }, { "tableName": "titles", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-titles-table.sql" }, { "tableName": "access_types", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "access_types_mappings", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "holdings", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-table.sql" }, { "tableName": "holdings_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-table.sql" }, { "tableName": "holdings_status_audit", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-audit-table.sql" }, { "tableName": "retry_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-retry-status-table.sql" }, { "tableName": "transaction_ids", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-transaction-ids-table.sql" } ], "scripts": [ { "run": "after", "snippetPath": "update_started_date_before_insertion.sql", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1" }, { "run": "after", "snippetPath": "drop_set_id_in_jsonb.sql" }, { "run": "after", "snippetPath": "change_table_owner.sql" }, { "run": "after", "snippetPath": "change_function_owner.sql" } ] } $mainftl$); 16:14:01 [] [] [] [] INFO PostgresClient Successfully executed UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '32.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.6.6-SNAPSHOT', 'schemaJson', $mainftl${ "tables": [ { "tableName": "tags", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-tags-table.sql" }, { "tableName": "packages", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-packages-table.sql" }, { "tableName": "providers", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-providers-table.sql" }, { "tableName": "resources", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-resources-table.sql" }, { "tableName": "titles", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-titles-table.sql" }, { "tableName": "access_types", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "access_types_mappings", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false }, { "tableName": "holdings", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-table.sql" }, { "tableName": "holdings_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-table.sql" }, { "tableName": "holdings_status_audit", "fromModuleVersion": "mod-kb-ebsco-java-3.0.2", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-holdings-status-audit-table.sql" }, { "tableName": "retry_status", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-retry-status-table.sql" }, { "tableName": "transaction_ids", "fromModuleVersion": "mod-kb-ebsco-java-3.1.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "create-transaction-ids-table.sql" } ], "scripts": [ { "run": "after", "snippetPath": "update_started_date_before_insertion.sql", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1" }, { "run": "after", "snippetPath": "drop_set_id_in_jsonb.sql" }, { "run": "after", "snippetPath": "change_table_owner.sql" }, { "run": "after", "snippetPath": "change_function_owner.sql" } ] } $mainftl$); 16:14:01 [] [] [] [] INFO TenantApiImpl ************ Running schema updates ************ 16:14:01 [] [] [] [] INFO LiquibaseUtil Initializing schema diku_mod_kb_ebsco_java for tenant diku 16:14:01 [] [] [] [] INFO leConnectionProvider Attempting to get connection for diku 16:14:01 [] [] [] [] INFO PostgresClient DB config read from environment variables 16:14:01 [] [] [] [] INFO PostgresClient Using schema: diku 16:14:01 [] [] [] [] INFO PostgresClient postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"diku_mod_kb_ebsco_java","host":"10.0.2.15","database":"okapi_modules","password":"..."} 16:14:06 [] [] [] [] INFO Slf4jLogger SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 16:14:06 [] [] [] [] INFO Slf4jLogger SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 16:14:06 [] [] [] [] INFO Slf4jLogger SELECT LOCKED FROM diku_mod_kb_ebsco_java.databasechangeloglock WHERE ID=1 16:14:06 [] [] [] [] INFO Slf4jLogger Successfully acquired change log lock 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT MD5SUM FROM diku_mod_kb_ebsco_java.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangelog 16:14:11 [] [] [] [] INFO Slf4jLogger Reading from diku_mod_kb_ebsco_java.databasechangelog 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT * FROM diku_mod_kb_ebsco_java.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 16:14:11 [] [] [] [] INFO Slf4jLogger CREATE TABLE diku_mod_kb_ebsco_java.currencies (code VARCHAR(3) NOT NULL, description VARCHAR(100) NOT NULL, CONSTRAINT pk_currencies PRIMARY KEY (code)) 16:14:11 [] [] [] [] INFO Slf4jLogger Table currencies created 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml::MODKBEKBJ-492@@create-currencies-table::psmagin ran successfully in 16ms 16:14:11 [] [] [] [] INFO Slf4jLogger SELECT MAX(ORDEREXECUTED) FROM diku_mod_kb_ebsco_java.databasechangelog 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-492@@create-currencies-table', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml', NOW(), 108, '8:d07d5833264dd93c36c0abf4752cb3a3', 'createTable tableName=currencies', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.currencies(code, description) VALUES(?, ?) 16:14:11 [] [] [] [] INFO Slf4jLogger Executing JDBC DML batch was successful. 178 operations were executed, 1 individual UPDATE events were confirmed by the database. 16:14:11 [] [] [] [] INFO Slf4jLogger Data loaded from data/currencies.csv into currencies 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml::MODKBEKBJ-492@@populate-currencies::psmagin ran successfully in 42ms 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-492@@populate-currencies', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-currencies-table.xml', NOW(), 109, '8:0b3fb77ac6c89b6da7e5e7e69c2bfa4f', 'loadData tableName=currencies', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:11 [] [] [] [] INFO Slf4jLogger CREATE TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings (id UUID NOT NULL, kb_credentials_id UUID NOT NULL, customer_key VARCHAR(100) NOT NULL, start_month VARCHAR(3) NOT NULL, currency VARCHAR(3) NOT NULL, platform_type VARCHAR(12) NOT NULL, created_date TIMESTAMP WITH TIME ZONE DEFAULT NOW() NOT NULL, created_by_user_id UUID NOT NULL, created_by_user_name VARCHAR(100) NOT NULL, updated_date TIMESTAMP WITH TIME ZONE, updated_by_user_id UUID, updated_by_user_name VARCHAR(100), CONSTRAINT pk_usage_consolidation_settings PRIMARY KEY (id), UNIQUE (kb_credentials_id)) 16:14:11 [] [] [] [] INFO Slf4jLogger Table usage_consolidation_settings created 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@create-usage-consolidation-settings-table::psmagin ran successfully in 30ms 16:14:11 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@create-usage-consolidation-settings-table', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 110, '8:abef055da8796b1a70602f2cc846a511', 'createTable tableName=usage_consolidation_settings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:11 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT fk_usage_consolidation_settings_kb_credentials FOREIGN KEY (kb_credentials_id) REFERENCES diku_mod_kb_ebsco_java.kb_credentials (id) ON UPDATE RESTRICT ON DELETE CASCADE 16:14:11 [] [] [] [] INFO Slf4jLogger Foreign key constraint added to usage_consolidation_settings (kb_credentials_id) 16:14:11 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-kb-credentials::psmagin ran successfully in 24ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-kb-credentials', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 111, '8:e0603675a51fd552e987b5e7f57dc97b', 'addForeignKeyConstraint baseTableName=usage_consolidation_settings, constraintName=fk_usage_consolidation_settings_kb_credentials, referencedTableName=kb_credentials', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT fk_usage_consolidation_settings_currency FOREIGN KEY (currency) REFERENCES diku_mod_kb_ebsco_java.currencies (code) ON UPDATE RESTRICT ON DELETE RESTRICT 16:14:12 [] [] [] [] INFO Slf4jLogger Foreign key constraint added to usage_consolidation_settings (currency) 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-currencies::psmagin ran successfully in 11ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-foreign-key-from-usage-consolidation-settings-to-currencies', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 112, '8:f9c3ee3962bad187f3f35aceb3240f43', 'addForeignKeyConstraint baseTableName=usage_consolidation_settings, constraintName=fk_usage_consolidation_settings_currency, referencedTableName=currencies', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT chk_usage_consolidation_settings_start_month CHECK (start_month IN ('jan', 'feb', 'mar', 'apr', 'may', 'jun', 'jul', 'aug', 'sep', 'oct', 'nov', 'dec')) 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-start-month::psmagin ran successfully in 12ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-start-month', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 113, '8:adf0a74361b9bab3bf87202578a5679e', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.usage_consolidation_settings ADD CONSTRAINT chk_usage_consolidation_settings_platform_type CHECK (platform_type IN ('all', 'publisher', 'nonPublisher')) 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml::MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-platform-type::psmagin ran successfully in 9ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-494@@add-check-for-usage-consolidation-settings-platform-type', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-settings-table.xml', NOW(), 114, '8:4a08621e61f9abfae480f0b5c83d2a58', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger DROP VIEW diku_mod_kb_ebsco_java.access_types_view 16:14:12 [] [] [] [] INFO Slf4jLogger View access_types_view dropped 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE VIEW diku_mod_kb_ebsco_java.access_types_view AS SELECT a.id AS id, a.credentials_id AS credentials_id, a.name AS name, a.description AS description, a.created_date AS created_date, a.created_by_user_id AS created_by_user_id, u1.user_name AS created_by_user_name, u1.last_name AS created_by_last_name, u1.first_name AS created_by_first_name, u1.middle_name AS created_by_middle_name, a.updated_date AS updated_date, a.updated_by_user_id AS updated_by_user_id, u2.user_name AS updated_by_user_name, u2.last_name AS updated_by_last_name, u2.first_name AS updated_by_first_name, u2.middle_name AS updated_by_middle_name, am.usage_number AS usage_number FROM access_types a LEFT JOIN kb_users u1 ON a.created_by_user_id = u1.id LEFT JOIN kb_users u2 ON a.updated_by_user_id = u2.id LEFT JOIN (SELECT access_type_id, COUNT(access_type_id) AS usage_number FROM access_types_mappings GROUP BY access_type_id) as am ON a.id = am.access_type_id ORDER BY a.created_date ASC 16:14:12 [] [] [] [] INFO Slf4jLogger View access_types_view created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/update-access-types-view-user-name-column.xml::MODKBEKBJ-435@@update-access-types-view-user-name-column-name::psmagin ran successfully in 54ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-435@@update-access-types-view-user-name-column-name', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/update-access-types-view-user-name-column.xml', NOW(), 115, '8:ffbb125f81df98ea2dd89dfa29a1982a', 'dropView viewName=access_types_view; createView viewName=access_types_view', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE TABLE diku_mod_kb_ebsco_java.usage_consolidation_credentials (client_id VARCHAR(100) NOT NULL, client_secret VARCHAR(100) NOT NULL) 16:14:12 [] [] [] [] INFO Slf4jLogger Table usage_consolidation_credentials created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml::MODKBEKBJ-496@@create-usage-consolidation-settings-table::psmagin ran successfully in 15ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-496@@create-usage-consolidation-settings-table', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml', NOW(), 116, '8:8368f0ab610997f131ab2aee7ab03928', 'createTable tableName=usage_consolidation_credentials', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.check_single_uc_credentials() RETURNS TRIGGER AS $$ BEGIN IF (TG_OP = 'INSERT') THEN IF ((SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.usage_consolidation_credentials) = 1) THEN RAISE EXCEPTION 'Only one credentials can exist'; END IF; END IF; RETURN NEW; END; $$ LANGUAGE plpgsql 16:14:12 [] [] [] [] INFO Slf4jLogger Stored procedure created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml::MODKBEKBJ-496@@create-check-only-single-uc-credentials-trigger::psmagin ran successfully in 9ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-496@@create-check-only-single-uc-credentials-trigger', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml', NOW(), 117, '8:8e122110355d8042023705652c522266', 'createProcedure', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE TRIGGER check_single_uc_credentials_trigger BEFORE INSERT ON diku_mod_kb_ebsco_java.usage_consolidation_credentials FOR EACH ROW EXECUTE PROCEDURE diku_mod_kb_ebsco_java.check_single_uc_credentials() 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml::MODKBEKBJ-496@@enable-check-only-single-uc-credentials-trigger::psmagin ran successfully in 5ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-496@@enable-check-only-single-uc-credentials-trigger', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-usage-consolidation-credentials-table.xml', NOW(), 118, '8:a18bf4c70509885eaa06fee5fb279e20', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE INDEX holdings_package_id_idx ON diku_mod_kb_ebsco_java.holdings(package_id) 16:14:12 [] [] [] [] INFO Slf4jLogger Index holdings_package_id_idx created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/create-holdings-package-id-index.xml::MODKBEKBJ-487@@create-holdings-package-id-index::psmagin ran successfully in 10ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-487@@create-holdings-package-id-index', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/create-holdings-package-id-index.xml', NOW(), 119, '8:fcde0f6157fbf42e9c96f5412a0a3b6b', 'createIndex indexName=holdings_package_id_idx, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.holdings ALTER COLUMN package_id TYPE INTEGER USING (package_id::INTEGER) 16:14:12 [] [] [] [] INFO Slf4jLogger holdings.package_id datatype was changed to integer 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml::MODKBEKBJ-527@@change-holdings-package-id-type-to-integer::psmagin ran successfully in 23ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-527@@change-holdings-package-id-type-to-integer', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml', NOW(), 120, '8:9cb44ff347bec1da696b8204a671b351', 'modifyDataType columnName=package_id, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.holdings ALTER COLUMN title_id TYPE INTEGER USING (title_id::INTEGER) 16:14:12 [] [] [] [] INFO Slf4jLogger holdings.title_id datatype was changed to integer 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml::MODKBEKBJ-527@@change-holdings-title-id-type-to-integer::psmagin ran successfully in 15ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-527@@change-holdings-title-id-type-to-integer', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml', NOW(), 121, '8:7af885ebebe54e9801bdfb40c22bfcee', 'modifyDataType columnName=title_id, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger ALTER TABLE diku_mod_kb_ebsco_java.holdings ALTER COLUMN vendor_id TYPE INTEGER USING (vendor_id::INTEGER) 16:14:12 [] [] [] [] INFO Slf4jLogger holdings.vendor_id datatype was changed to integer 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml::MODKBEKBJ-527@@change-holdings-vendor-id-type-to-integer::psmagin ran successfully in 19ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-527@@change-holdings-vendor-id-type-to-integer', 'psmagin', 'liquibase/tenant/scripts/v3.6.0/alter-holdings-types.xml', NOW(), 122, '8:f9fa21da0b115cda9246dfda63a5cfbe', 'modifyDataType columnName=vendor_id, tableName=holdings', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger CREATE OR REPLACE FUNCTION diku_mod_kb_ebsco_java.get_single_credentials_id() RETURNS uuid AS $$ DECLARE rowCount int; BEGIN rowCount = (SELECT count(*) FROM diku_mod_kb_ebsco_java.kb_credentials); IF rowCount = 1 THEN RETURN (SELECT id FROM diku_mod_kb_ebsco_java.kb_credentials); ELSE RAISE EXCEPTION 'Single credentials record expected but % found', rowCount; END IF; END; $$ LANGUAGE 'plpgsql' 16:14:12 [] [] [] [] INFO Slf4jLogger Stored procedure created 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@create-get-single-credentials-id-function::psmagin ran successfully in 6ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@create-get-single-credentials-id-function', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 123, '8:aab923f2ba1b92e8e3c8535c5de23ebc', 'createProcedure', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger SELECT count(*) FROM diku_mod_kb_ebsco_java.holdings_status WHERE credentials_id = (SELECT diku_mod_kb_ebsco_java.get_single_credentials_id()) 16:14:12 [] [] [] [] INFO Slf4jLogger Marking ChangeSet: liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@save-status-not-started-for-dummy-credentials::psmagin ran despite precondition failure due to onFail='MARK_RAN': liquibase/tenant/changelog.xml : SQL Precondition failed. Expected '0' got '1' 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@save-status-not-started-for-dummy-credentials', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 124, '8:1e3d35c03dc310a4b9f6d8c487381114', 'sql', '', 'MARK_RAN', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger SELECT count(*) FROM diku_mod_kb_ebsco_java.retry_status WHERE credentials_id = (SELECT diku_mod_kb_ebsco_java.get_single_credentials_id()) 16:14:12 [] [] [] [] INFO Slf4jLogger Marking ChangeSet: liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@save-retry-status-for-dummy-credentials::psmagin ran despite precondition failure due to onFail='MARK_RAN': liquibase/tenant/changelog.xml : SQL Precondition failed. Expected '0' got '1' 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@save-retry-status-for-dummy-credentials', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 125, '8:6c0bc3f0b145670dc86ed7a27b4deccb', 'sql', '', 'MARK_RAN', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.get_single_credentials_id() 16:14:12 [] [] [] [] INFO Slf4jLogger Custom SQL executed 16:14:12 [] [] [] [] INFO Slf4jLogger ChangeSet liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml::MODKBEKBJ-556@@drop-get-single-credentials-id-function::psmagin ran successfully in 5ms 16:14:12 [] [] [] [] INFO Slf4jLogger INSERT INTO diku_mod_kb_ebsco_java.databasechangelog (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('MODKBEKBJ-556@@drop-get-single-credentials-id-function', 'psmagin', 'liquibase/tenant/scripts/v3.6.6/populate-holdings-and-retry-status.xml', NOW(), 126, '8:9dc519722530b02d87b55472fded5d79', 'sql', '', 'EXECUTED', NULL, NULL, '3.8.9', '5306451517') 16:14:12 [] [] [] [] INFO Slf4jLogger Successfully released change log lock 16:14:12 [] [] [] [] INFO LiquibaseUtil Schema is initialized for tenant diku 16:14:12 [] [] [] [] INFO TenantApiImpl Schema updated for tenant: diku 16:14:12 [] [] [] [] INFO PostgresClient Executing multiple statements with id 1986706864 16:14:12 [] [] [] [] INFO TenantApiImpl Received flag to initialize test data. Check the server log for details. 16:14:12 [] [] [] [] INFO TenantApiImpl ************ Creating test data ************ 16:14:12 [] [] [] [] INFO PostgresClient trying to execute: {} INSERT INTO diku_mod_kb_ebsco_java.tags (id, record_id, record_type, tag) VALUES ('9c1e6f3c-682d-4af4-bd6b-20dad912ff94', '53-2767121-90099', 'resource', 'EBSCO'), ('103d6152-ce59-4793-b079-f2d216af7792', '53-2767121', 'package', 'folio'), ('ed0fdcac-1292-4354-adc2-7b80b58638e3', '413-1988660', 'package', 'spitfire'), ('52687cb3-ecd6-4570-a2e2-3e212f26bef8', '36-2728041', 'package', 'EBSCO') ON CONFLICT DO NOTHING; 16:14:12 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:12 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 289 22 tid=diku OK 16:14:12 [] [] [] [] INFO PostgresClient Successfully executed INSERT INTO diku_mod_kb_ebsco_java.tags (id, record_id, record_type, tag) VALUES ('9c1e6f3c-682d-4af4-bd6b-20dad912ff94', '53-2767121-90099', 'resource', 'EBSCO'), ('103d6152-ce59-4793-b079-f2d216af7792', '53-2767121', 'package', 'folio'), ('ed0fdcac-1292-4354-adc2-7b80b58638e3', '413-1988660', 'package', 'spitfire'), ('52687cb3-ecd6-4570-a2e2-3e212f26bef8', '36-2728041', 'package', 'EBSCO') ON CONFLICT DO NOTHING; 16:14:12 [] [] [] [] INFO TenantAPI job ef487f94-ac43-490d-a174-6ee91cd58976 completed 16:14:12 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getTenantByOperationId 16:14:12 [] [] [] [] INFO LogUtil 10.0.2.15:55700 GET /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 200 288 10 tid=diku OK 16:14:12 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking deleteTenantByOperationId 16:14:12 [] [] [] [] INFO LogUtil 10.0.2.15:55700 DELETE /_/tenant/ef487f94-ac43-490d-a174-6ee91cd58976 null HTTP_1_1 204 0 24 tid=diku No Content 16:27:20 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1 WHERE id = (SELECT credentials_id FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE user_id = $1); with params = [{1 = UUID: 95af6e3b-321b-5267-94d5-29a46dc46fd0}] 16:27:20 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 16:27:20 [] [] [] [] INFO LogUtils Do count query = SELECT COUNT(*) as count FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE credentials_id = $1; with params = [{1 = UUID: de15fac0-efd7-4f43-b9e2-bc6abaaa6bb5}] 16:27:20 [] [] [] [] INFO oldingsRequestHelper constructurl - path=https://sandbox.ebsco.io/rm/rmaccounts/apidvgvmt/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename 16:27:20 [] [] [] [] INFO oldingsRequestHelper RMAPI Service GET absolute URL is: /rm/rmaccounts/apidvgvmt/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename 16:27:21 [] [] [] [] INFO oldingsRequestHelper [OK] RMAPI Service response: query = [/rm/rmaccounts/apidvgvmt/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename], method = [GET], statusCode = [200], body = [{"totalResults":10001,"packagesList":[{"packageId":3780332,"packageName":"","isCustom":false,"vendorId":0,"vendorName":"System Account","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"Unknown","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3780340,"packageName":"","isCustom":false,"vendorId":0,"vendorName":"System Account","titleCount":0,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"Unknown","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3781292,"packageName":"","isCustom":false,"vendorId":0,"vendorName":"System Account","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"Unknown","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3781293,"packageName":"","isCustom":false,"vendorId":0,"vendorName":"System Account","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"Unknown","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3781294,"packageName":"","isCustom":false,"vendorId":0,"vendorName":"System Account","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"Unknown","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3781295,"packageName":"","isCustom":false,"vendorId":0,"vendorName":"System Account","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"Unknown","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":22551,"packageName":"123Library eBooks","isCustom":false,"vendorId":58251,"vendorName":"123Library","titleCount":168637,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":168637,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"2018-03-12","endCoverage":"2018-04-13"},"packageType":"Variable"},{"packageId":2877665,"packageName":"1999-2015 AAP eBook Collection","isCustom":false,"vendorId":554,"vendorName":"American Academy of Pediatrics (AAP)","titleCount":164,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":164,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"2018-03-12","endCoverage":"2018-04-16"},"packageType":"Complete"},{"packageId":5154,"packageName":"19th Century Literature and Culture","isCustom":false,"vendorId":435,"vendorName":"University of Virginia Press","titleCount":7,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":7,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Variable"},{"packageId":1792,"packageName":"19th Century U.S. Newspapers","isCustom":false,"vendorId":18,"vendorName":"Gale | Cengage","titleCount":865,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3288891,"packageName":"1D Lab","isCustom":false,"vendorId":137226,"vendorName":"1D Lab","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"OnlineReference","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2848860,"packageName":"1Findr","isCustom":false,"vendorId":123517,"vendorName":"1science","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":19187,"packageName":"2014 Oxford Journals Collection (WALDO)","isCustom":false,"vendorId":63,"vendorName":"Oxford University Press","titleCount":259,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EJournal","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3660443,"packageName":"2014 Philosophy and Religion Collection Supplement","isCustom":false,"vendorId":62,"vendorName":"Project MUSE","titleCount":20,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":19239,"packageName":"2014 Royal Society of Chemistry Gold Collection (WALDO)","isCustom":false,"vendorId":40,"vendorName":"Royal Society of Chemistry","titleCount":44,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EJournal","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3660428,"packageName":"2015 Philosophy and Religion Collection Supplement","isCustom":false,"vendorId":62,"vendorName":"Project MUSE","titleCount":41,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2877671,"packageName":"2016 AAP eBook Collection","isCustom":false,"vendorId":554,"vendorName":"American Academy of Pediatrics (AAP)","titleCount":21,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3660367,"packageName":"2016 Philosophy and Religion Collection Supplement","isCustom":false,"vendorId":62,"vendorName":"Project MUSE","titleCount":12,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2877690,"packageName":"2017 AAP eBook Collection","isCustom":false,"vendorId":554,"vendorName":"American Academy of Pediatrics (AAP)","titleCount":16,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2877714,"packageName":"2018 AAP eBook Collection","isCustom":false,"vendorId":554,"vendorName":"American Academy of Pediatrics (AAP)","titleCount":25,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3196528,"packageName":"2019 AAP eBook Collection","isCustom":false,"vendorId":554,"vendorName":"American Academy of Pediatrics (AAP)","titleCount":29,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3580423,"packageName":"2020 AAP eBook Collection","isCustom":false,"vendorId":554,"vendorName":"American Academy of Pediatrics (AAP)","titleCount":7,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":8145,"packageName":"20th Century Religious Thought","isCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","titleCount":3553,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":6497,"packageName":"20th-Century American Newspapers, Series 1","isCustom":false,"vendorId":72,"vendorName":"NewsBank","titleCount":3,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Variable"},{"packageId":6498,"packageName":"20th-Century American Newspapers, Series 2","isCustom":false,"vendorId":72,"vendorName":"NewsBank","titleCount":3,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Variable"}]}] 16:27:21 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getEholdingsPackages 16:27:22 [] [] [] [] INFO LogUtil 10.0.2.15:55896 GET /eholdings/packages null HTTP_1_1 200 20387 2407 tid=diku OK 16:28:04 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1 WHERE id = (SELECT credentials_id FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE user_id = $1); with params = [{1 = UUID: 95af6e3b-321b-5267-94d5-29a46dc46fd0}] 16:28:04 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 16:28:04 [] [] [] [] INFO LogUtils Do count query = SELECT COUNT(*) as count FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE credentials_id = $1; with params = [{1 = UUID: de15fac0-efd7-4f43-b9e2-bc6abaaa6bb5}] 16:28:04 [] [] [] [] INFO oldingsRequestHelper constructurl - path=https://sandbox.ebsco.io/rm/rmaccounts/apidvgvmt/packages?selection=all&contenttype=all&search=ABC-CLIO&offset=1&count=25&orderby=relevance 16:28:04 [] [] [] [] INFO oldingsRequestHelper RMAPI Service GET absolute URL is: /rm/rmaccounts/apidvgvmt/packages?selection=all&contenttype=all&search=ABC-CLIO&offset=1&count=25&orderby=relevance 16:28:05 [] [] [] [] INFO oldingsRequestHelper [OK] RMAPI Service response: query = [/rm/rmaccounts/apidvgvmt/packages?selection=all&contenttype=all&search=ABC-CLIO&offset=1&count=25&orderby=relevance], method = [GET], statusCode = [200], body = [{"totalResults":14,"packagesList":[{"packageId":3649436,"packageName":"ABC-CLIO Daily Life Through History","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"OnlineReference","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":4345,"packageName":"ABC-CLIO eBook Collection","isCustom":false,"vendorId":583,"vendorName":"ABC-CLIO","titleCount":9913,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":9913,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"2018-08-12","endCoverage":"2018-09-13"},"packageType":"Variable"},{"packageId":3649443,"packageName":"ABC-CLIO World History: Ancient and Medieval Eras","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"OnlineReference","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":3649465,"packageName":"ABC-CLIO World Religions","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":1,"isTokenNeeded":false,"contentType":"OnlineReference","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2356523,"packageName":"ABC-CLIO eBook Collection 2008 (TAEBC)","isCustom":false,"vendorId":583,"vendorName":"ABC-CLIO","titleCount":693,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2356522,"packageName":"ABC-CLIO eBook Collection 2009 (TAEBC)","isCustom":false,"vendorId":583,"vendorName":"ABC-CLIO","titleCount":1624,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2356521,"packageName":"ABC-CLIO eBook Collection 2010 (TAEBC)","isCustom":false,"vendorId":583,"vendorName":"ABC-CLIO","titleCount":359,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2356520,"packageName":"ABC-CLIO eBook Collection 2011 (TAEBC)","isCustom":false,"vendorId":583,"vendorName":"ABC-CLIO","titleCount":221,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2356519,"packageName":"ABC-CLIO eBook Collection 2012 (TAEBC)","isCustom":false,"vendorId":583,"vendorName":"ABC-CLIO","titleCount":302,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2356518,"packageName":"ABC-CLIO eBook Collection 2014 (TAEBC)","isCustom":false,"vendorId":583,"vendorName":"ABC-CLIO","titleCount":169,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"EBook","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":5302,"packageName":"Credo ABC-CLIO Collection","isCustom":false,"vendorId":203,"vendorName":"Credo Reference","titleCount":339,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Variable"},{"packageId":5316,"packageName":"Credo ABC-CLIO Contemporary World Issues","isCustom":false,"vendorId":203,"vendorName":"Credo Reference","titleCount":74,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Variable"},{"packageId":5317,"packageName":"Credo ABC-CLIO World Mythology Collection","isCustom":false,"vendorId":203,"vendorName":"Credo Reference","titleCount":10,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Variable"},{"packageId":7698,"packageName":"ABC Chemistry: Directory of Free Full-Text Journals in Chemistry","isCustom":false,"vendorId":1075,"vendorName":"ABC Chemistry","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"OnlineReference","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"}]}] 16:28:05 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getEholdingsPackages 16:28:05 [] [] [] [] INFO LogUtil 10.0.2.15:55896 GET /eholdings/packages q=ABC-CLIO HTTP_1_1 200 11546 1802 tid=diku OK 16:28:40 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1 WHERE id = (SELECT credentials_id FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE user_id = $1); with params = [{1 = UUID: 95af6e3b-321b-5267-94d5-29a46dc46fd0}] 16:28:40 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 16:28:40 [] [] [] [] INFO LogUtils Do count query = SELECT COUNT(*) as count FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE credentials_id = $1; with params = [{1 = UUID: de15fac0-efd7-4f43-b9e2-bc6abaaa6bb5}] 16:28:40 [] [] [] [] INFO oldingsRequestHelper constructurl - path=https://sandbox.ebsco.io/rm/rmaccounts/apidvgvmt/vendors/19/packages/1714911 16:28:40 [] [] [] [] INFO oldingsRequestHelper RMAPI Service GET absolute URL is: /rm/rmaccounts/apidvgvmt/vendors/19/packages/1714911 16:28:41 [] [] [] [] INFO oldingsRequestHelper [OK] RMAPI Service response: query = [/rm/rmaccounts/apidvgvmt/vendors/19/packages/1714911], method = [GET], statusCode = [200], body = [{"packageId":1714911,"packageName":"AMA Marketing Watch","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":79,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"proxy":{"id":"","inherited":true},"allowEbscoToAddTitles":false,"packageToken":null,"packageType":"Complete"}] 16:28:41 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types t1 WHERE credentials_id = $1 AND id IN (SELECT access_type_id FROM diku_mod_kb_ebsco_java.access_types_mappings t1 WHERE record_id = $2 AND record_type = $3) LIMIT 1; with params = [{1 = UUID: de15fac0-efd7-4f43-b9e2-bc6abaaa6bb5}, {2 = String: 19-1714911}, {3 = String: package}] 16:28:41 [] [] [] [] INFO LogUtils Do select query = SELECT id, record_id, record_type, tag FROM diku_mod_kb_ebsco_java.tags WHERE record_id=$1 AND record_type=$2 ORDER BY tag with params = [{1 = String: 19-1714911}, {2 = String: package}] 16:28:41 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getEholdingsPackagesByPackageId 16:28:41 [] [] [] [] INFO LogUtil 10.0.2.15:55896 GET /eholdings/packages/19-1714911 null HTTP_1_1 200 1039 920 tid=diku OK 16:31:19 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 16:31:19 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getEholdingsKbCredentials 16:31:19 [] [] [] [] INFO LogUtil 10.0.2.15:55946 GET /eholdings/kb-credentials null HTTP_1_1 200 569 173 tid=diku OK 16:31:56 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1 WHERE id = (SELECT credentials_id FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE user_id = $1); with params = [{1 = UUID: 95af6e3b-321b-5267-94d5-29a46dc46fd0}] 16:31:56 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 16:31:56 [] [] [] [] INFO LogUtils Do count query = SELECT COUNT(*) as count FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE credentials_id = $1; with params = [{1 = UUID: de15fac0-efd7-4f43-b9e2-bc6abaaa6bb5}] 16:31:57 [] [] [] [] INFO oldingsRequestHelper constructurl - path=https://sandbox.ebsco.io/rm/rmaccounts/apidvgvmt/ 16:31:57 [] [] [] [] INFO oldingsRequestHelper RMAPI Service GET absolute URL is: /rm/rmaccounts/apidvgvmt/ 16:31:57 [] [] [] [] INFO oldingsRequestHelper [OK] RMAPI Service response: query = [/rm/rmaccounts/apidvgvmt/], method = [GET], statusCode = [200], body = [{"proxy":{"id":""},"vendorId":"123356","ftfTokens":[{"key":"user.csa","token":"mohan"},{"key":"password.csa","token":"testing"}],"labels":[{"id":1,"displayLabel":"label 1","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"label 2","displayOnFullTextFinder":true,"displayOnPublicationFinder":true},{"id":3,"displayLabel":"label 3","displayOnFullTextFinder":false,"displayOnPublicationFinder":true},{"id":4,"displayLabel":"label 4","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"label 5","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 16:31:57 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getEholdingsStatus 16:31:57 [] [] [] [] INFO LogUtil 10.0.2.15:55946 GET /eholdings/status null HTTP_1_1 200 172 1079 tid=diku OK 16:32:26 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1 WHERE id = (SELECT credentials_id FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE user_id = $1); with params = [{1 = UUID: 95af6e3b-321b-5267-94d5-29a46dc46fd0}] 16:32:26 [] [] [] [] INFO LogUtils Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 16:32:26 [] [] [] [] INFO LogUtils Do count query = SELECT COUNT(*) as count FROM diku_mod_kb_ebsco_java.assigned_users t1 WHERE credentials_id = $1; with params = [{1 = UUID: de15fac0-efd7-4f43-b9e2-bc6abaaa6bb5}] 16:32:26 [] [] [] [] INFO oldingsRequestHelper constructurl - path=https://sandbox.ebsco.io/rm/rmaccounts/apidvgvmt/titles?searchfield=titlename&selection=all&resourcetype=all&searchtype=contains&search=american&offset=1&count=25&orderby=relevance 16:32:26 [] [] [] [] INFO oldingsRequestHelper RMAPI Service GET absolute URL is: /rm/rmaccounts/apidvgvmt/titles?searchfield=titlename&selection=all&resourcetype=all&searchtype=contains&search=american&offset=1&count=25&orderby=relevance 16:32:27 [] [] [] [] INFO oldingsRequestHelper [OK] RMAPI Service response: query = [/rm/rmaccounts/apidvgvmt/titles?searchfield=titlename&selection=all&resourcetype=all&searchtype=contains&search=american&offset=1&count=25&orderby=relevance], method = [GET], statusCode = [200], body = [{"totalResults":10000,"titles":[{"titleId":91985,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[{"type":"Library of Congress","name":"Newspapers","subject":"Newspapers"},{"type":"Medical","name":"Newspapers","subject":"Newspapers"},{"type":"Library of Congress","name":"General Works","subject":"General Works"},{"type":"Medical","name":"Communications and Journalism","subject":"Communications and Journalism"}],"isTitleCustom":false,"pubType":"Newspaper","contributorsList":[],"customerResourcesList":[{"titleId":91985,"packageId":1393,"packageName":"America's Historical Newspapers: Early American Newspapers, Series I, 1690-1876","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":3233307,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1819-03-03","endCoverage":"1820-12-30"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/10D35048E774E038/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":91985,"packageId":2229,"packageName":"America's Historical Newspapers: Early American Newspapers, Series IV, 1756-1922","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":27275956,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1799-05-18","endCoverage":"1802-03-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/11AA2867CF47C228/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":91985,"packageId":2288,"packageName":"America's Historical Newspapers: Early American Newspapers, Series VI, 1741-1922","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":4846783,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1821-01-02","endCoverage":"1834-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/10D35048E774E038/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":91985,"packageId":1156921,"packageName":"America's Historical Newspapers: Early American Newspapers (DFG Nationallizenz)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":9522175,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1819-01-01","endCoverage":"1820-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/10D35048E774E038/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":91985,"packageId":2549568,"packageName":"America's Historical Newspapers: Early American Newspapers, Single Title","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":19086568,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1819-03-03","endCoverage":"1834-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/10D35048E774E038/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":91985,"packageId":3293927,"packageName":"Early American Newspapers, 19th Century","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":29811136,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1819-03-03","endCoverage":"1834-10-02"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/10D35048E774E038/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":91985,"packageId":3473179,"packageName":"Early American Newspapers, Student Edition (EANA1-5)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":31766868,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1819-03-03","endCoverage":"1820-12-30"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-K12&s_browseRef=decades/10D35048E774E038/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":95329,"titleName":"American Laboratory","alternateTitles":["American laboratory","American laboratory news edition","Am Lab","American Laboratory"],"publisherName":"Royal Society of Chemistry","identifiersList":[{"id":"0044-7749","source":"Print ISSN","subtype":1,"type":0},{"id":"01051418","source":"TSDID","subtype":0,"type":2},{"id":"R3X","source":"MID","subtype":0,"type":8},{"id":"410213-7","source":"ZDB-ID","subtype":0,"type":6}],"subjectsList":[{"type":"Library of Congress","name":"General","subject":"General"},{"type":"Medical","name":"Laboratory Techniques and Procedures ","subject":"Laboratory Techniques and Procedures "},{"type":"TLI","name":"Analytical Chemistry","subject":"Analytical Chemistry"},{"type":"Library of Congress","name":"Science (General)","subject":"Science (General)"},{"type":"Medical","name":"Medicine and Health Sciences","subject":"Medicine and Health Sciences"},{"type":"Library of Congress","name":"Science","subject":"Science"}],"isTitleCustom":false,"pubType":"Journal","contributorsList":[],"customerResourcesList":[{"titleId":95329,"packageId":0,"packageName":"Publisher's Site","packageType":"Selectable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":0,"vendorName":"System Account","locationId":12040898,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2013-11-01","endCoverage":"9999-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.americanlaboratory.com/1413-Issues/","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":328,"packageName":"Biomedical Reference Collection: Corporate","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6256410,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2012-01-01","endCoverage":"2019-04-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=cxh&jid=R3X&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":554,"packageName":"IngentaConnect","packageType":"Selectable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":17,"vendorName":"Ingenta","locationId":12189548,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1992-01-01","endCoverage":"2009-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.ingentaconnect.com/content/rsoc/00447749","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":3627,"packageName":"Food Science Source","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":5222012,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2012-01-01","endCoverage":"2019-04-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=fsr&jid=R3X&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":7314,"packageName":"CINAHL Complete","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":5708730,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2012-01-01","endCoverage":"2019-04-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=ccm&jid=R3X&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":2477771,"packageName":"CAPES FSTA Full Text Collection","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":17620825,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2012-01-01","endCoverage":"2019-04-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=fst&jid=R3X&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":2561032,"packageName":"Editorial Quality Standards Audits","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":19368939,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2012-01-01","endCoverage":"9999-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=ieq&jid=R3X&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":2593134,"packageName":"외국학술지지원센터(FRIC) – 무료문헌복사(KERIS)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":123205,"vendorName":"Korea Education Research Information Service (KERIS)","locationId":19728652,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2010-01-01","endCoverage":"2019-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.riss.kr/link?id=S407270","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":3123015,"packageName":"ProQuest Technology Collection (DRAA)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":22,"vendorName":"Proquest Info & Learning Co","locationId":26757935,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2009-01-01","endCoverage":"2009-01-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://search.proquest.com/publication/105576","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":95329,"packageId":3134395,"packageName":"ProQuest Material Science & Engineering Database (DRAA)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":22,"vendorName":"Proquest Info & Learning Co","locationId":27237420,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2009-01-01","endCoverage":"2009-01-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://search.proquest.com/publication/105576","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":898361,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[{"type":"Library of Congress","name":"Newspapers","subject":"Newspapers"},{"type":"Medical","name":"Newspapers","subject":"Newspapers"},{"type":"TLI","name":"News","subject":"News"},{"type":"Library of Congress","name":"General Works","subject":"General Works"},{"type":"Medical","name":"Communications and Journalism","subject":"Communications and Journalism"}],"isTitleCustom":false,"pubType":"Newspaper","contributorsList":[],"customerResourcesList":[{"titleId":898361,"packageId":1394,"packageName":"America's Historical Newspapers: Early American Newspapers, Series II, 1758-1900","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":3233410,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-04-26","endCoverage":"1816-04-26"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/113431F5F3894490/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":898361,"packageId":10323,"packageName":"America's Historical Newspapers College Edition","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":6980489,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-04-26","endCoverage":"1816-04-26"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-CE&s_browseRef=decades/113431F5F3894490/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":898361,"packageId":1156921,"packageName":"America's Historical Newspapers: Early American Newspapers (DFG Nationallizenz)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":9523060,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-01-01","endCoverage":"1816-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/113431F5F3894490/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":898361,"packageId":1300183,"packageName":"America's Historical Newspapers: Early American Newspapers, Student Edition (Selected Titles)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":10771647,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-04-26","endCoverage":"1816-04-26"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-K12&s_browseRef=decades/113431F5F3894490/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":898361,"packageId":2549568,"packageName":"America's Historical Newspapers: Early American Newspapers, Single Title","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":19085869,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-04-26","endCoverage":"1816-04-26"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/113431F5F3894490/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":898361,"packageId":3293927,"packageName":"Early American Newspapers, 19th Century","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":29811123,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-04-26","endCoverage":"1816-04-26"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/113431F5F3894490/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":898361,"packageId":3473179,"packageName":"Early American Newspapers, Student Edition (EANA1-5)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":31766867,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-04-26","endCoverage":"1816-04-26"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-K12&s_browseRef=decades/113431F5F3894490/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":904551,"titleName":"American","alternateTitles":[],"publisherName":"Alexander Street Press","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[],"customerResourcesList":[{"titleId":904551,"packageId":3757,"packageName":"Alexander Street Drama","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","locationId":3259028,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2004-01-01","endCoverage":"2004-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.aspresolver.com/aspresolver.asp?LALI;1000634603","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":904551,"packageId":3119382,"packageName":"Drama Texts Collection","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","locationId":40904170,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.aspresolver.com/aspresolver.asp?DTCO;3608359","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":904700,"titleName":"AmeRican","alternateTitles":[],"publisherName":"Arte Público Press","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[],"customerResourcesList":[{"titleId":904700,"packageId":3757,"packageName":"Alexander Street Drama","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","locationId":3259177,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1985-01-01","endCoverage":"1985-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.aspresolver.com/aspresolver.asp?LALI;1000024316","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":904700,"packageId":3785,"packageName":"Latino Literature","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","locationId":4357849,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1985-01-01","endCoverage":"1985-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.aspresolver.com/aspresolver.asp?LAFI;1000024316","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":1054986,"titleName":"American","alternateTitles":[],"publisherName":"ICON Classics","identifiersList":[{"id":"978-1-4356-3652-1","source":"Online ISBN","subtype":2,"type":1},{"id":"221840","source":"EP Book ID","subtype":0,"type":7},{"id":"978-1-281-63371-2","source":"Online ISBN","subtype":2,"type":1},{"id":"2805195","source":"GOBI Title ID","subtype":0,"type":18}],"subjectsList":[{"type":"Library of Congress","name":"Individual authors","subject":"Individual authors"},{"type":"Medical","name":"Literature","subject":"Literature"},{"type":"TLI","name":"American Literature","subject":"American Literature"},{"type":"Library of Congress","name":"American literature","subject":"American literature"},{"type":"Medical","name":"Language and Literature","subject":"Language and Literature"},{"type":"Library of Congress","name":"Language and literature","subject":"Language and literature"}],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"James, Henry"},{"type":"Author","contributor":"Parker, Philip M."}],"customerResourcesList":[{"titleId":1054986,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":3704801,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=221840","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1054986,"packageId":1861142,"packageName":"MyiLibrary","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":58388,"vendorName":"Ingram Content Group, Inc.","locationId":7902856,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://lib.myilibrary.com?id=163371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1054986,"packageId":1714905,"packageName":"eBook Subscription Super Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":11840166,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e010xww&AN=221840","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1054986,"packageId":2691705,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Austria","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":22324475,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xat&AN=221840","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1054986,"packageId":3579444,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Turkey","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":34548182,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xtr&AN=221840","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":1059544,"titleName":"American","alternateTitles":[],"publisherName":"ICON Classics","identifiersList":[{"id":"978-1-4356-3543-2","source":"Online ISBN","subtype":2,"type":1},{"id":"221529","source":"EP Book ID","subtype":0,"type":7},{"id":"978-1-281-64017-8","source":"Online ISBN","subtype":2,"type":1},{"id":"2799978","source":"GOBI Title ID","subtype":0,"type":18}],"subjectsList":[{"type":"Library of Congress","name":"Individual authors","subject":"Individual authors"},{"type":"Medical","name":"Literature","subject":"Literature"},{"type":"TLI","name":"American Literature","subject":"American Literature"},{"type":"Library of Congress","name":"American literature","subject":"American literature"},{"type":"Medical","name":"Language and Literature","subject":"Language and Literature"},{"type":"Library of Congress","name":"Language and literature","subject":"Language and literature"}],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"James, Henry"},{"type":"Author","contributor":"Parker, Philip M."}],"customerResourcesList":[{"titleId":1059544,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":3709403,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=221529","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059544,"packageId":1861142,"packageName":"MyiLibrary","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":58388,"vendorName":"Ingram Content Group, Inc.","locationId":7902853,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://lib.myilibrary.com?id=164017","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059544,"packageId":1714905,"packageName":"eBook Subscription Super Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":11839863,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e010xww&AN=221529","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059544,"packageId":2691705,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Austria","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":22324160,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xat&AN=221529","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059544,"packageId":3579444,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Turkey","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":34547912,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xtr&AN=221529","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":1059617,"titleName":"American","alternateTitles":[],"publisherName":"ICON Classics","identifiersList":[{"id":"978-1-4356-3602-6","source":"Online ISBN","subtype":2,"type":1},{"id":"221684","source":"EP Book ID","subtype":0,"type":7},{"id":"978-1-281-56061-2","source":"Online ISBN","subtype":2,"type":1},{"id":"2803085","source":"GOBI Title ID","subtype":0,"type":18}],"subjectsList":[{"type":"Library of Congress","name":"Individual authors","subject":"Individual authors"},{"type":"Medical","name":"Literature","subject":"Literature"},{"type":"TLI","name":"American Literature","subject":"American Literature"},{"type":"Library of Congress","name":"American literature","subject":"American literature"},{"type":"Medical","name":"Language and Literature","subject":"Language and Literature"},{"type":"Library of Congress","name":"Language and literature","subject":"Language and literature"}],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"James, Henry"},{"type":"Author","contributor":"Parker, Philip M."}],"customerResourcesList":[{"titleId":1059617,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":3709476,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=221684","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059617,"packageId":1861142,"packageName":"MyiLibrary","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":58388,"vendorName":"Ingram Content Group, Inc.","locationId":7902855,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://lib.myilibrary.com?id=156061","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059617,"packageId":1714905,"packageName":"eBook Subscription Super Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":11839995,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e010xww&AN=221684","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059617,"packageId":2691705,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Austria","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":22324323,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xat&AN=221684","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1059617,"packageId":3579444,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Turkey","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":34547535,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xtr&AN=221684","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":1128271,"titleName":"American","alternateTitles":[],"publisherName":"Blackstone Audio","identifiersList":[{"id":"978-1-4417-7331-9","source":"Online ISBN","subtype":2,"type":1},{"id":"332607","source":"EP Book ID","subtype":0,"type":7}],"subjectsList":[{"type":"Library of Congress","name":"1961-2000","subject":"1961-2000"},{"type":"Medical","name":"Literature","subject":"Literature"},{"type":"TLI","name":"English Literature","subject":"English Literature"},{"type":"Library of Congress","name":"English literature","subject":"English literature"},{"type":"Medical","name":"Language and Literature","subject":"Language and Literature"},{"type":"Library of Congress","name":"Language and literature","subject":"Language and literature"}],"isTitleCustom":false,"pubType":"AudioBook","contributorsList":[{"type":"Author","contributor":"Martin Booth"}],"customerResourcesList":[{"titleId":1128271,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":3857498,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2010-01-01","endCoverage":"2010-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=332607","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1128271,"packageId":2809925,"packageName":"AudioBookCloud","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":118376,"vendorName":"TumbleBooks Inc.","locationId":24608158,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://preview.audiobookcloud.com/book.aspx?id=2242","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":1165289,"titleName":"Chinese Americans (American Immigrants)","alternateTitles":["Chinese Americans (9781600446115)"],"publisherName":"Rourke Publishing, LLC.","identifiersList":[{"id":"978-1-60044-611-5","source":"Print ISBN","subtype":1,"type":1},{"id":"978-1-60472-752-4","source":"Online ISBN","subtype":2,"type":1},{"id":"392370","source":"EP Book ID","subtype":0,"type":7},{"id":"978-1-283-97572-8","source":"Online ISBN","subtype":2,"type":1},{"id":"53HN","source":"MID","subtype":0,"type":8},{"id":"7235667","source":"GOBI Title ID","subtype":0,"type":18}],"subjectsList":[{"type":"Library of Congress","name":"Elements in the population","subject":"Elements in the population"},{"type":"Medical","name":"History of North and South America","subject":"History of North and South America"},{"type":"TLI","name":"United States History","subject":"United States History"},{"type":"Library of Congress","name":"United States","subject":"United States"},{"type":"Medical","name":"History","subject":"History"},{"type":"Library of Congress","name":"History: America","subject":"History: America"}],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"Anderson, Dale"}],"customerResourcesList":[{"titleId":1165289,"packageId":843,"packageName":"Book Collection: Nonfiction","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":1531073,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=ndh&jid=53HN&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":3636,"packageName":"Book Collection Nonfiction: Middle School Edition","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2009089,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=n8h&jid=53HN&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":3948,"packageName":"MainFile","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2311621,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=mfi&jid=53HN&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":3971875,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=392370","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":9621,"packageName":"eBook Public Library Collection (EBSCOhost) – Worldwide","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6836727,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e700xww&AN=392370","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":9622,"packageName":"eBook K-8 Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6515112,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e860xna&AN=392370","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":9626,"packageName":"eBook Public Library Collection (EBSCOhost) – North America","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6800165,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e700xna&AN=392370","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":1861142,"packageName":"MyiLibrary","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":58388,"vendorName":"Ingram Content Group, Inc.","locationId":8298254,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2007-01-01","endCoverage":"2007-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://lib.myilibrary.com?id=428822","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":1714905,"packageName":"eBook Subscription Super Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":11890851,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e010xww&AN=392370","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":33441501,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2007-01-01","endCoverage":"2007-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9781604727524&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":2691705,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Austria","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":22378420,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xat&AN=392370","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1165289,"packageId":3579444,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Turkey","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":34596936,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xtr&AN=392370","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":1166764,"titleName":"Indian Americans (American Immigrants)","alternateTitles":["Indian Americans"],"publisherName":"Rourke Publishing, LLC.","identifiersList":[{"id":"978-1-60044-612-2","source":"Print ISBN","subtype":1,"type":1},{"id":"978-1-60472-753-1","source":"Online ISBN","subtype":2,"type":1},{"id":"392371","source":"EP Book ID","subtype":0,"type":7},{"id":"53E2","source":"MID","subtype":0,"type":8},{"id":"978-1-283-97573-5","source":"Online ISBN","subtype":2,"type":1},{"id":"7250907","source":"GOBI Title ID","subtype":0,"type":18}],"subjectsList":[{"type":"Library of Congress","name":"Elements in the population","subject":"Elements in the population"},{"type":"Medical","name":"History of North and South America","subject":"History of North and South America"},{"type":"TLI","name":"United States History","subject":"United States History"},{"type":"Library of Congress","name":"United States","subject":"United States"},{"type":"Medical","name":"History","subject":"History"},{"type":"Library of Congress","name":"History: America","subject":"History: America"}],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"Doak, Robin S."}],"customerResourcesList":[{"titleId":1166764,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":3973350,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=392371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":9621,"packageName":"eBook Public Library Collection (EBSCOhost) – Worldwide","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6843394,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e700xww&AN=392371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":9622,"packageName":"eBook K-8 Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6515107,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e860xna&AN=392371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":9626,"packageName":"eBook Public Library Collection (EBSCOhost) – North America","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6808057,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e700xna&AN=392371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":1861142,"packageName":"MyiLibrary","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":58388,"vendorName":"Ingram Content Group, Inc.","locationId":8279229,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2007-01-01","endCoverage":"2007-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://lib.myilibrary.com?id=428823","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":1714905,"packageName":"eBook Subscription Super Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":11890854,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e010xww&AN=392371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":36158957,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2007-01-01","endCoverage":"2007-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9781604727531&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":2691705,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Austria","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":22378407,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xat&AN=392371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166764,"packageId":3579444,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Turkey","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":34596923,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xtr&AN=392371","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":1166997,"titleName":"Korean Americans (American Immigrants)","alternateTitles":["Korean Americans (9781600446139)"],"publisherName":"Rourke Publishing, LLC.","identifiersList":[{"id":"978-1-60044-613-9","source":"Print ISBN","subtype":1,"type":1},{"id":"978-1-60472-754-8","source":"Online ISBN","subtype":2,"type":1},{"id":"392374","source":"EP Book ID","subtype":0,"type":7},{"id":"978-1-283-97574-2","source":"Online ISBN","subtype":2,"type":1},{"id":"53HO","source":"MID","subtype":0,"type":8},{"id":"7250908","source":"GOBI Title ID","subtype":0,"type":18}],"subjectsList":[{"type":"Library of Congress","name":"Elements in the population","subject":"Elements in the population"},{"type":"Medical","name":"History of North and South America","subject":"History of North and South America"},{"type":"TLI","name":"United States History","subject":"United States History"},{"type":"Library of Congress","name":"United States","subject":"United States"},{"type":"Medical","name":"History","subject":"History"},{"type":"Library of Congress","name":"History: America","subject":"History: America"}],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"Anderson, Dale"}],"customerResourcesList":[{"titleId":1166997,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":3973583,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=392374","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":9621,"packageName":"eBook Public Library Collection (EBSCOhost) – Worldwide","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6844526,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e700xww&AN=392374","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":9622,"packageName":"eBook K-8 Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6515130,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e860xna&AN=392374","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":9626,"packageName":"eBook Public Library Collection (EBSCOhost) – North America","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":6809375,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e700xna&AN=392374","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":1861142,"packageName":"MyiLibrary","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":58388,"vendorName":"Ingram Content Group, Inc.","locationId":8301476,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2007-01-01","endCoverage":"2007-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://lib.myilibrary.com?id=428824","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":1714905,"packageName":"eBook Subscription Super Collection (EBSCOhost)","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":11890843,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e010xww&AN=392374","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":33441524,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2007-01-01","endCoverage":"2007-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9781604727548&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":2691705,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Austria","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":22378412,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xat&AN=392374","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":1166997,"packageId":3579444,"packageName":"eBook Subscription Super Collection (EBSCOhost) - Turkey","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":34596906,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2008-01-01","endCoverage":"2008-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=e000xtr&AN=392374","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":7490529,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[],"customerResourcesList":[{"titleId":7490529,"packageId":6575,"packageName":"Music Online: Classical Scores Library, Volume 2","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","locationId":8911759,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1986-01-01","endCoverage":"1986-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.aspresolver.com/aspresolver.asp?SHM2;2244729","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":10311182,"titleName":"American","alternateTitles":[],"publisherName":"Alexander Street Press","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[],"customerResourcesList":[{"titleId":10311182,"packageId":3785,"packageName":"Latino Literature","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","locationId":14121842,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2004-01-01","endCoverage":"2004-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.aspresolver.com/aspresolver.asp?LADR;PL008082","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":18746216,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Newspaper","contributorsList":[],"customerResourcesList":[{"titleId":18746216,"packageId":3821,"packageName":"African American Newspapers (NewsBank)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":26765112,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1898-04-23","endCoverage":"1899-04-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/12B7C30EE42F4288/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":19326168,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[{"type":"Library of Congress","name":"Newspapers","subject":"Newspapers"},{"type":"Medical","name":"Newspapers","subject":"Newspapers"},{"type":"TLI","name":"News","subject":"News"},{"type":"Library of Congress","name":"General Works","subject":"General Works"},{"type":"Medical","name":"Communications and Journalism","subject":"Communications and Journalism"}],"isTitleCustom":false,"pubType":"Newspaper","contributorsList":[],"customerResourcesList":[{"titleId":19326168,"packageId":1300183,"packageName":"America's Historical Newspapers: Early American Newspapers, Student Edition (Selected Titles)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":28872949,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1799-05-18","endCoverage":"1802-03-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-K12&s_browseRef=decades/11AA2867CF47C228/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":19326168,"packageId":2549568,"packageName":"America's Historical Newspapers: Early American Newspapers, Single Title","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":27745417,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1799-05-18","endCoverage":"1801-12-15"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/11AA2867CF47C228/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":19326168,"packageId":3473179,"packageName":"Early American Newspapers, Student Edition (EANA1-5)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":31765846,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1799-05-18","endCoverage":"1802-03-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-K12&s_browseRef=decades/11AA2867CF47C228/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":19579360,"titleName":"American","alternateTitles":[],"publisherName":"Project Gutenberg","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"James, Henry"}],"customerResourcesList":[{"titleId":19579360,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":28153374,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9786410001776&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":23101962,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Journal","contributorsList":[],"customerResourcesList":[{"titleId":23101962,"packageId":3473179,"packageName":"Early American Newspapers, Student Edition (EANA1-5)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":31767086,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1816-02-07","endCoverage":"1817-04-02"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-K12&s_browseRef=decades/10C1C64AAF1C5550/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":23101994,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Journal","contributorsList":[],"customerResourcesList":[{"titleId":23101994,"packageId":3473179,"packageName":"Early American Newspapers, Student Edition (EANA1-5)","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":31767119,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1808-10-21","endCoverage":"1809-10-17"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX-K12&s_browseRef=decades/10CF526E8B71BBB8/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":23452890,"titleName":"American","alternateTitles":[],"publisherName":"Seltzer Books","identifiersList":[{"id":"978-1-4553-5299-9","source":"Online ISBN","subtype":2,"type":1},{"id":"2605235","source":"EP Book ID","subtype":0,"type":7}],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"Henry James"}],"customerResourcesList":[{"titleId":23452890,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":39417473,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2018-01-01","endCoverage":"2018-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2605235","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":23452890,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":32871191,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2018-01-01","endCoverage":"2018-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9781455352999&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":23639742,"titleName":"American","alternateTitles":[],"publisherName":"Dead Dodo Publishing","identifiersList":[{"id":"978-1-5080-2255-8","source":"Online ISBN","subtype":2,"type":1},{"id":"2608407","source":"EP Book ID","subtype":0,"type":7}],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"Henry James"}],"customerResourcesList":[{"titleId":23639742,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":39323828,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2015-01-01","endCoverage":"2015-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2608407","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":23639742,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":33405675,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2015-01-01","endCoverage":"2015-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9781508022558&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":23656049,"titleName":"American","alternateTitles":[],"publisherName":"Charles River Editors","identifiersList":[{"id":"978-1-61430-917-8","source":"Online ISBN","subtype":2,"type":1},{"id":"2617230","source":"EP Book ID","subtype":0,"type":7}],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"Henry James"}],"customerResourcesList":[{"titleId":23656049,"packageId":5207,"packageName":"EBSCO eBooks","packageType":"Selectable","proxy":{"id":"DE44374","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":39393464,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2018-01-01","endCoverage":"2018-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=2617230","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null},{"titleId":23656049,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":33434632,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2018-01-01","endCoverage":"2018-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9781614309178&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":25385850,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[{"type":"Library of Congress","name":"Newspapers","subject":"Newspapers"},{"type":"Library of Congress","name":"General Works","subject":"General Works"}],"isTitleCustom":false,"pubType":"Newspaper","contributorsList":[],"customerResourcesList":[{"titleId":25385850,"packageId":2549568,"packageName":"America's Historical Newspapers: Early American Newspapers, Single Title","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":72,"vendorName":"NewsBank","locationId":35399895,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"1821-01-02","endCoverage":"1834-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://infoweb.newsbank.com/?db=EANX&s_browseRef=decades/10D35048E774E038/all.xml","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":25806744,"titleName":"American","alternateTitles":[],"publisherName":"Unspecified","identifiersList":[],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[],"customerResourcesList":[{"titleId":25806744,"packageId":3679553,"packageName":"Latin American Drama","packageType":"Complete","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":413,"vendorName":"Alexander Street Press","locationId":36924987,"isSelected":false,"isTokenNeeded":false,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://www.aspresolver.com/aspresolver.asp?LDRA;3608359","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]},{"titleId":25816847,"titleName":"American","alternateTitles":[],"publisherName":"Saga Egmont International","identifiersList":[{"id":"978-91-7639-317-8","source":"Online ISBN","subtype":2,"type":1}],"subjectsList":[],"isTitleCustom":false,"pubType":"Book","contributorsList":[{"type":"Author","contributor":"Henry James, James"}],"customerResourcesList":[{"titleId":25816847,"packageId":2631932,"packageName":"VLeBooks","packageType":"Variable","proxy":{"id":"","inherited":true},"isPackageCustom":false,"vendorId":125531,"vendorName":"Askews & Holts","locationId":36935782,"isSelected":false,"isTokenNeeded":true,"visibilityData":{"isHidden":false,"reason":""},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"https://www.vlebooks.com/vleweb/product/openreader?id=[[vleid]]&isbn=9789176393178&uid=none","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null}]}]}] 16:32:27 [] [] [] [] INFO LogUtil org.folio.rest.RestVerticle start invoking getEholdingsTitles 16:32:27 [] [] [] [] INFO LogUtil 10.0.2.15:55946 GET /eholdings/titles filter[name]=american HTTP_1_1 200 19595 1890 tid=diku OK