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 WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance. starting rest verticle service.......... 29 Oct 2020 16:41:22:473 INFO Version [] HV000001: Hibernate Validator null 29 Oct 2020 16:41:23:199 INFO Messages [] Loading messages from /infra-messages/APIMessages_de.properties ................................ 29 Oct 2020 16:41:23:203 INFO Messages [] Loading messages from /infra-messages/APIMessages_en.properties ................................ 29 Oct 2020 16:41:23:235 INFO RestVerticle [] git: https://github.com/folio-org/raml-module-builder.git 1f82ec6b096e421278817f22637eda00e32c89f0 29 Oct 2020 16:41:23:278 INFO PomReader [] Reading from jar 29 Oct 2020 16:41:23:367 INFO PomReader [] module name: mod_kb_ebsco_java, version: 3.6.2 29 Oct 2020 16:41:23:444 INFO LogUtil [] org.folio.rest.RestVerticle start metrics enabled: false 29 Oct 2020 16:41:24:320 INFO RestVerticle [] ^/_/ramls 29 Oct 2020 16:41:24:378 INFO RestVerticle [] ^/eholdings/user-kb-credential 29 Oct 2020 16:41:24:379 INFO RestVerticle [] ^/eholdings/access-types 29 Oct 2020 16:41:24:379 INFO RestVerticle [] ^/eholdings/cache 29 Oct 2020 16:41:24:412 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/access-types 29 Oct 2020 16:41:24:413 INFO RestVerticle [] ^/eholdings/titles 29 Oct 2020 16:41:24:415 INFO RestVerticle [] ^/eholdings/custom-labels 29 Oct 2020 16:41:24:415 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/proxy-types 29 Oct 2020 16:41:24:417 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/root-proxy 29 Oct 2020 16:41:24:418 INFO RestVerticle [] ^/eholdings/packages 29 Oct 2020 16:41:24:418 INFO RestVerticle [] ^/eholdings/resources 29 Oct 2020 16:41:24:419 INFO RestVerticle [] ^/_/jsonSchemas 29 Oct 2020 16:41:24:419 INFO RestVerticle [] ^/eholdings/providers 29 Oct 2020 16:41:24:419 INFO RestVerticle [] ^/rmbtests 29 Oct 2020 16:41:24:422 INFO RestVerticle [] ^/admin 29 Oct 2020 16:41:24:423 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/users 29 Oct 2020 16:41:24:424 INFO RestVerticle [] ^/eholdings/status 29 Oct 2020 16:41:24:425 INFO RestVerticle [] ^/eholdings/kb-credentials 29 Oct 2020 16:41:24:426 INFO RestVerticle [] ^/eholdings/tags 29 Oct 2020 16:41:24:427 INFO RestVerticle [] ^/_/tenant 29 Oct 2020 16:41:24:428 INFO RestVerticle [] ^/eholdings/proxy-types 29 Oct 2020 16:41:24:429 INFO RestVerticle [] ^/eholdings/root-proxy 29 Oct 2020 16:41:24:431 INFO RestVerticle [] ^/eholdings/loading/kb-credentials 29 Oct 2020 16:41:24:445 INFO RestVerticle [] ^/eholdings/kb-credentials/{id}/custom-labels 29 Oct 2020 16:41:24:447 INFO RestVerticle [] ^configurations 29 Oct 2020 16:41:24:494 INFO RestVerticle [] 1 verticles deployed 29 Oct 2020 16:41:24:960 INFO LogUtil [] org.folio.rest.RestVerticle runHook One time hook called with implemented class named org.folio.rest.impl.InitAPIImpl 29 Oct 2020 16:41:26:949 INFO ConfigurationClassEnhancer$BeanMethodInterceptor [] @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. 29 Oct 2020 16:41:28:407 INFO RestVerticle [] init succeeded....... 29 Oct 2020 16:41:28:661 INFO LogUtil [] org.folio.rest.RestVerticle runPeriodicHook no periodic implementation found, continuing with deployment 29 Oct 2020 16:41:29:145 INFO LogUtil [] org.folio.rest.RestVerticle runPostDeployHook no Post Deploy Hook implementation found, continuing with deployment 29 Oct 2020 16:41:29:145 INFO LogUtil [] org.folio.rest.RestVerticle start http server for apis and docs started on port 8081. 29 Oct 2020 16:41:29:145 INFO LogUtil [] org.folio.rest.RestVerticle start Documentation available at: http://localhost:8081/apidocs/ 29 Oct 2020 16:41:29:150 INFO VertxIsolatedDeployer [] Succeeded in deploying verticle 29 Oct 2020 16:41:32:964 INFO TenantAPI [] sending... postTenant for diku 29 Oct 2020 16:41:32:967 INFO PostgresClient [] DB config read from environment variables 29 Oct 2020 16:41:33:004 INFO PostgresClient [] postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"folio_admin","host":"10.0.2.15","database":"okapi_modules","password":"..."} 29 Oct 2020 16:41:34:496 INFO PostgresClient [] Executing multiple statements with id -930780454 29 Oct 2020 16:41:34:632 INFO PostgresClient [] trying to execute: ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user" 29 Oct 2020 16:41:34:638 INFO PostgresClient [] Successfully executed: ALTER ROLE diku_mod_kb_ebsco_java SET search_path = "$user" 29 Oct 2020 16:41:34:640 INFO PostgresClient [] trying to execute: SET search_path TO diku_mod_kb_ebsco_java 29 Oct 2020 16:41:34:642 INFO PostgresClient [] Successfully executed: SET search_path TO diku_mod_kb_ebsco_java 29 Oct 2020 16:41:34:643 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 $$ 29 Oct 2020 16:41:34:659 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 $$ 29 Oct 2020 16:41:34:660 INFO PostgresClient [] trying to execute: CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public 29 Oct 2020 16:41:34:664 INFO PostgresClient [] Successfully executed: CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public 29 Oct 2020 16:41:34:665 INFO PostgresClient [] trying to execute: CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public 29 Oct 2020 16:41:34:669 INFO PostgresClient [] Successfully executed: CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public 29 Oct 2020 16:41:34:670 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 ) 29 Oct 2020 16:41:34:672 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 ) 29 Oct 2020 16:41:34:672 INFO PostgresClient [] trying to execute: UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE 29 Oct 2020 16:41:34:675 INFO PostgresClient [] Successfully executed: UPDATE diku_mod_kb_ebsco_java.rmb_internal_index SET remove = TRUE 29 Oct 2020 16:41:34:675 INFO PostgresClient [] trying to execute: CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ) 29 Oct 2020 16:41:34:676 INFO PostgresClient [] Successfully executed: CREATE TABLE IF NOT EXISTS rmb_internal_analyze ( tablename text ) 29 Oct 2020 16:41:34:677 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text) 29 Oct 2020 16:41:34:680 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.count_estimate_smart2(bigint,bigint,text) 29 Oct 2020 16:41:34:681 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 29 Oct 2020 16:41:34:685 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; 29 Oct 2020 16:41:34:686 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 29 Oct 2020 16:41:34:688 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 29 Oct 2020 16:41:34:689 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 29 Oct 2020 16:41:34:691 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 < 100 29 Oct 2020 16:41:34:692 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\u033 29 Oct 2020 16:41:34:695 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 STRIC 29 Oct 2020 16:41:34:696 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 29 Oct 2020 16:41:34:697 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 29 Oct 2020 16:41:34:698 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 29 Oct 2020 16:41:34:700 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, '&')) 29 Oct 2020 16:41:34:701 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 29 Oct 2020 16:41:34:704 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 29 Oct 2020 16:41:34:704 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 29 Oct 2020 16:41:34:706 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 29 Oct 2020 16:41:34:707 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 29 Oct 2020 16:41:34:709 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 ' ' 29 Oct 2020 16:41:34:709 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' 29 Oct 2020 16:41:34:711 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' 29 Oct 2020 16:41:34:712 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 29 Oct 2020 16:41:34:713 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 29 Oct 2020 16:41:34:714 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 29 Oct 2020 16:41:34:717 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 29 Oct 2020 16:41:34:719 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 29 Oct 2020 16:41:34:721 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 29 Oct 2020 16:41:34:721 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 29 Oct 2020 16:41:34:726 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 29 Oct 2020 16:41:34:727 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 29 Oct 2020 16:41:34:729 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 29 Oct 2020 16:41:34:729 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text) 29 Oct 2020 16:41:34:730 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS rmb_internal_index(aname text, tops text, newdef text) 29 Oct 2020 16:41:34:731 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 'DE 29 Oct 2020 16:41:34:734 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 EX 29 Oct 2020 16:41:34:735 INFO PostgresClient [] trying to execute: REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java 29 Oct 2020 16:41:34:738 INFO PostgresClient [] Successfully executed: REVOKE ALL PRIVILEGES ON SCHEMA public FROM diku_mod_kb_ebsco_java 29 Oct 2020 16:41:34:739 INFO PostgresClient [] trying to execute: REVOKE CREATE ON SCHEMA public FROM PUBLIC 29 Oct 2020 16:41:34:742 INFO PostgresClient [] Successfully executed: REVOKE CREATE ON SCHEMA public FROM PUBLIC 29 Oct 2020 16:41:34:743 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE 29 Oct 2020 16:41:34:745 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_tags_references ON diku_mod_kb_ebsco_java.tags CASCADE 29 Oct 2020 16:41:34:746 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references() 29 Oct 2020 16:41:34:748 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_tags_references() 29 Oct 2020 16:41:34:751 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE 29 Oct 2020 16:41:34:757 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_packages_references ON diku_mod_kb_ebsco_java.packages CASCADE 29 Oct 2020 16:41:34:758 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references() 29 Oct 2020 16:41:34:760 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_packages_references() 29 Oct 2020 16:41:34:763 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE 29 Oct 2020 16:41:34:765 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_providers_references ON diku_mod_kb_ebsco_java.providers CASCADE 29 Oct 2020 16:41:34:767 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references() 29 Oct 2020 16:41:34:768 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_providers_references() 29 Oct 2020 16:41:34:769 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE 29 Oct 2020 16:41:34:770 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_resources_references ON diku_mod_kb_ebsco_java.resources CASCADE 29 Oct 2020 16:41:34:771 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references() 29 Oct 2020 16:41:34:772 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_resources_references() 29 Oct 2020 16:41:34:772 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE 29 Oct 2020 16:41:34:774 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_titles_references ON diku_mod_kb_ebsco_java.titles CASCADE 29 Oct 2020 16:41:34:774 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references() 29 Oct 2020 16:41:34:776 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_titles_references() 29 Oct 2020 16:41:34:776 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE 29 Oct 2020 16:41:34:777 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_access_types_references ON diku_mod_kb_ebsco_java.access_types CASCADE 29 Oct 2020 16:41:34:780 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references() 29 Oct 2020 16:41:34:782 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_references() 29 Oct 2020 16:41:34:782 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE 29 Oct 2020 16:41:34:795 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_access_types_mappings_references ON diku_mod_kb_ebsco_java.access_types_mappings CASCADE 29 Oct 2020 16:41:34:795 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references() 29 Oct 2020 16:41:34:803 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_access_types_mappings_references() 29 Oct 2020 16:41:34:803 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE 29 Oct 2020 16:41:34:811 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_holdings_references ON diku_mod_kb_ebsco_java.holdings CASCADE 29 Oct 2020 16:41:34:812 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references() 29 Oct 2020 16:41:34:820 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_references() 29 Oct 2020 16:41:34:822 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE 29 Oct 2020 16:41:34:829 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_holdings_status_references ON diku_mod_kb_ebsco_java.holdings_status CASCADE 29 Oct 2020 16:41:34:831 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references() 29 Oct 2020 16:41:34:834 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_references() 29 Oct 2020 16:41:34:843 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE 29 Oct 2020 16:41:34:848 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_holdings_status_audit_references ON diku_mod_kb_ebsco_java.holdings_status_audit CASCADE 29 Oct 2020 16:41:34:851 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references() 29 Oct 2020 16:41:34:857 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_holdings_status_audit_references() 29 Oct 2020 16:41:34:858 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE 29 Oct 2020 16:41:34:859 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_retry_status_references ON diku_mod_kb_ebsco_java.retry_status CASCADE 29 Oct 2020 16:41:34:860 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references() 29 Oct 2020 16:41:34:863 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_retry_status_references() 29 Oct 2020 16:41:34:863 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE 29 Oct 2020 16:41:34:869 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS update_transaction_ids_references ON diku_mod_kb_ebsco_java.transaction_ids CASCADE 29 Oct 2020 16:41:34:872 INFO PostgresClient [] trying to execute: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references() 29 Oct 2020 16:41:34:874 INFO PostgresClient [] Successfully executed: DROP FUNCTION IF EXISTS diku_mod_kb_ebsco_java.update_transaction_ids_references() 29 Oct 2020 16:41:34:874 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE 29 Oct 2020 16:41:34:877 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON tags CASCADE 29 Oct 2020 16:41:34:877 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE 29 Oct 2020 16:41:34:878 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON packages CASCADE 29 Oct 2020 16:41:34:879 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE 29 Oct 2020 16:41:34:880 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON providers CASCADE 29 Oct 2020 16:41:34:882 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE 29 Oct 2020 16:41:34:890 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON resources CASCADE 29 Oct 2020 16:41:34:891 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE 29 Oct 2020 16:41:34:893 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON titles CASCADE 29 Oct 2020 16:41:34:893 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE 29 Oct 2020 16:41:34:897 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings CASCADE 29 Oct 2020 16:41:34:901 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE 29 Oct 2020 16:41:34:903 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON retry_status CASCADE 29 Oct 2020 16:41:34:903 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE 29 Oct 2020 16:41:34:904 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status CASCADE 29 Oct 2020 16:41:34:905 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE 29 Oct 2020 16:41:34:908 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON holdings_status_audit CASCADE 29 Oct 2020 16:41:34:908 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE 29 Oct 2020 16:41:34:914 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON transaction_ids CASCADE 29 Oct 2020 16:41:34:914 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE 29 Oct 2020 16:41:34:922 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types CASCADE 29 Oct 2020 16:41:34:923 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE 29 Oct 2020 16:41:34:925 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON access_types_mappings CASCADE 29 Oct 2020 16:41:34:926 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE 29 Oct 2020 16:41:34:927 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON kb_credentials CASCADE 29 Oct 2020 16:41:34:928 INFO PostgresClient [] trying to execute: DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE 29 Oct 2020 16:41:34:929 INFO PostgresClient [] Successfully executed: DROP TRIGGER IF EXISTS set_id_in_jsonb ON assigned_users CASCADE 29 Oct 2020 16:41:34:929 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 29 Oct 2020 16:41:34:930 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 29 Oct 2020 16:41:34:931 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 29 Oct 2020 16:41:34:935 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; 29 Oct 2020 16:41:34:936 INFO PostgresClient [] trying to execute: DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql 29 Oct 2020 16:41:34:960 INFO PostgresClient [] Successfully executed: DO $$ BEGIN EXECUTE change_owner_all(); END $$ language plpgsql 29 Oct 2020 16:41:34:962 INFO PostgresClient [] trying to execute: DROP FUNCTION change_owner_all 29 Oct 2020 16:41:34:963 INFO PostgresClient [] Successfully executed: DROP FUNCTION change_owner_all 29 Oct 2020 16:41:34:964 INFO PostgresClient [] trying to execute: DROP FUNCTION change_owner 29 Oct 2020 16:41:34:966 INFO PostgresClient [] Successfully executed: DROP FUNCTION change_owner 29 Oct 2020 16:41:34:970 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 29 Oct 2020 16:41:34:982 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_namespa 29 Oct 2020 16:41:34:982 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 $$ 29 Oct 2020 16:41:34:986 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 $$ 29 Oct 2020 16:41:34:987 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 $$ 29 Oct 2020 16:41:34:991 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' 29 Oct 2020 16:41:34:992 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 $$ 29 Oct 2020 16:41:35:004 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 $$ 29 Oct 2020 16:41:35:005 INFO PostgresClient [] trying to execute: TRUNCATE rmb_internal_analyze 29 Oct 2020 16:41:35:022 INFO PostgresClient [] Successfully executed: TRUNCATE rmb_internal_analyze 29 Oct 2020 16:41:35:022 INFO PostgresClient [] trying to execute: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java 29 Oct 2020 16:41:35:027 INFO PostgresClient [] Successfully executed: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA diku_mod_kb_ebsco_java TO diku_mod_kb_ebsco_java 29 Oct 2020 16:41:35:027 INFO PostgresClient [] trying to execute: UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '31.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.6.2-SNAPSHOT.1', '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, "w 29 Oct 2020 16:41:35:035 INFO PostgresClient [] Successfully executed: UPDATE diku_mod_kb_ebsco_java.rmb_internal SET jsonb = jsonb || jsonb_build_object( 'rmbVersion', '31.1.0', 'moduleVersion', 'mod-kb-ebsco-java-3.6.2-SNAPSHOT.1', 'schemaJson', $mainftl${ "tables": [ { "tableName": "tags", "fromModuleVersion": "mod-kb-ebsco-java-3.0.1", "withMetadata": false, "withAuditing": false, "customSnippetPath": "cre 29 Oct 2020 16:41:35:058 INFO PostgresClient [] Successfully committed: -930780454 29 Oct 2020 16:41:35:188 INFO TenantApiImpl [] ************ Running schema updates ************ 29 Oct 2020 16:41:35:198 INFO LiquibaseUtil [] Initializing schema diku_mod_kb_ebsco_java for tenant diku 29 Oct 2020 16:41:35:203 INFO SingleConnectionProvider [] Attempting to get connection for diku 29 Oct 2020 16:41:35:204 INFO PostgresClient [] DB config read from environment variables 29 Oct 2020 16:41:35:204 INFO PostgresClient [] Using schema: diku 29 Oct 2020 16:41:35:211 INFO PostgresClient [] postgreSQLClientConfig = {"maxPoolSize":5,"port":5432,"username":"diku_mod_kb_ebsco_java","host":"10.0.2.15","database":"okapi_modules","password":"..."} 29 Oct 2020 16:41:39:460 INFO Slf4jLogger [] SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 29 Oct 2020 16:41:39:467 INFO Slf4jLogger [] SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangeloglock 29 Oct 2020 16:41:39:474 INFO Slf4jLogger [] SELECT LOCKED FROM diku_mod_kb_ebsco_java.databasechangeloglock WHERE ID=1 29 Oct 2020 16:41:39:519 INFO Slf4jLogger [] Successfully acquired change log lock 29 Oct 2020 16:41:46:005 INFO Slf4jLogger [] SELECT MD5SUM FROM diku_mod_kb_ebsco_java.databasechangelog WHERE MD5SUM IS NOT NULL LIMIT 1 29 Oct 2020 16:41:46:008 INFO Slf4jLogger [] SELECT COUNT(*) FROM diku_mod_kb_ebsco_java.databasechangelog 29 Oct 2020 16:41:46:011 INFO Slf4jLogger [] Reading from diku_mod_kb_ebsco_java.databasechangelog 29 Oct 2020 16:41:46:013 INFO Slf4jLogger [] SELECT * FROM diku_mod_kb_ebsco_java.databasechangelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 29 Oct 2020 16:41:46:555 INFO Slf4jLogger [] Successfully released change log lock 29 Oct 2020 16:41:46:558 INFO LiquibaseUtil [] Schema is initialized for tenant diku 29 Oct 2020 16:41:46:559 INFO TenantApiImpl [] Schema updated for tenant: diku 29 Oct 2020 16:41:46:578 INFO PostgresClient [] Executing multiple statements with id 1986706864 29 Oct 2020 16:41:46:615 INFO TenantApiImpl [] Received flag to initialize test data. Check the server log for details. 29 Oct 2020 16:41:46:615 INFO TenantApiImpl [] ************ Creating test data ************ 29 Oct 2020 16:41:46:661 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 29 Oct 2020 16:41:46:725 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 C 29 Oct 2020 16:41:46:727 INFO PostgresClient [] Successfully committed: 1986706864 29 Oct 2020 16:41:46:728 INFO LogUtil [reqId=033975/proxy;555868/tenant] org.folio.rest.RestVerticle start invoking postTenant 29 Oct 2020 16:41:46:783 INFO LogUtil [reqId=033975/proxy;555868/tenant] 10.0.2.15:41636 POST /_/tenant null HTTP_1_1 200 3 14969 tid=diku OK 29 Oct 2020 16:48:50:395 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:48:51:262 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:48:51:444 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:48:51:478 INFO LogUtil [reqId=044940/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsKbCredentials 29 Oct 2020 16:48:51:697 INFO LogUtil [reqId=044940/eholdings] 10.0.2.15:41758 GET /eholdings/kb-credentials null HTTP_1_1 200 561 994 tid=diku OK 29 Oct 2020 16:48:51:729 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:48:51:735 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:48:51:937 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:48:51:982 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:48:52:050 INFO LogUtil [reqId=586734/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsKbCredentials 29 Oct 2020 16:48:52:170 INFO LogUtil [reqId=586734/eholdings] 10.0.2.15:41758 GET /eholdings/kb-credentials null HTTP_1_1 200 561 435 tid=diku OK 29 Oct 2020 16:48:56:617 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:48:56:690 INFO LogUtil [reqId=918295/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsStatus 29 Oct 2020 16:48:56:724 INFO LogUtil [reqId=918295/eholdings] 10.0.2.15:41756 GET /eholdings/status null HTTP_1_1 200 172 7075 tid=diku OK 29 Oct 2020 16:49:48:350 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1 WHERE id = $1 LIMIT 1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:49:48:365 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:49:48:367 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:49:49:397 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:49:49:445 INFO LogUtil [reqId=958733/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsKbCredentialsCustomLabelsById 29 Oct 2020 16:49:49:533 INFO LogUtil [reqId=958733/eholdings] 10.0.2.15:41756 GET /eholdings/kb-credentials/80898dee-449f-44dd-9c8e-37d5eb469b1d/custom-labels null HTTP_1_1 200 1378 1735 tid=diku OK 29 Oct 2020 16:49:55:538 INFO LogUtil [reqId=288418/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsStatus 29 Oct 2020 16:49:55:546 INFO LogUtil [reqId=288418/eholdings] 10.0.2.15:41756 GET /eholdings/status null HTTP_1_1 200 172 9 tid=diku OK 29 Oct 2020 16:49:55:698 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:49:55:716 INFO LogUtil [reqId=433406/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsKbCredentials 29 Oct 2020 16:49:55:821 INFO LogUtil [reqId=433406/eholdings] 10.0.2.15:41776 GET /eholdings/kb-credentials null HTTP_1_1 200 561 122 tid=diku OK 29 Oct 2020 16:49:56:701 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:49:56:889 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:49:56:896 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:49:57:194 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types_view t1 WHERE credentials_id = $1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:49:57:256 INFO LogUtil [reqId=176628/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsAccessTypes 29 Oct 2020 16:49:57:266 INFO LogUtil [reqId=176628/eholdings] 10.0.2.15:41776 GET /eholdings/access-types null HTTP_1_1 200 102 1403 tid=diku OK 29 Oct 2020 16:49:57:278 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:49:57:354 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:49:57:400 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:49:57:410 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types_view t1 WHERE credentials_id = $1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:49:57:417 INFO LogUtil [reqId=231218/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsAccessTypes 29 Oct 2020 16:49:57:425 INFO LogUtil [reqId=231218/eholdings] 10.0.2.15:41776 GET /eholdings/access-types null HTTP_1_1 200 102 147 tid=diku OK 29 Oct 2020 16:50:05:676 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:05:684 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:05:699 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:05:779 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors?search=Ebsco&offset=1&count=25&orderby=relevance 29 Oct 2020 16:50:05:804 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors?search=Ebsco&offset=1&count=25&orderby=relevance 29 Oct 2020 16:50:06:458 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors?search=Ebsco&offset=1&count=25&orderby=relevance], method = [GET], statusCode = [200], body = [{"totalResults":2,"vendors":[{"vendorId":19,"vendorName":"EBSCO","isCustomer":false,"packagesTotal":654,"packagesSelected":140,"vendorToken":null},{"vendorId":273,"vendorName":"EBSCO Open Access Lists","isCustomer":false,"packagesTotal":25,"packagesSelected":9,"vendorToken":null}]}] 29 Oct 2020 16:50:06:580 INFO LogUtil [reqId=145886/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProviders 29 Oct 2020 16:50:06:658 INFO LogUtil [reqId=145886/eholdings] 10.0.2.15:41776 GET /eholdings/providers q=Ebsco&page=1 HTTP_1_1 200 755 1449 tid=diku OK 29 Oct 2020 16:50:13:061 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:13:115 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:13:168 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:13:201 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:13:218 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:13:225 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:13:312 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19 29 Oct 2020 16:50:13:313 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19 29 Oct 2020 16:50:13:371 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename 29 Oct 2020 16:50:13:371 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename 29 Oct 2020 16:50:13:907 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:14:083 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types_view t1 WHERE credentials_id = $1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:14:482 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:14:541 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:14:550 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:14:605 INFO LogUtil [reqId=889248/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsAccessTypes 29 Oct 2020 16:50:14:633 INFO LogUtil [reqId=889248/eholdings] 10.0.2.15:41776 GET /eholdings/access-types null HTTP_1_1 200 102 1599 tid=diku OK 29 Oct 2020 16:50:14:648 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:14:848 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:14:850 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:50:14:851 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:50:14:866 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:14:869 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:14:877 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:14:906 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename 29 Oct 2020 16:50:14:908 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename 29 Oct 2020 16:50:14:976 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:50:14:978 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:50:15:234 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19], method = [GET], statusCode = [200], body = [{"isCustomer":false,"packagesSelected":140,"packagesTotal":654,"vendorId":19,"vendorName":"EBSCO","proxy":{"id":"ezproxy","inherited":true},"vendorToken":null}] 29 Oct 2020 16:50:15:616 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename], method = [GET], statusCode = [200], body = [{"totalResults":652,"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":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":2516,"packageName":"Abstracts in Social Gerontology","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":1073,"packageName":"Academic Search Alumni Edition","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":3693,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":3693,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":1615,"packageName":"Academic Search Complete","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":10667,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":10667,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"1990-01-01","endCoverage":""},"packageType":"Complete"},{"packageId":158,"packageName":"Academic Search Elite","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":3471,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":3471,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"2018-08-13","endCoverage":"2018-09-13"},"packageType":"Complete"},{"packageId":1327231,"packageName":"Academic Search Index","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":4065,"packageName":"Academic Search Main Edition ","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2961,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":2960,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":160,"packageName":"Academic Search Premier","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":6087,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":6087,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"2018-08-13","endCoverage":"2018-09-13"},"packageType":"Complete"},{"packageId":2333054,"packageName":"Academic Search Ultimate","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":13908,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":13907,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"2018-08-13","endCoverage":"2018-09-13"},"packageType":"Complete"},{"packageId":1153,"packageName":"Advanced Placement Source","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":4239,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":4238,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":6529,"packageName":"Advanstar Communications Collection","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":55,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":55,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":22440,"packageName":"Advertising Periodicals, 1815-1888","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":297,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":297,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":5188,"packageName":"African American Archives","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":1,"isTokenNeeded":false,"contentType":"OnlineReference","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":5738,"packageName":"African American Historical Serials Collection","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":177,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":177,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2552,"packageName":"Africa-Wide Information","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2699,"packageName":"AgeLine (EBSCO)","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2681,"packageName":"Agricola (EBSCO)","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":22427,"packageName":"Agricultural Periodicals from the Northeastern U.S., 1789-1879","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":231,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":231,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"1993-04-11","endCoverage":"2020-04-09"},"packageType":"Complete"},{"packageId":22449,"packageName":"Agricultural Periodicals from the Southern, Midwestern, and Western U.S., 1800-1878","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":188,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":188,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":1376381,"packageName":"Agriculture Plus","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":274,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":273,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":4270,"packageName":"AHFS Consumer Medication Information","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":500,"packageName":"Alt HealthWatch","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":188,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":188,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":22428,"packageName":"Alternative Faith and Philosophy Periodicals, 1789-1878","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":163,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"}]}] 29 Oct 2020 16:50:15:680 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}, {2 = String: provider}] 29 Oct 2020 16:50:15:726 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:50:15:743 INFO LogUtil [reqId=872182/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsRootProxy 29 Oct 2020 16:50:15:841 INFO LogUtil [reqId=872182/eholdings] 10.0.2.15:41786 GET /eholdings/root-proxy null HTTP_1_1 200 264 2401 tid=diku OK 29 Oct 2020 16:50:15:922 INFO LogUtil [reqId=825519/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProvidersByProviderId 29 Oct 2020 16:50:16:049 INFO LogUtil [reqId=825519/eholdings] 10.0.2.15:41756 GET /eholdings/providers/19 include=packages HTTP_1_1 200 22767 2953 tid=diku OK 29 Oct 2020 16:50:16:063 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages?selection=all&contenttype=all&search=&offset=1&count=25&orderby=packagename], method = [GET], statusCode = [200], body = [{"totalResults":652,"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":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":2516,"packageName":"Abstracts in Social Gerontology","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":1073,"packageName":"Academic Search Alumni Edition","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":3693,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":3693,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":1615,"packageName":"Academic Search Complete","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":10667,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":10667,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"1990-01-01","endCoverage":""},"packageType":"Complete"},{"packageId":158,"packageName":"Academic Search Elite","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":3471,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":3471,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"2018-08-13","endCoverage":"2018-09-13"},"packageType":"Complete"},{"packageId":1327231,"packageName":"Academic Search Index","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":4065,"packageName":"Academic Search Main Edition ","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2961,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":2960,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":160,"packageName":"Academic Search Premier","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":6087,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":6087,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"2018-08-13","endCoverage":"2018-09-13"},"packageType":"Complete"},{"packageId":2333054,"packageName":"Academic Search Ultimate","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":13908,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":13907,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"2018-08-13","endCoverage":"2018-09-13"},"packageType":"Complete"},{"packageId":1153,"packageName":"Advanced Placement Source","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":4239,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":4238,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":6529,"packageName":"Advanstar Communications Collection","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":55,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":55,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":22440,"packageName":"Advertising Periodicals, 1815-1888","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":297,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":297,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":5188,"packageName":"African American Archives","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":1,"isTokenNeeded":false,"contentType":"OnlineReference","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":5738,"packageName":"African American Historical Serials Collection","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":177,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":177,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2552,"packageName":"Africa-Wide Information","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2699,"packageName":"AgeLine (EBSCO)","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":2681,"packageName":"Agricola (EBSCO)","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":1,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AbstractAndIndex","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":22427,"packageName":"Agricultural Periodicals from the Northeastern U.S., 1789-1879","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":231,"isSelected":true,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":231,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"1993-04-11","endCoverage":"2020-04-09"},"packageType":"Complete"},{"packageId":22449,"packageName":"Agricultural Periodicals from the Southern, Midwestern, and Western U.S., 1800-1878","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":188,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":188,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":1376381,"packageName":"Agriculture Plus","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":274,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":273,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":4270,"packageName":"AHFS Consumer Medication Information","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by EP"},"selectedCount":1,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":500,"packageName":"Alt HealthWatch","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":188,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":188,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"},{"packageId":22428,"packageName":"Alternative Faith and Philosophy Periodicals, 1789-1878","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":163,"isSelected":false,"visibilityData":{"isHidden":false,"reason":""},"selectedCount":0,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"packageType":"Complete"}]}] 29 Oct 2020 16:50:16:072 INFO LogUtils [] Do select query = SELECT packages.id as id, packages.credentials_id as credentials_id, packages.name as name, packages.content_type as content_type, tags.tag as tag FROM diku_mod_kb_ebsco_java.packages LEFT JOIN diku_mod_kb_ebsco_java.tags as tags ON tags.record_id = packages.id AND tags.record_type = 'package' WHERE packages.id IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25)AND credentials_id=$26 with params = [{1 = String: 19-3649436}, {2 = String: 19-3649443}, {3 = String: 19-3649465}, {4 = String: 19-2516}, {5 = String: 19-1073}, {6 = String: 19-1615}, {7 = String: 19-158}, {8 = String: 19-1327231}, {9 = String: 19-4065}, {10 = String: 19-160}, {11 = String: 19-2333054}, {12 = String: 19-1153}, {13 = String: 19-6529}, {14 = String: 19-22440}, {15 = String: 19-5188}, {16 = String: 19-5738}, {17 = String: 19-2552}, {18 = String: 19-2699}, {19 = String: 19-2681}, {20 = String: 19-22427}, {21 = String: 19-22449}, {22 = String: 19-1376381}, {23 = String: 19-4270}, {24 = String: 19-500}, {25 = String: 19-22428}, {26 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:16:126 INFO LogUtil [reqId=819630/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProvidersPackagesByProviderId 29 Oct 2020 16:50:16:142 INFO LogUtil [reqId=819630/eholdings] 10.0.2.15:41794 GET /eholdings/providers/19/packages page=1 HTTP_1_1 200 21782 1610 tid=diku OK 29 Oct 2020 16:50:16:475 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies], method = [GET], statusCode = [200], body = [[{"id":"","name":"None","urlMask":""},{"id":"Chalmers","name":"Chalmers","urlMask":"http://proxy.lib.chalmers.se/login?url={targetURL}"},{"id":"EZProxy","name":"EZProxy","urlMask":"http://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"MJProxy","name":"MJProxy","urlMask":"https://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"TestingFolio","name":"TestingFolio","urlMask":"https://folio.frontside.io"}]] 29 Oct 2020 16:50:16:487 INFO LogUtil [reqId=438900/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProxyTypes 29 Oct 2020 16:50:16:510 INFO LogUtil [reqId=438900/eholdings] 10.0.2.15:41788 GET /eholdings/proxy-types null HTTP_1_1 200 1369 2416 tid=diku OK 29 Oct 2020 16:50:55:134 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:55:228 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:55:270 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:55:276 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:55:280 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:55:290 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:55:305 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:55:381 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:55:432 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:55:440 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19 29 Oct 2020 16:50:55:456 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19 29 Oct 2020 16:50:55:461 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:50:55:465 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:50:55:548 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types_view t1 WHERE credentials_id = $1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:55:652 INFO LogUtil [reqId=579137/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsAccessTypes 29 Oct 2020 16:50:55:662 INFO LogUtil [reqId=579137/eholdings] 10.0.2.15:41756 GET /eholdings/access-types null HTTP_1_1 200 102 397 tid=diku OK 29 Oct 2020 16:50:56:252 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:56:522 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:50:56:548 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:56:554 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:50:56:558 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:56:562 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:50:56:629 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:50:56:630 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:50:56:664 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles?searchfield=titlename&selection=all&resourcetype=all&searchtype=advanced&search=&offset=1&count=25&orderby=titlename 29 Oct 2020 16:50:56:666 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles?searchfield=titlename&selection=all&resourcetype=all&searchtype=advanced&search=&offset=1&count=25&orderby=titlename 29 Oct 2020 16:50:56:825 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies], method = [GET], statusCode = [200], body = [[{"id":"","name":"None","urlMask":""},{"id":"Chalmers","name":"Chalmers","urlMask":"http://proxy.lib.chalmers.se/login?url={targetURL}"},{"id":"EZProxy","name":"EZProxy","urlMask":"http://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"MJProxy","name":"MJProxy","urlMask":"https://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"TestingFolio","name":"TestingFolio","urlMask":"https://folio.frontside.io"}]] 29 Oct 2020 16:50:56:826 INFO LogUtil [reqId=581503/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProxyTypes 29 Oct 2020 16:50:56:831 INFO LogUtil [reqId=581503/eholdings] 10.0.2.15:41788 GET /eholdings/proxy-types null HTTP_1_1 200 1369 1697 tid=diku OK 29 Oct 2020 16:50:56:897 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19], method = [GET], statusCode = [200], body = [{"isCustomer":false,"packagesSelected":140,"packagesTotal":654,"vendorId":19,"vendorName":"EBSCO","proxy":{"id":"ezproxy","inherited":true},"vendorToken":null}] 29 Oct 2020 16:50:56:899 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}, {2 = String: provider}] 29 Oct 2020 16:50:56:948 INFO LogUtil [reqId=843556/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProvidersByProviderId 29 Oct 2020 16:50:56:965 INFO LogUtil [reqId=843556/eholdings] 10.0.2.15:41794 GET /eholdings/providers/19 null HTTP_1_1 200 525 1755 tid=diku OK 29 Oct 2020 16:50:57:194 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065], method = [GET], statusCode = [200], body = [{"packageId":4065,"packageName":"Academic Search Main Edition ","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2961,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":2960,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"proxy":{"id":"ezproxy","inherited":true},"allowEbscoToAddTitles":true,"packageToken":null,"packageType":"Complete"}] 29 Oct 2020 16:50:57:215 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}, {2 = String: 19-4065}, {3 = String: package}] 29 Oct 2020 16:50:57:229 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-4065}, {2 = String: package}] 29 Oct 2020 16:50:57:242 INFO LogUtil [reqId=557439/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsPackagesByPackageId 29 Oct 2020 16:50:57:276 INFO LogUtil [reqId=557439/eholdings] 10.0.2.15:41786 GET /eholdings/packages/19-4065 include=accessType HTTP_1_1 200 1049 1555 tid=diku OK 29 Oct 2020 16:50:57:418 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles?searchfield=titlename&selection=all&resourcetype=all&searchtype=advanced&search=&offset=1&count=25&orderby=titlename], method = [GET], statusCode = [200], body = [{"totalResults":2961,"titles":[{"titleId":339740,"titleName":"35 days to Gettysburg Diary Entries","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266T","source":"MFS","subtype":0,"type":8},{"id":"339740","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339740,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432714,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266T&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339741,"titleName":"3rd Annual Message to Congress (Franklin Roosevelt)","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266U","source":"MFS","subtype":0,"type":8},{"id":"339741","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Political Science & Studies"}],"isTitleCustom":false,"pubType":"Proceedings","customerResourcesList":[{"titleId":339741,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432715,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-08-01","endCoverage":""}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266U&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":351,"titleName":"ABA Journal","publisherName":"American Bar Association","identifiersList":[{"id":"0747-0088","source":"ResourceIdentifier","subtype":1,"type":0},{"id":"2162-7983","source":"ResourceIdentifier","subtype":2,"type":0},{"id":"10269097","source":"ResourceIdentifier","subtype":0,"type":2},{"id":"2024521-X","source":"ResourceIdentifier","subtype":0,"type":6},{"id":"231139-2","source":"ResourceIdentifier","subtype":0,"type":6},{"id":"ABJ","source":"MFS","subtype":0,"type":8},{"id":"351","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Law"},{"type":"TLI","subject":"Legal Profession"}],"isTitleCustom":false,"pubType":"Journal","customerResourcesList":[{"titleId":351,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432716,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"1985-01-01","endCoverage":""}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=ABJ&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339742,"titleName":"Abigail Adams' Letters of March 31 & May 7, 1776","publisherName":"Great Neck Publishing","identifiersList":[{"id":"263C","source":"MFS","subtype":0,"type":8},{"id":"339742","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339742,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432717,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=263C&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339743,"titleName":"Abolition of Slavery in the Republic of Mexico","publisherName":"Great Neck Publishing","identifiersList":[{"id":"26CO","source":"MFS","subtype":0,"type":8},{"id":"339743","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339743,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432719,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=26CO&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339744,"titleName":"Abraham Lincoln's House Divided Speech","publisherName":"Great Neck Publishing","identifiersList":[{"id":"263D","source":"MFS","subtype":0,"type":8},{"id":"339744","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Proceedings","customerResourcesList":[{"titleId":339744,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432720,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-08-01","endCoverage":""}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=263D&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339745,"titleName":"Abrams et al. v. United States","publisherName":"Great Neck Publishing","identifiersList":[{"id":"2670","source":"MFS","subtype":0,"type":8},{"id":"339745","source":"AtoZ","subtype":0,"type":9}],"subjectsList":null,"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339745,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432721,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=2670&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339746,"titleName":"Abrogation of the Platt Amendment, 1934","publisherName":"Great Neck Publishing","identifiersList":[{"id":"26CP","source":"MFS","subtype":0,"type":8},{"id":"339746","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Diplomacy & International Relations"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339746,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432722,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=26CP&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":583,"titleName":"Academe: Bulletin of the AAUP","publisherName":"American Association of University Professors","identifiersList":[{"id":"0190-2946","source":"ResourceIdentifier","subtype":1,"type":0},{"id":"2162-5247","source":"ResourceIdentifier","subtype":2,"type":0},{"id":"04688683","source":"ResourceIdentifier","subtype":0,"type":2},{"id":"003870003","source":"ResourceIdentifier","subtype":0,"type":3},{"id":"714735","source":"ResourceIdentifier","subtype":0,"type":4},{"id":"97200","source":"MFS","subtype":0,"type":8},{"id":"ACD","source":"MFS","subtype":0,"type":8},{"id":"583","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Higher Education"},{"type":"TLI","subject":"Teaching & Instruction"}],"isTitleCustom":false,"pubType":"Journal","customerResourcesList":[{"titleId":583,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432723,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2002-01-01","endCoverage":""}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=ACD&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":602,"titleName":"Academic leader","publisherName":"Magna Publications Incorporated","identifiersList":[{"id":"8750-7730","source":"ResourceIdentifier","subtype":1,"type":0},{"id":"11747079","source":"ResourceIdentifier","subtype":0,"type":2},{"id":"004104204","source":"ResourceIdentifier","subtype":0,"type":3},{"id":"712828","source":"ResourceIdentifier","subtype":0,"type":4},{"id":"2141917-6","source":"ResourceIdentifier","subtype":0,"type":6},{"id":"QUG","source":"MFS","subtype":0,"type":8},{"id":"602","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Educational Administration"},{"type":"TLI","subject":"Higher Education"},{"type":"TLI","subject":"Teaching & Instruction"}],"isTitleCustom":false,"pubType":"Journal","customerResourcesList":[{"titleId":602,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432724,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2004-01-01","endCoverage":"2006-08-01"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=QUG&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":607,"titleName":"Academic Questions","publisherName":"Springer Nature","identifiersList":[{"id":"0895-4852","source":"ResourceIdentifier","subtype":1,"type":0},{"id":"1936-4709","source":"ResourceIdentifier","subtype":2,"type":0},{"id":"1936-4709","source":"ResourceIdentifier","subtype":7,"type":0},{"id":"16657327","source":"ResourceIdentifier","subtype":0,"type":2},{"id":"004114948","source":"ResourceIdentifier","subtype":0,"type":3},{"id":"004115047","source":"ResourceIdentifier","subtype":0,"type":3},{"id":"103913","source":"ResourceIdentifier","subtype":0,"type":4},{"id":"1268535-5","source":"ResourceIdentifier","subtype":0,"type":6},{"id":"2010125-9","source":"ResourceIdentifier","subtype":0,"type":6},{"id":"ACQ","source":"MFS","subtype":0,"type":8},{"id":"607","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Higher Education"}],"isTitleCustom":false,"pubType":"Journal","customerResourcesList":[{"titleId":607,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2433013,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"1987-12-01","endCoverage":""}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":"years","embargoValue":1},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=ACQ&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339747,"titleName":"Acheson's Address on Strategy of Freedom","publisherName":"Great Neck Publishing","identifiersList":[{"id":"26CQ","source":"MFS","subtype":0,"type":8},{"id":"339747","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Diplomacy & International Relations"}],"isTitleCustom":false,"pubType":"Proceedings","customerResourcesList":[{"titleId":339747,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432725,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-08-01","endCoverage":""}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=26CQ&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":862,"titleName":"Acoustical Physics","publisherName":"Springer Science+Business Media B.V.","identifiersList":[{"id":"1063-7710","source":"ResourceIdentifier","subtype":1,"type":0},{"id":"1562-6865","source":"ResourceIdentifier","subtype":2,"type":0},{"id":"26142019","source":"ResourceIdentifier","subtype":0,"type":2},{"id":"006521769","source":"ResourceIdentifier","subtype":0,"type":3},{"id":"026286823","source":"ResourceIdentifier","subtype":0,"type":3},{"id":"376151072","source":"ResourceIdentifier","subtype":0,"type":3},{"id":"114478","source":"ResourceIdentifier","subtype":0,"type":4},{"id":"1158030-6","source":"ResourceIdentifier","subtype":0,"type":6},{"id":"2007093-7","source":"ResourceIdentifier","subtype":0,"type":6},{"id":"2V7","source":"MFS","subtype":0,"type":8},{"id":"862","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Acoustics & Sound"}],"isTitleCustom":false,"pubType":"Journal","customerResourcesList":[{"titleId":862,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432726,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2000-01-01","endCoverage":""}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":"years","embargoValue":1},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=2V7&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339748,"titleName":"Act Abolishing Slavery in the District of Columbia","publisherName":"Great Neck Publishing","identifiersList":[{"id":"26CR","source":"MFS","subtype":0,"type":8},{"id":"339748","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Political Science & Studies"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339748,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432727,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=26CR&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339749,"titleName":"Act Abolishing the Slave Trade in the District of Columbia","publisherName":"Great Neck Publishing","identifiersList":[{"id":"263O","source":"MFS","subtype":0,"type":8},{"id":"339749","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Political Science & Studies"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339749,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432728,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=263O&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339750,"titleName":"Act Admitting Arkansas to Representation in Congress","publisherName":"Great Neck Publishing","identifiersList":[{"id":"2671","source":"MFS","subtype":0,"type":8},{"id":"339750","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Constitutional Law"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339750,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432729,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=2671&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339751,"titleName":"Act for a National Bank","publisherName":"Great Neck Publishing","identifiersList":[{"id":"263E","source":"MFS","subtype":0,"type":8},{"id":"339751","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Banking, Finance & Investing"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339751,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432730,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=263E&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339752,"titleName":"Act for a National Loan","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266L","source":"MFS","subtype":0,"type":8},{"id":"339752","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Banking, Finance & Investing"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339752,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432731,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266L&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339753,"titleName":"Act for an Additional Article of War","publisherName":"Great Neck Publishing","identifiersList":[{"id":"2672","source":"MFS","subtype":0,"type":8},{"id":"339753","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Military Law"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339753,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432732,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=2672&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339754,"titleName":"Act for Calling Out the Militia","publisherName":"Great Neck Publishing","identifiersList":[{"id":"2673","source":"MFS","subtype":0,"type":8},{"id":"339754","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Political Science & Studies"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339754,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432733,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=2673&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339755,"titleName":"Act for the Prosecution of the Mexican War","publisherName":"Great Neck Publishing","identifiersList":[{"id":"263F","source":"MFS","subtype":0,"type":8},{"id":"339755","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Military History & Science"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339755,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432734,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=263F&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339756,"titleName":"Act of Authorizing the Employment of Volunteers","publisherName":"Great Neck Publishing","identifiersList":[{"id":"26CS","source":"MFS","subtype":0,"type":8},{"id":"339756","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Military History & Science"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339756,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432735,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=26CS&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339757,"titleName":"Act of Authorizing the Seizure of Railroad & Telegraph","publisherName":"Great Neck Publishing","identifiersList":[{"id":"2674","source":"MFS","subtype":0,"type":8},{"id":"339757","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Railroads & Trains"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339757,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432736,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=2674&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339758,"titleName":"Act of Chapultepec, 1945","publisherName":"Great Neck Publishing","identifiersList":[{"id":"26CT","source":"MFS","subtype":0,"type":8},{"id":"339758","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Diplomacy & International Relations"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339758,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432737,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=26CT&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]},{"titleId":339759,"titleName":"Act of Havana","publisherName":"Great Neck Publishing","identifiersList":[{"id":"26CU","source":"MFS","subtype":0,"type":8},{"id":"339759","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"Political Science & Studies"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339759,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432738,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=26CU&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}]}]}] 29 Oct 2020 16:50:57:645 INFO LogUtils [] Do select query = SELECT id, record_id, record_type, tag FROM diku_mod_kb_ebsco_java.tags WHERE record_id IN ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25) AND record_type=$26 with params = [{1 = String: 19-4065-339754}, {2 = String: 19-4065-339755}, {3 = String: 19-4065-339752}, {4 = String: 19-4065-339753}, {5 = String: 19-4065-339758}, {6 = String: 19-4065-607}, {7 = String: 19-4065-339759}, {8 = String: 19-4065-339756}, {9 = String: 19-4065-339757}, {10 = String: 19-4065-339750}, {11 = String: 19-4065-339751}, {12 = String: 19-4065-862}, {13 = String: 19-4065-583}, {14 = String: 19-4065-602}, {15 = String: 19-4065-339743}, {16 = String: 19-4065-339744}, {17 = String: 19-4065-339741}, {18 = String: 19-4065-339742}, {19 = String: 19-4065-339747}, {20 = String: 19-4065-339748}, {21 = String: 19-4065-339745}, {22 = String: 19-4065-339746}, {23 = String: 19-4065-339740}, {24 = String: 19-4065-351}, {25 = String: 19-4065-339749}, {26 = String: resource}] 29 Oct 2020 16:50:57:745 INFO LogUtil [reqId=931903/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsPackagesResourcesByPackageId 29 Oct 2020 16:50:57:934 INFO LogUtil [reqId=931903/eholdings] 10.0.2.15:41756 GET /eholdings/packages/19-4065/resources page=1 HTTP_1_1 200 38712 1567 tid=diku OK 29 Oct 2020 16:51:12:193 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:12:262 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:12:274 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:12:742 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:12:747 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:12:753 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:12:762 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:12:765 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:12:776 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:12:782 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:12:790 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:12:794 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:12:824 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:51:12:829 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:51:12:831 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:51:12:846 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:51:12:856 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:51:12:857 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:51:12:877 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types_view t1 WHERE credentials_id = $1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:12:879 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:51:12:880 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:51:12:907 INFO LogUtil [reqId=219261/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsAccessTypes 29 Oct 2020 16:51:12:910 INFO LogUtil [reqId=219261/eholdings] 10.0.2.15:41794 GET /eholdings/access-types null HTTP_1_1 200 102 638 tid=diku OK 29 Oct 2020 16:51:13:503 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:51:13:506 INFO LogUtil [reqId=380887/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsCustomLabels 29 Oct 2020 16:51:13:520 INFO LogUtil [reqId=380887/eholdings] 10.0.2.15:41788 GET /eholdings/custom-labels null HTTP_1_1 200 1068 1238 tid=diku OK 29 Oct 2020 16:51:13:531 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies], method = [GET], statusCode = [200], body = [[{"id":"","name":"None","urlMask":""},{"id":"Chalmers","name":"Chalmers","urlMask":"http://proxy.lib.chalmers.se/login?url={targetURL}"},{"id":"EZProxy","name":"EZProxy","urlMask":"http://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"MJProxy","name":"MJProxy","urlMask":"https://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"TestingFolio","name":"TestingFolio","urlMask":"https://folio.frontside.io"}]] 29 Oct 2020 16:51:13:537 INFO LogUtil [reqId=148514/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProxyTypes 29 Oct 2020 16:51:13:544 INFO LogUtil [reqId=148514/eholdings] 10.0.2.15:41786 GET /eholdings/proxy-types null HTTP_1_1 200 1369 1342 tid=diku OK 29 Oct 2020 16:51:13:561 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740], method = [GET], statusCode = [200], body = [{"titleId":339740,"titleName":"35 days to Gettysburg Diary Entries","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266T","source":"MFS","subtype":0,"type":8},{"id":"339740","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339740,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","proxy":{"id":"ezproxy","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432714,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266T&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}],"description":null,"edition":null,"isPeerReviewed":false,"contributorsList":[]}] 29 Oct 2020 16:51:13:625 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065], method = [GET], statusCode = [200], body = [{"packageId":4065,"packageName":"Academic Search Main Edition ","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2961,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":2960,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"proxy":{"id":"ezproxy","inherited":true},"allowEbscoToAddTitles":true,"packageToken":null,"packageType":"Complete"}] 29 Oct 2020 16:51:13:627 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}, {2 = String: 19-4065-339740}, {3 = String: resource}] 29 Oct 2020 16:51:13:639 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-4065-339740}, {2 = String: resource}] 29 Oct 2020 16:51:13:690 INFO LogUtil [reqId=959090/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsResourcesByResourceId 29 Oct 2020 16:51:13:762 INFO LogUtil [reqId=959090/eholdings] 10.0.2.15:41756 GET /eholdings/resources/19-4065-339740 include=package%2Ctitle%2CaccessType HTTP_1_1 200 3220 2371 tid=diku OK 29 Oct 2020 16:51:14:101 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:14:121 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:14:136 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:14:145 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:51:14:160 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:51:14:606 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:51:14:636 INFO LogUtil [reqId=096274/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsCustomLabels 29 Oct 2020 16:51:14:678 INFO LogUtil [reqId=096274/eholdings] 10.0.2.15:41756 GET /eholdings/custom-labels null HTTP_1_1 200 1068 580 tid=diku OK 29 Oct 2020 16:51:37:688 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:37:714 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:37:718 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:37:735 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:37:739 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:37:753 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:37:771 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:37:776 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:37:780 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:37:790 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:51:37:790 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:51:37:861 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:51:37:874 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:51:37:875 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:51:37:878 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:51:37:901 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types_view t1 WHERE credentials_id = $1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:37:905 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:51:37:929 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:51:37:939 INFO LogUtil [reqId=660413/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsAccessTypes 29 Oct 2020 16:51:37:998 INFO LogUtil [reqId=660413/eholdings] 10.0.2.15:41786 GET /eholdings/access-types null HTTP_1_1 200 102 290 tid=diku OK 29 Oct 2020 16:51:38:000 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:51:38:133 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:51:38:134 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:51:38:379 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740], method = [GET], statusCode = [200], body = [{"titleId":339740,"titleName":"35 days to Gettysburg Diary Entries","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266T","source":"MFS","subtype":0,"type":8},{"id":"339740","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339740,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","proxy":{"id":"ezproxy","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432714,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266T&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}],"description":null,"edition":null,"isPeerReviewed":false,"contributorsList":[]}] 29 Oct 2020 16:51:38:396 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies], method = [GET], statusCode = [200], body = [[{"id":"","name":"None","urlMask":""},{"id":"Chalmers","name":"Chalmers","urlMask":"http://proxy.lib.chalmers.se/login?url={targetURL}"},{"id":"EZProxy","name":"EZProxy","urlMask":"http://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"MJProxy","name":"MJProxy","urlMask":"https://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"TestingFolio","name":"TestingFolio","urlMask":"https://folio.frontside.io"}]] 29 Oct 2020 16:51:38:405 INFO LogUtil [reqId=762662/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProxyTypes 29 Oct 2020 16:51:38:432 INFO LogUtil [reqId=762662/eholdings] 10.0.2.15:41788 GET /eholdings/proxy-types null HTTP_1_1 200 1369 712 tid=diku OK 29 Oct 2020 16:51:38:466 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065], method = [GET], statusCode = [200], body = [{"packageId":4065,"packageName":"Academic Search Main Edition ","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2961,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":2960,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"proxy":{"id":"ezproxy","inherited":true},"allowEbscoToAddTitles":true,"packageToken":null,"packageType":"Complete"}] 29 Oct 2020 16:51:38:495 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}, {2 = String: 19-4065-339740}, {3 = String: resource}] 29 Oct 2020 16:51:38:499 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-4065-339740}, {2 = String: resource}] 29 Oct 2020 16:51:38:506 INFO LogUtil [reqId=760414/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsResourcesByResourceId 29 Oct 2020 16:51:38:517 INFO LogUtil [reqId=760414/eholdings] 10.0.2.15:41756 GET /eholdings/resources/19-4065-339740 include=package%2Ctitle%2CaccessType HTTP_1_1 200 3220 830 tid=diku OK 29 Oct 2020 16:51:38:604 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:51:38:626 INFO LogUtil [reqId=874654/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsCustomLabels 29 Oct 2020 16:51:38:675 INFO LogUtil [reqId=874654/eholdings] 10.0.2.15:41794 GET /eholdings/custom-labels null HTTP_1_1 200 1068 771 tid=diku OK 29 Oct 2020 16:52:12:143 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:52:12:154 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:52:12:158 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:12:168 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:12:170 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:12:568 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740], method = [GET], statusCode = [200], body = [{"titleId":339740,"titleName":"35 days to Gettysburg Diary Entries","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266T","source":"MFS","subtype":0,"type":8},{"id":"339740","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339740,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","proxy":{"id":"ezproxy","inherited":true},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432714,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":null,"managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266T&scope=site","userDefinedField1":null,"userDefinedField2":null,"userDefinedField3":null,"userDefinedField4":null,"userDefinedField5":null,"selectedBy":"Unknown"}],"description":null,"edition":null,"isPeerReviewed":false,"contributorsList":[]}] 29 Oct 2020 16:52:12:587 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:12:588 INFO HoldingsRequestHelper [] RMAPI Service PUT absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:12:602 INFO HoldingsRequestHelper [] RMAPI Service PUT body is: { "userDefinedField1" : "sdfsdf", "userDefinedField2" : "", "userDefinedField3" : "", "userDefinedField4" : "sdfsdf", "userDefinedField5" : "", "isHidden" : true, "titleName" : null, "pubType" : "Book", "publisherName" : null, "isPeerReviewed" : false, "description" : null, "edition" : null, "contributorsList" : null, "identifiersList" : null, "coverageStatement" : "", "isSelected" : true, "customEmbargoPeriod" : { "embargoUnit" : "Days", "embargoValue" : 12 }, "proxy" : { "id" : "TestingFolio", "inherited" : false }, "url" : null, "customCoverageList" : [ ] } 29 Oct 2020 16:52:13:268 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740], method = [PUT], statusCode = [204], body = [] 29 Oct 2020 16:52:13:270 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:13:271 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:13:930 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740], method = [GET], statusCode = [200], body = [{"titleId":339740,"titleName":"35 days to Gettysburg Diary Entries","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266T","source":"MFS","subtype":0,"type":8},{"id":"339740","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339740,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","proxy":{"id":"TestingFolio","inherited":false},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432714,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":"","managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":"Days","embargoValue":12},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266T&scope=site","userDefinedField1":"sdfsdf","userDefinedField2":"","userDefinedField3":"","userDefinedField4":"sdfsdf","userDefinedField5":"","selectedBy":"Unknown"}],"description":null,"edition":null,"isPeerReviewed":false,"contributorsList":[]}] 29 Oct 2020 16:52:13:932 INFO LogUtils [] Do delete query = DELETE FROM diku_mod_kb_ebsco_java.access_types_mappings WHERE record_id = $1 AND record_type = $2 AND access_type_id IN (SELECT id FROM diku_mod_kb_ebsco_java.access_types t1 WHERE credentials_id = $3); with params = [{1 = String: 19-4065-339740}, {2 = String: resource}, {3 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:13:953 INFO LogUtil [reqId=317208/eholdings] org.folio.rest.RestVerticle start invoking putEholdingsResourcesByResourceId 29 Oct 2020 16:52:13:970 INFO LogUtil [reqId=317208/eholdings] 10.0.2.15:41794 PUT /eholdings/resources/19-4065-339740 null HTTP_1_1 200 1881 2360 tid=diku OK 29 Oct 2020 16:52:14:472 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:52:14:488 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:52:14:506 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:52:14:521 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:52:14:531 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:52:14:535 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:14:541 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:14:544 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:52:14:556 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:14:561 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740 29 Oct 2020 16:52:14:566 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:52:14:571 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065 29 Oct 2020 16:52:14:617 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:14:643 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.access_types_view t1 WHERE credentials_id = $1; with params = [{1 = UUID: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:14:670 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:52:14:674 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies 29 Oct 2020 16:52:14:687 INFO LogUtil [reqId=224143/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsAccessTypes 29 Oct 2020 16:52:14:700 INFO LogUtil [reqId=224143/eholdings] 10.0.2.15:41788 GET /eholdings/access-types null HTTP_1_1 200 102 195 tid=diku OK 29 Oct 2020 16:52:14:872 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:52:15:337 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:52:15:358 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:15:364 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:52:15:364 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:52:15:547 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065], method = [GET], statusCode = [200], body = [{"packageId":4065,"packageName":"Academic Search Main Edition ","isCustom":false,"vendorId":19,"vendorName":"EBSCO","titleCount":2961,"isSelected":true,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"selectedCount":2960,"isTokenNeeded":false,"contentType":"AggregatedFullText","customCoverage":{"beginCoverage":"","endCoverage":""},"proxy":{"id":"ezproxy","inherited":true},"allowEbscoToAddTitles":true,"packageToken":null,"packageType":"Complete"}] 29 Oct 2020 16:52:15:553 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/proxies], method = [GET], statusCode = [200], body = [[{"id":"","name":"None","urlMask":""},{"id":"Chalmers","name":"Chalmers","urlMask":"http://proxy.lib.chalmers.se/login?url={targetURL}"},{"id":"EZProxy","name":"EZProxy","urlMask":"http://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"MJProxy","name":"MJProxy","urlMask":"https://ezproxy.myinstitute.edu/login?url={targetURL}"},{"id":"TestingFolio","name":"TestingFolio","urlMask":"https://folio.frontside.io"}]] 29 Oct 2020 16:52:15:558 INFO LogUtil [reqId=114991/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsProxyTypes 29 Oct 2020 16:52:15:609 INFO LogUtil [reqId=114991/eholdings] 10.0.2.15:41756 GET /eholdings/proxy-types null HTTP_1_1 200 1369 1134 tid=diku OK 29 Oct 2020 16:52:15:733 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/vendors/19/packages/4065/titles/339740], method = [GET], statusCode = [200], body = [{"titleId":339740,"titleName":"35 days to Gettysburg Diary Entries","publisherName":"Great Neck Publishing","identifiersList":[{"id":"266T","source":"MFS","subtype":0,"type":8},{"id":"339740","source":"AtoZ","subtype":0,"type":9}],"subjectsList":[{"type":"TLI","subject":"History of the Americas"}],"isTitleCustom":false,"pubType":"Book","customerResourcesList":[{"titleId":339740,"packageId":4065,"packageName":"Academic Search Main Edition ","packageType":"Complete","proxy":{"id":"TestingFolio","inherited":false},"isPackageCustom":false,"vendorId":19,"vendorName":"EBSCO","locationId":2432714,"isSelected":true,"isTokenNeeded":false,"visibilityData":{"isHidden":true,"reason":"Hidden by Customer"},"managedCoverageList":[{"beginCoverage":"2017-01-01","endCoverage":"2017-12-31"}],"customCoverageList":[],"coverageStatement":"","managedEmbargoPeriod":{"embargoUnit":null,"embargoValue":0},"customEmbargoPeriod":{"embargoUnit":"Days","embargoValue":12},"url":"http://search.ebscohost.com/direct.asp?db=asm&jid=266T&scope=site","userDefinedField1":"sdfsdf","userDefinedField2":"","userDefinedField3":"","userDefinedField4":"sdfsdf","userDefinedField5":"","selectedBy":"Unknown"}],"description":null,"edition":null,"isPeerReviewed":false,"contributorsList":[]}] 29 Oct 2020 16:52:15:736 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}, {2 = String: 19-4065-339740}, {3 = String: resource}] 29 Oct 2020 16:52:15:739 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-4065-339740}, {2 = String: resource}] 29 Oct 2020 16:52:15:760 INFO LogUtil [reqId=640935/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsResourcesByResourceId 29 Oct 2020 16:52:15:793 INFO LogUtil [reqId=640935/eholdings] 10.0.2.15:41794 GET /eholdings/resources/19-4065-339740 include=package%2Ctitle%2CaccessType HTTP_1_1 200 3463 1357 tid=diku OK 29 Oct 2020 16:52:15:893 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:52:15:896 INFO LogUtil [reqId=185041/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsCustomLabels 29 Oct 2020 16:52:15:906 INFO LogUtil [reqId=185041/eholdings] 10.0.2.15:41788 GET /eholdings/custom-labels null HTTP_1_1 200 1068 1047 tid=diku OK 29 Oct 2020 16:52:16:081 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: 290616d1-96f4-5498-81fc-3b742f9dbb11}] 29 Oct 2020 16:52:16:090 INFO LogUtils [] Do select query = SELECT * FROM diku_mod_kb_ebsco_java.kb_credentials t1; with params = [] 29 Oct 2020 16:52:16:093 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: 80898dee-449f-44dd-9c8e-37d5eb469b1d}] 29 Oct 2020 16:52:16:194 INFO HoldingsRequestHelper [] constructurl - path=https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:52:16:201 INFO HoldingsRequestHelper [] RMAPI Service GET absolute URL is: https://api.ebsco.io/rm/rmaccounts/apidvcorp/ 29 Oct 2020 16:52:16:752 INFO HoldingsRequestHelper [] [OK] RMAPI Service response: query = [https://api.ebsco.io/rm/rmaccounts/apidvcorp/], method = [GET], statusCode = [200], body = [{"proxy":{"id":"EZProxy"},"vendorId":"123355","ftfTokens":[{"key":"CCC.LicenseType","token":"555555"},{"key":"CCC.Password","token":"4"},{"key":"CCC.Username","token":"3"},{"key":"COAlliance.Id","token":"8"},{"key":"EBSCOILL.Email","token":"6"},{"key":"EBSCOILL.FormNumber","token":"7"},{"key":"FirstSearch.AuthorizationCode","token":"18"},{"key":"MDConsult.Password","token":"10"},{"key":"MDConsult.Username","token":"9"},{"key":"OCLC.Symbol","token":"19"},{"key":"OVID.Password","token":"12"},{"key":"OVID.UserId","token":"11"},{"key":"password.csa","token":"2"},{"key":"Relais.Password","token":"14"},{"key":"Relais.Username","token":"13"},{"key":"SOD.Email","token":"16"},{"key":"SOD.InstitutionCode","token":"15"},{"key":"SyndeticsClient.Id","token":"17"},{"key":"user.csa","token":"11111111"}],"labels":[{"id":1,"displayLabel":"simple","displayOnFullTextFinder":true,"displayOnPublicationFinder":false},{"id":2,"displayLabel":"145","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":3,"displayLabel":"141","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":4,"displayLabel":"123","displayOnFullTextFinder":false,"displayOnPublicationFinder":false},{"id":5,"displayLabel":"122","displayOnFullTextFinder":false,"displayOnPublicationFinder":false}]}] 29 Oct 2020 16:52:16:753 INFO LogUtil [reqId=147481/eholdings] org.folio.rest.RestVerticle start invoking getEholdingsCustomLabels 29 Oct 2020 16:52:16:755 INFO LogUtil [reqId=147481/eholdings] 10.0.2.15:41788 GET /eholdings/custom-labels null HTTP_1_1 200 1068 676 tid=diku OK