2020-11-01 14:52:28,593 INFO [startup] [AbstractCommandLauncher] [main] Option: name=verbose, value={}
2020-11-01 14:52:28,638 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2020 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2020-11-01 14:52:28,699 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on 0.0.0.0:8080:HTTP/1.1
2020-11-01 14:52:28,941 INFO [store-002] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2020-11-01 14:52:29,621 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2020-11-01 14:52:29,662 INFO [store-002] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'postgres95', version '12', protocol 'postgresql'
2020-11-01 14:52:29,673 INFO [store-002] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSql95DatabasePlatform
2020-11-01 14:52:29,734 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.PostgreSqlSymmetricDialect
2020-11-01 14:52:29,756 INFO [store-002] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /Users/danridinger/Downloads/symmetric-server-3.12.4/tmp/store-002
2020-11-01 14:52:30,147 INFO [store-002] [ClientExtensionService] [symmetric-engine-startup-1] Found 8 extension points from spring that will be registered
2020-11-01 14:52:30,154 INFO [store-002] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2020-11-01 14:52:30,170 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object:
CREATE or REPLACE FUNCTION sym_triggers_disabled() RETURNS INTEGER AS $$ DECLARE triggerDisabled INTEGER; BEGIN select current_setting('symmetric.triggers_disabled') into triggerDisabled; return triggerDisabled; EXCEPTION WHEN OTHERS THEN return 0; END; $$ LANGUAGE plpgsql;
2020-11-01 14:52:30,269 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Just installed sym_triggers_disabled
2020-11-01 14:52:30,270 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object:
CREATE or REPLACE FUNCTION sym_node_disabled() RETURNS VARCHAR AS $$ DECLARE nodeId VARCHAR(50); BEGIN select current_setting('symmetric.node_disabled') into nodeId; return nodeId; EXCEPTION WHEN OTHERS THEN return ''; END; $$ LANGUAGE plpgsql;
2020-11-01 14:52:30,272 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Just installed sym_node_disabled
2020-11-01 14:52:30,273 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object:
CREATE OR REPLACE FUNCTION sym_largeobject(objectId oid) RETURNS text AS $$ DECLARE encodedBlob text; encodedBlobPage text; BEGIN encodedBlob := ''; FOR encodedBlobPage IN SELECT pg_catalog.encode(data, 'escape') FROM pg_largeobject WHERE loid = objectId ORDER BY pageno LOOP encodedBlob := encodedBlob || encodedBlobPage; END LOOP; RETURN pg_catalog.encode(pg_catalog.decode(encodedBlob, 'escape'), 'base64'); EXCEPTION WHEN OTHERS THEN RETURN ''; END $$ LANGUAGE plpgsql;
2020-11-01 14:52:30,274 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Just installed sym_largeobject
2020-11-01 14:52:30,275 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2020-11-01 14:52:30,443 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered
2020-11-01 14:52:30,464 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_channel"(
"channel_id" VARCHAR(128) NOT NULL,
"processing_order" INTEGER DEFAULT 1 NOT NULL,
"max_batch_size" INTEGER DEFAULT 1000 NOT NULL,
"max_batch_to_send" INTEGER DEFAULT 60 NOT NULL,
"max_data_to_route" INTEGER DEFAULT 100000 NOT NULL,
"extract_period_millis" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"reload_flag" SMALLINT DEFAULT 0 NOT NULL,
"file_sync_flag" SMALLINT DEFAULT 0 NOT NULL,
"contains_big_lob" SMALLINT DEFAULT 0 NOT NULL,
"batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL,
"data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
"description" VARCHAR(255),
"queue" VARCHAR(25) DEFAULT 'default' NOT NULL,
"max_network_kbps" NUMERIC(10,3) DEFAULT 0.000 NOT NULL,
"data_event_action" CHAR(1),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("channel_id")
)
2020-11-01 14:52:30,467 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_conflict"(
"conflict_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_channel_id" VARCHAR(128),
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"detect_type" VARCHAR(128) NOT NULL,
"detect_expression" TEXT,
"resolve_type" VARCHAR(128) NOT NULL,
"ping_back" VARCHAR(128) NOT NULL,
"resolve_changes_only" SMALLINT DEFAULT 0,
"resolve_row_only" SMALLINT DEFAULT 0,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("conflict_id")
)
2020-11-01 14:52:30,469 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_context"(
"name" VARCHAR(80) NOT NULL,
"context_value" TEXT,
"create_time" TIMESTAMP,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("name")
)
2020-11-01 14:52:30,471 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE SEQUENCE "sym_data_data_id_seq"
2020-11-01 14:52:30,478 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_data"(
"data_id" BIGINT NOT NULL DEFAULT nextval('"sym_data_data_id_seq"'),
"table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"row_data" TEXT,
"pk_data" TEXT,
"old_data" TEXT,
"trigger_hist_id" INTEGER NOT NULL,
"channel_id" VARCHAR(128),
"transaction_id" VARCHAR(255),
"source_node_id" VARCHAR(50),
"external_data" VARCHAR(50),
"node_list" VARCHAR(255),
"is_prerouted" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id")
)
2020-11-01 14:52:30,480 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE UNIQUE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2020-11-01 14:52:30,481 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_data_event"(
"data_id" BIGINT NOT NULL,
"batch_id" BIGINT NOT NULL,
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id", "batch_id")
)
2020-11-01 14:52:30,482 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2020-11-01 14:52:30,483 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_data_gap"(
"start_id" BIGINT NOT NULL,
"end_id" BIGINT NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_hostname" VARCHAR(255),
PRIMARY KEY ("start_id", "end_id")
)
2020-11-01 14:52:30,487 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_extension"(
"extension_id" VARCHAR(50) NOT NULL,
"extension_type" VARCHAR(10) NOT NULL,
"interface_name" VARCHAR(255),
"node_group_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"extension_order" INTEGER DEFAULT 1 NOT NULL,
"extension_text" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("extension_id")
)
2020-11-01 14:52:30,491 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_extract_request"(
"request_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"queue" VARCHAR(128),
"status" CHAR(2),
"start_batch_id" BIGINT NOT NULL,
"end_batch_id" BIGINT NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"load_id" BIGINT,
"table_name" VARCHAR(255),
"extracted_rows" BIGINT DEFAULT 0 NOT NULL,
"extracted_millis" BIGINT DEFAULT 0 NOT NULL,
"transferred_rows" BIGINT DEFAULT 0 NOT NULL,
"transferred_millis" BIGINT DEFAULT 0 NOT NULL,
"last_transferred_batch_id" BIGINT,
"loaded_rows" BIGINT DEFAULT 0 NOT NULL,
"loaded_millis" BIGINT DEFAULT 0 NOT NULL,
"last_loaded_batch_id" BIGINT,
"total_rows" BIGINT,
"loaded_time" TIMESTAMP,
"parent_request_id" BIGINT DEFAULT 0 NOT NULL,
"last_update_time" TIMESTAMP,
"create_time" TIMESTAMP,
PRIMARY KEY ("request_id")
)
2020-11-01 14:52:30,497 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_incoming"(
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"file_modified_time" BIGINT,
PRIMARY KEY ("relative_dir", "file_name")
)
2020-11-01 14:52:30,512 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_snapshot"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"crc32_checksum" BIGINT,
"file_size" BIGINT,
"file_modified_time" BIGINT,
"last_update_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name")
)
2020-11-01 14:52:30,515 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2020-11-01 14:52:30,547 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"base_dir" VARCHAR(255) NOT NULL,
"recurse" SMALLINT DEFAULT 1 NOT NULL,
"includes_files" VARCHAR(255),
"excludes_files" VARCHAR(255),
"sync_on_create" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_modified" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_ctl_file" SMALLINT DEFAULT 0 NOT NULL,
"delete_after_sync" SMALLINT DEFAULT 0 NOT NULL,
"before_copy_script" TEXT,
"after_copy_script" TEXT,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id")
)
2020-11-01 14:52:30,555 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_enabled" SMALLINT DEFAULT 1 NOT NULL,
"target_base_dir" VARCHAR(255),
"conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2020-11-01 14:52:30,557 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"grouplet_link_policy" CHAR(1) DEFAULT 'I' NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id")
)
2020-11-01 14:52:30,559 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_grouplet_link"(
"grouplet_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "external_id")
)
2020-11-01 14:52:30,564 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_incoming_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"sql_state" VARCHAR(10),
"sql_code" INTEGER DEFAULT 0 NOT NULL,
"sql_message" TEXT,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP,
"create_time" TIMESTAMP,
"summary" VARCHAR(255),
"ignore_count" INTEGER DEFAULT 0 NOT NULL,
"byte_count" BIGINT DEFAULT 0 NOT NULL,
"load_flag" SMALLINT DEFAULT 0,
"extract_count" INTEGER DEFAULT 0 NOT NULL,
"sent_count" INTEGER DEFAULT 0 NOT NULL,
"load_count" INTEGER DEFAULT 0 NOT NULL,
"reload_row_count" INTEGER DEFAULT 0 NOT NULL,
"other_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"network_millis" INTEGER DEFAULT 0 NOT NULL,
"filter_millis" INTEGER DEFAULT 0 NOT NULL,
"load_millis" INTEGER DEFAULT 0 NOT NULL,
"router_millis" INTEGER DEFAULT 0 NOT NULL,
"extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_load_millis" INTEGER DEFAULT 0 NOT NULL,
"load_id" BIGINT,
"common_flag" SMALLINT DEFAULT 0,
"fallback_insert_count" INTEGER DEFAULT 0 NOT NULL,
"fallback_update_count" INTEGER DEFAULT 0 NOT NULL,
"ignore_row_count" INTEGER DEFAULT 0 NOT NULL,
"missing_delete_count" INTEGER DEFAULT 0 NOT NULL,
"skip_count" INTEGER DEFAULT 0 NOT NULL,
"failed_row_number" INTEGER DEFAULT 0 NOT NULL,
"failed_line_number" INTEGER DEFAULT 0 NOT NULL,
"failed_data_id" BIGINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("batch_id", "node_id")
)
2020-11-01 14:52:30,565 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2020-11-01 14:52:30,567 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2020-11-01 14:52:30,569 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_incoming_error"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"failed_row_number" BIGINT NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"binary_encoding" VARCHAR(10) DEFAULT 'HEX' NOT NULL,
"column_names" TEXT NOT NULL,
"pk_column_names" TEXT NOT NULL,
"row_data" TEXT,
"old_data" TEXT,
"cur_data" TEXT,
"resolve_data" TEXT,
"resolve_ignore" SMALLINT DEFAULT 0,
"conflict_id" VARCHAR(50),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("batch_id", "node_id", "failed_row_number")
)
2020-11-01 14:52:30,572 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_job"(
"job_name" VARCHAR(50) NOT NULL,
"job_type" VARCHAR(10) NOT NULL,
"requires_registration" SMALLINT DEFAULT 1 NOT NULL,
"job_expression" TEXT,
"description" VARCHAR(255),
"default_schedule" VARCHAR(50),
"default_auto_start" SMALLINT DEFAULT 1 NOT NULL,
"node_group_id" VARCHAR(50) NOT NULL,
"create_by" VARCHAR(50),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("job_name")
)
2020-11-01 14:52:30,575 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_load_filter"(
"load_filter_id" VARCHAR(50) NOT NULL,
"load_filter_type" VARCHAR(10) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"filter_on_update" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"before_write_script" TEXT,
"after_write_script" TEXT,
"batch_complete_script" TEXT,
"batch_commit_script" TEXT,
"batch_rollback_script" TEXT,
"handle_error_script" TEXT,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"load_filter_order" INTEGER DEFAULT 1 NOT NULL,
"fail_on_error" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("load_filter_id")
)
2020-11-01 14:52:30,577 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_lock"(
"lock_action" VARCHAR(50) NOT NULL,
"lock_type" VARCHAR(50) NOT NULL,
"locking_server_id" VARCHAR(255),
"lock_time" TIMESTAMP,
"shared_count" INTEGER DEFAULT 0 NOT NULL,
"shared_enable" INTEGER DEFAULT 0 NOT NULL,
"last_lock_time" TIMESTAMP,
"last_locking_server_id" VARCHAR(255),
PRIMARY KEY ("lock_action")
)
2020-11-01 14:52:30,580 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node"(
"node_id" VARCHAR(50) NOT NULL,
"node_group_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"sync_enabled" SMALLINT DEFAULT 0,
"sync_url" VARCHAR(255),
"schema_version" VARCHAR(50),
"symmetric_version" VARCHAR(50),
"config_version" VARCHAR(50),
"database_type" VARCHAR(50),
"database_version" VARCHAR(50),
"database_name" VARCHAR(50),
"batch_to_send_count" INTEGER DEFAULT 0,
"batch_in_error_count" INTEGER DEFAULT 0,
"created_at_node_id" VARCHAR(50),
"deployment_type" VARCHAR(50),
"deployment_sub_type" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2020-11-01 14:52:30,582 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_communication"(
"node_id" VARCHAR(50) NOT NULL,
"queue" VARCHAR(25) DEFAULT 'default' NOT NULL,
"communication_type" VARCHAR(10) NOT NULL,
"lock_time" TIMESTAMP,
"locking_server_id" VARCHAR(255),
"last_lock_time" TIMESTAMP,
"last_lock_millis" BIGINT DEFAULT 0,
"success_count" BIGINT DEFAULT 0,
"fail_count" BIGINT DEFAULT 0,
"skip_count" BIGINT DEFAULT 0,
"total_success_count" BIGINT DEFAULT 0,
"total_fail_count" BIGINT DEFAULT 0,
"total_success_millis" BIGINT DEFAULT 0,
"total_fail_millis" BIGINT DEFAULT 0,
"batch_to_send_count" BIGINT DEFAULT 0,
"node_priority" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "queue", "communication_type")
)
2020-11-01 14:52:30,585 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_channel_ctl"(
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"suspend_enabled" SMALLINT DEFAULT 0,
"ignore_enabled" SMALLINT DEFAULT 0,
"last_extract_time" TIMESTAMP,
PRIMARY KEY ("node_id", "channel_id")
)
2020-11-01 14:52:30,587 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_group"(
"node_group_id" VARCHAR(50) NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("node_group_id")
)
2020-11-01 14:52:30,588 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2020-11-01 14:52:30,590 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_group_link"(
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"data_event_action" CHAR(1) DEFAULT 'W' NOT NULL,
"sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL,
"is_reversible" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("source_node_group_id", "target_node_group_id")
)
2020-11-01 14:52:30,594 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"instance_id" VARCHAR(60),
"ip_address" VARCHAR(50),
"os_user" VARCHAR(50),
"os_name" VARCHAR(50),
"os_arch" VARCHAR(50),
"os_version" VARCHAR(50),
"available_processors" INTEGER DEFAULT 0,
"free_memory_bytes" BIGINT DEFAULT 0,
"total_memory_bytes" BIGINT DEFAULT 0,
"max_memory_bytes" BIGINT DEFAULT 0,
"java_version" VARCHAR(50),
"java_vendor" VARCHAR(255),
"jdbc_version" VARCHAR(255),
"symmetric_version" VARCHAR(50),
"timezone_offset" VARCHAR(6),
"heartbeat_time" TIMESTAMP,
"last_restart_time" TIMESTAMP NOT NULL,
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("node_id", "host_name")
)
2020-11-01 14:52:30,598 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
"data_loaded_outgoing" BIGINT DEFAULT 0,
"data_bytes_loaded_outgoing" BIGINT DEFAULT 0,
"data_loaded_outgoing_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2020-11-01 14:52:30,600 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2020-11-01 14:52:30,603 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2020-11-01 14:52:30,604 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2020-11-01 14:52:30,606 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2020-11-01 14:52:30,607 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time")
2020-11-01 14:52:30,609 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_identity"(
"node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("node_id")
)
2020-11-01 14:52:30,612 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_security"(
"node_id" VARCHAR(50) NOT NULL,
"node_password" VARCHAR(50) NOT NULL,
"registration_enabled" SMALLINT DEFAULT 0,
"registration_time" TIMESTAMP,
"initial_load_enabled" SMALLINT DEFAULT 0,
"initial_load_time" TIMESTAMP,
"initial_load_id" BIGINT,
"initial_load_create_by" VARCHAR(255),
"rev_initial_load_enabled" SMALLINT DEFAULT 0,
"rev_initial_load_time" TIMESTAMP,
"rev_initial_load_id" BIGINT,
"rev_initial_load_create_by" VARCHAR(255),
"failed_logins" SMALLINT DEFAULT 0,
"created_at_node_id" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2020-11-01 14:52:30,614 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_monitor"(
"monitor_id" VARCHAR(128) NOT NULL,
"node_group_id" VARCHAR(50) DEFAULT 'ALL' NOT NULL,
"external_id" VARCHAR(255) DEFAULT 'ALL' NOT NULL,
"type" VARCHAR(50) NOT NULL,
"expression" TEXT,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"run_period" INTEGER DEFAULT 0 NOT NULL,
"run_count" INTEGER DEFAULT 0 NOT NULL,
"severity_level" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("monitor_id")
)
2020-11-01 14:52:30,617 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_monitor_event"(
"monitor_id" VARCHAR(128) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"event_time" TIMESTAMP NOT NULL,
"host_name" VARCHAR(60),
"type" VARCHAR(50) NOT NULL,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"event_value" BIGINT DEFAULT 0 NOT NULL,
"event_count" INTEGER DEFAULT 0 NOT NULL,
"severity_level" INTEGER DEFAULT 0 NOT NULL,
"is_resolved" SMALLINT DEFAULT 0 NOT NULL,
"is_notified" SMALLINT DEFAULT 0 NOT NULL,
"details" TEXT,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("monitor_id", "node_id", "event_time")
)
2020-11-01 14:52:30,620 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_notification"(
"notification_id" VARCHAR(128) NOT NULL,
"node_group_id" VARCHAR(50) DEFAULT 'ALL' NOT NULL,
"external_id" VARCHAR(255) DEFAULT 'ALL' NOT NULL,
"severity_level" INTEGER DEFAULT 0 NOT NULL,
"type" VARCHAR(50) NOT NULL,
"expression" TEXT,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("notification_id")
)
2020-11-01 14:52:30,625 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_outgoing_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"sql_state" VARCHAR(10),
"sql_code" INTEGER DEFAULT 0 NOT NULL,
"sql_message" TEXT,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP,
"create_time" TIMESTAMP,
"summary" VARCHAR(255),
"ignore_count" INTEGER DEFAULT 0 NOT NULL,
"byte_count" BIGINT DEFAULT 0 NOT NULL,
"load_flag" SMALLINT DEFAULT 0,
"extract_count" INTEGER DEFAULT 0 NOT NULL,
"sent_count" INTEGER DEFAULT 0 NOT NULL,
"load_count" INTEGER DEFAULT 0 NOT NULL,
"reload_row_count" INTEGER DEFAULT 0 NOT NULL,
"other_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"network_millis" INTEGER DEFAULT 0 NOT NULL,
"filter_millis" INTEGER DEFAULT 0 NOT NULL,
"load_millis" INTEGER DEFAULT 0 NOT NULL,
"router_millis" INTEGER DEFAULT 0 NOT NULL,
"extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_load_millis" INTEGER DEFAULT 0 NOT NULL,
"load_id" BIGINT,
"common_flag" SMALLINT DEFAULT 0,
"fallback_insert_count" INTEGER DEFAULT 0 NOT NULL,
"fallback_update_count" INTEGER DEFAULT 0 NOT NULL,
"ignore_row_count" INTEGER DEFAULT 0 NOT NULL,
"missing_delete_count" INTEGER DEFAULT 0 NOT NULL,
"skip_count" INTEGER DEFAULT 0 NOT NULL,
"total_extract_millis" INTEGER DEFAULT 0 NOT NULL,
"total_load_millis" INTEGER DEFAULT 0 NOT NULL,
"extract_job_flag" SMALLINT DEFAULT 0,
"extract_start_time" TIMESTAMP,
"transfer_start_time" TIMESTAMP,
"load_start_time" TIMESTAMP,
"failed_data_id" BIGINT DEFAULT 0 NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"create_by" VARCHAR(255),
PRIMARY KEY ("batch_id", "node_id")
)
2020-11-01 14:52:30,627 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2020-11-01 14:52:30,628 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2020-11-01 14:52:30,629 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2020-11-01 14:52:30,632 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_parameter"(
"external_id" VARCHAR(255) NOT NULL,
"node_group_id" VARCHAR(50) NOT NULL,
"param_key" VARCHAR(80) NOT NULL,
"param_value" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("external_id", "node_group_id", "param_key")
)
2020-11-01 14:52:30,633 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_registration_redirect"(
"registrant_external_id" VARCHAR(255) NOT NULL,
"registration_node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("registrant_external_id")
)
2020-11-01 14:52:30,637 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_registration_request"(
"node_group_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"status" CHAR(2) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"ip_address" VARCHAR(50) NOT NULL,
"attempt_count" INTEGER DEFAULT 0,
"registered_node_id" VARCHAR(50),
"error_message" TEXT,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("node_group_id", "external_id", "create_time")
)
2020-11-01 14:52:30,639 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2020-11-01 14:52:30,640 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2020-11-01 14:52:30,643 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_router"(
"router_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"router_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
"router_expression" TEXT,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"use_source_catalog_schema" SMALLINT DEFAULT 1 NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("router_id")
)
2020-11-01 14:52:30,648 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_sequence"(
"sequence_name" VARCHAR(50) NOT NULL,
"current_value" BIGINT DEFAULT 0 NOT NULL,
"increment_by" INTEGER DEFAULT 1 NOT NULL,
"min_value" BIGINT DEFAULT 1 NOT NULL,
"max_value" BIGINT DEFAULT 9999999999 NOT NULL,
"cycle_flag" SMALLINT DEFAULT 0,
"cache_size" INTEGER DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("sequence_name")
)
2020-11-01 14:52:30,651 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"create_table" SMALLINT DEFAULT 0 NOT NULL,
"delete_first" SMALLINT DEFAULT 0 NOT NULL,
"reload_select" TEXT,
"before_custom_sql" TEXT,
"reload_time" TIMESTAMP,
"load_id" BIGINT,
"processed" SMALLINT DEFAULT 0 NOT NULL,
"channel_id" VARCHAR(128),
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time")
)
2020-11-01 14:52:30,683 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_table_reload_status"(
"load_id" BIGINT NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"target_node_id" VARCHAR(50) NOT NULL,
"start_time" TIMESTAMP,
"end_time" TIMESTAMP,
"completed" SMALLINT DEFAULT 0 NOT NULL,
"cancelled" SMALLINT DEFAULT 0 NOT NULL,
"start_data_batch_id" BIGINT,
"end_data_batch_id" BIGINT,
"setup_batch_count" BIGINT DEFAULT 0 NOT NULL,
"data_batch_count" BIGINT DEFAULT 0 NOT NULL,
"finalize_batch_count" BIGINT DEFAULT 0 NOT NULL,
"setup_batch_loaded" BIGINT DEFAULT 0 NOT NULL,
"data_batch_loaded" BIGINT DEFAULT 0 NOT NULL,
"finalize_batch_loaded" BIGINT DEFAULT 0 NOT NULL,
"table_count" BIGINT DEFAULT 0 NOT NULL,
"rows_loaded" BIGINT DEFAULT 0 NOT NULL,
"rows_count" BIGINT DEFAULT 0 NOT NULL,
"error_flag" SMALLINT DEFAULT 0 NOT NULL,
"sql_state" VARCHAR(10),
"sql_code" INTEGER DEFAULT 0 NOT NULL,
"sql_message" TEXT,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("load_id", "source_node_id")
)
2020-11-01 14:52:30,686 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_transform_table"(
"transform_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"transform_point" VARCHAR(10) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"update_first" SMALLINT DEFAULT 0,
"update_action" VARCHAR(255) DEFAULT 'UPDATE_COL' NOT NULL,
"delete_action" VARCHAR(10) NOT NULL,
"transform_order" INTEGER DEFAULT 1 NOT NULL,
"column_policy" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
"description" TEXT,
PRIMARY KEY ("transform_id", "source_node_group_id", "target_node_group_id")
)
2020-11-01 14:52:30,693 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_transform_column"(
"transform_id" VARCHAR(50) NOT NULL,
"include_on" CHAR(1) DEFAULT '*' NOT NULL,
"target_column_name" VARCHAR(128) NOT NULL,
"source_column_name" VARCHAR(128),
"pk" SMALLINT DEFAULT 0,
"transform_type" VARCHAR(50) DEFAULT 'copy',
"transform_expression" TEXT,
"transform_order" INTEGER DEFAULT 1 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
"description" TEXT,
PRIMARY KEY ("transform_id", "include_on", "target_column_name")
)
2020-11-01 14:52:30,697 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'reload' NOT NULL,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_incoming_batch" SMALLINT DEFAULT 0 NOT NULL,
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"sync_on_update_condition" TEXT,
"sync_on_insert_condition" TEXT,
"sync_on_delete_condition" TEXT,
"custom_before_update_text" TEXT,
"custom_before_insert_text" TEXT,
"custom_before_delete_text" TEXT,
"custom_on_update_text" TEXT,
"custom_on_insert_text" TEXT,
"custom_on_delete_text" TEXT,
"external_select" TEXT,
"tx_id_expression" TEXT,
"channel_expression" TEXT,
"excluded_column_names" TEXT,
"included_column_names" TEXT,
"sync_key_names" TEXT,
"use_stream_lobs" SMALLINT DEFAULT 0 NOT NULL,
"use_capture_lobs" SMALLINT DEFAULT 0 NOT NULL,
"use_capture_old_data" SMALLINT DEFAULT 1 NOT NULL,
"use_handle_key_updates" SMALLINT DEFAULT 1 NOT NULL,
"stream_row" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id")
)
2020-11-01 14:52:30,699 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_trigger_hist"(
"trigger_hist_id" INTEGER NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"source_table_name" VARCHAR(255) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"table_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_row_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_template_hash" BIGINT DEFAULT 0 NOT NULL,
"column_names" TEXT NOT NULL,
"pk_column_names" TEXT NOT NULL,
"last_trigger_build_reason" CHAR(1) NOT NULL,
"error_message" TEXT,
"create_time" TIMESTAMP NOT NULL,
"inactive_time" TIMESTAMP,
PRIMARY KEY ("trigger_hist_id")
)
2020-11-01 14:52:30,700 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time")
2020-11-01 14:52:30,703 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_order" INTEGER DEFAULT 1 NOT NULL,
"initial_load_select" TEXT,
"initial_load_delete_stmt" TEXT,
"ping_back_enabled" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2020-11-01 14:52:30,705 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_trigger_router_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"applies_when" CHAR(1) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when")
)
2020-11-01 14:52:30,709 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2020-11-01 14:52:30,710 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2020-11-01 14:52:30,711 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2020-11-01 14:52:30,712 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2020-11-01 14:52:30,713 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2020-11-01 14:52:30,714 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2020-11-01 14:52:30,715 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_identity"
ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2020-11-01 14:52:30,716 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2020-11-01 14:52:30,717 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2020-11-01 14:52:30,719 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2020-11-01 14:52:30,721 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2020-11-01 14:52:30,722 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2020-11-01 14:52:30,723 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2020-11-01 14:52:30,724 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2020-11-01 14:52:30,725 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2020-11-01 14:52:30,727 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2020-11-01 14:52:30,731 INFO [store-002] [ClusterService] [symmetric-engine-startup-1] This node picked a server id of MyMac.local
2020-11-01 14:52:30,732 INFO [store-002] [TriggerRouterService] [symmetric-engine-startup-1] Synchronizing triggers
2020-11-01 14:52:30,755 INFO [store-002] [TriggerRouterService] [symmetric-engine-startup-1] Done synchronizing triggers
2020-11-01 14:52:30,756 INFO [store-002] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Done with auto update of SymmetricDS tables
2020-11-01 14:52:30,757 INFO [store-002] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring config channel
2020-11-01 14:52:30,764 INFO [store-002] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring reload channel
2020-11-01 14:52:30,766 INFO [store-002] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring monitor channel
2020-11-01 14:52:30,767 INFO [store-002] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring heartbeat channel
2020-11-01 14:52:30,769 INFO [store-002] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring default channel
2020-11-01 14:52:30,771 INFO [store-002] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring dynamic channel
2020-11-01 14:52:30,789 INFO [store-002] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Done initializing SymmetricDS database
2020-11-01 14:52:30,790 INFO [store-002] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS database version : null
2020-11-01 14:52:30,790 INFO [store-002] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS software version : 3.12.4
2020-11-01 14:52:30,823 INFO [store-002] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Starting unregistered node [group=store, externalId=store-002]
2020-11-01 14:52:30,834 INFO [store-002] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 5000ms with the first run at 2020-11-01T14:52:35.307-0800
2020-11-01 14:52:30,836 INFO [store-002] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 10000ms with the first run at 2020-11-01T14:52:35.310-0800
2020-11-01 14:52:30,836 INFO [store-002] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 10000ms with the first run at 2020-11-01T14:52:35.310-0800
2020-11-01 14:52:30,837 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start
2020-11-01 14:52:30,837 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start
2020-11-01 14:52:30,838 INFO [store-002] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 */4 * * *'
2020-11-01 14:52:30,839 INFO [store-002] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 */4 * * *'
2020-11-01 14:52:30,839 INFO [store-002] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2020-11-01 14:52:30,840 INFO [store-002] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2020-11-01 14:52:30,840 INFO [store-002] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at 2020-11-01T14:52:35.314-0800
2020-11-01 14:52:30,841 INFO [store-002] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at 2020-11-01T14:52:35.315-0800
2020-11-01 14:52:30,841 INFO [store-002] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2020-11-01 14:52:30,841 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start
2020-11-01 14:52:30,842 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start
2020-11-01 14:52:30,842 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start
2020-11-01 14:52:30,842 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start
2020-11-01 14:52:30,842 INFO [store-002] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at 2020-11-01T14:52:35.316-0800
2020-11-01 14:52:30,842 INFO [store-002] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at 2020-11-01T14:52:35.316-0800
2020-11-01 14:52:30,843 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start
2020-11-01 14:52:30,843 INFO [store-002] [JobManager] [symmetric-engine-startup-1] Job Log Miner not configured for auto start
2020-11-01 14:52:30,843 INFO [store-002] [InitialLoadJob] [symmetric-engine-startup-1] Starting Initial Load Queue on periodic schedule: every 10000ms with the first run at 2020-11-01T14:52:35.317-0800
2020-11-01 14:52:30,845 INFO [store-002] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED:
nodeId=store-002
groupId=store
type=server
subType=null
name=store-002
softwareVersion=3.12.4
databaseName=PostgreSQL
databaseVersion=12.3
driverName=PostgreSQL JDBC Driver
driverVersion=42.2.16
uptime=0 sec.
2020-11-01 14:52:35,314 INFO [store-002] [PushJob] [store-002-job-2] Did not run the 'Push' job because the engine is not registered.
2020-11-01 14:52:35,316 INFO [store-002] [RouterJob] [store-002-job-1] Did not run the 'Routing' job because the engine is not registered.
2020-11-01 14:52:35,317 INFO [store-002] [InitialLoadExtractorJob] [store-002-job-7] Did not run the 'Initial Load Extract' job because the engine is not registered.
2020-11-01 14:52:35,319 INFO [store-002] [InitialLoadJob] [store-002-job-8] Did not run the 'Initial Load Queue' job because the engine is not registered.
2020-11-01 14:52:35,319 INFO [store-002] [MonitorJob] [store-002-job-6] Did not run the 'Monitor' job because the engine is not registered.
2020-11-01 14:52:35,332 INFO [store-002] [RegistrationService] [store-002-job-3] This node is unregistered. It will attempt to register using the registration.url
2020-11-01 14:52:35,345 INFO [store-002] [DataLoaderService] [store-002-job-3] Using registration URL of http://10.0.1.132:8080/sync/corp-000/registration
2020-11-01 14:52:36,401 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-1] Grouplets flushed because new grouplet config came through the data loader
2020-11-01 14:52:36,402 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-1] Load filters flushed because new filter config came through the data loader
2020-11-01 14:52:36,402 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-1] Channels flushed because new channels came through the data loader
2020-11-01 14:52:36,402 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-1] About to refresh the cache of conflict settings because new configuration came through the data loader
2020-11-01 14:52:36,402 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-1] About to refresh the cache of parameters because new configuration came through the data loader
2020-11-01 14:52:36,412 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-1] About to refresh the cache of node security because new configuration came through the data loader
2020-11-01 14:52:36,413 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-job-3] About to refresh the cache of transformation because new configuration came through the data loader
2020-11-01 14:52:36,413 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-job-3] About to clear the staging area because new transform configuration came through the data loader
2020-11-01 14:52:36,413 INFO [store-002] [StagingManager] [store-002-job-3] Cleaning staging...
2020-11-01 14:52:36,415 INFO [store-002] [StagingManager] [store-002-job-3] Purged 1 staging files, freed 163 KB of disk space.
2020-11-01 14:52:36,415 INFO [store-002] [StagingManager] [store-002-job-3] Finished cleaning staging in 0 seconds.
2020-11-01 14:52:36,416 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-job-3] About to syncTriggers because new configuration came through the data loader
2020-11-01 14:52:36,416 INFO [store-002] [TriggerRouterService] [store-002-job-3] Synchronizing triggers
2020-11-01 14:52:36,433 INFO [store-002] [TriggerRouterService] [store-002-job-3] Done synchronizing triggers
2020-11-01 14:52:36,455 INFO [store-002] [RegistrationService] [store-002-job-3] Successfully registered node [id=store-002]
2020-11-01 14:52:36,476 INFO [store-002] [ExtensionService] [store-002-job-3] Found 0 extension points from the database that will be registered
2020-11-01 14:52:36,476 INFO [store-002] [ClientExtensionService] [store-002-job-3] Found 8 extension points from spring that will be registered
2020-11-01 14:52:36,476 INFO [store-002] [PushHeartbeatListener] [store-002-job-3] Some attribute(s) of node changed. Recording changes
2020-11-01 14:52:36,476 INFO [store-002] [PushHeartbeatListener] [store-002-job-3] Updating my node configuration info according to the symmetric properties
2020-11-01 14:52:36,484 INFO [store-002] [PullService] [store-002-job-3] Node store:store-002 just registered, not pulling yet
2020-11-01 14:52:40,327 INFO [store-002] [DataService] [store-002-job-9] Inserting missing last data gap: { startId: 1, endId: 50000001, createTime: "Sun Nov 01 14:52:40 PST 2020" }
2020-11-01 14:52:40,339 INFO [store-002] [DataGapFastDetector] [store-002-job-9] Full gap analysis is running
2020-11-01 14:52:40,340 INFO [store-002] [DataGapFastDetector] [store-002-job-9] Querying data in gaps from database took 1 ms
2020-11-01 14:52:40,341 INFO [store-002] [DataGapFastDetector] [store-002-job-9] Full gap analysis is done after 2 ms
2020-11-01 14:52:46,489 INFO [store-002] [NodeCommunicationService] [store-002-job-5] pull will use 10 threads
2020-11-01 14:52:49,465 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-2] About to refresh the cache of node security because new configuration came through the data loader
2020-11-01 14:52:49,469 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-2] About to refresh the cache of nodes because new configuration came through the data loader
2020-11-01 14:52:49,478 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,480 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."customer_customer_uid_seq";
CREATE TABLE "public"."customer"(
"customer_uid" INTEGER NOT NULL DEFAULT nextval('"public"."customer_customer_uid_seq"'),
"name" VARCHAR(1000) NOT NULL,
"address" VARCHAR(1000),
"city" VARCHAR(100),
"state" VARCHAR(100),
"zipcode" VARCHAR(16),
"customernumber" VARCHAR(30),
"taxnumber" VARCHAR(32),
"defunct" BOOLEAN DEFAULT 'false',
"id" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
"default_payment_type" INTEGER DEFAULT 1 NOT NULL,
"fts_vector" VARCHAR(10485760),
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("customer_uid")
);
2020-11-01 14:52:49,493 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,495 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."division_order_division_order_uid_seq";
CREATE TABLE "public"."division_order"(
"division_order_uid" INTEGER NOT NULL DEFAULT nextval('"public"."division_order_division_order_uid_seq"'),
"doc_id" VARCHAR(40),
"do_num" VARCHAR(100),
"lessee_id" INTEGER,
"well_name" VARCHAR(1000),
"ctnum" INTEGER,
"date_received" DATE,
"date_executed" DATE,
"date_paid_first" DATE,
"date_last_paid" DATE,
"file_location" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"do_status" INTEGER,
"customer_uid" INTEGER NOT NULL,
"date_effective" DATE,
"operator_uid" INTEGER,
"fts_vector" VARCHAR(10485760),
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("division_order_uid")
);
2020-11-01 14:52:49,508 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,511 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."legal_desc_div_legal_desc_div_uid_seq";
CREATE TABLE "public"."legal_desc_div"(
"legal_desc_div_uid" INTEGER NOT NULL DEFAULT nextval('"public"."legal_desc_div_legal_desc_div_uid_seq"'),
"tr_origin" VARCHAR(1000),
"tr_abstract" VARCHAR(1000),
"tr_section" INTEGER,
"tr_twnshp_num" INTEGER,
"tr_twnshp_drctn" VARCHAR(100),
"tr_range_num" INTEGER,
"tr_range_drctn" VARCHAR(500),
"tr_block" VARCHAR(20),
"tr_lot" VARCHAR(10),
"tr_desc" VARCHAR(10000000),
"tr_fractional" VARCHAR(1000),
"tr_decimal" NUMERIC(22,10),
"tr_gross_acres" NUMERIC(22,10),
"tr_net_acres" NUMERIC(22,10),
"tr_free_acres" NUMERIC(22,10),
"tr_well_name" VARCHAR(1000),
"tr_pdoc_id" VARCHAR(40),
"tr_notes" VARCHAR(10000000),
"tr_prod" BOOLEAN,
"tr_ctnum" INTEGER,
"tr_type" VARCHAR(10),
"tr_doc_id" VARCHAR(45),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"division_order_uid" INTEGER,
"certificate_number" VARCHAR(10),
"fts_vector" VARCHAR(10485760),
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("legal_desc_div_uid")
);
2020-11-01 14:52:49,523 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,526 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."rcpt_method_rcpt_method_uid_seq";
CREATE TABLE "public"."rcpt_method"(
"rcpt_method_uid" INTEGER NOT NULL DEFAULT nextval('"public"."rcpt_method_rcpt_method_uid_seq"'),
"rcpt_method_code" VARCHAR(25) NOT NULL,
"rcpt_method_name" VARCHAR(100) NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"rcpt_method_descr" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"rcpt_method_sortorder" VARCHAR(25) NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"gl_account" VARCHAR(25),
"rcpt_method_shortname" VARCHAR(30) NOT NULL,
PRIMARY KEY ("rcpt_method_uid")
);
2020-11-01 14:52:49,541 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,543 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."rcpt_hdr_rcpt_hdr_uid_seq";
CREATE TABLE "public"."rcpt_hdr"(
"rcpt_hdr_uid" INTEGER NOT NULL DEFAULT nextval('"public"."rcpt_hdr_rcpt_hdr_uid_seq"'),
"rcpt_date" DATE,
"rcpt_number" VARCHAR(20),
"rcpt_amt" NUMERIC(18,2),
"memo" VARCHAR(500),
"date_received" DATE,
"deposit_date" DATE,
"customer_uid" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"owner_number" VARCHAR(100),
"rcpt_method_uid" INTEGER,
"payee_id" INTEGER,
"fts_vector" VARCHAR(10485760),
"customer_owner_number_uid" INTEGER,
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("rcpt_hdr_uid")
);
2020-11-01 14:52:49,555 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,559 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."note_rcpt_hdr_note_rcpt_hdr_uid_seq";
CREATE TABLE "public"."note_rcpt_hdr"(
"note_rcpt_hdr_uid" INTEGER NOT NULL DEFAULT nextval('"public"."note_rcpt_hdr_note_rcpt_hdr_uid_seq"'),
"note_date" TIMESTAMP,
"note_text" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"rcpt_hdr_uid" INTEGER NOT NULL,
"fts_vector" VARCHAR(10485760),
PRIMARY KEY ("note_rcpt_hdr_uid")
);
2020-11-01 14:52:49,573 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,575 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."pmt_method_pmt_method_uid_seq";
CREATE TABLE "public"."pmt_method"(
"pmt_method_uid" INTEGER NOT NULL DEFAULT nextval('"public"."pmt_method_pmt_method_uid_seq"'),
"pmt_method_code" VARCHAR(100),
"pmt_method_name" VARCHAR(100),
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"notes" VARCHAR(10485760),
"deadfiled" BOOLEAN NOT NULL,
"sort_order" VARCHAR(25),
"required" BOOLEAN,
PRIMARY KEY ("pmt_method_uid")
);
2020-11-01 14:52:49,586 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,588 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."pmt_hdr_pmt_hdr_uid_seq";
CREATE TABLE "public"."pmt_hdr"(
"pmt_hdr_uid" INTEGER NOT NULL DEFAULT nextval('"public"."pmt_hdr_pmt_hdr_uid_seq"'),
"pmt_date" DATE,
"pmt_number" VARCHAR(20),
"pmt_amt" NUMERIC(18,2),
"memo" VARCHAR(500),
"date_received" DATE,
"deposit_date" DATE,
"customer_uid" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"owner_number" VARCHAR(100),
"pmt_method_uid" INTEGER,
PRIMARY KEY ("pmt_hdr_uid")
);
2020-11-01 14:52:49,600 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,602 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."well_well_uid_seq";
CREATE TABLE "public"."well"(
"well_uid" INTEGER NOT NULL DEFAULT nextval('"public"."well_well_uid_seq"'),
"doc_id" VARCHAR(40),
"well_number" VARCHAR(100),
"well_name" VARCHAR(1000),
"ctnum" INTEGER,
"date_spudded_in" DATE,
"date_paid_first" DATE,
"date_last_paid" DATE,
"file_location" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"well_status" INTEGER,
"operator_uid" INTEGER,
"latitude" VARCHAR(50),
"longitude" VARCHAR(50),
"utm" VARCHAR(100),
"fts_vector" VARCHAR(10485760),
"state_no" VARCHAR(100),
"well_status_code" VARCHAR(100) NOT NULL,
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("well_uid")
);
2020-11-01 14:52:49,617 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,619 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."legal_desc_well_legal_desc_well_uid_seq";
CREATE TABLE "public"."legal_desc_well"(
"legal_desc_well_uid" INTEGER NOT NULL DEFAULT nextval('"public"."legal_desc_well_legal_desc_well_uid_seq"'),
"tr_origin" VARCHAR(1000),
"tr_abstract" VARCHAR(1000),
"tr_section" INTEGER,
"tr_twnshp_num" INTEGER,
"tr_twnshp_drctn" VARCHAR(100),
"tr_range_num" INTEGER,
"tr_range_drctn" VARCHAR(500),
"tr_block" VARCHAR(20),
"tr_lot" VARCHAR(10),
"tr_desc" VARCHAR(10000000),
"tr_fractional" VARCHAR(1000),
"tr_decimal" NUMERIC(22,10),
"tr_gross_acres" NUMERIC(22,10),
"tr_net_acres" NUMERIC(22,10),
"tr_free_acres" NUMERIC(22,10),
"tr_well_name" VARCHAR(1000),
"tr_pdoc_id" VARCHAR(40),
"tr_notes" VARCHAR(10000000),
"tr_prod" BOOLEAN,
"tr_ctnum" INTEGER,
"tr_type" VARCHAR(10),
"tr_doc_id" VARCHAR(45),
"de_dt" TIMESTAMP DEFAULT 'now()' NOT NULL,
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"well_uid" INTEGER NOT NULL,
"certificate_number" VARCHAR(10),
"fts_vector" VARCHAR(10485760),
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("legal_desc_well_uid")
);
2020-11-01 14:52:49,632 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,634 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."note_well_note_well_uid_seq";
CREATE TABLE "public"."note_well"(
"note_well_uid" INTEGER NOT NULL DEFAULT nextval('"public"."note_well_note_well_uid_seq"'),
"note_date" TIMESTAMP,
"note_text" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"well_uid" INTEGER NOT NULL,
"fts_vector" VARCHAR(10485760),
PRIMARY KEY ("note_well_uid")
);
2020-11-01 14:52:49,648 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,650 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_check_detail_ccd_uid_seq";
CREATE TABLE "public"."cdex_check_detail"(
"ccd_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_check_detail_ccd_uid_seq"'),
"record_type" VARCHAR(1),
"company_code" VARCHAR(2),
"check_number" VARCHAR(50),
"property_lease_code" VARCHAR(14),
"product_code" VARCHAR(2),
"transaction_code1" VARCHAR(2),
"lease_gross_volume" VARCHAR(12),
"lease_gross_sev_tax" VARCHAR(9),
"lease_net_value" VARCHAR(12),
"owner_share_lease_net_value" VARCHAR(12),
"transaction_code2" VARCHAR(2),
"lease_gross_value" VARCHAR(12),
"owner_share_lease_gross_value" VARCHAR(12),
"transmission_date" VARCHAR(3),
"type_of_interest" VARCHAR(1),
"decimal_flag" VARCHAR(1),
"decimal_interest" VARCHAR(9),
"btu_factor" VARCHAR(4),
"blank" VARCHAR(2),
"full_company_code" VARCHAR(4),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" INTEGER,
"processed_dt" TIMESTAMP,
"ccs_uid" INTEGER,
"from_production_date" DATE,
"production_date" DATE,
PRIMARY KEY ("ccd_uid")
);
2020-11-01 14:52:49,661 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,663 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_check_summary_ccs_uid_seq";
CREATE TABLE "public"."cdex_check_summary"(
"ccs_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_check_summary_ccs_uid_seq"'),
"record_type" VARCHAR(1),
"company_code" VARCHAR(2),
"check_number" VARCHAR(50),
"record_count" VARCHAR(4),
"actual_check_amount" VARCHAR(12),
"net_out_flag" VARCHAR(1),
"payment_flag" VARCHAR(1),
"effective_date" VARCHAR(4),
"lease_gross_volume_hash_total" VARCHAR(13),
"lease_gross_sev_tax_hash_total" VARCHAR(10),
"lease_net_value_hash_total" VARCHAR(13),
"owner_share_lease_net_hash_total" VARCHAR(13),
"lease_gross_value_hash_total" VARCHAR(13),
"owner_share_lease_gross_value_hash_total" VARCHAR(13),
"transmission_date" VARCHAR(3),
"owner_number" VARCHAR(12),
"blank" VARCHAR(5),
"full_company_code" VARCHAR(4),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" INTEGER,
"processed_dt" TIMESTAMP,
"file_name" VARCHAR(100),
"raw_data" VARCHAR(10485760),
"cdd_uid" INTEGER,
"check_year" CHAR(4),
PRIMARY KEY ("ccs_uid")
);
2020-11-01 14:52:49,678 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,680 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."doc_type_doc_type_uid_seq";
CREATE TABLE "public"."doc_type"(
"doc_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."doc_type_doc_type_uid_seq"'),
"doc_type_code" VARCHAR(25) NOT NULL,
"doc_type_descr" VARCHAR(10485760) NOT NULL,
"doc_type_shortname" VARCHAR(30) NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"doc_type_name" VARCHAR(100) NOT NULL,
"doc_type_sortorder" VARCHAR(25) NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"usage" VARCHAR(255),
PRIMARY KEY ("doc_type_uid")
);
2020-11-01 14:52:49,691 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,696 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."legal_title_legal_title_uid_seq";
CREATE TABLE "public"."legal_title"(
"legal_title_uid" INTEGER NOT NULL DEFAULT nextval('"public"."legal_title_legal_title_uid_seq"'),
"ttl_code" VARCHAR(50),
"ttl_desc" VARCHAR(10000000),
"ttl_type" VARCHAR(10),
"ttl_cnty_num" INTEGER,
"ttl_interest" NUMERIC(22,10),
"ttl_gross_acres" NUMERIC(22,10),
"ttl_net_acres" NUMERIC(22,10),
"ttl_grantor" VARCHAR(10000000),
"ttl_grantee" VARCHAR(10000000),
"ttl_grant_date" DATE,
"ttl_proofed" BOOLEAN,
"ttl_notorized" BOOLEAN,
"ttl_mailed" BOOLEAN,
"ttl_received" BOOLEAN,
"ttl_recorded" BOOLEAN,
"ttl_doc_id" VARCHAR(40) NOT NULL,
"ttl_file_location" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"ctnum" INTEGER,
"ttl_fractional" VARCHAR(1000),
"ttl_book_num" VARCHAR(50),
"ttl_book_page_num" VARCHAR(50),
"grantor_uid" INTEGER DEFAULT 0 NOT NULL,
"grantee_uid" INTEGER DEFAULT 0 NOT NULL,
"ttl_date_recorded" DATE,
"fts_vector" VARCHAR(10485760),
"tgm_vector" VARCHAR(10485760),
"instrument_number" VARCHAR(50) NOT NULL,
"doc_type_uid" INTEGER,
PRIMARY KEY ("legal_title_uid")
);
2020-11-01 14:52:49,707 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,710 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."legal_desc_title_legal_desc_title_uid_seq";
CREATE TABLE "public"."legal_desc_title"(
"legal_desc_title_uid" INTEGER NOT NULL DEFAULT nextval('"public"."legal_desc_title_legal_desc_title_uid_seq"'),
"tr_origin" VARCHAR(1000),
"tr_abstract" VARCHAR(1000),
"tr_section" INTEGER,
"tr_twnshp_num" INTEGER,
"tr_twnshp_drctn" VARCHAR(100),
"tr_range_num" INTEGER,
"tr_range_drctn" VARCHAR(500),
"tr_block" VARCHAR(20),
"tr_lot" VARCHAR(10),
"tr_desc" VARCHAR(10000000),
"tr_fractional" VARCHAR(1000),
"tr_decimal" NUMERIC(22,10),
"tr_gross_acres" NUMERIC(22,10),
"tr_net_acres" NUMERIC(22,10),
"tr_free_acres" NUMERIC(22,10),
"tr_well_name" VARCHAR(1000),
"tr_pdoc_id" VARCHAR(40),
"tr_notes" VARCHAR(10000000),
"tr_prod" BOOLEAN,
"tr_ctnum" INTEGER,
"tr_type" VARCHAR(10),
"tr_doc_id" VARCHAR(45),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"legal_title_uid" INTEGER NOT NULL,
"certificate_number" VARCHAR(10),
"fts_vector" VARCHAR(10485760),
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("legal_desc_title_uid")
);
2020-11-01 14:52:49,719 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,721 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."division_title_division_title_uid_seq";
CREATE TABLE "public"."division_title"(
"division_title_uid" INTEGER NOT NULL DEFAULT nextval('"public"."division_title_division_title_uid_seq"'),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"legal_desc_div_uid" INTEGER,
"legal_desc_title_uid" INTEGER,
PRIMARY KEY ("division_title_uid")
);
2020-11-01 14:52:49,732 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,734 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."document_doc_uid_seq";
CREATE TABLE "public"."document"(
"doc_uid" INTEGER NOT NULL DEFAULT nextval('"public"."document_doc_uid_seq"'),
"repository_file_name" TEXT DEFAULT 'uuid_generate_v4()' NOT NULL,
"source_file_name" VARCHAR(500),
"file_modifed_date" DATE,
"file_created_date" DATE,
"file_comment" VARCHAR(2000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"repository_path_name" VARCHAR(500),
PRIMARY KEY ("doc_uid")
);
2020-11-01 14:52:49,743 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,744 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."document_title"(
"doc_uid" INTEGER NOT NULL,
"legal_title_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("doc_uid", "legal_title_uid")
);
2020-11-01 14:52:49,753 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,754 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."doc_option_doc_option_uid_seq";
CREATE TABLE "public"."doc_option"(
"doc_option_uid" INTEGER NOT NULL DEFAULT nextval('"public"."doc_option_doc_option_uid_seq"'),
"doc_option_type_uid" INTEGER NOT NULL,
"doc_option_desc" VARCHAR(200),
"doc_option_table" VARCHAR(200) NOT NULL,
"doc_option_table_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP,
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"doc_option_name" VARCHAR(100) NOT NULL,
PRIMARY KEY ("doc_option_uid")
);
2020-11-01 14:52:49,764 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,765 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."well_title_well_title_uid_seq";
CREATE TABLE "public"."well_title"(
"well_title_uid" INTEGER NOT NULL DEFAULT nextval('"public"."well_title_well_title_uid_seq"'),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"legal_desc_title_uid" INTEGER NOT NULL,
"legal_desc_well_uid" INTEGER NOT NULL,
PRIMARY KEY ("well_title_uid")
);
2020-11-01 14:52:49,774 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,777 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_new_property_np_uid_seq";
CREATE TABLE "public"."cdex_new_property"(
"np_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_new_property_np_uid_seq"'),
"record_type" VARCHAR(1),
"company_code" VARCHAR(2),
"property_number" VARCHAR(14),
"property_name" VARCHAR(40),
"operator_name" VARCHAR(20),
"state_code" VARCHAR(2),
"county_code" VARCHAR(3),
"decimal_interest" VARCHAR(9),
"type_of_interest" VARCHAR(1),
"lease_description" VARCHAR(37),
"transmission_date" VARCHAR(3),
"blank" VARCHAR(4),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" INTEGER,
"processed_dt" TIMESTAMP,
PRIMARY KEY ("np_uid")
);
2020-11-01 14:52:49,788 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,789 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_transaction_code_cdex_transaction_code_uid_seq";
CREATE TABLE "public"."cdex_transaction_code"(
"cdex_transaction_code_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_transaction_code_cdex_transaction_code_uid_seq"'),
"code" VARCHAR(10) NOT NULL,
"short_name" VARCHAR(40) NOT NULL,
"full_name" VARCHAR(100) NOT NULL,
"sort_order" VARCHAR(10) NOT NULL,
"default_value" VARCHAR(100) NOT NULL,
"notes" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
PRIMARY KEY ("cdex_transaction_code_uid")
);
2020-11-01 14:52:49,799 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,801 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."customer_owner_number_customer_owner_number_uid_seq";
CREATE TABLE "public"."customer_owner_number"(
"owner_number" VARCHAR(100) NOT NULL,
"customer_uid" INTEGER NOT NULL,
"date_first_paid" DATE,
"date_last_paid" DATE,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"payee_customer_uid" INTEGER DEFAULT 0 NOT NULL,
"customer_owner_number_uid" INTEGER NOT NULL DEFAULT nextval('"public"."customer_owner_number_customer_owner_number_uid_seq"'),
PRIMARY KEY ("owner_number", "customer_uid")
);
2020-11-01 14:52:49,810 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,813 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_transmission_summary_ts_uid_seq";
CREATE TABLE "public"."cdex_transmission_summary"(
"ts_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_transmission_summary_ts_uid_seq"'),
"record_type" VARCHAR(1),
"check_count" VARCHAR(5),
"check_total" VARCHAR(14),
"blank" VARCHAR(116),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" INTEGER,
"processed_dt" TIMESTAMP,
PRIMARY KEY ("ts_uid")
);
2020-11-01 14:52:49,823 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,824 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."user_label"(
"db_column_name" VARCHAR(150) NOT NULL,
"label_text" VARCHAR(300),
"description" VARCHAR(1000),
"language" VARCHAR(10) DEFAULT 'en' NOT NULL,
PRIMARY KEY ("db_column_name")
);
2020-11-01 14:52:49,833 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,834 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."document_receipt"(
"doc_uid" INTEGER NOT NULL,
"rcpt_hdr_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("doc_uid", "rcpt_hdr_uid")
);
2020-11-01 14:52:49,844 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,846 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_state_code_cdex_state_code_uid_seq";
CREATE TABLE "public"."cdex_state_code"(
"cdex_state_code_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_state_code_cdex_state_code_uid_seq"'),
"code" VARCHAR(10) NOT NULL,
"short_name" VARCHAR(40) NOT NULL,
"full_name" VARCHAR(100) NOT NULL,
"sort_order" VARCHAR(10) NOT NULL,
"default_value" VARCHAR(100) NOT NULL,
"notes" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
PRIMARY KEY ("cdex_state_code_uid")
);
2020-11-01 14:52:49,855 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,858 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."product_type_product_type_uid_seq";
CREATE TABLE "public"."product_type"(
"product_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."product_type_product_type_uid_seq"'),
"product_type_code" VARCHAR(25) NOT NULL,
"product_type_name" VARCHAR(100) NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"product_type_descr" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"default_unit_type_uid" INTEGER,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"default_unit_type_code" VARCHAR(25) NOT NULL,
"product_type_sortorder" VARCHAR(25) NOT NULL,
"product_type_shortname" VARCHAR(30) NOT NULL,
PRIMARY KEY ("product_type_uid")
);
2020-11-01 14:52:49,871 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,873 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."rcpt_type_rcpt_type_uid_seq";
CREATE TABLE "public"."rcpt_type"(
"rcpt_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."rcpt_type_rcpt_type_uid_seq"'),
"rcpt_type_code" VARCHAR(25) NOT NULL,
"rcpt_type_name" VARCHAR(100) NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"rcpt_type_descr" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"rcpt_type_sortorder" VARCHAR(25) NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"rcpt_type_editor" VARCHAR(250),
"rcpt_type_shortname" VARCHAR(30) NOT NULL,
PRIMARY KEY ("rcpt_type_uid")
);
2020-11-01 14:52:49,883 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,885 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."rcpt_dist_rcpt_dist_uid_seq";
CREATE TABLE "public"."rcpt_dist"(
"rcpt_dist_uid" INTEGER NOT NULL DEFAULT nextval('"public"."rcpt_dist_rcpt_dist_uid_seq"'),
"product_type_uid" INTEGER,
"sale_quantity" NUMERIC(22,10),
"sale_unit_price" NUMERIC(22,10),
"unit_type_uid" INTEGER,
"sale_gross_amt" NUMERIC(22,10),
"sale_net_amt" NUMERIC(22,10),
"decimal_interest" NUMERIC(22,10),
"owner_net_amt" NUMERIC(22,10),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"rcpt_hdr_uid" INTEGER,
"gl_account" VARCHAR(25),
"well_uid" INTEGER,
"division_order_uid" INTEGER,
"rcpt_type_uid" INTEGER,
"description" VARCHAR(1000),
"lease_uid" INTEGER,
"from_date" VARCHAR(8),
"to_date" VARCHAR(8),
PRIMARY KEY ("rcpt_dist_uid")
);
2020-11-01 14:52:49,900 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,901 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."rcpt_distribution_type_rcpt_distribution_type_uid_seq";
CREATE TABLE "public"."rcpt_distribution_type"(
"rcpt_distribution_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."rcpt_distribution_type_rcpt_distribution_type_uid_seq"'),
"rcpt_distribution_type_code" VARCHAR(25) NOT NULL,
"rcpt_distribution_type_name" VARCHAR(100) NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"rcpt_distribution_type_descr" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"rcpt_distribution_type_sortorder" VARCHAR(25) NOT NULL,
"gl_account" VARCHAR(25),
"rcpt_distribution_type_shortname" VARCHAR(30) NOT NULL,
PRIMARY KEY ("rcpt_distribution_type_uid")
);
2020-11-01 14:52:49,911 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,913 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."rcpt_dist_detail_rcpt_dist_detail_uid_seq";
CREATE TABLE "public"."rcpt_dist_detail"(
"rcpt_dist_detail_uid" INTEGER NOT NULL DEFAULT nextval('"public"."rcpt_dist_detail_rcpt_dist_detail_uid_seq"'),
"sale_amt" NUMERIC(22,10),
"owner_amt" NUMERIC(22,10),
"gl_account" VARCHAR(25),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN NOT NULL,
"rcpt_dist_uid" INTEGER NOT NULL,
"rcpt_distribution_type_uid" INTEGER NOT NULL,
"imported" BOOLEAN DEFAULT 'false',
PRIMARY KEY ("rcpt_dist_detail_uid")
);
2020-11-01 14:52:49,922 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,924 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."document_division_order"(
"doc_uid" INTEGER NOT NULL,
"division_order_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("doc_uid", "division_order_uid")
);
2020-11-01 14:52:49,932 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,933 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."lease_term_unit_lease_term_unit_uid_seq";
CREATE TABLE "public"."lease_term_unit"(
"lease_term_unit_uid" INTEGER NOT NULL DEFAULT nextval('"public"."lease_term_unit_lease_term_unit_uid_seq"'),
"unit" VARCHAR(200) NOT NULL,
"lease_term_unit_sort_order" VARCHAR(25) NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()' NOT NULL,
"de_usr" INTEGER NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" VARCHAR(25),
PRIMARY KEY ("lease_term_unit_uid")
);
2020-11-01 14:52:49,943 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,946 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."meridian_meridian_uid_seq";
CREATE TABLE "public"."meridian"(
"meridian_uid" INTEGER NOT NULL DEFAULT nextval('"public"."meridian_meridian_uid_seq"'),
"m_name" VARCHAR(200) NOT NULL,
"baseline" VARCHAR(100),
"year_established" INTEGER,
"initial_point" VARCHAR(50),
"utm" VARCHAR(25),
"deadfiled" BOOLEAN,
PRIMARY KEY ("meridian_uid")
);
2020-11-01 14:52:49,955 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,957 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."report_parameters_report_parameters_uid_seq";
CREATE TABLE "public"."report_parameters"(
"report_parameters_uid" INTEGER NOT NULL DEFAULT nextval('"public"."report_parameters_report_parameters_uid_seq"'),
"report_category" VARCHAR(300) DEFAULT 'New Reports' NOT NULL,
"report_name" VARCHAR(300) DEFAULT 'new report' NOT NULL,
"report_desc" VARCHAR(2000),
"report_class" VARCHAR(250),
"parameter_class" VARCHAR(250),
"data_class" VARCHAR(250),
"report_method" VARCHAR(250),
"report_title" VARCHAR(600),
"report_sub_title" VARCHAR(1000),
"starting_step" INTEGER DEFAULT 1 NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
PRIMARY KEY ("report_parameters_uid")
);
2020-11-01 14:52:49,972 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,975 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."unit_type_unit_type_uid_seq";
CREATE TABLE "public"."unit_type"(
"unit_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."unit_type_unit_type_uid_seq"'),
"unit_type_code" VARCHAR(25) NOT NULL,
"unit_type_name" VARCHAR(100) NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"unit_type_descr" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"unit_type_shortname" VARCHAR(30) NOT NULL,
"unit_type_sortorder" VARCHAR(25) NOT NULL,
PRIMARY KEY ("unit_type_uid")
);
2020-11-01 14:52:49,987 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:49,989 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."pmt_distribution_type_pmt_dist_type_uid_seq";
CREATE TABLE "public"."pmt_distribution_type"(
"pmt_dist_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."pmt_distribution_type_pmt_dist_type_uid_seq"'),
"pmt_dist_type_code" VARCHAR(100),
"pmt_dist_type_name" VARCHAR(100),
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"notes" VARCHAR(10485760),
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"sort_order" VARCHAR(25),
"gl_account" VARCHAR(25),
PRIMARY KEY ("pmt_dist_type_uid")
);
2020-11-01 14:52:50,002 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,004 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."customer_distribution_type"(
"customer_uid" INTEGER NOT NULL,
"pmt_dist_type_uid" INTEGER NOT NULL,
PRIMARY KEY ("customer_uid", "pmt_dist_type_uid")
);
2020-11-01 14:52:50,013 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,015 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."lease_lease_uid_seq";
CREATE TABLE "public"."lease"(
"lease_uid" INTEGER NOT NULL DEFAULT nextval('"public"."lease_lease_uid_seq"'),
"doc_id" VARCHAR(40),
"lessee_id" INTEGER,
"lease_type" VARCHAR(10000000),
"lease_description" VARCHAR(10000000),
"lease_name" VARCHAR(1000),
"ctnum" INTEGER,
"date_received" DATE,
"date_executed" DATE,
"term_years" INTEGER,
"term_interest_fractional" VARCHAR(10000000),
"term_acre_rental" NUMERIC(18,2),
"term_net_acre" NUMERIC(22,10),
"term_bonus" NUMERIC(22,10),
"lease_status" INTEGER NOT NULL,
"check_num" VARCHAR(10000000),
"check_amt" NUMERIC(22,2),
"date_deposited" DATE,
"file_location" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"customer_uid" INTEGER NOT NULL,
"date_effective" DATE,
"term_interest_decimal" NUMERIC(22,10),
"gross_net_ind" BOOLEAN DEFAULT 'true' NOT NULL,
"date_first_pmt" DATE,
"date_last_pmt" DATE,
"date_released" DATE,
"depth_min" INTEGER,
"depth_max" INTEGER,
"fts_vector" VARCHAR(10485760),
"lessor_id" INTEGER,
"lease_term_unit_uid" INTEGER DEFAULT 0 NOT NULL,
"gross_net" INTEGER,
"term_acre_bonus" NUMERIC(22,10),
"tgm_vector" VARCHAR(10485760),
"doc_type_uid" INTEGER,
"last_payor_uid" INTEGER,
PRIMARY KEY ("lease_uid")
);
2020-11-01 14:52:50,027 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,030 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."document_lease"(
"doc_uid" INTEGER NOT NULL,
"lease_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("doc_uid", "lease_uid")
);
2020-11-01 14:52:50,039 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,041 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_html_contacts_chc_uid_seq";
CREATE TABLE "public"."cdex_html_contacts"(
"chc_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_html_contacts_chc_uid_seq"'),
"company" VARCHAR(100),
"contact" VARCHAR(100),
"phone" VARCHAR(20),
"email" VARCHAR(50),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" BIGINT,
"dm_dt" TIMESTAMP,
"dm_usr" BIGINT,
"processed" SMALLINT,
"processed_dt" TIMESTAMP,
"cdd_uid" INTEGER,
PRIMARY KEY ("chc_uid")
);
2020-11-01 14:52:50,050 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,053 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."note_division_order_note_division_order_uid_seq";
CREATE TABLE "public"."note_division_order"(
"note_division_order_uid" INTEGER NOT NULL DEFAULT nextval('"public"."note_division_order_note_division_order_uid_seq"'),
"note_date" TIMESTAMP,
"note_text" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"division_order_uid" INTEGER NOT NULL,
"fts_vector" VARCHAR(10485760),
PRIMARY KEY ("note_division_order_uid")
);
2020-11-01 14:52:50,063 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,065 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."note_lease_note_lease_uid_seq";
CREATE TABLE "public"."note_lease"(
"note_lease_uid" INTEGER NOT NULL DEFAULT nextval('"public"."note_lease_note_lease_uid_seq"'),
"note_date" TIMESTAMP,
"note_text" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"lease_uid" INTEGER NOT NULL,
"fts_vector" VARCHAR(10485760),
PRIMARY KEY ("note_lease_uid")
);
2020-11-01 14:52:50,078 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,081 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."pmt_type_pmt_type_uid_seq";
CREATE TABLE "public"."pmt_type"(
"pmt_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."pmt_type_pmt_type_uid_seq"'),
"pmt_type_code" VARCHAR(100),
"pmt_type_name" VARCHAR(100),
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
"notes" VARCHAR(10485760),
"deadfiled" BOOLEAN NOT NULL,
"sort_order" VARCHAR(25),
"required" BOOLEAN DEFAULT 'false' NOT NULL,
PRIMARY KEY ("pmt_type_uid")
);
2020-11-01 14:52:50,092 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,095 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."pmt_dist_pmt_dist_uid_seq";
CREATE TABLE "public"."pmt_dist"(
"pmt_dist_uid" INTEGER NOT NULL DEFAULT nextval('"public"."pmt_dist_pmt_dist_uid_seq"'),
"product_type_uid" INTEGER,
"sale_quantity" NUMERIC(22,10),
"sale_unit_price" NUMERIC(22,10),
"unit_type_uid" INTEGER,
"sale_gross_amt" NUMERIC(22,10),
"sale_net_amt" NUMERIC(22,10),
"decimal_interest" NUMERIC(22,10),
"owner_net_amt" NUMERIC(22,10),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"pmt_hdr_uid" INTEGER,
"gl_account" VARCHAR(25),
"well_uid" INTEGER,
"division_order_uid" INTEGER,
"pmt_type_uid" INTEGER,
"description" VARCHAR(1000),
"lease_uid" INTEGER,
PRIMARY KEY ("pmt_dist_uid")
);
2020-11-01 14:52:50,106 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,108 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."pmt_dist_detail_pmt_dist_detail_uid_seq";
CREATE TABLE "public"."pmt_dist_detail"(
"pmt_dist_detail_uid" INTEGER NOT NULL DEFAULT nextval('"public"."pmt_dist_detail_pmt_dist_detail_uid_seq"'),
"sale_amt" NUMERIC(22,10),
"owner_amt" NUMERIC(22,10),
"gl_account" VARCHAR(25),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN NOT NULL,
"pmt_dist_uid" INTEGER NOT NULL,
"pmt_dist_type_uid" INTEGER NOT NULL,
PRIMARY KEY ("pmt_dist_detail_uid")
);
2020-11-01 14:52:50,121 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,123 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."meta_column_meta_column_uid_seq";
CREATE TABLE "public"."meta_column"(
"meta_column_uid" INTEGER NOT NULL DEFAULT nextval('"public"."meta_column_meta_column_uid_seq"'),
"usage_type" VARCHAR(50) NOT NULL,
"usage" VARCHAR(50) NOT NULL,
"parent_tablename" VARCHAR(50) NOT NULL,
"parent_columnname" VARCHAR(50) NOT NULL,
"display_name" VARCHAR(100) NOT NULL,
"display_width" SMALLINT,
"mandatory_for_import" SMALLINT DEFAULT 0 NOT NULL,
"description" VARCHAR(1024) NOT NULL,
"tooltip_text" VARCHAR(1024) NOT NULL,
"dev_description" VARCHAR(1024) NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER DEFAULT 0 NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("meta_column_uid")
);
2020-11-01 14:52:50,132 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,135 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."saved_layout_saved_layout_uid_seq";
CREATE TABLE "public"."saved_layout"(
"saved_layout_uid" INTEGER NOT NULL DEFAULT nextval('"public"."saved_layout_saved_layout_uid_seq"'),
"usage_type" VARCHAR(50) NOT NULL,
"usage" VARCHAR(50) NOT NULL,
"name" VARCHAR(100) NOT NULL,
"description" VARCHAR(1024) NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER DEFAULT 0 NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("saved_layout_uid")
);
2020-11-01 14:52:50,146 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,147 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."saved_layout_meta_column_link_s_layout_meta_column_link_uid_seq";
CREATE TABLE "public"."saved_layout_meta_column_link"(
"saved_layout_meta_column_link_uid" INTEGER NOT NULL DEFAULT nextval('"public"."saved_layout_meta_column_link_s_layout_meta_column_link_uid_seq"'),
"saved_layout_uid" INTEGER NOT NULL,
"meta_column_uid" INTEGER NOT NULL,
"column_number_in_list" INTEGER DEFAULT 0 NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER DEFAULT 0 NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("saved_layout_meta_column_link_uid")
);
2020-11-01 14:52:50,157 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,159 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."sasm_dev_sasm_id_seq";
CREATE TABLE "public"."sasm_dev"(
"sasm_id" INTEGER NOT NULL DEFAULT nextval('"public"."sasm_dev_sasm_id_seq"'),
"the_script" VARCHAR(10485760),
"sort_order" VARCHAR(16),
"version_number" INTEGER,
PRIMARY KEY ("sasm_id")
);
2020-11-01 14:52:50,172 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,173 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_payment_type_cdex_payment_type_uid_seq";
CREATE TABLE "public"."cdex_payment_type"(
"cdex_payment_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_payment_type_cdex_payment_type_uid_seq"'),
"code" VARCHAR(10) NOT NULL,
"short_name" VARCHAR(40) NOT NULL,
"full_name" VARCHAR(100) NOT NULL,
"sort_order" VARCHAR(10) NOT NULL,
"default_value" VARCHAR(100) NOT NULL,
"notes" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
PRIMARY KEY ("cdex_payment_type_uid")
);
2020-11-01 14:52:50,184 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,185 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_html_check_header_cdd_uid_seq";
CREATE TABLE "public"."cdex_html_check_header"(
"cdd_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_html_check_header_cdd_uid_seq"'),
"date_time" VARCHAR(30),
"file_name" VARCHAR(100),
"number_of_checks" INTEGER,
"number_of_total_lines" INTEGER,
"number_of_billable_lines" INTEGER,
"total_amount" NUMERIC(15,2),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" SMALLINT,
"processed_dt" TIMESTAMP,
"raw_html" VARCHAR(10485760),
"raw_csv" VARCHAR(10485760),
"batch_num" INTEGER,
PRIMARY KEY ("cdd_uid")
);
2020-11-01 14:52:50,198 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,200 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."contact_type_contact_type_uid_seq";
CREATE TABLE "public"."contact_type"(
"contact_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."contact_type_contact_type_uid_seq"'),
"contact_type_name" VARCHAR(200) NOT NULL,
"contact_type_sortorder" VARCHAR(25) NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()' NOT NULL,
"de_usr" INTEGER NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" VARCHAR(25),
"contact_type_code" VARCHAR(25) NOT NULL,
"contact_type_shortname" VARCHAR(30) NOT NULL,
"contact_type_descr" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
PRIMARY KEY ("contact_type_uid")
);
2020-11-01 14:52:50,244 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,247 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."contact_contact_uid_seq";
CREATE TABLE "public"."contact"(
"contact_uid" INTEGER NOT NULL DEFAULT nextval('"public"."contact_contact_uid_seq"'),
"cn_name" VARCHAR(10000000),
"cn_method" VARCHAR(100),
"cn_value" VARCHAR(10000000),
"cn_id" INTEGER,
"customer_id" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"customer_uid" INTEGER NOT NULL,
"contact_type_uid" INTEGER,
PRIMARY KEY ("contact_uid")
);
2020-11-01 14:52:50,257 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,259 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."lease_rental_lease_rental_uid_seq";
CREATE TABLE "public"."lease_rental"(
"lease_rental_uid" INTEGER NOT NULL DEFAULT nextval('"public"."lease_rental_lease_rental_uid_seq"'),
"date_due" DATE,
"date_paid" DATE,
"amount_due" NUMERIC(22,10),
"amount_paid" NUMERIC(18,6),
"customer_uid" INTEGER NOT NULL,
"lease_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
"pmt_hdr_uid" INTEGER,
"rcpt_hdr_uid" INTEGER,
PRIMARY KEY ("lease_rental_uid")
);
2020-11-01 14:52:50,273 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,274 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."user_mod_name_user_mod_name_uid_seq";
CREATE TABLE "public"."user_mod_name"(
"user_mod_name_uid" INTEGER NOT NULL DEFAULT nextval('"public"."user_mod_name_user_mod_name_uid_seq"'),
"umn_name" VARCHAR(500),
"umn_category" VARCHAR(100),
"umn_short_name" VARCHAR(100),
"umn_sort_order" VARCHAR(100),
"umn_active" BOOLEAN,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
PRIMARY KEY ("user_mod_name_uid")
);
2020-11-01 14:52:50,286 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,288 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."legal_desc_lease_legal_desc_lease_uid_seq";
CREATE TABLE "public"."legal_desc_lease"(
"legal_desc_lease_uid" INTEGER NOT NULL DEFAULT nextval('"public"."legal_desc_lease_legal_desc_lease_uid_seq"'),
"tr_origin" VARCHAR(1000),
"tr_abstract" VARCHAR(1000),
"tr_section" INTEGER,
"tr_twnshp_num" INTEGER,
"tr_twnshp_drctn" VARCHAR(100),
"tr_range_num" INTEGER,
"tr_range_drctn" VARCHAR(500),
"tr_block" VARCHAR(20),
"tr_lot" VARCHAR(10),
"tr_desc" VARCHAR(10000000),
"tr_fractional" VARCHAR(1000),
"tr_decimal" NUMERIC(22,10),
"tr_gross_acres" NUMERIC(22,10),
"tr_net_acres" NUMERIC(22,10),
"tr_free_acres" NUMERIC(22,10),
"tr_well_name" VARCHAR(1000),
"tr_pdoc_id" VARCHAR(40),
"tr_notes" VARCHAR(10000000),
"tr_prod" BOOLEAN,
"tr_ctnum" INTEGER,
"tr_type" VARCHAR(10),
"tr_doc_id" VARCHAR(45),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"lease_uid" INTEGER,
"certificate_number" VARCHAR(10),
"fts_vector" VARCHAR(10485760),
"tgm_vector" VARCHAR(10485760),
PRIMARY KEY ("legal_desc_lease_uid")
);
2020-11-01 14:52:50,303 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,304 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."option_type_option_type_uid_seq";
CREATE TABLE "public"."option_type"(
"option_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."option_type_option_type_uid_seq"'),
"option_type_code" VARCHAR(25) NOT NULL,
"option_type_name" VARCHAR(200) NOT NULL,
"option_type_sortorder" VARCHAR(25) NOT NULL,
"option_type_shortname" VARCHAR(30) NOT NULL,
"option_type_desc" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN NOT NULL,
"required" BOOLEAN NOT NULL,
"dm_dt" TIMESTAMP,
"de_dt" TIMESTAMP,
"dm_usr" INTEGER,
"de_usr" INTEGER,
PRIMARY KEY ("option_type_uid")
);
2020-11-01 14:52:50,315 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,317 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."division_interest_division_interest_uid_seq";
CREATE TABLE "public"."division_interest"(
"division_interest_uid" INTEGER NOT NULL DEFAULT nextval('"public"."division_interest_division_interest_uid_seq"'),
"do_doc_id" VARCHAR(40),
"decimal_interest" NUMERIC(22,10),
"date_active" DATE,
"date_inactive" DATE,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"id" INTEGER,
"division_order_uid" INTEGER,
"fractional_interest" VARCHAR(1000),
PRIMARY KEY ("division_interest_uid")
);
2020-11-01 14:52:50,329 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,330 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."notification_notification_uid_seq";
CREATE TABLE "public"."notification"(
"notification_uid" INTEGER NOT NULL DEFAULT nextval('"public"."notification_notification_uid_seq"'),
"type" BIGINT,
"severity" INTEGER,
"note" VARCHAR(10485760),
"reported_from" VARCHAR(10485760),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" SMALLINT,
"processed_usr" INTEGER,
"msgcode" VARCHAR(100) NOT NULL,
"msgname" VARCHAR(200) NOT NULL,
"msg_uid" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("notification_uid")
);
2020-11-01 14:52:50,342 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,346 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."user_hdr_user_hdr_uid_seq";
CREATE TABLE "public"."user_hdr"(
"user_hdr_uid" INTEGER NOT NULL DEFAULT nextval('"public"."user_hdr_user_hdr_uid_seq"'),
"usr_name" VARCHAR(500),
"usr_dept" VARCHAR(100),
"usr_initials" VARCHAR(50),
"usr_pwd" VARCHAR(100),
"usr_active" BOOLEAN DEFAULT 'true',
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
"usr_role" INTEGER DEFAULT 0,
PRIMARY KEY ("user_hdr_uid")
);
2020-11-01 14:52:50,360 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,362 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."user_pref_name_user_pref_name_uid_seq";
CREATE TABLE "public"."user_pref_name"(
"user_pref_name_uid" INTEGER NOT NULL DEFAULT nextval('"public"."user_pref_name_user_pref_name_uid_seq"'),
"upn_name" VARCHAR(500),
"upn_category" VARCHAR(100),
"upn_short_name" VARCHAR(100),
"upn_sort_order" VARCHAR(100),
"upn_datatype" VARCHAR(100),
"upn_default_value" VARCHAR(2000),
"upn_active" BOOLEAN,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
PRIMARY KEY ("user_pref_name_uid")
);
2020-11-01 14:52:50,375 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,379 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."user_pref_user_pref_uid_seq";
CREATE TABLE "public"."user_pref"(
"user_pref_uid" INTEGER NOT NULL DEFAULT nextval('"public"."user_pref_user_pref_uid_seq"'),
"user_pref_name_uid" INTEGER,
"user_hdr_uid" INTEGER,
"up_value" VARCHAR(2000),
"up_comment" VARCHAR(2000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
PRIMARY KEY ("user_pref_uid")
);
2020-11-01 14:52:50,391 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,393 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."document_customer"(
"doc_uid" INTEGER NOT NULL,
"customer_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("doc_uid", "customer_uid")
);
2020-11-01 14:52:50,402 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,404 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_csv_check_detail_ccc_uid_seq";
CREATE TABLE "public"."cdex_csv_check_detail"(
"ccc_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_csv_check_detail_ccc_uid_seq"'),
"line_number" INTEGER,
"check_number" VARCHAR(50),
"sender" VARCHAR(20),
"to_date" VARCHAR(10),
"property_number" VARCHAR(50),
"product_code" VARCHAR(50),
"gross_volume" NUMERIC(15,2),
"gross_value" NUMERIC(15,2),
"gross_sev_tax" NUMERIC(15,2),
"net_value" NUMERIC(15,2),
"owner_share_lnv" NUMERIC(15,2),
"tran_code1" VARCHAR(20),
"tran_code2" VARCHAR(20),
"gross_deduction" NUMERIC(15,2),
"owner_deduction" NUMERIC(15,2),
"transaction_date" VARCHAR(10),
"interest_type" VARCHAR(10),
"decimal_flag" VARCHAR(10),
"owner_decimal" NUMERIC(15,10),
"btu" INTEGER,
"property_name" VARCHAR(200),
"production_unit" VARCHAR(200),
"mapped_interest_type" VARCHAR(100),
"from_date" VARCHAR(10),
"mapped_tran_code2" VARCHAR(100),
"mapped_tran_code1" VARCHAR(100),
"mapped_product_code" VARCHAR(100),
"mapped_owner_decimal" NUMERIC(15,10),
"gross_net_value" NUMERIC(15,2),
"owner_net_value" NUMERIC(15,2),
"owner_sev_tax" NUMERIC(15,2),
"owner_gross_volume" NUMERIC(15,2),
"owner_gross_value" NUMERIC(15,2),
"owner_volume" INTEGER,
"div_of_interest" INTEGER,
"line_comment" VARCHAR(1000),
"lease_name" VARCHAR(200),
"code_import" VARCHAR(200),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" SMALLINT,
"processed_dt" TIMESTAMP,
"cdd_uid" INTEGER,
PRIMARY KEY ("ccc_uid")
);
2020-11-01 14:52:50,417 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,418 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_product_code_cdex_product_code_uid_seq";
CREATE TABLE "public"."cdex_product_code"(
"cdex_product_code_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_product_code_cdex_product_code_uid_seq"'),
"code" VARCHAR(10) NOT NULL,
"short_name" VARCHAR(40) NOT NULL,
"full_name" VARCHAR(100) NOT NULL,
"sort_order" VARCHAR(10) NOT NULL,
"default_value" VARCHAR(100) NOT NULL,
"notes" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
PRIMARY KEY ("cdex_product_code_uid")
);
2020-11-01 14:52:50,432 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,434 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."note_legal_title_note_legal_title_uid_seq";
CREATE TABLE "public"."note_legal_title"(
"note_legal_title_uid" INTEGER NOT NULL DEFAULT nextval('"public"."note_legal_title_note_legal_title_uid_seq"'),
"note_date" TIMESTAMP,
"note_text" VARCHAR(10000000),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"legal_title_uid" INTEGER NOT NULL,
"fts_vector" VARCHAR(10485760),
PRIMARY KEY ("note_legal_title_uid")
);
2020-11-01 14:52:50,445 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,446 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."gpstate_gpstate_uid_seq";
CREATE TABLE "public"."gpstate"(
"gpstate_uid" INTEGER NOT NULL DEFAULT nextval('"public"."gpstate_gpstate_uid_seq"'),
"stname" VARCHAR(100),
"stalpha" VARCHAR(10),
"stnum" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
"required" BOOLEAN,
PRIMARY KEY ("gpstate_uid")
);
2020-11-01 14:52:50,457 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,459 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."meridian_state_assoc_meridian_state_uid_seq";
CREATE TABLE "public"."meridian_state_assoc"(
"meridian_state_uid" INTEGER NOT NULL DEFAULT nextval('"public"."meridian_state_assoc_meridian_state_uid_seq"'),
"meridian_uid" INTEGER NOT NULL,
"gpstate_uid" INTEGER NOT NULL,
PRIMARY KEY ("meridian_state_uid")
);
2020-11-01 14:52:50,470 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,471 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."well_division_well_division_uid_seq";
CREATE TABLE "public"."well_division"(
"well_division_uid" INTEGER NOT NULL DEFAULT nextval('"public"."well_division_well_division_uid_seq"'),
"legal_desc_div_uid" INTEGER,
"legal_desc_well_uid" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("well_division_uid")
);
2020-11-01 14:52:50,484 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,486 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_html_check_summary_cds_uid_seq";
CREATE TABLE "public"."cdex_html_check_summary"(
"cds_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_html_check_summary_cds_uid_seq"'),
"check_number" VARCHAR(50),
"sender" VARCHAR(100),
"lines" INTEGER,
"amount" NUMERIC(15,2),
"owner_uid" VARCHAR(50),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" SMALLINT,
"processed_dt" TIMESTAMP,
"cdd_uid" INTEGER,
PRIMARY KEY ("cds_uid")
);
2020-11-01 14:52:50,496 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,498 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_interest_type_cdex_interest_type_uid_seq";
CREATE TABLE "public"."cdex_interest_type"(
"cdex_interest_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_interest_type_cdex_interest_type_uid_seq"'),
"code" VARCHAR(10) NOT NULL,
"short_name" VARCHAR(40) NOT NULL,
"full_name" VARCHAR(100) NOT NULL,
"sort_order" VARCHAR(10) NOT NULL,
"default_value" VARCHAR(100) NOT NULL,
"notes" VARCHAR(10485760) NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"de_dt" DATE DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" DATE,
"dm_usr" INTEGER,
PRIMARY KEY ("cdex_interest_type_uid")
);
2020-11-01 14:52:50,512 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,515 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_vendor_customer_ccl_uid_seq";
CREATE TABLE "public"."cdex_vendor_customer"(
"ccl_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_vendor_customer_ccl_uid_seq"'),
"cdex_customer_code" VARCHAR(10),
"cdex_customer_name" VARCHAR(500),
"cdex_vendor_code" VARCHAR(100),
"customer_uid" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("ccl_uid")
);
2020-11-01 14:52:50,526 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,527 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."division_owner_division_owner_uid_seq";
CREATE TABLE "public"."division_owner"(
"division_owner_uid" INTEGER NOT NULL DEFAULT nextval('"public"."division_owner_division_owner_uid_seq"'),
"do_doc_id" VARCHAR(40),
"owner_number" VARCHAR(100),
"date_first_paid" DATE,
"date_last_paid" DATE,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"id" INTEGER,
"division_order_uid" INTEGER,
"customer_owner_number_uid" INTEGER,
PRIMARY KEY ("division_owner_uid")
);
2020-11-01 14:52:50,538 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,540 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."division_lease_division_lease_uid_seq";
CREATE TABLE "public"."division_lease"(
"division_lease_uid" INTEGER NOT NULL DEFAULT nextval('"public"."division_lease_division_lease_uid_seq"'),
"legal_desc_div_uid" INTEGER,
"legal_desc_lease_uid" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("division_lease_uid")
);
2020-11-01 14:52:50,549 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,551 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."user_mod_user_mod_uid_seq";
CREATE TABLE "public"."user_mod"(
"user_mod_uid" INTEGER NOT NULL DEFAULT nextval('"public"."user_mod_user_mod_uid_seq"'),
"usr_mod" VARCHAR(100),
"mod_status" BOOLEAN,
"cmddelete" BOOLEAN,
"cmdedit" BOOLEAN,
"cmdinsert" BOOLEAN,
"cmdlstadd" BOOLEAN,
"cmdlstdelete" BOOLEAN,
"cmdlstedit" BOOLEAN,
"cmdnav" BOOLEAN,
"cmdprint" BOOLEAN,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
"user_hdr_uid" INTEGER,
PRIMARY KEY ("user_mod_uid")
);
2020-11-01 14:52:50,565 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,566 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."well_lease_well_lease_uid_seq";
CREATE TABLE "public"."well_lease"(
"well_lease_uid" INTEGER NOT NULL DEFAULT nextval('"public"."well_lease_well_lease_uid_seq"'),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"legal_desc_lease_uid" INTEGER NOT NULL,
"legal_desc_well_uid" INTEGER,
PRIMARY KEY ("well_lease_uid")
);
2020-11-01 14:52:50,576 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,578 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."customer_role_customer_role_uid_seq";
CREATE TABLE "public"."customer_role"(
"customer_role_uid" INTEGER NOT NULL DEFAULT nextval('"public"."customer_role_customer_role_uid_seq"'),
"customer_uid" INTEGER NOT NULL,
"linked_table" VARCHAR(60) NOT NULL,
"linked_uid" INTEGER NOT NULL,
"customer_role_code" VARCHAR(25) NOT NULL,
"customer_role_name" VARCHAR(100) NOT NULL,
"customer_role_descr" VARCHAR(10485760) NOT NULL,
"share_of_title" NUMERIC(22,10) DEFAULT 0 NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("customer_role_uid")
);
2020-11-01 14:52:50,589 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,592 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."lease_title_lease_title_uid_seq";
CREATE TABLE "public"."lease_title"(
"lease_title_uid" INTEGER NOT NULL DEFAULT nextval('"public"."lease_title_lease_title_uid_seq"'),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"legal_desc_lease_uid" INTEGER NOT NULL,
"legal_desc_title_uid" INTEGER NOT NULL,
PRIMARY KEY ("lease_title_uid")
);
2020-11-01 14:52:50,604 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,606 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."db_version"(
"db_version_id" INTEGER NOT NULL,
"version_number" INTEGER,
"sasm_id" INTEGER,
"update_date" TIMESTAMP,
"usr_id" INTEGER,
PRIMARY KEY ("db_version_id")
);
2020-11-01 14:52:50,615 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,616 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."registration_reg_uid_seq";
CREATE TABLE "public"."registration"(
"reg_uid" INTEGER NOT NULL DEFAULT nextval('"public"."registration_reg_uid_seq"'),
"manager" VARCHAR(1000),
"organization" VARCHAR(1000),
"address" VARCHAR(1000),
"city" VARCHAR(250),
"state" CHAR(2),
"zip" VARCHAR(25),
"telephone" VARCHAR(50),
"email" VARCHAR(50),
"product_name" VARCHAR(50),
"product_code" VARCHAR(50),
"activation_code" VARCHAR(100),
"reg_expiry" DATE,
"client_code" VARCHAR(100),
"org_id" VARCHAR(50),
"reg_status" INTEGER DEFAULT 0,
PRIMARY KEY ("reg_uid")
);
2020-11-01 14:52:50,626 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,628 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."log_user_log_user_uid_seq";
CREATE TABLE "public"."log_user"(
"log_user_uid" INTEGER NOT NULL DEFAULT nextval('"public"."log_user_log_user_uid_seq"'),
"lg_action" VARCHAR(100),
"lg_usr_id" INTEGER,
"lg_datetime" TIMESTAMP,
"parent_uid" INTEGER NOT NULL,
"column_name" VARCHAR(50) NOT NULL,
"old_value" VARCHAR(10485760) NOT NULL,
"new_value" VARCHAR(10485760) NOT NULL,
"parent_table" VARCHAR(60) NOT NULL,
PRIMARY KEY ("log_user_uid")
);
2020-11-01 14:52:50,638 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,639 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."well_status_well_status_uid_seq";
CREATE TABLE "public"."well_status"(
"well_status_uid" INTEGER NOT NULL DEFAULT nextval('"public"."well_status_well_status_uid_seq"'),
"well_status_name" VARCHAR(100) NOT NULL,
"well_status_code" VARCHAR(25) NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"well_status_descr" TEXT NOT NULL,
"deadfiled" BOOLEAN DEFAULT 'false' NOT NULL,
"well_status_sortorder" VARCHAR(25) NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"well_status_editor" VARCHAR(255),
"well_status_shortname" VARCHAR(30) NOT NULL,
PRIMARY KEY ("well_status_uid")
);
2020-11-01 14:52:50,653 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,655 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."customer_owner_portfolio_customer_owner_portfolio_uid_seq";
CREATE TABLE "public"."customer_owner_portfolio"(
"customer_owner_portfolio_uid" INTEGER NOT NULL DEFAULT nextval('"public"."customer_owner_portfolio_customer_owner_portfolio_uid_seq"'),
"customer_owner_number_uid" INTEGER NOT NULL,
"customer_uid" INTEGER NOT NULL,
"interest" NUMERIC(22,10) DEFAULT 0 NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER DEFAULT 0 NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("customer_owner_portfolio_uid")
);
2020-11-01 14:52:50,665 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,667 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."sasm_sasm_id_seq";
CREATE TABLE "public"."sasm"(
"sasm_id" INTEGER NOT NULL DEFAULT nextval('"public"."sasm_sasm_id_seq"'),
"the_script" VARCHAR(10485760),
"sort_order" VARCHAR(16),
"has_been_run" INTEGER,
"error_code" INTEGER,
"error_message" VARCHAR(10485760),
"version_number" INTEGER,
PRIMARY KEY ("sasm_id")
);
2020-11-01 14:52:50,680 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,682 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."search_parameter_search_parameter_uid_seq";
CREATE TABLE "public"."search_parameter"(
"search_parameter_uid" INTEGER NOT NULL DEFAULT nextval('"public"."search_parameter_search_parameter_uid_seq"'),
"code" VARCHAR(10),
"short_name" VARCHAR(20),
"description" VARCHAR(1000),
"data_name" VARCHAR(1000),
"data_type" VARCHAR(1000),
"sort_order" VARCHAR(20),
"usage" VARCHAR(100),
"de_dt" TIMESTAMP,
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"comparisons" VARCHAR(1000),
"option_function" VARCHAR(1000),
"deadfiled" BOOLEAN DEFAULT 'false',
PRIMARY KEY ("search_parameter_uid")
);
2020-11-01 14:52:50,695 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,697 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."codetype_codetype_uid_seq";
CREATE TABLE "public"."codetype"(
"codetype_uid" INTEGER NOT NULL DEFAULT nextval('"public"."codetype_codetype_uid_seq"'),
"codetype" VARCHAR(100) NOT NULL,
"code" VARCHAR(100) NOT NULL,
"name" VARCHAR(200) NOT NULL,
"shortname" VARCHAR(30) NOT NULL,
"sortorder" VARCHAR(100) NOT NULL,
"description" VARCHAR(10485760) NOT NULL,
"value1" VARCHAR(100) NOT NULL,
"value2" VARCHAR(100) NOT NULL,
"value3" VARCHAR(100) NOT NULL,
"value4" VARCHAR(100) NOT NULL,
"value5" VARCHAR(100) NOT NULL,
"value6" VARCHAR(100) NOT NULL,
"value7" VARCHAR(100) NOT NULL,
"value8" VARCHAR(100) NOT NULL,
"value9" VARCHAR(100) NOT NULL,
"groupname" VARCHAR(100) NOT NULL,
"commnt" VARCHAR(10485760) NOT NULL,
"msg" VARCHAR(10485760) NOT NULL,
"required" BOOLEAN DEFAULT 'false' NOT NULL,
"hide" SMALLINT DEFAULT 0 NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()' NOT NULL,
"de_usr" INTEGER DEFAULT 0 NOT NULL,
"dm_dt" TIMESTAMP DEFAULT 'now()' NOT NULL,
"dm_usr" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("codetype_uid")
);
2020-11-01 14:52:50,710 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,712 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."lease_product_type_lease_product_type_uid_seq";
CREATE TABLE "public"."lease_product_type"(
"lease_product_type_uid" INTEGER NOT NULL DEFAULT nextval('"public"."lease_product_type_lease_product_type_uid_seq"'),
"lease_uid" INTEGER NOT NULL,
"product_type_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("lease_product_type_uid")
);
2020-11-01 14:52:50,723 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,726 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."customernote_customernote_uid_seq";
CREATE TABLE "public"."customernote"(
"customernote_uid" INTEGER NOT NULL DEFAULT nextval('"public"."customernote_customernote_uid_seq"'),
"note_date" TIMESTAMP,
"note_text" VARCHAR(10000000),
"note_id" INTEGER,
"customer_id" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN,
"customer_uid" INTEGER NOT NULL,
"fts_vector" VARCHAR(10485760),
PRIMARY KEY ("customernote_uid")
);
2020-11-01 14:52:50,740 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,741 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE TABLE "public"."document_well"(
"doc_uid" INTEGER NOT NULL,
"well_uid" INTEGER NOT NULL,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
PRIMARY KEY ("doc_uid", "well_uid")
);
2020-11-01 14:52:50,751 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,753 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."cdex_property_summary_ps_uid_seq";
CREATE TABLE "public"."cdex_property_summary"(
"ps_uid" INTEGER NOT NULL DEFAULT nextval('"public"."cdex_property_summary_ps_uid_seq"'),
"record_type" VARCHAR(1),
"record_count" VARCHAR(5),
"blank" VARCHAR(130),
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"processed" INTEGER,
"processed_dt" TIMESTAMP,
PRIMARY KEY ("ps_uid")
);
2020-11-01 14:52:50,767 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,768 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."gpcounty_gpcounty_uid_seq";
CREATE TABLE "public"."gpcounty"(
"gpcounty_uid" INTEGER NOT NULL DEFAULT nextval('"public"."gpcounty_gpcounty_uid_seq"'),
"ctname" VARCHAR(100),
"ctalpha" VARCHAR(10),
"ctnum" INTEGER,
"stnum" INTEGER,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER,
"deadfiled" BOOLEAN DEFAULT 'false',
"required" BOOLEAN,
PRIMARY KEY ("gpcounty_uid")
);
2020-11-01 14:52:50,777 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-2] About to create table using the following definition:
2020-11-01 14:52:50,779 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-2] Running alter sql:
CREATE SEQUENCE "public"."failed_import_failed_import_uid_seq";
CREATE TABLE "public"."failed_import"(
"failed_import_uid" INTEGER NOT NULL DEFAULT nextval('"public"."failed_import_failed_import_uid_seq"'),
"usage_type" VARCHAR(50) NOT NULL,
"usage" VARCHAR(50) NOT NULL,
"name" VARCHAR(100) NOT NULL,
"description" VARCHAR(1024) NOT NULL,
"error_list" BYTEA,
"import_list" BYTEA,
"column_list" BYTEA,
"de_dt" TIMESTAMP DEFAULT 'now()',
"de_usr" INTEGER DEFAULT 0 NOT NULL,
"dm_dt" TIMESTAMP,
"dm_usr" INTEGER DEFAULT 0 NOT NULL,
PRIMARY KEY ("failed_import_uid")
);
2020-11-01 14:52:52,252 INFO [store-002] [PullService] [store-002-pull-default-1] Pull data received from corp:corp-000:corp-000 on queue default. 101 rows and 99 batches were processed. (sym_node, sym_table_reload_request, sym_node_security, customer, division_order, legal_desc_div, rcpt_method, rcpt_hdr, note_rcpt_hdr, pmt_method, pmt_hdr, well, legal_desc_well, note_well, cdex_check_detail, cdex_check_summary, doc_type, legal_title, legal_desc_title, division_title, document, document_title, doc_option, well_title, cdex_new_property, cdex_transaction_code, customer_owner_number, cdex_transmission_summary, user_label, document_receipt, cdex_state_code, product_type, rcpt_type, rcpt_dist...)
2020-11-01 14:52:52,772 INFO [store-002] [PullService] [store-002-pull-default-1] Pull data received from corp:corp-000:corp-000 on queue default. 570 rows and 45 batches were processed. (customer, rcpt_method, pmt_method, doc_type, cdex_transaction_code, user_label, cdex_state_code, product_type, rcpt_type, rcpt_distribution_type, lease_term_unit, meridian, report_parameters, unit_type, pmt_distribution_type)
2020-11-01 14:52:52,879 INFO [store-002] [PullService] [store-002-pull-default-1] Pull data received from corp:corp-000:corp-000 on queue default. 161 rows and 7 batches were processed. (pmt_type, meta_column)
2020-11-01 14:52:52,935 INFO [store-002] [PullService] [store-002-pull-default-1] Pull data received from corp:corp-000:corp-000 on queue default. 4 rows and 2 batches were processed. (cdex_payment_type)
2020-11-01 14:52:52,971 INFO [store-002] [PullService] [store-002-pull-default-1] Pull data received from corp:corp-000:corp-000 on queue default. 40 rows and 1 batches were processed. (contact_type)
2020-11-01 14:52:57,948 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-7] About to refresh the cache of nodes because new configuration came through the data loader
2020-11-01 14:52:57,974 INFO [store-002] [ConfigurationChangedDatabaseWriterFilter] [store-002-dataloader-7] About to refresh the cache of node security because new configuration came through the data loader
2020-11-01 14:52:58,078 INFO [store-002] [PullService] [store-002-pull-default-2] Pull data received from corp:corp-000:corp-000 on queue default. 7211 rows and 42 batches were processed. (contact, user_mod_name, option_type, user_hdr, user_pref_name, user_pref, cdex_product_code, gpstate, meridian_state_assoc, cdex_interest_type, cdex_vendor_customer, user_mod, db_version, well_status, sasm, search_parameter, codetype, gpcounty, sym_node, sym_node_security)
2020-11-01 14:52:59,745 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:52:59,760 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."division_order"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."division_order"
ADD CONSTRAINT "division_order_customer_uid" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid");
CREATE INDEX "division_order_fts_vector" ON "public"."division_order" ("fts_vector");
CREATE INDEX "division_order_customer_uid_idx" ON "public"."division_order" ("customer_uid");
CREATE INDEX "division_order_tgm_vector" ON "public"."division_order" ("tgm_vector");
2020-11-01 14:52:59,782 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:52:59,799 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."legal_desc_div"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."legal_desc_div"
ADD CONSTRAINT "legal_desc_div_division_order_uid" FOREIGN KEY ("division_order_uid") REFERENCES "public"."division_order" ("division_order_uid") ON DELETE CASCADE;
CREATE INDEX "legal_desc_div_fts_vector" ON "public"."legal_desc_div" ("fts_vector");
CREATE INDEX "division_tr_abstract_idx" ON "public"."legal_desc_div" ("tr_abstract");
CREATE INDEX "division_tr_block_idx" ON "public"."legal_desc_div" ("tr_block");
CREATE INDEX "division_tr_ctnum_idx" ON "public"."legal_desc_div" ("tr_ctnum");
CREATE INDEX "division_tr_lot_idx" ON "public"."legal_desc_div" ("tr_lot");
CREATE INDEX "division_tr_origin_idx" ON "public"."legal_desc_div" ("tr_origin");
CREATE INDEX "division_tr_range_drctn_idx" ON "public"."legal_desc_div" ("tr_range_drctn");
CREATE INDEX "division_tr_range_num_idx" ON "public"."legal_desc_div" ("tr_range_num");
CREATE INDEX "division_tr_section_idx" ON "public"."legal_desc_div" ("tr_section");
CREATE INDEX "division_tr_twnshp_drctn_idx" ON "public"."legal_desc_div" ("tr_twnshp_drctn");
CREATE INDEX "division_tr_twnshp_num_idx" ON "public"."legal_desc_div" ("tr_twnshp_num");
CREATE INDEX "legal_desc_div_division_order_uid_idx" ON "public"."legal_desc_div" ("division_order_uid");
CREATE INDEX "legal_desc_div_tgm_vector" ON "public"."legal_desc_div" ("tgm_vector");
2020-11-01 14:52:59,826 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:52:59,840 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."note_rcpt_hdr"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."note_rcpt_hdr"
ADD CONSTRAINT "note_rcpt_hdr_rcpt_hdr_uid" FOREIGN KEY ("rcpt_hdr_uid") REFERENCES "public"."rcpt_hdr" ("rcpt_hdr_uid") ON DELETE CASCADE;
CREATE INDEX "note_rcpt_hdr_note_text_trgm" ON "public"."note_rcpt_hdr" ("note_text");
CREATE INDEX "note_rcpt_hdr_rcpt_hdr_uid_idx" ON "public"."note_rcpt_hdr" ("rcpt_hdr_uid");
CREATE INDEX "rcpt_hdr_note_text" ON "public"."note_rcpt_hdr" ("note_text");
2020-11-01 14:52:59,860 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:52:59,872 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."pmt_hdr"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."pmt_hdr"
ADD CONSTRAINT "pmt_method_pmt_hdr_fk" FOREIGN KEY ("pmt_method_uid") REFERENCES "public"."pmt_method" ("pmt_method_uid");
CREATE INDEX "index_pmt_hdr_date_received" ON "public"."pmt_hdr" ("date_received");
CREATE INDEX "index_pmt_hdr_deposit_date" ON "public"."pmt_hdr" ("deposit_date");
CREATE INDEX "index_pmt_hdr_pmt_date" ON "public"."pmt_hdr" ("pmt_date");
CREATE INDEX "index_pmt_hdr_pmt_number" ON "public"."pmt_hdr" ("pmt_number");
CREATE INDEX "pmt_hdr_customer_uid_idx" ON "public"."pmt_hdr" ("customer_uid");
2020-11-01 14:52:59,895 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:52:59,908 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."legal_desc_well"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."legal_desc_well"
ADD CONSTRAINT "legal_desc_well_well_uid_fkey" FOREIGN KEY ("well_uid") REFERENCES "public"."well" ("well_uid") ON DELETE CASCADE;
CREATE INDEX "legal_desc_well_fts_vector" ON "public"."legal_desc_well" ("fts_vector");
CREATE INDEX "legal_desc_well_tgm_vector" ON "public"."legal_desc_well" ("tgm_vector");
CREATE INDEX "legal_desc_well_well_uid_idx" ON "public"."legal_desc_well" ("well_uid");
CREATE INDEX "well_tr_abstract_idx" ON "public"."legal_desc_well" ("tr_abstract");
CREATE INDEX "well_tr_block_idx" ON "public"."legal_desc_well" ("tr_block");
CREATE INDEX "well_tr_ctnum_idx" ON "public"."legal_desc_well" ("tr_ctnum");
CREATE INDEX "well_tr_lot_idx" ON "public"."legal_desc_well" ("tr_lot");
CREATE INDEX "well_tr_origin_idx" ON "public"."legal_desc_well" ("tr_origin");
CREATE INDEX "well_tr_range_drctn_idx" ON "public"."legal_desc_well" ("tr_range_drctn");
CREATE INDEX "well_tr_range_num_idx" ON "public"."legal_desc_well" ("tr_range_num");
CREATE INDEX "well_tr_section_idx" ON "public"."legal_desc_well" ("tr_section");
CREATE INDEX "well_tr_twnshp_drctn_idx" ON "public"."legal_desc_well" ("tr_twnshp_drctn");
CREATE INDEX "well_tr_twnshp_num_idx" ON "public"."legal_desc_well" ("tr_twnshp_num");
2020-11-01 14:52:59,938 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:52:59,952 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."note_well"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."note_well"
ADD CONSTRAINT "note_well_well_uid" FOREIGN KEY ("well_uid") REFERENCES "public"."well" ("well_uid") ON DELETE CASCADE;
CREATE INDEX "note_well_note_text_trgm" ON "public"."note_well" ("note_text");
CREATE INDEX "note_well_well_uid_idx" ON "public"."note_well" ("well_uid");
2020-11-01 14:52:59,970 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:52:59,986 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_check_detail"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,001 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,016 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_check_summary"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,031 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,044 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."division_title"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."division_title"
ADD CONSTRAINT "division_title_legal_desc_div_uid" FOREIGN KEY ("legal_desc_div_uid") REFERENCES "public"."legal_desc_div" ("legal_desc_div_uid") ON DELETE CASCADE;
ALTER TABLE "public"."division_title"
ADD CONSTRAINT "division_title_legal_desc_title_uid" FOREIGN KEY ("legal_desc_title_uid") REFERENCES "public"."legal_desc_title" ("legal_desc_title_uid") ON DELETE CASCADE;
CREATE INDEX "division_title_legal_desc_div_uid_idx" ON "public"."division_title" ("legal_desc_div_uid");
CREATE INDEX "division_title_legal_desc_title_uid_idx" ON "public"."division_title" ("legal_desc_title_uid");
2020-11-01 14:53:00,065 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,078 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."document_title"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."document_title"
ADD CONSTRAINT "document_repo_document_uid" FOREIGN KEY ("doc_uid") REFERENCES "public"."document" ("doc_uid");
ALTER TABLE "public"."document_title"
ADD CONSTRAINT "document_repo_legal_title_uid" FOREIGN KEY ("legal_title_uid") REFERENCES "public"."legal_title" ("legal_title_uid");
2020-11-01 14:53:00,097 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,110 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
CREATE INDEX "fki_doc_option_doc_option_type_uid_fkey" ON "public"."doc_option" ("doc_option_type_uid");
2020-11-01 14:53:00,126 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,139 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."well_title"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."well_title"
ADD CONSTRAINT "well_title_legal_desc_title_fkey" FOREIGN KEY ("legal_desc_title_uid") REFERENCES "public"."legal_desc_title" ("legal_desc_title_uid") ON DELETE CASCADE;
ALTER TABLE "public"."well_title"
ADD CONSTRAINT "well_title_legal_desc_well_fkey" FOREIGN KEY ("legal_desc_well_uid") REFERENCES "public"."legal_desc_well" ("legal_desc_well_uid") ON DELETE CASCADE;
CREATE INDEX "well_title_legal_desc_title_uid_idx" ON "public"."well_title" ("legal_desc_title_uid");
CREATE INDEX "well_title_legal_desc_well_uid_idx" ON "public"."well_title" ("legal_desc_well_uid");
2020-11-01 14:53:00,161 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,176 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_new_property"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,193 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,208 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_transaction_code"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "cdex_transaction_code_unique_code" ON "public"."cdex_transaction_code" ("code");
2020-11-01 14:53:00,224 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,238 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."customer_owner_number"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "customer_owner_number_uid_unique" ON "public"."customer_owner_number" ("customer_owner_number_uid");
2020-11-01 14:53:00,259 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,272 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_transmission_summary"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,291 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,304 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.user_label
2020-11-01 14:53:00,319 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,335 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."doc_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "doc_type_doc_type_code_unique" ON "public"."doc_type" ("doc_type_code");
CREATE UNIQUE INDEX "doc_type_idx00" ON "public"."doc_type" ("doc_type_code");
2020-11-01 14:53:00,355 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,369 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."document_receipt"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."document_receipt"
ADD CONSTRAINT "document_repo_document_uid" FOREIGN KEY ("doc_uid") REFERENCES "public"."document" ("doc_uid");
ALTER TABLE "public"."document_receipt"
ADD CONSTRAINT "document_repo_rcpt_hdr_uid" FOREIGN KEY ("rcpt_hdr_uid") REFERENCES "public"."rcpt_hdr" ("rcpt_hdr_uid");
2020-11-01 14:53:00,389 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,403 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_state_code"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "cdex_state_code_unique_code" ON "public"."cdex_state_code" ("code");
2020-11-01 14:53:00,422 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,436 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."rcpt_dist_detail"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."rcpt_dist_detail"
ADD CONSTRAINT "rcpt_dist_rcpt_dist_detail_fk" FOREIGN KEY ("rcpt_dist_uid") REFERENCES "public"."rcpt_dist" ("rcpt_dist_uid") ON DELETE CASCADE;
ALTER TABLE "public"."rcpt_dist_detail"
ADD CONSTRAINT "rcpt_distribution_type_uid_rcpt_dist_detail_fk" FOREIGN KEY ("rcpt_distribution_type_uid") REFERENCES "public"."rcpt_distribution_type" ("rcpt_distribution_type_uid");
2020-11-01 14:53:00,454 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,469 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."document_division_order"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."document_division_order"
ADD CONSTRAINT "document_repo_division_order_uid" FOREIGN KEY ("division_order_uid") REFERENCES "public"."division_order" ("division_order_uid");
ALTER TABLE "public"."document_division_order"
ADD CONSTRAINT "document_repo_document_uid" FOREIGN KEY ("doc_uid") REFERENCES "public"."document" ("doc_uid");
2020-11-01 14:53:00,486 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,501 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."lease_term_unit"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "lease_term_unit_unit_unique" ON "public"."lease_term_unit" ("unit");
2020-11-01 14:53:00,519 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,533 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.meridian
2020-11-01 14:53:00,549 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,564 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."report_parameters"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,579 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,593 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."unit_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,608 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,623 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."customer_distribution_type"
ADD CONSTRAINT "pmt_distribution_type_customer_fk" FOREIGN KEY ("pmt_dist_type_uid") REFERENCES "public"."pmt_distribution_type" ("pmt_dist_type_uid") ON DELETE CASCADE;
2020-11-01 14:53:00,640 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,656 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."document_lease"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."document_lease"
ADD CONSTRAINT "document_repo_document_uid" FOREIGN KEY ("doc_uid") REFERENCES "public"."document" ("doc_uid");
ALTER TABLE "public"."document_lease"
ADD CONSTRAINT "document_repo_lease_uid" FOREIGN KEY ("lease_uid") REFERENCES "public"."lease" ("lease_uid");
2020-11-01 14:53:00,677 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,692 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."rcpt_method"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,710 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,725 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_html_contacts"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:00,742 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,758 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."note_division_order"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."note_division_order"
ADD CONSTRAINT "note_division_order_division_order_uid" FOREIGN KEY ("division_order_uid") REFERENCES "public"."division_order" ("division_order_uid") ON DELETE CASCADE;
CREATE INDEX "note_division_order_division_order_uid_idx" ON "public"."note_division_order" ("division_order_uid");
CREATE INDEX "note_division_order_note_text_trgm" ON "public"."note_division_order" ("note_text");
2020-11-01 14:53:00,780 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,794 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."note_lease"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."note_lease"
ADD CONSTRAINT "note_lease_lease_uid" FOREIGN KEY ("lease_uid") REFERENCES "public"."lease" ("lease_uid") ON DELETE CASCADE;
CREATE INDEX "note_lease_lease_uid_idx" ON "public"."note_lease" ("lease_uid");
CREATE INDEX "note_lease_note_text_trgm" ON "public"."note_lease" ("note_text");
2020-11-01 14:53:00,814 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,830 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."pmt_dist_detail"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."pmt_dist_detail"
ADD CONSTRAINT "pmt_dist_pmt_dist_detail_fk" FOREIGN KEY ("pmt_dist_uid") REFERENCES "public"."pmt_dist" ("pmt_dist_uid") ON DELETE CASCADE;
ALTER TABLE "public"."pmt_dist_detail"
ADD CONSTRAINT "pmt_dist_type_uid_pmt_dist_detail_fk" FOREIGN KEY ("pmt_dist_type_uid") REFERENCES "public"."pmt_distribution_type" ("pmt_dist_type_uid");
2020-11-01 14:53:00,849 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,863 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."saved_layout_meta_column_link"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."saved_layout_meta_column_link"
ADD CONSTRAINT "saved_layout_meta_column_link_meta_column_uid_fkey" FOREIGN KEY ("meta_column_uid") REFERENCES "public"."meta_column" ("meta_column_uid");
ALTER TABLE "public"."saved_layout_meta_column_link"
ADD CONSTRAINT "saved_layout_meta_column_link_saved_layout_uid_fkey" FOREIGN KEY ("saved_layout_uid") REFERENCES "public"."saved_layout" ("saved_layout_uid");
2020-11-01 14:53:00,884 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,899 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."lease"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."lease"
ADD CONSTRAINT "lease_customer_uid" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid");
ALTER TABLE "public"."lease"
ADD CONSTRAINT "lease_last_payor_uid" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid");
ALTER TABLE "public"."lease"
ADD CONSTRAINT "lease_doc_type_uid" FOREIGN KEY ("doc_type_uid") REFERENCES "public"."doc_type" ("doc_type_uid");
ALTER TABLE "public"."lease"
ADD CONSTRAINT "lease_lease_term_unit_uid" FOREIGN KEY ("lease_term_unit_uid") REFERENCES "public"."lease_term_unit" ("lease_term_unit_uid");
CREATE INDEX "lease_customer_uid_idx" ON "public"."lease" ("customer_uid");
CREATE INDEX "lease_tgm_vector" ON "public"."lease" ("tgm_vector");
2020-11-01 14:53:00,922 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,940 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."rcpt_hdr"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."rcpt_hdr"
ADD CONSTRAINT "rcpt_method_uid_rcpt_hdr_fk" FOREIGN KEY ("rcpt_method_uid") REFERENCES "public"."rcpt_method" ("rcpt_method_uid");
CREATE INDEX "rcpt_hdr_fts_vector" ON "public"."rcpt_hdr" ("fts_vector");
CREATE INDEX "rcpt_hdr_tgm_vector" ON "public"."rcpt_hdr" ("tgm_vector");
2020-11-01 14:53:00,961 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:00,977 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.sasm_dev
2020-11-01 14:53:00,995 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,011 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_payment_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "cdex_payment_type_unique_code" ON "public"."cdex_payment_type" ("code");
2020-11-01 14:53:01,030 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,047 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_html_check_header"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,064 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,080 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."contact"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."contact"
ADD CONSTRAINT "contact_contact_type_uid" FOREIGN KEY ("contact_type_uid") REFERENCES "public"."contact_type" ("contact_type_uid");
ALTER TABLE "public"."contact"
ADD CONSTRAINT "contact_customer_uid" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid") ON DELETE CASCADE;
CREATE INDEX "contact_ct_uid_idx" ON "public"."contact" ("contact_type_uid");
CREATE INDEX "contact_customer_uid_idx" ON "public"."contact" ("customer_uid");
2020-11-01 14:53:01,103 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,119 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."lease_rental"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,138 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,153 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."user_mod_name"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,171 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,188 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."pmt_distribution_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,206 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,223 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."legal_desc_title"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."legal_desc_title"
ADD CONSTRAINT "legal_title_uid_legal_desc_title_uid_fkey" FOREIGN KEY ("legal_title_uid") REFERENCES "public"."legal_title" ("legal_title_uid") ON DELETE CASCADE;
CREATE INDEX "legal_desc_title_fts_vector" ON "public"."legal_desc_title" ("fts_vector");
CREATE INDEX "legal_desc_title_legal_title_uid_idx" ON "public"."legal_desc_title" ("legal_title_uid");
CREATE INDEX "legal_desc_title_tgm_vector" ON "public"."legal_desc_title" ("tgm_vector");
CREATE INDEX "title_tr_abstract_idx" ON "public"."legal_desc_title" ("tr_abstract");
CREATE INDEX "title_tr_block_idx" ON "public"."legal_desc_title" ("tr_block");
CREATE INDEX "title_tr_ctnum_idx" ON "public"."legal_desc_title" ("tr_ctnum");
CREATE INDEX "title_tr_lot_idx" ON "public"."legal_desc_title" ("tr_lot");
CREATE INDEX "title_tr_origin_idx" ON "public"."legal_desc_title" ("tr_origin");
CREATE INDEX "title_tr_range_drctn_idx" ON "public"."legal_desc_title" ("tr_range_drctn");
CREATE INDEX "title_tr_range_num_idx" ON "public"."legal_desc_title" ("tr_range_num");
CREATE INDEX "title_tr_section_idx" ON "public"."legal_desc_title" ("tr_section");
CREATE INDEX "title_tr_twnshp_drctn_idx" ON "public"."legal_desc_title" ("tr_twnshp_drctn");
CREATE INDEX "title_tr_twnshp_num_idx" ON "public"."legal_desc_title" ("tr_twnshp_num");
2020-11-01 14:53:01,254 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,271 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."product_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,289 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,305 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."meta_column"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE INDEX "meta_column_usage_name_idx" ON "public"."meta_column" ("usage_type", "usage", "display_name");
2020-11-01 14:53:01,328 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,346 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."legal_desc_lease"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."legal_desc_lease"
ADD CONSTRAINT "legal_desc_lease_lease_uid" FOREIGN KEY ("lease_uid") REFERENCES "public"."lease" ("lease_uid") ON DELETE CASCADE;
CREATE INDEX "legal_desc_lease_fts_vector" ON "public"."legal_desc_lease" ("fts_vector");
CREATE INDEX "lease_tr_abstract_idx" ON "public"."legal_desc_lease" ("tr_abstract");
CREATE INDEX "lease_tr_block_idx" ON "public"."legal_desc_lease" ("tr_block");
CREATE INDEX "lease_tr_ctnum_idx" ON "public"."legal_desc_lease" ("tr_ctnum");
CREATE INDEX "lease_tr_lot_idx" ON "public"."legal_desc_lease" ("tr_lot");
CREATE INDEX "lease_tr_origin_idx" ON "public"."legal_desc_lease" ("tr_origin");
CREATE INDEX "lease_tr_range_drctn_idx" ON "public"."legal_desc_lease" ("tr_range_drctn");
CREATE INDEX "lease_tr_range_num_idx" ON "public"."legal_desc_lease" ("tr_range_num");
CREATE INDEX "lease_tr_section_idx" ON "public"."legal_desc_lease" ("tr_section");
CREATE INDEX "lease_tr_twnshp_drctn_idx" ON "public"."legal_desc_lease" ("tr_twnshp_drctn");
CREATE INDEX "lease_tr_twnshp_num_idx" ON "public"."legal_desc_lease" ("tr_twnshp_num");
CREATE INDEX "legal_desc_lease_lease_uid_idx" ON "public"."legal_desc_lease" ("lease_uid");
CREATE INDEX "legal_desc_lease_order_tgm_vector" ON "public"."legal_desc_lease" ("tgm_vector");
2020-11-01 14:53:01,377 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,395 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
CREATE UNIQUE INDEX "option_type_option_type_code_unique" ON "public"."option_type" ("option_type_code");
2020-11-01 14:53:01,414 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,430 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."division_interest"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."division_interest"
ADD CONSTRAINT "division_interest_division_order_uid" FOREIGN KEY ("division_order_uid") REFERENCES "public"."division_order" ("division_order_uid") ON DELETE CASCADE;
CREATE INDEX "division_interest_division_order_uid_idx" ON "public"."division_interest" ("division_order_uid");
2020-11-01 14:53:01,451 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,468 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."saved_layout"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE INDEX "saved_layout_usage_name_idx" ON "public"."saved_layout" ("usage_type", "usage", "name");
2020-11-01 14:53:01,488 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,506 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."rcpt_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,524 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,541 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."notification"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,561 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,576 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."customer"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "customer_name_number_idx" ON "public"."customer" ("name", "customernumber");
CREATE INDEX "customer_fts_vector" ON "public"."customer" ("fts_vector");
CREATE INDEX "customer_tgm_vector" ON "public"."customer" ("tgm_vector");
2020-11-01 14:53:01,599 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,615 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."user_pref"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."user_pref"
ADD CONSTRAINT "user_hdr_user_hdr_uid_fkey" FOREIGN KEY ("user_hdr_uid") REFERENCES "public"."user_hdr" ("user_hdr_uid") ON DELETE CASCADE;
ALTER TABLE "public"."user_pref"
ADD CONSTRAINT "user_pref_name_user_pref_name_uid_fkey" FOREIGN KEY ("user_pref_name_uid") REFERENCES "public"."user_pref_name" ("user_pref_name_uid") ON DELETE CASCADE;
2020-11-01 14:53:01,637 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,654 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."document_customer"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."document_customer"
ADD CONSTRAINT "document_repo_customer_id" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid");
ALTER TABLE "public"."document_customer"
ADD CONSTRAINT "document_repo_document_uid" FOREIGN KEY ("doc_uid") REFERENCES "public"."document" ("doc_uid");
2020-11-01 14:53:01,676 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,696 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_csv_check_detail"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,716 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,733 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_product_code"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "cdex_product_code_unique_code" ON "public"."cdex_product_code" ("code");
2020-11-01 14:53:01,753 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,771 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."note_legal_title"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."note_legal_title"
ADD CONSTRAINT "note_legal_title_legal_title_uid" FOREIGN KEY ("legal_title_uid") REFERENCES "public"."legal_title" ("legal_title_uid") ON DELETE CASCADE;
CREATE INDEX "note_legal_title_legal_title_uid_idx" ON "public"."note_legal_title" ("legal_title_uid");
CREATE INDEX "note_legal_title_note_text_trgm" ON "public"."note_legal_title" ("note_text");
2020-11-01 14:53:01,793 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,811 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."meridian_state_assoc"
ADD CONSTRAINT "gpstate_meridian_state_assoc_uid" FOREIGN KEY ("gpstate_uid") REFERENCES "public"."gpstate" ("gpstate_uid") ON DELETE CASCADE;
ALTER TABLE "public"."meridian_state_assoc"
ADD CONSTRAINT "meridian_meridian_state_assoc_uid" FOREIGN KEY ("meridian_uid") REFERENCES "public"."meridian" ("meridian_uid") ON DELETE CASCADE;
2020-11-01 14:53:01,832 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,850 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."pmt_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,869 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,886 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."well_division"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."well_division"
ADD CONSTRAINT "well_division_legal_desc_div_uid_fkey" FOREIGN KEY ("legal_desc_div_uid") REFERENCES "public"."legal_desc_div" ("legal_desc_div_uid") ON DELETE CASCADE;
ALTER TABLE "public"."well_division"
ADD CONSTRAINT "well_division_legal_desc_well_uid_fkey" FOREIGN KEY ("legal_desc_well_uid") REFERENCES "public"."legal_desc_well" ("legal_desc_well_uid") ON DELETE CASCADE;
2020-11-01 14:53:01,908 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,927 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."document"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,951 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:01,968 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."pmt_method"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:01,989 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,006 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_html_check_summary"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:02,027 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,045 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_interest_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "cdex_interest_type_unique_code" ON "public"."cdex_interest_type" ("code");
2020-11-01 14:53:02,066 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,084 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_vendor_customer"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:02,103 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,121 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."division_owner"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."division_owner"
ADD CONSTRAINT "division_owner_division_order_uid" FOREIGN KEY ("division_order_uid") REFERENCES "public"."division_order" ("division_order_uid") ON DELETE CASCADE;
CREATE INDEX "division_owner_division_order_uid_idx" ON "public"."division_owner" ("division_order_uid");
2020-11-01 14:53:02,144 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,162 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."rcpt_dist"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."rcpt_dist"
ADD CONSTRAINT "product_type_uid_rcpt_dist_fk" FOREIGN KEY ("product_type_uid") REFERENCES "public"."product_type" ("product_type_uid");
ALTER TABLE "public"."rcpt_dist"
ADD CONSTRAINT "rcpt_dist_rcpt_hdr_uid_uid_fkey" FOREIGN KEY ("rcpt_hdr_uid") REFERENCES "public"."rcpt_hdr" ("rcpt_hdr_uid") ON DELETE CASCADE;
ALTER TABLE "public"."rcpt_dist"
ADD CONSTRAINT "rcpt_type_uid_rcpt_hdr_fk" FOREIGN KEY ("rcpt_type_uid") REFERENCES "public"."rcpt_type" ("rcpt_type_uid");
2020-11-01 14:53:02,184 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,203 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."division_lease"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."division_lease"
ADD CONSTRAINT "division_lease_legal_desc_div_uid" FOREIGN KEY ("legal_desc_div_uid") REFERENCES "public"."legal_desc_div" ("legal_desc_div_uid") ON DELETE CASCADE;
ALTER TABLE "public"."division_lease"
ADD CONSTRAINT "division_lease_legal_desc_lease_uid" FOREIGN KEY ("legal_desc_lease_uid") REFERENCES "public"."legal_desc_lease" ("legal_desc_lease_uid") ON DELETE CASCADE;
CREATE INDEX "division_lease_legal_desc_div_uid_idx" ON "public"."division_lease" ("legal_desc_div_uid");
CREATE INDEX "division_lease_legal_desc_lease_uid_idx" ON "public"."division_lease" ("legal_desc_lease_uid");
2020-11-01 14:53:02,227 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,246 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."user_mod"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."user_mod"
ADD CONSTRAINT "user_mod_user_hdr_uid_fkey" FOREIGN KEY ("user_hdr_uid") REFERENCES "public"."user_hdr" ("user_hdr_uid") ON DELETE CASCADE;
2020-11-01 14:53:02,267 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,290 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."pmt_dist"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."pmt_dist"
ADD CONSTRAINT "pmt_dist_pmt_hdr_uid_uid_fkey" FOREIGN KEY ("pmt_hdr_uid") REFERENCES "public"."pmt_hdr" ("pmt_hdr_uid") ON DELETE CASCADE;
ALTER TABLE "public"."pmt_dist"
ADD CONSTRAINT "pmt_type_uid_pmt_hdr_fk" FOREIGN KEY ("pmt_type_uid") REFERENCES "public"."pmt_type" ("pmt_type_uid");
ALTER TABLE "public"."pmt_dist"
ADD CONSTRAINT "product_type_uid_pmt_dist_fk" FOREIGN KEY ("product_type_uid") REFERENCES "public"."product_type" ("product_type_uid");
ALTER TABLE "public"."pmt_dist"
ADD CONSTRAINT "unit_type_uid_pmt_dist_fk" FOREIGN KEY ("unit_type_uid") REFERENCES "public"."unit_type" ("unit_type_uid");
CREATE INDEX "index_pmt_dist_uid" ON "public"."pmt_dist" ("product_type_uid");
CREATE INDEX "pmt_dist_division_order_uid_idx" ON "public"."pmt_dist" ("division_order_uid");
CREATE INDEX "pmt_dist_pmt_hdr_uid_idx" ON "public"."pmt_dist" ("pmt_hdr_uid");
CREATE INDEX "pmt_dist_well_uid_idx" ON "public"."pmt_dist" ("well_uid");
2020-11-01 14:53:02,315 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,335 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."well_lease"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."well_lease"
ADD CONSTRAINT "well_lease_legal_desc_well_uid_fkey" FOREIGN KEY ("legal_desc_well_uid") REFERENCES "public"."legal_desc_well" ("legal_desc_well_uid") ON DELETE CASCADE;
ALTER TABLE "public"."well_lease"
ADD CONSTRAINT "well_lease_uid_legal_desc_well_uid_fkey" FOREIGN KEY ("legal_desc_well_uid") REFERENCES "public"."legal_desc_well" ("legal_desc_well_uid") ON DELETE CASCADE;
2020-11-01 14:53:02,358 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,377 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."customer_role"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."customer_role"
ADD CONSTRAINT "customer_role_customer_uid_fkey" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid");
CREATE UNIQUE INDEX "customer_role_customer_role_table_unique" ON "public"."customer_role" ("customer_uid", "customer_role_code", "linked_table", "linked_uid");
2020-11-01 14:53:02,400 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,419 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."user_hdr"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:02,439 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,458 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."lease_title"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."lease_title"
ADD CONSTRAINT "lease_title_uid_legal_desc_lease_uid_fkey" FOREIGN KEY ("legal_desc_lease_uid") REFERENCES "public"."legal_desc_lease" ("legal_desc_lease_uid") ON DELETE CASCADE;
ALTER TABLE "public"."lease_title"
ADD CONSTRAINT "lease_title_uid_legal_desc_title_uid_fkey" FOREIGN KEY ("legal_desc_title_uid") REFERENCES "public"."legal_desc_title" ("legal_desc_title_uid") ON DELETE CASCADE;
CREATE INDEX "lease_title_legal_desc_lease_uid_idx" ON "public"."lease_title" ("legal_desc_lease_uid");
CREATE INDEX "lease_title_legal_desc_title_uid_idx" ON "public"."lease_title" ("legal_desc_title_uid");
2020-11-01 14:53:02,483 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,504 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."well"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE INDEX "well_fts_vector" ON "public"."well" ("fts_vector");
CREATE INDEX "well_tgm_vector" ON "public"."well" ("tgm_vector");
2020-11-01 14:53:02,526 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,545 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.db_version
2020-11-01 14:53:02,566 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,586 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.registration
2020-11-01 14:53:02,607 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,627 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.log_user
2020-11-01 14:53:02,648 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,670 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."well_status"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "well_status_well_status_code_unique" ON "public"."well_status" ("well_status_code");
CREATE UNIQUE INDEX "well_status_well_status_name_unique" ON "public"."well_status" ("well_status_name");
2020-11-01 14:53:02,694 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,713 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."customer_owner_portfolio"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."customer_owner_portfolio"
ADD CONSTRAINT "customer_owner_portfolio_customer_uid_fkey" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid");
ALTER TABLE "public"."customer_owner_portfolio"
ADD CONSTRAINT "customer_owner_portfolio_customer_owner_number_uid_fkey" FOREIGN KEY ("customer_owner_number_uid") REFERENCES "public"."customer_owner_number" ("customer_owner_number_uid");
2020-11-01 14:53:02,736 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,757 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.sasm
2020-11-01 14:53:02,777 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,798 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."user_pref_name"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:02,821 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,842 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."rcpt_distribution_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "rcpt_distribution_type_code_unique" ON "public"."rcpt_distribution_type" ("rcpt_distribution_type_code");
CREATE UNIQUE INDEX "rcpt_distribution_type_name_unique" ON "public"."rcpt_distribution_type" ("rcpt_distribution_type_name");
2020-11-01 14:53:02,865 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,886 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Tables up to date. No alters found for public.search_parameter
2020-11-01 14:53:02,906 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,927 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."codetype"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."codetype"
ALTER COLUMN "dm_dt" SET DEFAULT 'now()';
CREATE INDEX "codetype_codetype_code_idx" ON "public"."codetype" ("codetype", "code");
2020-11-01 14:53:02,950 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:02,970 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."lease_product_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."lease_product_type"
ADD CONSTRAINT "lease_product_type_uid_lease_uid_fkey" FOREIGN KEY ("lease_uid") REFERENCES "public"."lease" ("lease_uid") ON DELETE CASCADE;
ALTER TABLE "public"."lease_product_type"
ADD CONSTRAINT "lease_product_type_uid_product_type_uid_fkey" FOREIGN KEY ("product_type_uid") REFERENCES "public"."product_type" ("product_type_uid") ON DELETE CASCADE;
CREATE INDEX "lease_product_type_lease_uid_idx" ON "public"."lease_product_type" ("lease_uid");
CREATE INDEX "lease_product_type_product_type_uid_idx" ON "public"."lease_product_type" ("product_type_uid");
2020-11-01 14:53:02,996 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:03,017 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."customernote"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."customernote"
ADD CONSTRAINT "customernote_customer_uid" FOREIGN KEY ("customer_uid") REFERENCES "public"."customer" ("customer_uid") ON DELETE CASCADE;
CREATE INDEX "customernote_customer_uid_idx" ON "public"."customernote" ("customer_uid");
2020-11-01 14:53:03,044 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:03,065 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."document_well"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."document_well"
ADD CONSTRAINT "document_repo_document_uid" FOREIGN KEY ("doc_uid") REFERENCES "public"."document" ("doc_uid");
ALTER TABLE "public"."document_well"
ADD CONSTRAINT "document_repo_well_uid" FOREIGN KEY ("well_uid") REFERENCES "public"."well" ("well_uid");
2020-11-01 14:53:03,091 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:03,114 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."contact_type"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
CREATE UNIQUE INDEX "contact_type_contact_type_name_unique" ON "public"."contact_type" ("contact_type_name");
2020-11-01 14:53:03,137 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:03,160 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."legal_title"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."legal_title"
ADD CONSTRAINT "legal_title_doc_type_uid" FOREIGN KEY ("doc_type_uid") REFERENCES "public"."doc_type" ("doc_type_uid");
ALTER TABLE "public"."legal_title"
ADD CONSTRAINT "ttl_type_doc_type_code_fkey" FOREIGN KEY ("ttl_type") REFERENCES "public"."doc_type" ("doc_type_code") ON UPDATE CASCADE;
CREATE UNIQUE INDEX "ttl_doc_id" ON "public"."legal_title" ("ttl_doc_id");
CREATE INDEX "legal_title_fts_vector" ON "public"."legal_title" ("fts_vector");
CREATE INDEX "legal_title_tgm_vector" ON "public"."legal_title" ("tgm_vector");
2020-11-01 14:53:03,186 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:03,207 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."cdex_property_summary"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
2020-11-01 14:53:03,228 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] About to create table using the following definition:
2020-11-01 14:53:03,249 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-8] Running alter sql:
ALTER TABLE "public"."gpcounty"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."gpcounty"
ADD CONSTRAINT "gpcounty_gpstat_stnum_kfey" FOREIGN KEY ("stnum") REFERENCES "public"."gpstate" ("stnum") ON DELETE CASCADE ON UPDATE CASCADE;
2020-11-01 14:53:03,252 WARN [store-002] [JdbcSqlTemplate] [store-002-dataloader-8] ERROR: there is no unique constraint matching given keys for referenced table "gpstate". Failed to execute: ALTER TABLE "public"."gpcounty"
ADD CONSTRAINT "gpcounty_gpstat_stnum_kfey" FOREIGN KEY ("stnum") REFERENCES "public"."gpstate" ("stnum") ON DELETE CASCADE ON UPDATE CASCADE
2020-11-01 14:53:03,252 ERROR [store-002] [DefaultDatabaseWriter] [store-002-dataloader-8] Failed to alter table using the following xml:
StackTraceKey.init [SqlException:70098548] org.jumpmind.db.sql.SqlException: ERROR: there is no unique constraint matching given keys for referenced table "gpstate"
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:306)
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:295)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:523)
at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:431)
at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:114)
at org.jumpmind.db.platform.AbstractDatabasePlatform.alterTables(AbstractDatabasePlatform.java:250)
at org.jumpmind.db.platform.AbstractDatabasePlatform.alterDatabase(AbstractDatabasePlatform.java:214)
at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.create(DefaultDatabaseWriter.java:584)
at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:204)
at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84)
at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:202)
at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:212)
at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:178)
at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:124)
at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1085)
at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1061)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
at java.base/java.lang.Thread.run(Thread.java:832)
Caused by: org.postgresql.util.PSQLException: ERROR: there is no unique constraint matching given keys for referenced table "gpstate"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:446)
at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:431)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:521)
... 19 more
2020-11-01 14:53:03,268 ERROR [store-002] [ManageIncomingBatchListener] [store-002-dataloader-8] Failed to load batch corp-000-305 StackTraceKey [SqlException:70098548]
2020-11-01 14:53:09,167 INFO [store-002] [IncomingBatchService] [store-002-dataloader-9] Retrying batch corp-000-305
2020-11-01 14:53:09,204 INFO [store-002] [DefaultDatabaseWriter] [store-002-dataloader-9] About to create table using the following definition:
2020-11-01 14:53:09,227 INFO [store-002] [PostgreSql95DatabasePlatform] [store-002-dataloader-9] Running alter sql:
ALTER TABLE "public"."gpcounty"
ALTER COLUMN "de_dt" SET DEFAULT 'now()';
ALTER TABLE "public"."gpcounty"
ADD CONSTRAINT "gpcounty_gpstat_stnum_kfey" FOREIGN KEY ("stnum") REFERENCES "public"."gpstate" ("stnum") ON DELETE CASCADE ON UPDATE CASCADE;
2020-11-01 14:53:09,229 WARN [store-002] [JdbcSqlTemplate] [store-002-dataloader-9] ERROR: there is no unique constraint matching given keys for referenced table "gpstate". Failed to execute: ALTER TABLE "public"."gpcounty"
ADD CONSTRAINT "gpcounty_gpstat_stnum_kfey" FOREIGN KEY ("stnum") REFERENCES "public"."gpstate" ("stnum") ON DELETE CASCADE ON UPDATE CASCADE
2020-11-01 14:53:09,229 ERROR [store-002] [DefaultDatabaseWriter] [store-002-dataloader-9] Failed to alter table using the following xml: