Nikita Noark5 Core 0.7 med ElasticSearch 8.1.3

Ole Aamot ole at aamotsoftware.no
Mon May 2 06:19:14 CEST 2022


OK, thanks a lot for your help and for showing me the installation document
in
https://gitlab.com/OsloMet-ABI/nikita-noark5-core/-/blob/master/docs/general/Install.md

I installed docker.io from apt on Ubuntu 22.04.

ole at ubuntu:~/nikita-noark5-core$ sudo apt install docker.io

ole at ubuntu:~/nikita-noark5-core$ sudo scripts/start-containers
This might take some minutes, sit back and relax with a beverage
Using default tag: latest
latest: Pulling from nikita5/noark5-tester
693502eb7dfb: Pull complete
d488fc561b9b: Pull complete
d0ca841565e1: Pull complete
66b2eacf2e01: Pull complete
Digest:
sha256:0a83a9df63c2cea375f35322ef3933396ef525469f785e96e9595f480293f91d
Status: Downloaded newer image for nikita5/noark5-tester:latest
docker.io/nikita5/noark5-tester:latest
Using default tag: latest
latest: Pulling from oslometabi/nikita-noark5-core
36698cfa5275: Pull complete
6a8659ec8836: Pull complete
a1f1879bb7de: Pull complete
46942b1b2a2c: Pull complete
7f693fb4c128: Pull complete
0526d3c8ad56: Pull complete
cc8876f348be: Pull complete
061b276909be: Pull complete
Digest:
sha256:f831935a93efca93d51a149a096f53d4f53174d7a176b74157c476b631ee2caf
Status: Downloaded newer image for oslometabi/nikita-noark5-core:latest
docker.io/oslometabi/nikita-noark5-core:latest
89d38173a685b6217014f79f2d9e38e0bf2a1808a1cb388e508d7d38d7fd0f0a
Waiting on server

          _   _      _   _
    _      _____
         (_) | |    (_) | |
  | |    | ____|
  _ __    _  | | __  _  | |_    __ _   ______   _ __     ___     __ _   _
__  | | __ | |__    ______    ___    ___    _ __    ___
 | '_ \  | | | |/ / | | | __|  / _` | |______| | '_ \   / _ \   / _` | |
'__| | |/ / |___ \  |______|  / __|  / _ \  | '__|  / _ \
 | | | | | | |   <  | | | |_  | (_| |          | | | | | (_) | | (_| | | |
   |   <   ___) |          | (__  | (_) | | |    |  __/
 |_| |_| |_| |_|\_\ |_|  \__|  \__,_|          |_| |_|  \___/   \__,_| |_|
   |_|\_\ |____/            \___|  \___/  |_|     \___|

2022-05-02 06:17:56.579  INFO 31670 --- [           main] nikita.N5CoreApp
                        : Starting N5CoreApp using Java 11.0.15 on
fedora.aamot.software with PID 31670
(/home/ole/nikita-noark5-core/target/classes started by ole in
/home/ole/nikita-noark5-core)
2022-05-02 06:17:56.582  INFO 31670 --- [           main] nikita.N5CoreApp
                        : No active profile set, falling back to default
profiles: default
2022-05-02 06:17:57.954  INFO 31670 --- [           main]
.s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA
repositories in DEFAULT mode.
2022-05-02 06:17:58.247  INFO 31670 --- [           main]
.s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository
scanning in 286 ms. Found 76 JPA repository interfaces.
2022-05-02 06:17:58.836  INFO 31670 --- [           main]
o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s):
8092 (http)
2022-05-02 06:17:58.845  INFO 31670 --- [           main]
o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-05-02 06:17:58.845  INFO 31670 --- [           main]
org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache
Tomcat/9.0.55]
2022-05-02 06:17:58.973  INFO 31670 --- [           main]
o.a.c.c.C.[.[localhost].[/noark5v5]      : Initializing Spring embedded
WebApplicationContext
2022-05-02 06:17:58.973  INFO 31670 --- [           main]
w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext:
initialization completed in 2329 ms
2022-05-02 06:17:59.141  INFO 31670 --- [           main]
n.webapp.spring.ODataRedirectFilter      : ODataRedirectFilter init
2022-05-02 06:17:59.142  INFO 31670 --- [           main]
nikita.webapp.spring.SimpleCORSFilter    : SimpleCORSFilter init
2022-05-02 06:17:59.296  INFO 31670 --- [           main]
com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2022-05-02 06:17:59.437  INFO 31670 --- [           main]
com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2022-05-02 06:17:59.501  INFO 31670 --- [           main]
o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing
PersistenceUnitInfo [name: default]
2022-05-02 06:17:59.605  INFO 31670 --- [           main]
org.hibernate.Version                    : HHH000412: Hibernate ORM core
version 5.6.1.Final
2022-05-02 06:17:59.731  INFO 31670 --- [           main]
o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons
Annotations {5.1.2.Final}
2022-05-02 06:17:59.864  INFO 31670 --- [           main]
org.hibernate.dialect.Dialect            : HHH000400: Using dialect:
org.hibernate.dialect.H2Dialect
2022-05-02 06:17:59.941  INFO 31670 --- [           main]
o.h.e.boot.internal.EnversServiceImpl    : Envers integration enabled? :
true
2022-05-02 06:18:01.531  INFO 31670 --- [           main]
o.h.s.m.o.b.i.HibernateSearchIntegrator  : HSEARCH000034: Hibernate Search
version 6.0.6.Final
Hibernate: drop table if exists ad_administrative_unit CASCADE
2022-05-02 06:18:03.276  INFO 31670 --- [           main]
org.hibernate.orm.connections.access     : HHH10001501: Connection obtained
from JdbcConnectionAccess
[org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess at f0ced73]
for (non-JTA) DDL execution was not in auto-commit mode; the Connection
'local transaction' will be committed and the Connection will be set into
auto-commit mode.
Hibernate: drop table if exists ad_administrative_unit_user CASCADE
Hibernate: drop table if exists ad_authority CASCADE
Hibernate: drop table if exists ad_organisation CASCADE
Hibernate: drop table if exists ad_user CASCADE
Hibernate: drop table if exists ad_user_authority CASCADE
Hibernate: drop table if exists as_author CASCADE
Hibernate: drop table if exists as_building CASCADE
Hibernate: drop table if exists as_business_address CASCADE
Hibernate: drop table if exists as_cadastral CASCADE
Hibernate: drop table if exists as_changelog CASCADE
Hibernate: drop table if exists as_class CASCADE
Hibernate: drop table if exists as_class_keyword CASCADE
Hibernate: drop table if exists as_classification_system CASCADE
Hibernate: drop table if exists as_classified CASCADE
Hibernate: drop table if exists as_comment CASCADE
Hibernate: drop table if exists as_contact_information CASCADE
Hibernate: drop table if exists as_conversion CASCADE
Hibernate: drop table if exists as_correspondence_part CASCADE
Hibernate: drop table if exists as_correspondence_part_internal CASCADE
Hibernate: drop table if exists as_correspondence_part_person CASCADE
Hibernate: drop table if exists as_correspondence_part_unit CASCADE
Hibernate: drop table if exists as_cross_reference CASCADE
Hibernate: drop table if exists as_d_number CASCADE
Hibernate: drop table if exists as_deletion CASCADE
Hibernate: drop table if exists as_disposal CASCADE
Hibernate: drop table if exists as_disposal_undertaken CASCADE
Hibernate: drop table if exists as_document_description CASCADE
Hibernate: drop table if exists as_document_description_comment CASCADE
Hibernate: drop table if exists as_document_description_party CASCADE
Hibernate: drop table if exists as_document_flow CASCADE
Hibernate: drop table if exists as_document_object CASCADE
Hibernate: drop table if exists as_electronic_signature CASCADE
Hibernate: drop table if exists as_event_log CASCADE
Hibernate: drop table if exists as_file CASCADE
Hibernate: drop table if exists as_file_comment CASCADE
Hibernate: drop table if exists as_file_keyword CASCADE
Hibernate: drop table if exists as_file_part CASCADE
Hibernate: drop table if exists as_file_storage_location CASCADE
Hibernate: drop table if exists as_fonds CASCADE
Hibernate: drop table if exists as_fonds_creator CASCADE
Hibernate: drop table if exists as_fonds_fonds_creator CASCADE
Hibernate: drop table if exists as_fonds_storage_location CASCADE
Hibernate: drop table if exists as_keyword CASCADE
Hibernate: drop table if exists as_national_identifier CASCADE
Hibernate: drop table if exists as_part CASCADE
Hibernate: drop table if exists as_part_person CASCADE
Hibernate: drop table if exists as_part_unit CASCADE
Hibernate: drop table if exists as_plan CASCADE
Hibernate: drop table if exists as_position CASCADE
Hibernate: drop table if exists as_postal_address CASCADE
Hibernate: drop table if exists as_record CASCADE
Hibernate: drop table if exists as_record_comment CASCADE
Hibernate: drop table if exists as_record_document_description CASCADE
Hibernate: drop table if exists as_record_keyword CASCADE
Hibernate: drop table if exists as_record_part CASCADE
Hibernate: drop table if exists as_record_storage_location CASCADE
Hibernate: drop table if exists as_residing_address CASCADE
Hibernate: drop table if exists as_screening CASCADE
Hibernate: drop table if exists as_screening_metadata CASCADE
Hibernate: drop table if exists as_series CASCADE
Hibernate: drop table if exists as_series_classification_system CASCADE
Hibernate: drop table if exists as_series_storage_location CASCADE
Hibernate: drop table if exists as_sign_off CASCADE
Hibernate: drop table if exists as_social_security_number CASCADE
Hibernate: drop table if exists as_storage_location CASCADE
Hibernate: drop table if exists as_unit CASCADE
Hibernate: drop table if exists aud_ad_administrative_unit_aud CASCADE
Hibernate: drop table if exists aud_ad_user_aud CASCADE
Hibernate: drop table if exists aud_as_author_aud CASCADE
Hibernate: drop table if exists aud_as_building_aud CASCADE
Hibernate: drop table if exists aud_as_cadastral_aud CASCADE
Hibernate: drop table if exists aud_as_changelog_aud CASCADE
Hibernate: drop table if exists aud_as_class_aud CASCADE
Hibernate: drop table if exists aud_as_classification_system_aud CASCADE
Hibernate: drop table if exists aud_as_classified_aud CASCADE
Hibernate: drop table if exists aud_as_comment_aud CASCADE
Hibernate: drop table if exists aud_as_contact_information_aud CASCADE
Hibernate: drop table if exists aud_as_conversion_aud CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_aud CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_internal_aud
CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_person_aud
CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_unit_aud CASCADE
Hibernate: drop table if exists aud_as_d_number_aud CASCADE
Hibernate: drop table if exists aud_as_deletion_aud CASCADE
Hibernate: drop table if exists aud_as_disposal_aud CASCADE
Hibernate: drop table if exists aud_as_disposal_undertaken_aud CASCADE
Hibernate: drop table if exists aud_as_document_description_aud CASCADE
Hibernate: drop table if exists aud_as_document_flow_aud CASCADE
Hibernate: drop table if exists aud_as_document_object_aud CASCADE
Hibernate: drop table if exists aud_as_electronic_signature_aud CASCADE
Hibernate: drop table if exists aud_as_event_log_aud CASCADE
Hibernate: drop table if exists aud_as_file_aud CASCADE
Hibernate: drop table if exists aud_as_fonds_aud CASCADE
Hibernate: drop table if exists aud_as_fonds_creator_aud CASCADE
Hibernate: drop table if exists aud_as_keyword_aud CASCADE
Hibernate: drop table if exists aud_as_national_identifier_aud CASCADE
Hibernate: drop table if exists aud_as_part_aud CASCADE
Hibernate: drop table if exists aud_as_part_person_aud CASCADE
Hibernate: drop table if exists aud_as_part_unit_aud CASCADE
Hibernate: drop table if exists aud_as_plan_aud CASCADE
Hibernate: drop table if exists aud_as_position_aud CASCADE
Hibernate: drop table if exists aud_as_record_aud CASCADE
Hibernate: drop table if exists aud_as_screening_aud CASCADE
Hibernate: drop table if exists aud_as_screening_metadata_aud CASCADE
Hibernate: drop table if exists aud_as_series_aud CASCADE
Hibernate: drop table if exists aud_as_sign_off_aud CASCADE
Hibernate: drop table if exists aud_as_social_security_number_aud CASCADE
Hibernate: drop table if exists aud_as_storage_location_aud CASCADE
Hibernate: drop table if exists aud_as_unit_aud CASCADE
Hibernate: drop table if exists aud_bsm_base_aud CASCADE
Hibernate: drop table if exists aud_md_correspondence_part_type_aud CASCADE
Hibernate: drop table if exists aud_md_part_role_aud CASCADE
Hibernate: drop table if exists aud_md_postal_code_aud CASCADE
Hibernate: drop table if exists aud_mu_meeting_file_aud CASCADE
Hibernate: drop table if exists aud_mu_meeting_participant_aud CASCADE
Hibernate: drop table if exists aud_mu_meeting_record_aud CASCADE
Hibernate: drop table if exists aud_sa_case_file_aud CASCADE
Hibernate: drop table if exists aud_sa_precedence_aud CASCADE
Hibernate: drop table if exists aud_sa_record_note_aud CASCADE
Hibernate: drop table if exists aud_sa_registry_entry_aud CASCADE
Hibernate: drop table if exists aud_system_id_entity_aud CASCADE
Hibernate: drop table if exists bsm_base CASCADE
Hibernate: drop table if exists md_access_category CASCADE
Hibernate: drop table if exists md_access_restriction CASCADE
Hibernate: drop table if exists md_associated_with_record_as CASCADE
Hibernate: drop table if exists md_bsm CASCADE
Hibernate: drop table if exists md_case_status CASCADE
Hibernate: drop table if exists md_classification_type CASCADE
Hibernate: drop table if exists md_classified_code CASCADE
Hibernate: drop table if exists md_comment_type CASCADE
Hibernate: drop table if exists md_coordinate_system CASCADE
Hibernate: drop table if exists md_correspondence_part_type CASCADE
Hibernate: drop table if exists md_country CASCADE
Hibernate: drop table if exists md_deletion_type CASCADE
Hibernate: drop table if exists md_disposal_decision CASCADE
Hibernate: drop table if exists md_document_medium CASCADE
Hibernate: drop table if exists md_document_status CASCADE
Hibernate: drop table if exists md_document_type CASCADE
Hibernate: drop table if exists md_electronic_signature_security_level
CASCADE
Hibernate: drop table if exists md_electronic_signature_verified CASCADE
Hibernate: drop table if exists md_event_type CASCADE
Hibernate: drop table if exists md_file_type CASCADE
Hibernate: drop table if exists md_flow_status CASCADE
Hibernate: drop table if exists md_fonds_status CASCADE
Hibernate: drop table if exists md_format CASCADE
Hibernate: drop table if exists md_meeting_file_type CASCADE
Hibernate: drop table if exists md_meeting_participant_function CASCADE
Hibernate: drop table if exists md_meeting_registration_status CASCADE
Hibernate: drop table if exists md_meeting_registration_type CASCADE
Hibernate: drop table if exists md_part_role CASCADE
Hibernate: drop table if exists md_postal_code CASCADE
Hibernate: drop table if exists md_precedence_status CASCADE
Hibernate: drop table if exists md_registry_entry_status CASCADE
Hibernate: drop table if exists md_registry_entry_type CASCADE
Hibernate: drop table if exists md_screening_document CASCADE
Hibernate: drop table if exists md_screening_metadata CASCADE
Hibernate: drop table if exists md_series_status CASCADE
Hibernate: drop table if exists md_sign_off_method CASCADE
Hibernate: drop table if exists md_variant_format CASCADE
Hibernate: drop table if exists mu_meeting_file CASCADE
Hibernate: drop table if exists mu_meeting_participant CASCADE
Hibernate: drop table if exists mu_meeting_record CASCADE
Hibernate: drop table if exists revinfo CASCADE
Hibernate: drop table if exists sa_case_file CASCADE
Hibernate: drop table if exists sa_case_file_precedence CASCADE
Hibernate: drop table if exists sa_precedence CASCADE
Hibernate: drop table if exists sa_record_note CASCADE
Hibernate: drop table if exists sa_registry_entry CASCADE
Hibernate: drop table if exists sa_registry_entry_precedence CASCADE
Hibernate: drop table if exists sa_registry_entry_sign_off CASCADE
Hibernate: drop table if exists sa_sequence_generator CASCADE
Hibernate: drop table if exists system_id_entity CASCADE
Hibernate: drop sequence if exists authority_seq
Hibernate: create sequence authority_seq start with 1 increment by 1
2022-05-02 06:18:03.304  INFO 31670 --- [           main]
org.hibernate.orm.connections.access     : HHH10001501: Connection obtained
from JdbcConnectionAccess
[org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess at 223459f]
for (non-JTA) DDL execution was not in auto-commit mode; the Connection
'local transaction' will be committed and the Connection will be set into
auto-commit mode.
Hibernate: create table ad_administrative_unit (administrative_unit_name
varchar(255), administrativ_enhetsstatus varchar(255),
default_administrative_unit boolean, finalised_by varchar(255),
finalised_date timestamp, short_name varchar(255), system_id varchar(40)
not null, reference_parent_administrative_unit_system_id varchar(40),
primary key (system_id))
Hibernate: create table ad_administrative_unit_user
(f_pk_administrative_unit_id varchar(40) not null, f_pk_user_id varchar(40)
not null, primary key (f_pk_administrative_unit_id, f_pk_user_id))
Hibernate: create table ad_authority (id bigint not null, authority_name
varchar(100), primary key (id))
Hibernate: create table ad_organisation (description varchar(5000),
finalised_by varchar(255), finalised_date timestamp, title varchar(5000)
not null, organisation_name varchar(255), organisation_status varchar(255),
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table ad_user (account_non_expired boolean not null,
account_non_locked boolean not null, credentials_non_expired boolean not
null, enabled boolean, finalised_by varchar(255), finalised_date timestamp,
firstname varchar(50), last_password_reset_date timestamp, lastname
varchar(50), password varchar(100), username varchar(100), system_id
varchar(40) not null, user_organisation_id varchar(40), primary key
(system_id))
Hibernate: create table ad_user_authority (f_pk_user_id varchar(40) not
null, authority_id bigint not null, primary key (f_pk_user_id,
authority_id))
Hibernate: create table as_author (author varchar(255),
is_for_document_description boolean, is_for_record boolean, system_id
varchar(40) not null, f_pk_document_description_id varchar(40),
f_pk_record_id varchar(40), primary key (system_id))
Hibernate: create table as_building (building_number integer not null,
endringsloepenummer integer, system_id varchar(40) not null, primary key
(system_id))
Hibernate: create table as_business_address (address_line_1 varchar(255),
address_line_2 varchar(255), address_line_3 varchar(255), address_type
varchar(255) not null, country_code varchar(255), postal_number
varchar(255), postal_town varchar(255), system_id varchar(40) not null,
part_unit_system_id varchar(40),
reference_correspondence_part_unit_system_id varchar(40), primary key
(system_id))
Hibernate: create table as_cadastral (holding_number integer not null,
lease_number integer, municipality_number varchar(255) not null,
section_number integer, sub_holding_number integer not null, system_id
varchar(40) not null, primary key (system_id))
Hibernate: create table as_changelog (new_value varchar(255), old_value
varchar(255), reference_archive_unit binary, reference_changed_by
varchar(255), reference_metadata varchar(255), system_id varchar(40) not
null, system_id_entity_id varchar(40), primary key (system_id))
Hibernate: create table as_class (description varchar(5000), finalised_by
varchar(255), finalised_date timestamp, title varchar(5000) not null,
class_id varchar(255), system_id varchar(40) not null,
class_classification_system_id varchar(40), class_classified_id
varchar(40), class_disposal_id varchar(40),
reference_parent_class_system_id varchar(40), class_screening_id
varchar(40), primary key (system_id))
Hibernate: create table as_class_keyword (f_pk_class_id varchar(40) not
null, f_pk_keyword_id varchar(40) not null, primary key (f_pk_class_id,
f_pk_keyword_id))
Hibernate: create table as_classification_system (description
varchar(5000), finalised_by varchar(255), finalised_date timestamp, title
varchar(5000) not null, classification_type_code varchar(255),
classification_type_code_name varchar(255), system_id varchar(40) not null,
primary key (system_id))
Hibernate: create table as_classified (classification_by varchar(255),
classification_code varchar(255) not null, classification_name
varchar(255), classification_date timestamp, classification_downgraded_by
varchar(255), classification_downgraded_date timestamp, system_id
varchar(40) not null, primary key (system_id))
Hibernate: create table as_comment (comment_date timestamp,
comment_registered_by varchar(255), comment_text varchar(8192),
comment_type_code varchar(255), comment_type_code_name varchar(255),
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_contact_information (email_address varchar(255),
mobile_telephone_number varchar(255), telephone_number varchar(255),
system_id varchar(40) not null, part_person_system_id varchar(40),
part_unit_system_id varchar(40),
reference_correspondence_part_person_system_id varchar(40),
reference_correspondence_part_unit_system_id varchar(40), primary key
(system_id))
Hibernate: create table as_conversion (conversion_comment varchar(255),
conversion_tool varchar(255), converted_by varchar(255), converted_date
timestamp, converted_from_format_code varchar(255),
converted_from_format_code_name varchar(255), converted_to_format_code
varchar(255), converted_to_format_code_name varchar(255), system_id
varchar(40) not null, conversion_document_object_id varchar(40), primary
key (system_id))
Hibernate: create table as_correspondence_part
(correspondence_part_type_code varchar(255) not null,
correspondence_part_type_code_name varchar(255), system_id varchar(40) not
null, f_pk_record_id varchar(40), primary key (system_id))
Hibernate: create table as_correspondence_part_internal
(administrative_unit varchar(255), case_handler varchar(255), system_id
varchar(40) not null, reference_administrative_unit_system_id varchar(40),
user_system_id varchar(40), primary key (system_id))
Hibernate: create table as_correspondence_part_person (d_number
varchar(255), name varchar(255), social_security_number varchar(255),
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_correspondence_part_unit (contact_person
varchar(255), name varchar(255), unit_identifier varchar(255), system_id
varchar(40) not null, primary key (system_id))
Hibernate: create table as_cross_reference (reference_from_type
varchar(255) not null, from_system_id binary not null, reference_type
varchar(255) not null, to_system_id binary not null, system_id varchar(40)
not null, cross_reference_class_id varchar(40), cross_reference_file_id
varchar(40), cross_reference_record_id varchar(40), primary key (system_id))
Hibernate: create table as_d_number (d_number varchar(255) not null,
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_deletion (deletion_by varchar(255),
deletion_date timestamp, deletion_type_code varchar(255),
deletion_type_code_name varchar(255), system_id varchar(40) not null,
primary key (system_id))
Hibernate: create table as_disposal (disposal_authority varchar(255),
disposal_date timestamp, disposal_decision varchar(255), preservation_time
integer, system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_disposal_undertaken (disposal_by varchar(255),
disposal_date timestamp, system_id varchar(40) not null, primary key
(system_id))
Hibernate: create table as_document_description (associated_by
varchar(255), associated_with_record_as_code varchar(255) not null,
associated_with_record_as_code_name varchar(255) not null, association_date
timestamp, description varchar(5000), document_medium_code varchar(255),
document_medium_code_name varchar(255), document_number integer,
document_status_code varchar(255), document_status_code_name varchar(255),
document_type_code varchar(255) not null, document_type_code_name
varchar(255) not null, external_reference varchar(255), storage_location
varchar(255), title varchar(5000) not null, system_id varchar(40) not null,
document_description_classified_id varchar(40),
document_description_deletion_id varchar(40),
document_description_disposal_id varchar(40),
document_description_disposal_undertaken_id varchar(40),
document_description_screening_id varchar(40), primary key (system_id))
Hibernate: create table as_document_description_comment
(f_pk_document_description_id varchar(40) not null, f_pk_comment_id
varchar(40) not null, primary key (f_pk_document_description_id,
f_pk_comment_id))
Hibernate: create table as_document_description_party
(f_pk_document_description_id varchar(40) not null, f_pk_part_id
varchar(40) not null, primary key (f_pk_document_description_id,
f_pk_part_id))
Hibernate: create table as_document_flow (flow_comment varchar(255),
flow_from varchar(255), flow_received_date timestamp, flow_sent_date
timestamp, flow_status_code varchar(255), flow_status_code_name
varchar(255), flow_to varchar(255), reference_flow_from binary,
reference_flow_to binary, system_id varchar(40) not null,
document_flow_flow_from_id varchar(40), document_flow_flow_to_id
varchar(40), document_flow_record_note_id varchar(40),
document_flow_registry_entry_id varchar(40), primary key (system_id))
Hibernate: create table as_document_object (checksum varchar(255),
checksum_algorithm varchar(255), document_tokens clob, file_size bigint,
format_code varchar(255), format_code_name varchar(255), format_details
varchar(255), mime_type varchar(255), original_filename varchar(100),
reference_document_file varchar(255), variant_format_code varchar(255) not
null, variant_format_code_name varchar(255) not null, version_number
integer not null, system_id varchar(40) not null,
document_object_document_description_id varchar(40), primary key
(system_id))
Hibernate: create table as_electronic_signature (system_id varchar(40) not
null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint,
electronic_signature_security_level_code_ varchar(255),
electronic_signature_security_level_code_name varchar(255),
electronic_signature_verified_code varchar(255),
electronic_signature_verified_code_name varchar(255), verified_by
varchar(255), verified_date timestamp, owned_by varchar(40), primary key
(system_id))
Hibernate: create table as_event_log (description varchar(5000), event_date
timestamp, event_log_event_type_code varchar(255),
event_log_event_type_code_name varchar(255), system_id varchar(40) not
null, primary key (system_id))
Hibernate: create table as_file (description varchar(5000), finalised_by
varchar(255), finalised_date timestamp, title varchar(5000) not null,
document_medium_code varchar(255), document_medium_code_name varchar(255),
file_id varchar(255), public_title varchar(5000), system_id varchar(40) not
null, file_class_id varchar(40), file_classified_id varchar(40),
file_disposal_id varchar(40), reference_parent_file_system_id varchar(40),
file_screening_id varchar(40), file_series_id varchar(40), primary key
(system_id))
Hibernate: create table as_file_comment (f_pk_file_id varchar(40) not null,
f_pk_comment_id varchar(40) not null, primary key (f_pk_file_id,
f_pk_comment_id))
Hibernate: create table as_file_keyword (f_pk_file_id varchar(40) not null,
f_pk_keyword_id varchar(40) not null, primary key (f_pk_file_id,
f_pk_keyword_id))
Hibernate: create table as_file_part (f_pk_file_id varchar(40) not null,
f_pk_part_id varchar(40) not null, primary key (f_pk_file_id, f_pk_part_id))
Hibernate: create table as_file_storage_location (f_pk_file_id varchar(40)
not null, f_pk_storage_location_id varchar(40) not null, primary key
(f_pk_file_id, f_pk_storage_location_id))
Hibernate: create table as_fonds (description varchar(5000), finalised_by
varchar(255), finalised_date timestamp, title varchar(5000) not null,
document_medium_code varchar(255), document_medium_code_name varchar(255),
fonds_status_code varchar(255), fonds_status_code_name varchar(255),
system_id varchar(40) not null, reference_parent_fonds_system_id
varchar(40), primary key (system_id))
Hibernate: create table as_fonds_creator (description varchar(5000),
fonds_creator_id varchar(255) not null, fonds_creator_name varchar(255) not
null, system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_fonds_fonds_creator (f_pk_fonds_id varchar(40)
not null, f_pk_fonds_creator_id varchar(40) not null, primary key
(f_pk_fonds_id, f_pk_fonds_creator_id))
Hibernate: create table as_fonds_storage_location (f_pk_fonds_id
varchar(40) not null, f_pk_storage_location_id varchar(40) not null,
primary key (f_pk_fonds_id, f_pk_storage_location_id))
Hibernate: create table as_keyword (keyword varchar(255) not null,
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_national_identifier (system_id varchar(40) not
null, national_identifier_file_id varchar(40),
national_identifier_record_id varchar(40), primary key (system_id))
Hibernate: create table as_part (description varchar(5000), finalised_by
varchar(255), finalised_date timestamp, title varchar(5000) not null, name
varchar(255), part_role_code varchar(255) not null, part_role_code_name
varchar(255), system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_part_person (d_number varchar(255),
social_security_number varchar(255), system_id varchar(40) not null,
primary key (system_id))
Hibernate: create table as_part_unit (contact_person varchar(255),
organisation_number varchar(255), system_id varchar(40) not null, primary
key (system_id))
Hibernate: create table as_plan (country_code varchar(255),
country_code_name varchar(255), county_number varchar(255), kommunenummer
varchar(255), plan_identification varchar(255) not null, system_id
varchar(40) not null, primary key (system_id))
Hibernate: create table as_position (coordinate_system_code varchar(255)
not null, coordinate_system_code_name varchar(255) not null, x double not
null, y double not null, z double, system_id varchar(40) not null, primary
key (system_id))
Hibernate: create table as_postal_address (address_line_1 varchar(255),
address_line_2 varchar(255), address_line_3 varchar(255), address_type
varchar(255) not null, country_code varchar(255), postal_number
varchar(255), postal_town varchar(255), system_id varchar(40) not null,
part_person_system_id varchar(40), part_unit_system_id varchar(40),
reference_correspondence_part_person_system_id varchar(40),
reference_correspondence_part_unit_system_id varchar(40), primary key
(system_id))
Hibernate: create table as_record (archived_by varchar(255), archived_date
timestamp, description varchar(5000), document_medium_code varchar(255),
document_medium_code_name varchar(255), public_title varchar(5000),
record_id varchar(255), title varchar(5000) not null, system_id varchar(40)
not null, record_class_id varchar(40), record_classified_id varchar(40),
record_disposal_id varchar(40), record_file_id varchar(40),
record_screening_id varchar(40), record_series_id varchar(40), primary key
(system_id))
Hibernate: create table as_record_comment (f_pk_record_id varchar(40) not
null, f_pk_comment_id varchar(40) not null, primary key (f_pk_record_id,
f_pk_comment_id))
Hibernate: create table as_record_document_description (f_pk_record_id
varchar(40) not null, f_pk_document_description_id varchar(40) not null,
primary key (f_pk_record_id, f_pk_document_description_id))
Hibernate: create table as_record_keyword (f_pk_record_id varchar(40) not
null, f_pk_keyword_id varchar(40) not null, primary key (f_pk_record_id,
f_pk_keyword_id))
Hibernate: create table as_record_part (f_pk_record_id varchar(40) not
null, f_pk_part_id varchar(40) not null, primary key (f_pk_record_id,
f_pk_part_id))
Hibernate: create table as_record_storage_location (f_pk_record_id
varchar(40) not null, f_pk_storage_location_id varchar(40) not null,
primary key (f_pk_record_id, f_pk_storage_location_id))
Hibernate: create table as_residing_address (address_line_1 varchar(255),
address_line_2 varchar(255), address_line_3 varchar(255), address_type
varchar(255) not null, country_code varchar(255), postal_number
varchar(255), postal_town varchar(255), system_id varchar(40) not null,
part_person_system_id varchar(40),
reference_correspondence_part_person_system_id varchar(40), primary key
(system_id))
Hibernate: create table as_screening (access_restriction_code varchar(255),
access_restriction_code_name varchar(255), screening_authority
varchar(255), screening_document_code varchar(255),
screening_document_code_name varchar(255), skjermingsvarighet integer,
screening_expires_date timestamp, system_id varchar(40) not null, primary
key (system_id))
Hibernate: create table as_screening_metadata (code varchar(255), code_name
varchar(255), system_id varchar(40) not null,
screening_screening_metadata_id varchar(40), primary key (system_id))
Hibernate: create table as_series (description varchar(5000), finalised_by
varchar(255), finalised_date timestamp, title varchar(5000) not null,
document_medium_code varchar(255), document_medium_code_name varchar(255),
reference_precursor_id varchar(255), reference_successor_id varchar(255),
series_end_date timestamp, series_start_date timestamp, series_status_code
varchar(255) not null, series_status_code_name varchar(255) not null,
system_id varchar(40) not null, series_classified_id varchar(40),
series_deletion_id varchar(40), series_disposal_id varchar(40),
series_disposal_undertaken_id varchar(40), series_fonds_id varchar(40),
reference_precursor_system_id varchar(40), series_screening_id varchar(40),
primary key (system_id))
Hibernate: create table as_series_classification_system (f_pk_series_id
varchar(40) not null, f_pk_classification_system_id varchar(40) not null,
primary key (f_pk_series_id, f_pk_classification_system_id))
Hibernate: create table as_series_storage_location (f_pk_series_id
varchar(40) not null, f_pk_storage_location_id varchar(40) not null,
primary key (f_pk_series_id, f_pk_storage_location_id))
Hibernate: create table as_sign_off (reference_correspondence_part_id
binary, reference_record_id binary, sign_off_by varchar(255), sign_off_date
timestamp, sign_off_method_code varchar(255), sign_off_method_code_name
varchar(255), system_id varchar(40) not null, pk_correspondence_part_id
varchar(40), fk_record_id varchar(40), primary key (system_id))
Hibernate: create table as_social_security_number (social_security_number
varchar(255), system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_storage_location (storage_location varchar(255),
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table as_unit (organisation_number varchar(255) not null,
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table aud_ad_administrative_unit_aud (system_id
varchar(40) not null, rev integer not null, administrative_unit_name
varchar(255), administrativ_enhetsstatus varchar(255),
default_administrative_unit boolean, finalised_by varchar(255),
finalised_date timestamp, short_name varchar(255), primary key (system_id,
rev))
Hibernate: create table aud_ad_user_aud (system_id varchar(40) not null,
rev integer not null, finalised_by varchar(255), finalised_date timestamp,
primary key (system_id, rev))
Hibernate: create table aud_as_author_aud (system_id varchar(40) not null,
rev integer not null, author varchar(255), is_for_document_description
boolean, is_for_record boolean, primary key (system_id, rev))
Hibernate: create table aud_as_building_aud (system_id varchar(40) not
null, rev integer not null, building_number integer, endringsloepenummer
integer, primary key (system_id, rev))
Hibernate: create table aud_as_cadastral_aud (system_id varchar(40) not
null, rev integer not null, holding_number integer, lease_number integer,
municipality_number varchar(255), section_number integer,
sub_holding_number integer, primary key (system_id, rev))
Hibernate: create table aud_as_changelog_aud (system_id varchar(40) not
null, rev integer not null, new_value varchar(255), old_value varchar(255),
reference_archive_unit binary, reference_changed_by varchar(255),
reference_metadata varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_class_aud (system_id varchar(40) not null,
rev integer not null, description varchar(5000), finalised_by varchar(255),
finalised_date timestamp, title varchar(5000), class_id varchar(255),
primary key (system_id, rev))
Hibernate: create table aud_as_classification_system_aud (system_id
varchar(40) not null, rev integer not null, description varchar(5000),
finalised_by varchar(255), finalised_date timestamp, title varchar(5000),
classification_type_code varchar(255), classification_type_code_name
varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_classified_aud (system_id varchar(40) not
null, rev integer not null, classification_by varchar(255),
classification_code varchar(255), classification_name varchar(255),
classification_date timestamp, classification_downgraded_by varchar(255),
classification_downgraded_date timestamp, primary key (system_id, rev))
Hibernate: create table aud_as_comment_aud (system_id varchar(40) not null,
rev integer not null, comment_date timestamp, comment_registered_by
varchar(255), comment_text varchar(8192), comment_type_code varchar(255),
comment_type_code_name varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_contact_information_aud (system_id
varchar(40) not null, rev integer not null, email_address varchar(255),
mobile_telephone_number varchar(255), telephone_number varchar(255),
primary key (system_id, rev))
Hibernate: create table aud_as_conversion_aud (system_id varchar(40) not
null, rev integer not null, conversion_comment varchar(255),
conversion_tool varchar(255), converted_by varchar(255), converted_date
timestamp, converted_from_format_code varchar(255),
converted_from_format_code_name varchar(255), converted_to_format_code
varchar(255), converted_to_format_code_name varchar(255), primary key
(system_id, rev))
Hibernate: create table aud_as_correspondence_part_aud (system_id
varchar(40) not null, rev integer not null, correspondence_part_type_code
varchar(255), correspondence_part_type_code_name varchar(255),
f_pk_record_id varchar(40), primary key (system_id, rev))
Hibernate: create table aud_as_correspondence_part_internal_aud (system_id
varchar(40) not null, rev integer not null, administrative_unit
varchar(255), case_handler varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_correspondence_part_person_aud (system_id
varchar(40) not null, rev integer not null, d_number varchar(255), name
varchar(255), social_security_number varchar(255), primary key (system_id,
rev))
Hibernate: create table aud_as_correspondence_part_unit_aud (system_id
varchar(40) not null, rev integer not null, contact_person varchar(255),
name varchar(255), unit_identifier varchar(255), primary key (system_id,
rev))
Hibernate: create table aud_as_d_number_aud (system_id varchar(40) not
null, rev integer not null, d_number varchar(255), primary key (system_id,
rev))
Hibernate: create table aud_as_deletion_aud (system_id varchar(40) not
null, rev integer not null, deletion_by varchar(255), deletion_date
timestamp, deletion_type_code varchar(255), deletion_type_code_name
varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_disposal_aud (system_id varchar(40) not
null, rev integer not null, disposal_authority varchar(255), disposal_date
timestamp, disposal_decision varchar(255), preservation_time integer,
primary key (system_id, rev))
Hibernate: create table aud_as_disposal_undertaken_aud (system_id
varchar(40) not null, rev integer not null, disposal_by varchar(255),
disposal_date timestamp, primary key (system_id, rev))
Hibernate: create table aud_as_document_description_aud (system_id
varchar(40) not null, rev integer not null, associated_by varchar(255),
associated_with_record_as_code varchar(255),
associated_with_record_as_code_name varchar(255), association_date
timestamp, description varchar(5000), document_medium_code varchar(255),
document_medium_code_name varchar(255), document_number integer,
document_status_code varchar(255), document_status_code_name varchar(255),
document_type_code varchar(255), document_type_code_name varchar(255),
external_reference varchar(255), storage_location varchar(255), title
varchar(5000), primary key (system_id, rev))
Hibernate: create table aud_as_document_flow_aud (system_id varchar(40) not
null, rev integer not null, flow_comment varchar(255), flow_from
varchar(255), flow_received_date timestamp, flow_sent_date timestamp,
flow_status_code varchar(255), flow_status_code_name varchar(255), flow_to
varchar(255), reference_flow_from binary, reference_flow_to binary, primary
key (system_id, rev))
Hibernate: create table aud_as_document_object_aud (system_id varchar(40)
not null, rev integer not null, checksum varchar(255), checksum_algorithm
varchar(255), file_size bigint, format_code varchar(255), format_code_name
varchar(255), format_details varchar(255), mime_type varchar(255),
original_filename varchar(100), reference_document_file varchar(255),
variant_format_code varchar(255), variant_format_code_name varchar(255),
version_number integer, primary key (system_id, rev))
Hibernate: create table aud_as_electronic_signature_aud (system_id
varchar(40) not null, rev integer not null, revtype tinyint, created_by
varchar(255), created_date timestamp,
electronic_signature_security_level_code_ varchar(255),
electronic_signature_security_level_code_name varchar(255),
electronic_signature_verified_code varchar(255),
electronic_signature_verified_code_name varchar(255), verified_by
varchar(255), verified_date timestamp, primary key (system_id, rev))
Hibernate: create table aud_as_event_log_aud (system_id varchar(40) not
null, rev integer not null, description varchar(5000), event_date
timestamp, event_log_event_type_code varchar(255),
event_log_event_type_code_name varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_file_aud (system_id varchar(40) not null,
rev integer not null, description varchar(5000), finalised_by varchar(255),
finalised_date timestamp, title varchar(5000), document_medium_code
varchar(255), document_medium_code_name varchar(255), file_id varchar(255),
public_title varchar(5000), primary key (system_id, rev))
Hibernate: create table aud_as_fonds_aud (system_id varchar(40) not null,
rev integer not null, description varchar(5000), finalised_by varchar(255),
finalised_date timestamp, title varchar(5000), document_medium_code
varchar(255), document_medium_code_name varchar(255), fonds_status_code
varchar(255), fonds_status_code_name varchar(255), primary key (system_id,
rev))
Hibernate: create table aud_as_fonds_creator_aud (system_id varchar(40) not
null, rev integer not null, description varchar(5000), fonds_creator_id
varchar(255), fonds_creator_name varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_keyword_aud (system_id varchar(40) not null,
rev integer not null, keyword varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_national_identifier_aud (system_id
varchar(40) not null, rev integer not null, national_identifier_file_id
varchar(40), national_identifier_record_id varchar(40), primary key
(system_id, rev))
Hibernate: create table aud_as_part_aud (system_id varchar(40) not null,
rev integer not null, description varchar(5000), finalised_by varchar(255),
finalised_date timestamp, title varchar(5000), name varchar(255),
part_role_code varchar(255), part_role_code_name varchar(255), primary key
(system_id, rev))
Hibernate: create table aud_as_part_person_aud (system_id varchar(40) not
null, rev integer not null, d_number varchar(255), social_security_number
varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_part_unit_aud (system_id varchar(40) not
null, rev integer not null, contact_person varchar(255),
organisation_number varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_plan_aud (system_id varchar(40) not null,
rev integer not null, country_code varchar(255), country_code_name
varchar(255), county_number varchar(255), kommunenummer varchar(255),
plan_identification varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_position_aud (system_id varchar(40) not
null, rev integer not null, coordinate_system_code varchar(255),
coordinate_system_code_name varchar(255), x double, y double, z double,
primary key (system_id, rev))
Hibernate: create table aud_as_record_aud (system_id varchar(40) not null,
rev integer not null, archived_by varchar(255), archived_date timestamp,
description varchar(5000), document_medium_code varchar(255),
document_medium_code_name varchar(255), public_title varchar(5000),
record_id varchar(255), title varchar(5000), primary key (system_id, rev))
Hibernate: create table aud_as_screening_aud (system_id varchar(40) not
null, rev integer not null, access_restriction_code varchar(255),
access_restriction_code_name varchar(255), screening_authority
varchar(255), screening_document_code varchar(255),
screening_document_code_name varchar(255), skjermingsvarighet integer,
screening_expires_date timestamp, primary key (system_id, rev))
Hibernate: create table aud_as_screening_metadata_aud (system_id
varchar(40) not null, rev integer not null, code varchar(255), code_name
varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_series_aud (system_id varchar(40) not null,
rev integer not null, description varchar(5000), finalised_by varchar(255),
finalised_date timestamp, title varchar(5000), document_medium_code
varchar(255), document_medium_code_name varchar(255), series_end_date
timestamp, series_start_date timestamp, series_status_code varchar(255),
series_status_code_name varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_sign_off_aud (system_id varchar(40) not
null, rev integer not null, reference_correspondence_part_id binary,
reference_record_id binary, sign_off_by varchar(255), sign_off_date
timestamp, sign_off_method_code varchar(255), sign_off_method_code_name
varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_social_security_number_aud (system_id
varchar(40) not null, rev integer not null, social_security_number
varchar(255), primary key (system_id, rev))
Hibernate: create table aud_as_storage_location_aud (system_id varchar(40)
not null, rev integer not null, storage_location varchar(255), primary key
(system_id, rev))
Hibernate: create table aud_as_unit_aud (system_id varchar(40) not null,
rev integer not null, organisation_number varchar(255), primary key
(system_id, rev))
Hibernate: create table aud_bsm_base_aud (system_id varchar(40) not null,
rev integer not null, data_type varchar(255), value_name varchar(255),
value_namespace varchar(255), primary key (system_id, rev))
Hibernate: create table aud_md_correspondence_part_type_aud (code
varchar(60) not null, rev integer not null, revtype tinyint, created_by
varchar(255), created_date timestamp, code_name varchar(255), inactive
boolean, primary key (code, rev))
Hibernate: create table aud_md_part_role_aud (code varchar(60) not null,
rev integer not null, revtype tinyint, created_by varchar(255),
created_date timestamp, code_name varchar(255), inactive boolean, primary
key (code, rev))
Hibernate: create table aud_md_postal_code_aud (code varchar(60) not null,
rev integer not null, revtype tinyint, created_by varchar(255),
created_date timestamp, code_name varchar(255), inactive boolean, category
varchar(255), municipality_name varchar(255), municipality_number
varchar(255), primary key (code, rev))
Hibernate: create table aud_mu_meeting_file_aud (system_id varchar(40) not
null, rev integer not null, committee varchar(255), loaned_date timestamp,
meeting_number varchar(255), meeting_place varchar(255), primary key
(system_id, rev))
Hibernate: create table aud_mu_meeting_participant_aud (system_id
varchar(40) not null, rev integer not null, meeting_participant_function
varchar(255), meeting_participant_name varchar(255), primary key
(system_id, rev))
Hibernate: create table aud_mu_meeting_record_aud (system_id varchar(40)
not null, rev integer not null, administrative_unit varchar(255),
case_handler varchar(255), meeting_case_type varchar(255),
meeting_record_status varchar(255), meeting_record_type varchar(255),
primary key (system_id, rev))
Hibernate: create table aud_sa_case_file_aud (system_id varchar(40) not
null, rev integer not null, case_date timestamp, case_responsible
varchar(255), case_sequence_number integer, case_status_code varchar(255),
case_status_code_name varchar(255), case_year integer, loaned_date
timestamp, loaned_to varchar(255), records_management_unit varchar(255),
primary key (system_id, rev))
Hibernate: create table aud_sa_precedence_aud (system_id varchar(40) not
null, rev integer not null, description varchar(5000), finalised_by
varchar(255), finalised_date timestamp, title varchar(5000),
precedence_approved_by varchar(255), precedence_approved_date timestamp,
precedence_authority varchar(255), precedence_date timestamp,
precedence_status_code varchar(255), precedence_status_code_name
varchar(255), precedence_approved_by_reference binary, source_of_law
varchar(255), primary key (system_id, rev))
Hibernate: create table aud_sa_record_note_aud (system_id varchar(40) not
null, rev integer not null, document_date timestamp, due_date timestamp,
freedom_assessment_date timestamp, loaned_date timestamp, loaned_to
varchar(255), number_of_attachments integer, received_date timestamp,
sent_date timestamp, primary key (system_id, rev))
Hibernate: create table aud_sa_registry_entry_aud (system_id varchar(40)
not null, rev integer not null, document_date timestamp, due_date
timestamp, freedom_assessment_date timestamp, loaned_date timestamp,
loaned_to varchar(255), number_of_attachments integer, received_date
timestamp, record_date timestamp, record_sequence_number integer,
record_year integer, records_management_unit varchar(255),
registry_entry_number integer, registry_entry_status_code varchar(255),
registry_entry_status_code_name varchar(255), registry_entry_type_code
varchar(255), registry_entry_type_code_name varchar(255), sent_date
timestamp, primary key (system_id, rev))
Hibernate: create table aud_system_id_entity_aud (system_id varchar(40) not
null, rev integer not null, revtype tinyint, created_by varchar(255),
created_date timestamp, object_type varchar(255), primary key (system_id,
rev))
Hibernate: create table bsm_base (boolean_value boolean, data_type
varchar(255) not null, double_value double, integer_value integer,
is_null_value boolean, offsetdatetime_value timestamp, string_value
varchar(10000), uri_value varchar(255), value_name varchar(255),
value_namespace varchar(255), system_id varchar(40) not null,
fk_bsm_administrative_unit_id varchar(40), fk_bsm_correspondence_part_id
varchar(40), fk_bsm_document_description_id varchar(40), fk_bsm_file_id
varchar(40), fk_bsm_part_id varchar(40), fk_bsm_record_id varchar(40),
primary key (system_id))
Hibernate: create table md_access_category (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_access_restriction (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_associated_with_record_as (code varchar(60) not
null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_bsm (description varchar(255), attribute_name
varchar(80) not null, outdated boolean not null, source varchar(255),
datatype varchar(255) not null, system_id varchar(40) not null, primary key
(system_id))
Hibernate: create table md_case_status (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_classification_type (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_classified_code (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_comment_type (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_coordinate_system (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_correspondence_part_type (code varchar(60) not
null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_country (code varchar(60) not null, created_by
varchar(255), created_date timestamp, last_modified_by varchar(255),
last_modified_date timestamp, version bigint, code_name varchar(255),
inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_deletion_type (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_disposal_decision (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_document_medium (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_document_status (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_document_type (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_electronic_signature_security_level (code
varchar(60) not null, created_by varchar(255), created_date timestamp,
last_modified_by varchar(255), last_modified_date timestamp, version
bigint, code_name varchar(255), inactive boolean, owned_by varchar(40),
primary key (code))
Hibernate: create table md_electronic_signature_verified (code varchar(60)
not null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_event_type (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_file_type (code varchar(60) not null, created_by
varchar(255), created_date timestamp, last_modified_by varchar(255),
last_modified_date timestamp, version bigint, code_name varchar(255),
inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_flow_status (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_fonds_status (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_format (code varchar(60) not null, created_by
varchar(255), created_date timestamp, last_modified_by varchar(255),
last_modified_date timestamp, version bigint, code_name varchar(255),
inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_meeting_file_type (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_meeting_participant_function (code varchar(60)
not null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_meeting_registration_status (code varchar(60)
not null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_meeting_registration_type (code varchar(60) not
null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_part_role (code varchar(60) not null, created_by
varchar(255), created_date timestamp, last_modified_by varchar(255),
last_modified_date timestamp, version bigint, code_name varchar(255),
inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_postal_code (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, category varchar(255), municipality_name
varchar(255), municipality_number varchar(255), owned_by varchar(40),
primary key (code))
Hibernate: create table md_precedence_status (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_registry_entry_status (code varchar(60) not
null, created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_registry_entry_type (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_screening_document (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_screening_metadata (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_series_status (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_sign_off_method (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table md_variant_format (code varchar(60) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, code_name
varchar(255), inactive boolean, owned_by varchar(40), primary key (code))
Hibernate: create table mu_meeting_file (committee varchar(255),
loaned_date timestamp, meeting_number varchar(255), meeting_place
varchar(255), system_id varchar(40) not null,
reference_next_meeting_system_id varchar(40),
reference_previous_meeting_system_id varchar(40), primary key (system_id))
Hibernate: create table mu_meeting_participant
(meeting_participant_function varchar(255), meeting_participant_name
varchar(255), system_id varchar(40) not null, meeting_participant_file_id
varchar(40), primary key (system_id))
Hibernate: create table mu_meeting_record (administrative_unit
varchar(255), case_handler varchar(255), meeting_case_type varchar(255),
meeting_record_status varchar(255), meeting_record_type varchar(255),
system_id varchar(40) not null,
reference_from_meeting_registration_system_id varchar(40),
reference_to_meeting_registration_system_id varchar(40), primary key
(system_id))
Hibernate: create table revinfo (rev integer generated by default as
identity, revtstmp bigint, primary key (rev))
Hibernate: create table sa_case_file (case_date timestamp not null,
case_responsible varchar(255) not null, case_sequence_number integer,
case_status_code varchar(255) not null, case_status_code_name varchar(255),
case_year integer, loaned_date timestamp, loaned_to varchar(255),
records_management_unit varchar(255), system_id varchar(40) not null,
case_file_administrative_unit_id varchar(40), primary key (system_id))
Hibernate: create table sa_case_file_precedence (f_pk_case_file_id
varchar(40) not null, f_pk_precedence_id varchar(40) not null, primary key
(f_pk_case_file_id, f_pk_precedence_id))
Hibernate: create table sa_precedence (description varchar(5000),
finalised_by varchar(255), finalised_date timestamp, title varchar(5000)
not null, precedence_approved_by varchar(255), precedence_approved_date
timestamp, precedence_authority varchar(255), precedence_date timestamp,
precedence_status_code varchar(255), precedence_status_code_name
varchar(255), precedence_approved_by_reference binary, source_of_law
varchar(255), system_id varchar(40) not null, precedence_approved_by_id
varchar(40), primary key (system_id))
Hibernate: create table sa_record_note (document_date timestamp, due_date
timestamp, freedom_assessment_date timestamp, loaned_date timestamp,
loaned_to varchar(255), number_of_attachments integer, received_date
timestamp, sent_date timestamp, system_id varchar(40) not null, primary key
(system_id))
Hibernate: create table sa_registry_entry (document_date timestamp,
due_date timestamp, freedom_assessment_date timestamp, loaned_date
timestamp, loaned_to varchar(255), number_of_attachments integer,
received_date timestamp, record_date timestamp not null,
record_sequence_number integer not null, record_year integer not null,
records_management_unit varchar(255), registry_entry_number integer not
null, registry_entry_status_code varchar(255),
registry_entry_status_code_name varchar(255) not null,
registry_entry_type_code varchar(255) not null,
registry_entry_type_code_name varchar(255) not null, sent_date timestamp,
system_id varchar(40) not null, primary key (system_id))
Hibernate: create table sa_registry_entry_precedence (f_pk_record_id
varchar(40) not null, f_pk_precedence_id varchar(40) not null, primary key
(f_pk_record_id, f_pk_precedence_id))
Hibernate: create table sa_registry_entry_sign_off (f_pk_record_id
varchar(40) not null, f_pk_sign_off_id varchar(40) not null, primary key
(f_pk_record_id, f_pk_sign_off_id))
Hibernate: create table sa_sequence_generator (year integer not null,
administrative_unit_name varchar(255), record_sequence_number integer,
case_file_sequence_number integer, reference_administrative_unit
varchar(40) not null, primary key (reference_administrative_unit, year))
Hibernate: create table system_id_entity (system_id varchar(40) not null,
created_by varchar(255), created_date timestamp, last_modified_by
varchar(255), last_modified_date timestamp, version bigint, object_type
varchar(255), owned_by varchar(40), primary key (system_id))
Hibernate: alter table ad_authority add constraint
UK_k73f0tpniuqlq1iomgfysf4q0 unique (authority_name)
Hibernate: alter table ad_user add constraint UK_1fwlix94vjrf85npdg1y5ta18
unique (username)
Hibernate: create index index_filname on as_document_object
(original_filename)
Hibernate: alter table md_bsm add constraint UK_ehdcv7grjbih3n5jo4rb98vo6
unique (attribute_name)
Hibernate: alter table ad_administrative_unit add constraint
FKciyfjmuels27qqfebbeowdjtn foreign key
(reference_parent_administrative_unit_system_id) references
ad_administrative_unit
Hibernate: alter table ad_administrative_unit add constraint
FKoo9fwvp1g7rbetota2bfbu1mh foreign key (system_id) references
system_id_entity
Hibernate: alter table ad_administrative_unit_user add constraint
FKfdvm7nef6anbgg3p8a4vl5es4 foreign key (f_pk_user_id) references ad_user
Hibernate: alter table ad_administrative_unit_user add constraint
FKpe8qegorjcqrkeu1ocdkfn636 foreign key (f_pk_administrative_unit_id)
references ad_administrative_unit
Hibernate: alter table ad_organisation add constraint
FKffe965spuw9557xvbpblmnqrp foreign key (system_id) references
system_id_entity
Hibernate: alter table ad_user add constraint FKo5t0ab04msp2obbh49ev39hjj
foreign key (user_organisation_id) references ad_organisation
Hibernate: alter table ad_user add constraint FKkvb63y2t14gva5hvyal4c5ncc
foreign key (system_id) references system_id_entity
Hibernate: alter table ad_user_authority add constraint
FKhkppggxx63ob75bus4a01136h foreign key (authority_id) references
ad_authority
Hibernate: alter table ad_user_authority add constraint
FK96f8b9f0xuvl1gijalj5ek2mx foreign key (f_pk_user_id) references ad_user
Hibernate: alter table as_author add constraint FKbjahtxdmu7vftkcjvu1x76lt6
foreign key (f_pk_document_description_id) references
as_document_description
Hibernate: alter table as_author add constraint FKtl967itiq0nkcvltxw9rsmflx
foreign key (f_pk_record_id) references as_record
Hibernate: alter table as_author add constraint FKd12ncpp5nimo7fu92dvgicn0q
foreign key (system_id) references system_id_entity
Hibernate: alter table as_building add constraint
FKsev7k271x73rgjbpel2hqyaof foreign key (system_id) references
as_national_identifier
Hibernate: alter table as_business_address add constraint
FK317ebpyyqctojl774nuuvem46 foreign key (part_unit_system_id) references
as_part_unit
Hibernate: alter table as_business_address add constraint
FK3yxe891ui3sotgopyfkplyxlu foreign key
(reference_correspondence_part_unit_system_id) references
as_correspondence_part_unit
Hibernate: alter table as_business_address add constraint
FKpqhvcv3hcfsb88ixh5jkxf01v foreign key (system_id) references
system_id_entity
Hibernate: alter table as_cadastral add constraint
FKb2ond3q5i4yx5f8hecs880iru foreign key (system_id) references
as_national_identifier
Hibernate: alter table as_changelog add constraint
FKkd4lvd17ruciorq7s85cmtdfm foreign key (system_id_entity_id) references
system_id_entity
Hibernate: alter table as_changelog add constraint
FKsaej6snrqa8eyrapec8x2g53 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_class add constraint FK5c5xe5il3ev953k7mbxofeqsp
foreign key (class_classification_system_id) references
as_classification_system
Hibernate: alter table as_class add constraint FKnt24cbrswpqps8vh449s831uq
foreign key (class_classified_id) references as_classified
Hibernate: alter table as_class add constraint FKrn8drt9fm5krj87iie6xauxra
foreign key (class_disposal_id) references as_disposal
Hibernate: alter table as_class add constraint FK82phrwsmcf54h322yqllw03e0
foreign key (reference_parent_class_system_id) references as_class
Hibernate: alter table as_class add constraint FKda281am0aoa43p4f5u0tw6l9o
foreign key (class_screening_id) references as_screening
Hibernate: alter table as_class add constraint FK3adgirk1fq5p67pea5w8jhkjc
foreign key (system_id) references system_id_entity
Hibernate: alter table as_class_keyword add constraint
FK4c49uuxej1usu76sp3xo046tt foreign key (f_pk_keyword_id) references
as_keyword
Hibernate: alter table as_class_keyword add constraint
FKt9oovsur8l3k0rvsskk8patu0 foreign key (f_pk_class_id) references as_class
Hibernate: alter table as_classification_system add constraint
FK2dtamd9kgyc546d0niia21u34 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_classified add constraint
FKmsdi06gg4iauerd0v85ocq54c foreign key (system_id) references
system_id_entity
Hibernate: alter table as_comment add constraint
FKrqxo6uv8qp9mcw2a22pqn0d1n foreign key (system_id) references
system_id_entity
Hibernate: alter table as_contact_information add constraint
FKobbbkjbxg51batpndgdpqgma0 foreign key (part_person_system_id) references
as_part_person
Hibernate: alter table as_contact_information add constraint
FKt12iu8u58jisr2djjei22pd6f foreign key (part_unit_system_id) references
as_part_unit
Hibernate: alter table as_contact_information add constraint
FKkv4f5nupd4jt3cmambamtbqw0 foreign key
(reference_correspondence_part_person_system_id) references
as_correspondence_part_person
Hibernate: alter table as_contact_information add constraint
FKa172887gvup7grwpkyg6x6r3 foreign key
(reference_correspondence_part_unit_system_id) references
as_correspondence_part_unit
Hibernate: alter table as_contact_information add constraint
FK1gg706en8qdj82a5q9m9ae1oy foreign key (system_id) references
system_id_entity
Hibernate: alter table as_conversion add constraint
FKcdflrpthmnoxhu0ja2napehds foreign key (conversion_document_object_id)
references as_document_object
Hibernate: alter table as_conversion add constraint
FKofaw0v8gti6c4tb2aqbilugdt foreign key (system_id) references
system_id_entity
Hibernate: alter table as_correspondence_part add constraint
FKdwp7s519ulohcqpkpdmrvx9r3 foreign key (f_pk_record_id) references
as_record
Hibernate: alter table as_correspondence_part add constraint
FK5q6j1wydyo95a5005k2v368p9 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_correspondence_part_internal add constraint
FK1oeqrb9iecj549mdqj9nlbbx4 foreign key
(reference_administrative_unit_system_id) references ad_administrative_unit
Hibernate: alter table as_correspondence_part_internal add constraint
FKs3c17o7a0vcdqaekuyf4i63qc foreign key (user_system_id) references ad_user
Hibernate: alter table as_correspondence_part_internal add constraint
FKm6ka1fgm5ibuhnbg48be40ojm foreign key (system_id) references
as_correspondence_part
Hibernate: alter table as_correspondence_part_person add constraint
FK9rnabemrshuo24ccky04ej5op foreign key (system_id) references
as_correspondence_part
Hibernate: alter table as_correspondence_part_unit add constraint
FKj8dtux2kh2f663h0lltn3u55p foreign key (system_id) references
as_correspondence_part
Hibernate: alter table as_cross_reference add constraint
FKmyvljmlm8mdh9bhvhwhom4if6 foreign key (cross_reference_class_id)
references as_class
Hibernate: alter table as_cross_reference add constraint
FKo3xnd5ep4yhqrcxp189912nnh foreign key (cross_reference_file_id)
references as_file
Hibernate: alter table as_cross_reference add constraint
FKmamnc31h5p4um7oqabqopswac foreign key (cross_reference_record_id)
references as_record
Hibernate: alter table as_cross_reference add constraint
FK75atdlf57msytd1lfqiq39jnc foreign key (system_id) references
system_id_entity
Hibernate: alter table as_d_number add constraint
FKcl6sc6o1rh0lmm5ulm3rdltyd foreign key (system_id) references
as_national_identifier
Hibernate: alter table as_deletion add constraint
FKeji1gkoem8f8544k9ncfg17dy foreign key (system_id) references
system_id_entity
Hibernate: alter table as_disposal add constraint
FKha65ktulis6agqbkgna9y7npy foreign key (system_id) references
system_id_entity
Hibernate: alter table as_disposal_undertaken add constraint
FKp7qig09riqfvtu36wrftyxo1q foreign key (system_id) references
system_id_entity
Hibernate: alter table as_document_description add constraint
FK9lpc78pqfr5e6rmrefmvmn6oe foreign key
(document_description_classified_id) references as_classified
Hibernate: alter table as_document_description add constraint
FKbl9kd2op7i82fgmvd4l9l1yq foreign key (document_description_deletion_id)
references as_deletion
Hibernate: alter table as_document_description add constraint
FK43gnyo32ae9q70wmb16miidh9 foreign key (document_description_disposal_id)
references as_disposal
Hibernate: alter table as_document_description add constraint
FKpdbejaeoe3oepl1pfa2y0a16b foreign key
(document_description_disposal_undertaken_id) references
as_disposal_undertaken
Hibernate: alter table as_document_description add constraint
FKmqvawisy7k9qy73pg98s8l3n6 foreign key (document_description_screening_id)
references as_screening
Hibernate: alter table as_document_description add constraint
FKer7jqg1f2n2mqfmtx9sg5x5gc foreign key (system_id) references
system_id_entity
Hibernate: alter table as_document_description_comment add constraint
FKaakfq2j8uir687ernnn6m0xjn foreign key (f_pk_comment_id) references
as_comment
Hibernate: alter table as_document_description_comment add constraint
FKnsn574d6l0mxvs4ekx2dvrn91 foreign key (f_pk_document_description_id)
references as_document_description
Hibernate: alter table as_document_description_party add constraint
FKg2ys00ceg0yri9ewcaldkp5u7 foreign key (f_pk_part_id) references as_part
Hibernate: alter table as_document_description_party add constraint
FKnw9olsjinghcbv4vh0mb6ckoq foreign key (f_pk_document_description_id)
references as_document_description
Hibernate: alter table as_document_flow add constraint
FKml9vi1bhoi94du59287rvs0hw foreign key (document_flow_flow_from_id)
references ad_user
Hibernate: alter table as_document_flow add constraint
FKdu6p7u41vrfgfqc7qk8i12eqb foreign key (document_flow_flow_to_id)
references ad_user
Hibernate: alter table as_document_flow add constraint
FKcm40lod3be04apaeorwjuhuv5 foreign key (document_flow_record_note_id)
references sa_record_note
Hibernate: alter table as_document_flow add constraint
FKpgs38mw5fbjjdgghij25jqubf foreign key (document_flow_registry_entry_id)
references sa_registry_entry
Hibernate: alter table as_document_flow add constraint
FKa81y853ct631b5hv2iktvb5ro foreign key (system_id) references
system_id_entity
Hibernate: alter table as_document_object add constraint
FK8m0sh86v4gsa00tiout7sewip foreign key
(document_object_document_description_id) references as_document_description
Hibernate: alter table as_document_object add constraint
FKfq4g6baopov3r4do6n4ouuufp foreign key (system_id) references
system_id_entity
Hibernate: alter table as_electronic_signature add constraint
FK9wts158qu67090ls6v4t77f0u foreign key (owned_by) references
ad_organisation
Hibernate: alter table as_electronic_signature add constraint
FK77cuhxwtf6pc9dacci77j8u3m foreign key (system_id) references
sa_registry_entry
Hibernate: alter table as_event_log add constraint
FK844khvknk41o5nqpa6rhjkxe0 foreign key (system_id) references as_changelog
Hibernate: alter table as_file add constraint FKk666o4gcuvm0va1mns5jt9k8k
foreign key (file_class_id) references as_class
Hibernate: alter table as_file add constraint FK7o3gi9sj2hl6dp3cd3lvpsglk
foreign key (file_classified_id) references as_classified
Hibernate: alter table as_file add constraint FKoag9r04kdwsitmds78mx5j6we
foreign key (file_disposal_id) references as_disposal
Hibernate: alter table as_file add constraint FKd1oxi9r7mj6frcxf9m4xjpfvq
foreign key (reference_parent_file_system_id) references as_file
Hibernate: alter table as_file add constraint FKqfg99fon6g9b8o3yfxvy31bln
foreign key (file_screening_id) references as_screening
Hibernate: alter table as_file add constraint FK6f68j66td41dii2vrbckqmjb5
foreign key (file_series_id) references as_series
Hibernate: alter table as_file add constraint FKijv2v7gq5lkdwrirmw5dy09ri
foreign key (system_id) references system_id_entity
Hibernate: alter table as_file_comment add constraint
FKkkdhb3l13ugsi46078vr16fv1 foreign key (f_pk_comment_id) references
as_comment
Hibernate: alter table as_file_comment add constraint
FKt0vru079r4y71tpr9i1xtxj5n foreign key (f_pk_file_id) references as_file
Hibernate: alter table as_file_keyword add constraint
FK6mk46uvwikvs269o9k8alqs7u foreign key (f_pk_keyword_id) references
as_keyword
Hibernate: alter table as_file_keyword add constraint
FK4190k3upuq9sl7vucp46xkv7x foreign key (f_pk_file_id) references as_file
Hibernate: alter table as_file_part add constraint
FK67i3jv6husrjq7y9kxqyxtlfl foreign key (f_pk_part_id) references as_part
Hibernate: alter table as_file_part add constraint
FKpa7tafqqkdwt40kq7kxb9tslg foreign key (f_pk_file_id) references as_file
Hibernate: alter table as_file_storage_location add constraint
FKsm68qak2m5xi7g1vinabfkkau foreign key (f_pk_storage_location_id)
references as_storage_location
Hibernate: alter table as_file_storage_location add constraint
FKotestbjtxcdgjy7mwwvr6fhpr foreign key (f_pk_file_id) references as_file
Hibernate: alter table as_fonds add constraint FKaf8b2cin8k5j0gx5f5axh6fq4
foreign key (reference_parent_fonds_system_id) references as_fonds
Hibernate: alter table as_fonds add constraint FKa4t22724wbqui0h7yhco5uq5
foreign key (system_id) references system_id_entity
Hibernate: alter table as_fonds_creator add constraint
FKggt60s8saav90hc1r4si32q7p foreign key (system_id) references
system_id_entity
Hibernate: alter table as_fonds_fonds_creator add constraint
FKt4hvoesvf5sb5d93iv491ryif foreign key (f_pk_fonds_creator_id) references
as_fonds_creator
Hibernate: alter table as_fonds_fonds_creator add constraint
FKnl3smx867dy1utjrf65vf86v2 foreign key (f_pk_fonds_id) references as_fonds
Hibernate: alter table as_fonds_storage_location add constraint
FKd20ih7s2jgxqwwdw0e3el8wp8 foreign key (f_pk_storage_location_id)
references as_storage_location
Hibernate: alter table as_fonds_storage_location add constraint
FKbbntfldbhlljrnydnfmqtngrx foreign key (f_pk_fonds_id) references as_fonds
Hibernate: alter table as_keyword add constraint
FK86f4ewsqhygkei2i8if63pwh5 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_national_identifier add constraint
FKk9i688hbitlatl9nj9xohrb72 foreign key (national_identifier_file_id)
references as_file
Hibernate: alter table as_national_identifier add constraint
FKcwmuj22ja83mogh3mwpvrdiga foreign key (national_identifier_record_id)
references as_record
Hibernate: alter table as_national_identifier add constraint
FKi862ibnwkg24yun345rnbuo10 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_part add constraint FKsqb5v44ljxppghlkhxuvxe71a
foreign key (system_id) references system_id_entity
Hibernate: alter table as_part_person add constraint
FK4lav91brmuom7ru2fy4fyvs9u foreign key (system_id) references as_part
Hibernate: alter table as_part_unit add constraint
FK46p30sxp5l5ybpdf1nj6kr11p foreign key (system_id) references as_part
Hibernate: alter table as_plan add constraint FK5m6x4g67dgegq5cfe67dxyxpg
foreign key (system_id) references as_national_identifier
Hibernate: alter table as_position add constraint
FKe9i7q0ojanpubvqkruvn218gp foreign key (system_id) references
as_national_identifier
Hibernate: alter table as_postal_address add constraint
FKikximfs56v9oys0vewu4s299g foreign key (part_person_system_id) references
as_part_person
Hibernate: alter table as_postal_address add constraint
FKe50ey3x66oxrb74tpw7x12o73 foreign key (part_unit_system_id) references
as_part_unit
Hibernate: alter table as_postal_address add constraint
FKg39gpo2ygc2f3ps9korqbb8xs foreign key
(reference_correspondence_part_person_system_id) references
as_correspondence_part_person
Hibernate: alter table as_postal_address add constraint
FKkrd9t25g823el00qeqkl6fj5y foreign key
(reference_correspondence_part_unit_system_id) references
as_correspondence_part_unit
Hibernate: alter table as_postal_address add constraint
FKbcp5jmtnr1h6skhdctvsgpdtv foreign key (system_id) references
system_id_entity
Hibernate: alter table as_record add constraint FK454dfx34wa5isjvxqnybotyvd
foreign key (record_class_id) references as_class
Hibernate: alter table as_record add constraint FKon3xqbov9mp4s9y73mu1srcfl
foreign key (record_classified_id) references as_classified
Hibernate: alter table as_record add constraint FKkk614kdrjs27974dhal0c7w6w
foreign key (record_disposal_id) references as_disposal
Hibernate: alter table as_record add constraint FK2epdy256er42urwvc0mel8ori
foreign key (record_file_id) references as_file
Hibernate: alter table as_record add constraint FKrx8lkgw8b93ui6kp1jehxeixf
foreign key (record_screening_id) references as_screening
Hibernate: alter table as_record add constraint FKr2mpdjx1we2efr05q4bk7j8xi
foreign key (record_series_id) references as_series
Hibernate: alter table as_record add constraint FKh5t19trhh5iuqre20yxnp3yst
foreign key (system_id) references system_id_entity
Hibernate: alter table as_record_comment add constraint
FKney5a6ql6eysb92127eo7h8cw foreign key (f_pk_comment_id) references
as_comment
Hibernate: alter table as_record_comment add constraint
FKvq7pebapik44v31i4wv1q75m foreign key (f_pk_record_id) references as_record
Hibernate: alter table as_record_document_description add constraint
FKlbsqfer18e5nd1ekckxlictr4 foreign key (f_pk_document_description_id)
references as_document_description
Hibernate: alter table as_record_document_description add constraint
FK6xb92wowlmbloijpok0x91i6s foreign key (f_pk_record_id) references
as_record
Hibernate: alter table as_record_keyword add constraint
FKlbnt8sh1i97ii0i99w9pv4jk2 foreign key (f_pk_keyword_id) references
as_keyword
Hibernate: alter table as_record_keyword add constraint
FKqofisqw9k0go9xhclr4mqer5a foreign key (f_pk_record_id) references
as_record
Hibernate: alter table as_record_part add constraint
FKdgoq4cf32ggj0p37xkxsgmcna foreign key (f_pk_part_id) references as_part
Hibernate: alter table as_record_part add constraint
FKjq276eb2qm4vecqvw343m27oc foreign key (f_pk_record_id) references
as_record
Hibernate: alter table as_record_storage_location add constraint
FKd294ooyqgyfo5rv1tb7frsf3l foreign key (f_pk_storage_location_id)
references as_storage_location
Hibernate: alter table as_record_storage_location add constraint
FK1bo272cpcvd4tidun82d92at3 foreign key (f_pk_record_id) references
as_record
Hibernate: alter table as_residing_address add constraint
FKjpfe6ihot0rmmpsne0kiuot9g foreign key (part_person_system_id) references
as_part_person
Hibernate: alter table as_residing_address add constraint
FKr971m361nmh76m37w4ekainu4 foreign key
(reference_correspondence_part_person_system_id) references
as_correspondence_part_person
Hibernate: alter table as_residing_address add constraint
FKagwfn0bysiue2ds8y24yuba17 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_screening add constraint
FKjqxx032n51rh6jv41l6v02wb7 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_screening_metadata add constraint
FKesdsawtwx365iheeh4os3jbns foreign key (screening_screening_metadata_id)
references as_screening
Hibernate: alter table as_screening_metadata add constraint
FKro381mm1eu661wq4391e4cith foreign key (system_id) references
system_id_entity
Hibernate: alter table as_series add constraint FKaejndrfejxipsr6chqkckahkh
foreign key (series_classified_id) references as_classified
Hibernate: alter table as_series add constraint FK6x52sd4dblqbrxn33ldu7bftc
foreign key (series_deletion_id) references as_deletion
Hibernate: alter table as_series add constraint FKit6b1hvuacdh8i6ggs7r2j4x3
foreign key (series_disposal_id) references as_disposal
Hibernate: alter table as_series add constraint FKixg0212or9rcjq6mow1ouejor
foreign key (series_disposal_undertaken_id) references
as_disposal_undertaken
Hibernate: alter table as_series add constraint FKcvtqdw42b5lpr2ymw83pbaqse
foreign key (series_fonds_id) references as_fonds
Hibernate: alter table as_series add constraint FKj6m9dhxnx46wnedcgf0bl1tpb
foreign key (reference_precursor_system_id) references as_series
Hibernate: alter table as_series add constraint FKdio4fi31e8djy05elw7yr0i2c
foreign key (series_screening_id) references as_screening
Hibernate: alter table as_series add constraint FKk7ypyjqnnqmy2ef342st01mtd
foreign key (system_id) references system_id_entity
Hibernate: alter table as_series_classification_system add constraint
FKlfs20ovj4hw83iv121wwf949g foreign key (f_pk_classification_system_id)
references as_classification_system
Hibernate: alter table as_series_classification_system add constraint
FKp2wmbgwjrref9dbqfpvwdpo0l foreign key (f_pk_series_id) references
as_series
Hibernate: alter table as_series_storage_location add constraint
FK7hvtrinig35bwj3eynifwobii foreign key (f_pk_storage_location_id)
references as_storage_location
Hibernate: alter table as_series_storage_location add constraint
FKr2nhf40rrpy7hp0xwnfq6lmo0 foreign key (f_pk_series_id) references
as_series
Hibernate: alter table as_sign_off add constraint
FKl52o8d4e7ute1tkp7dn1ap0v foreign key (pk_correspondence_part_id)
references as_correspondence_part
Hibernate: alter table as_sign_off add constraint
FKi4mkjllv0t0kba349gq5vd54 foreign key (fk_record_id) references
sa_registry_entry
Hibernate: alter table as_sign_off add constraint
FKtb9ym4j8y7jmd397wtohnc0c6 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_social_security_number add constraint
FKqh9ntsw5fhfs56ebe82kij76n foreign key (system_id) references
as_national_identifier
Hibernate: alter table as_storage_location add constraint
FKsyt1f8b97jp8pf2qb8tugdxi7 foreign key (system_id) references
system_id_entity
Hibernate: alter table as_unit add constraint FKnlckx1i624tbp9dcrqqqgm3w0
foreign key (system_id) references as_national_identifier
Hibernate: alter table aud_ad_administrative_unit_aud add constraint
FKgve0ff2poviqnne7oi85m2hdb foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_ad_user_aud add constraint
FKstu1ykwu5buv4r7pt6w1lw3rm foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_author_aud add constraint
FKtfbp2ey7cd5sqrrpr4waae9to foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_building_aud add constraint
FKgfx42q3w84w7yagu5ln9b4jnm foreign key (system_id, rev) references
aud_as_national_identifier_aud
Hibernate: alter table aud_as_cadastral_aud add constraint
FKf666vnbj904uf3c3tpbqc8okg foreign key (system_id, rev) references
aud_as_national_identifier_aud
Hibernate: alter table aud_as_changelog_aud add constraint
FKqhnyta7vk3ikab2lj86udshkt foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_class_aud add constraint
FKdr09qwbtcb5jqw7u4mwx69isp foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_classification_system_aud add constraint
FKpag8xxor97qy2a37gtt40f81a foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_classified_aud add constraint
FKp52ndvmxt7yx8skgtbvhoo9kj foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_comment_aud add constraint
FK5ussqou6vmttorbv9s5mv3tkf foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_contact_information_aud add constraint
FKpr7x21lmebwkotomc6qscsy1k foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_conversion_aud add constraint
FKp4yfsjhr559y8w5f8bq31ngn2 foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_correspondence_part_aud add constraint
FKpqtwby210nbk3iq2o2tw8ur6l foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_correspondence_part_internal_aud add
constraint FKkv5ugealo1lomb60l86qmcwc6 foreign key (system_id, rev)
references aud_as_correspondence_part_aud
Hibernate: alter table aud_as_correspondence_part_person_aud add constraint
FK3t5glndp1fmjvx6kiuyski32e foreign key (system_id, rev) references
aud_as_correspondence_part_aud
Hibernate: alter table aud_as_correspondence_part_unit_aud add constraint
FKiwiy96q0kax355294q9abnjvw foreign key (system_id, rev) references
aud_as_correspondence_part_aud
Hibernate: alter table aud_as_d_number_aud add constraint
FKli7l10qln1ropobja08ms2w1s foreign key (system_id, rev) references
aud_as_national_identifier_aud
Hibernate: alter table aud_as_deletion_aud add constraint
FKa5b1by47lf664sfk30tgj8agb foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_disposal_aud add constraint
FKhnvbfoo9vuoya4sy7djtrkc1c foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_disposal_undertaken_aud add constraint
FKbsof0tmd3aymk7gpvtvvc6oud foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_document_description_aud add constraint
FK4scbka8s02ug0wcux6foog7pt foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_document_flow_aud add constraint
FKb7aqgvn27ha9xopw5rlk8lm1k foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_document_object_aud add constraint
FKt6oaxosvhognm4k9ps7cqxfvw foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_electronic_signature_aud add constraint
FK2oxt8hgqjhqke1oro8rdlug1m foreign key (rev) references revinfo
Hibernate: alter table aud_as_event_log_aud add constraint
FKnofxguqn8n1ghma26lmai2dwn foreign key (system_id, rev) references
aud_as_changelog_aud
Hibernate: alter table aud_as_file_aud add constraint
FKoygo2050ftle2qv98svbk8p5l foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_fonds_aud add constraint
FKicnt1t16cwim8yu4gcoxxmd0g foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_fonds_creator_aud add constraint
FK2cu9x3eidvt6n8r8pfxg4264o foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_keyword_aud add constraint
FK17194ko8enfd55yimjbjeucxj foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_national_identifier_aud add constraint
FKlj5oym6yuy30malshcxxduvx foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_part_aud add constraint
FK5fcr04qt18ir57tmo5dyvs9rx foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_part_person_aud add constraint
FKg86uhj86wiund7mmop91fp3fs foreign key (system_id, rev) references
aud_as_part_aud
Hibernate: alter table aud_as_part_unit_aud add constraint
FKiap71gjjtdrly9oyvodheuxpe foreign key (system_id, rev) references
aud_as_part_aud
Hibernate: alter table aud_as_plan_aud add constraint
FKcnm5kp31h8ttq8qugh7ih6jmq foreign key (system_id, rev) references
aud_as_national_identifier_aud
Hibernate: alter table aud_as_position_aud add constraint
FKedv1vkgv6lj032dgvfaaaq6qx foreign key (system_id, rev) references
aud_as_national_identifier_aud
Hibernate: alter table aud_as_record_aud add constraint
FKodmw4n57ljtgdl389kt6df0d1 foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_screening_aud add constraint
FKej3yag3yh5k8esgdfsj93cxcq foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_screening_metadata_aud add constraint
FKkxjfi89swjnsehx8rpgiol90k foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_series_aud add constraint
FK82lt6yi2lqubyu8ccwxwyplqj foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_sign_off_aud add constraint
FK7a489yf4gwshcpmpcso302c3q foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_social_security_number_aud add constraint
FKn61459jepr1pebjxxwjd6qxn4 foreign key (system_id, rev) references
aud_as_national_identifier_aud
Hibernate: alter table aud_as_storage_location_aud add constraint
FKrqxiaynm2g9cjh4448n9ssmx foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_as_unit_aud add constraint
FKeubrt1lkk8iao6tpiyh8h4wm2 foreign key (system_id, rev) references
aud_as_national_identifier_aud
Hibernate: alter table aud_bsm_base_aud add constraint
FK9i0l3ua9ud9vhwrp6k9xxksuy foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_md_correspondence_part_type_aud add constraint
FKa1d1q5k1opkuxflayjvnbubdl foreign key (rev) references revinfo
Hibernate: alter table aud_md_part_role_aud add constraint
FKc40dl79evxv5yi6xsgn5wxbvt foreign key (rev) references revinfo
Hibernate: alter table aud_md_postal_code_aud add constraint
FKdtg6ec52h3jsscors5kigmkrp foreign key (rev) references revinfo
Hibernate: alter table aud_mu_meeting_file_aud add constraint
FKjdymein6ao2mf987uabxgpamb foreign key (system_id, rev) references
aud_as_file_aud
Hibernate: alter table aud_mu_meeting_participant_aud add constraint
FKgsj3wg02lt7u1xtb9681jmhs1 foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_mu_meeting_record_aud add constraint
FK8jfa3j904ja7kosev0keys9el foreign key (system_id, rev) references
aud_as_record_aud
Hibernate: alter table aud_sa_case_file_aud add constraint
FKkgp9jitv0tx9emu2pn2y9dc5 foreign key (system_id, rev) references
aud_as_file_aud
Hibernate: alter table aud_sa_precedence_aud add constraint
FKlmjbs1fw9l4qb1kflyawak4cc foreign key (system_id, rev) references
aud_system_id_entity_aud
Hibernate: alter table aud_sa_record_note_aud add constraint
FKqgy86pps03dqg98lgoe71pha6 foreign key (system_id, rev) references
aud_as_record_aud
Hibernate: alter table aud_sa_registry_entry_aud add constraint
FKarsfh5n28cd0qpf9rrlg6v0jb foreign key (system_id, rev) references
aud_as_record_aud
Hibernate: alter table aud_system_id_entity_aud add constraint
FKt5j75a1ov5n38p56b19vam6tv foreign key (rev) references revinfo
Hibernate: alter table bsm_base add constraint FK4ra3yt6dripgh1drsolbrm6b8
foreign key (fk_bsm_administrative_unit_id) references
ad_administrative_unit
Hibernate: alter table bsm_base add constraint FKka6uelsr1v8nssawm2thk33pv
foreign key (fk_bsm_correspondence_part_id) references
as_correspondence_part
Hibernate: alter table bsm_base add constraint FK734lrgol8sqt6u1shm59qskdq
foreign key (fk_bsm_document_description_id) references
as_document_description
Hibernate: alter table bsm_base add constraint FKf4n1j054wtmb29peib9hb5qdl
foreign key (fk_bsm_file_id) references as_file
Hibernate: alter table bsm_base add constraint FKpumr86xrklupd8gs8olruw8s9
foreign key (fk_bsm_part_id) references as_part
Hibernate: alter table bsm_base add constraint FKi3swy1w1u5q18uylrkqm2m5or
foreign key (fk_bsm_record_id) references as_record
Hibernate: alter table bsm_base add constraint FKaqnypg5gyoox2x3pmb428f236
foreign key (system_id) references system_id_entity
Hibernate: alter table md_access_category add constraint
FKjqca24an2ss2omtbw4w58nnvg foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_access_restriction add constraint
FK703sa76scic098epek7qrv0r foreign key (owned_by) references ad_organisation
Hibernate: alter table md_associated_with_record_as add constraint
FKl5wqeujig2gjdg2bg04q64xjp foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_bsm add constraint FKa8d9pddtyxnq8nwxev1plgx24
foreign key (system_id) references system_id_entity
Hibernate: alter table md_case_status add constraint
FKceg1eqgqa88rc9rlyd3520ec3 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_classification_type add constraint
FKdjp65mkdrh5fb1s37pc0vxroi foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_classified_code add constraint
FKf7xpccbo82btr5m14pnrwmi90 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_comment_type add constraint
FKj9oxlnos5s8q77v93x1efl9o5 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_coordinate_system add constraint
FKlhs25h8opnvymp6bnb2wfl0le foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_correspondence_part_type add constraint
FKcs42wkixnu8qh363ujhyp25uy foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_country add constraint FKmaxvif0ebp0jjhsobextxigw
foreign key (owned_by) references ad_organisation
Hibernate: alter table md_deletion_type add constraint
FKfrk9ek83gxcvlmdgscwr7blwe foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_disposal_decision add constraint
FKfo6wr7nvjk0eta4oaaia0wtb2 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_document_medium add constraint
FKrri8d85d9m2jentivk9phmf4m foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_document_status add constraint
FKdq9sddb4q0flv72gy87ojqnlc foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_document_type add constraint
FK6yj7pdkimrhlx0b2ciihn9vge foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_electronic_signature_security_level add
constraint FKi71lhmich7x0ynebvjsmvgree foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_electronic_signature_verified add constraint
FKbidkicnaw80nwj3cvduoamor0 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_event_type add constraint
FKnhkqhd6urjvy0r0gf3u6ux831 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_file_type add constraint
FKevf18r0a1qlspx530qpe6cfpv foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_flow_status add constraint
FK73s8a3uap4v1y2ruk6cx9px38 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_fonds_status add constraint
FKcisam6gg0v68tylwew5jlvxum foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_format add constraint FK1j0xe4puccrr2xu9dotin936s
foreign key (owned_by) references ad_organisation
Hibernate: alter table md_meeting_file_type add constraint
FKlf6lbq5hqs4mvk2v6fy4pn3c9 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_meeting_participant_function add constraint
FKkuw94nb1whl5aa4xxfnlxpw0b foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_meeting_registration_status add constraint
FKjfwjatk3cphexl3t8kechl17b foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_meeting_registration_type add constraint
FKeh79jr7m9kifqg10i6813p4a6 foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_part_role add constraint
FKa1s9n1igfvww1mh6ii9io1hnl foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_postal_code add constraint
FKnptj689fxke994iti1njdry3x foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_precedence_status add constraint
FKbmg562w4p8riis68lsfyb0ahj foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_registry_entry_status add constraint
FKh6pwudq59gmx9kkajy3iufvus foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_registry_entry_type add constraint
FK5cjper1uvfn0vs8rkoxguu4yb foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_screening_document add constraint
FK5911r6a534jbqrd7vwqu0kpkx foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_screening_metadata add constraint
FKeo9f2hvm46uuqjj73hducru9f foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_series_status add constraint
FKrrnpybr94r872itgwytw0lmy foreign key (owned_by) references ad_organisation
Hibernate: alter table md_sign_off_method add constraint
FKayhr0mc7ukngmfkmd2qe6923g foreign key (owned_by) references
ad_organisation
Hibernate: alter table md_variant_format add constraint
FKp2l6vnuxfchh4fql6w7wx0bch foreign key (owned_by) references
ad_organisation
Hibernate: alter table mu_meeting_file add constraint
FKpkydwqq6xvisqi1qs7rngl49a foreign key (reference_next_meeting_system_id)
references mu_meeting_file
Hibernate: alter table mu_meeting_file add constraint
FK3fd1wcuuh7uvokkjnvs6vyy4t foreign key
(reference_previous_meeting_system_id) references mu_meeting_file
Hibernate: alter table mu_meeting_file add constraint
FK83t4t9rgucb1d53q5icwpcyky foreign key (system_id) references as_file
Hibernate: alter table mu_meeting_participant add constraint
FKmodvb8bw4hqg8l0uuu8ye5usm foreign key (meeting_participant_file_id)
references mu_meeting_file
Hibernate: alter table mu_meeting_participant add constraint
FKchcmp2t03jfjpsqcbdqcfe8d4 foreign key (system_id) references
system_id_entity
Hibernate: alter table mu_meeting_record add constraint
FKq78vfcua1vs824kjnpnsi8xxd foreign key
(reference_from_meeting_registration_system_id) references mu_meeting_record
Hibernate: alter table mu_meeting_record add constraint
FKih2ktr0rmwkh1gno2cp6v6i6v foreign key
(reference_to_meeting_registration_system_id) references mu_meeting_record
Hibernate: alter table mu_meeting_record add constraint
FKgfl9p11ebxg67k2f63tq5okmc foreign key (system_id) references as_record
Hibernate: alter table sa_case_file add constraint
FKkbu9ijdobk9m3moo86xet4ax8 foreign key (case_file_administrative_unit_id)
references ad_administrative_unit
Hibernate: alter table sa_case_file add constraint
FK4uhutc5lh20fwoovm2uf3s1fi foreign key (system_id) references as_file
Hibernate: alter table sa_case_file_precedence add constraint
FKshh3cktn0cposw5efsdatirdq foreign key (f_pk_precedence_id) references
sa_precedence
Hibernate: alter table sa_case_file_precedence add constraint
FK3ob80nack1vijm9t0qqk1ch45 foreign key (f_pk_case_file_id) references
sa_case_file
Hibernate: alter table sa_precedence add constraint
FK6jtybotfthw352mitgqsu1bjh foreign key (precedence_approved_by_id)
references ad_user
Hibernate: alter table sa_precedence add constraint
FKepa0ajiw8bcqhe2xn4g3rytem foreign key (system_id) references
system_id_entity
Hibernate: alter table sa_record_note add constraint
FKj6thv1fxxnscsxj8kvvkrijkl foreign key (system_id) references as_record
Hibernate: alter table sa_registry_entry add constraint
FKt28nusrp5l0rd0vq6hixgfd2m foreign key (system_id) references as_record
Hibernate: alter table sa_registry_entry_precedence add constraint
FKrnodsrja0dcomf4i9yit3ty3y foreign key (f_pk_precedence_id) references
sa_precedence
Hibernate: alter table sa_registry_entry_precedence add constraint
FKpxb8demtj8f44yymf7qbd6424 foreign key (f_pk_record_id) references
sa_registry_entry
Hibernate: alter table sa_registry_entry_sign_off add constraint
FK7i8akn6u26b366ksc898r0qwe foreign key (f_pk_sign_off_id) references
as_sign_off
Hibernate: alter table sa_registry_entry_sign_off add constraint
FKkppdyj8gnj16kqwp5v04ej3kj foreign key (f_pk_record_id) references
sa_registry_entry
Hibernate: alter table sa_sequence_generator add constraint
FK9m2qhund6gycwf0g8nb3n7shp foreign key (reference_administrative_unit)
references ad_administrative_unit
Hibernate: alter table system_id_entity add constraint
FK4wyctfg8e48xs080sjbewmto5 foreign key (owned_by) references
ad_organisation
2022-05-02 06:18:03.874  INFO 31670 --- [           main]
o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform
implementation:
[org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2022-05-02 06:18:04.548 ERROR 31670 --- [           main]
o.h.s.e.r.spi.RootFailureCollector       : HSEARCH000521: Hibernate Search
encountered a failure during bootstrap; continuing for now to list all
problems, but the process will ultimately be aborted.
Context: default backend
Failure:

org.hibernate.search.util.common.SearchException: HSEARCH400080: Unable to
detect the Elasticsearch version running on the cluster: HSEARCH400007:
Elasticsearch request failed: Connection refused
Request: GET  with parameters {}
Response: (no response)
at
org.hibernate.search.backend.elasticsearch.client.impl.ElasticsearchClientUtils.getElasticsearchVersion(ElasticsearchClientUtils.java:56)
~[hibernate-search-backend-elasticsearch-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.backend.elasticsearch.impl.ElasticsearchLinkImpl.initVersion(ElasticsearchLinkImpl.java:200)
~[hibernate-search-backend-elasticsearch-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.backend.elasticsearch.impl.ElasticsearchLinkImpl.onStart(ElasticsearchLinkImpl.java:142)
~[hibernate-search-backend-elasticsearch-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.backend.elasticsearch.impl.ElasticsearchBackendFactory.create(ElasticsearchBackendFactory.java:115)
~[hibernate-search-backend-elasticsearch-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.engine.common.impl.IndexManagerBuildingStateHolder.createBackend(IndexManagerBuildingStateHolder.java:128)
~[hibernate-search-engine-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.engine.common.impl.IndexManagerBuildingStateHolder.createBackends(IndexManagerBuildingStateHolder.java:69)
~[hibernate-search-engine-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.engine.common.impl.SearchIntegrationBuilderImpl.prepareBuild(SearchIntegrationBuilderImpl.java:241)
~[hibernate-search-engine-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.doBootFirstPhase(HibernateOrmIntegrationBooterImpl.java:259)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.mapper.orm.bootstrap.spi.HibernateOrmIntegrationBooterBehavior.bootFirstPhase(HibernateOrmIntegrationBooterBehavior.java:17)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.lambda$bootNow$7(HibernateOrmIntegrationBooterImpl.java:218)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at java.base/java.util.Optional.orElseGet(Optional.java:369) ~[na:na]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.bootNow(HibernateOrmIntegrationBooterImpl.java:218)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
java.base/java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:642)
~[na:na]
at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
~[na:na]
at
java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073)
~[na:na]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateSearchSessionFactoryObserver.sessionFactoryCreated(HibernateSearchSessionFactoryObserver.java:41)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1498)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154)
~[spring-context-5.3.13.jar:5.3.13]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908)
~[spring-context-5.3.13.jar:5.3.13]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
~[spring-context-5.3.13.jar:5.3.13]
at
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:412)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:302)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1301)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1290)
~[spring-boot-2.6.1.jar:2.6.1]
at nikita.N5CoreApp.main(N5CoreApp.java:39) ~[classes/:na]
Caused by: org.hibernate.search.util.common.SearchException: HSEARCH400007:
Elasticsearch request failed: Connection refused
Request: GET  with parameters {}
Response: (no response)
at
org.hibernate.search.backend.elasticsearch.client.impl.ElasticsearchClientUtils.tryGetElasticsearchVersion(ElasticsearchClientUtils.java:75)
~[hibernate-search-backend-elasticsearch-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.backend.elasticsearch.client.impl.ElasticsearchClientUtils.getElasticsearchVersion(ElasticsearchClientUtils.java:53)
~[hibernate-search-backend-elasticsearch-6.0.6.Final.jar:6.0.6.Final]
... 42 common frames omitted
Caused by: org.hibernate.search.util.common.SearchException: Connection
refused
at
org.hibernate.search.util.common.impl.Throwables.toRuntimeException(Throwables.java:33)
~[hibernate-search-util-common-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.util.common.impl.Futures.unwrappedExceptionJoin(Futures.java:193)
~[hibernate-search-util-common-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.backend.elasticsearch.client.impl.ElasticsearchClientUtils.tryGetElasticsearchVersion(ElasticsearchClientUtils.java:64)
~[hibernate-search-backend-elasticsearch-6.0.6.Final.jar:6.0.6.Final]
... 43 common frames omitted
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
~[na:na]
at
java.base/sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:777)
~[na:na]
at
org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processEvent(DefaultConnectingIOReactor.java:174)
~[httpcore-nio-4.4.14.jar:4.4.14]
at
org.apache.http.impl.nio.reactor.DefaultConnectingIOReactor.processEvents(DefaultConnectingIOReactor.java:148)
~[httpcore-nio-4.4.14.jar:4.4.14]
at
org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor.execute(AbstractMultiworkerIOReactor.java:351)
~[httpcore-nio-4.4.14.jar:4.4.14]
at
org.apache.http.impl.nio.conn.PoolingNHttpClientConnectionManager.execute(PoolingNHttpClientConnectionManager.java:221)
~[httpasyncclient-4.1.4.jar:4.1.4]
at
org.apache.http.impl.nio.client.CloseableHttpAsyncClientBase$1.run(CloseableHttpAsyncClientBase.java:64)
~[httpasyncclient-4.1.4.jar:4.1.4]
at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na]

2022-05-02 06:18:04.556  INFO 31670 --- [           main]
.SchemaDropperImpl$DelayedDropActionImpl : HHH000477: Starting delayed
evictData of schema as part of SessionFactory shut-down'
Hibernate: drop table if exists ad_administrative_unit CASCADE
2022-05-02 06:18:04.557  INFO 31670 --- [           main]
org.hibernate.orm.connections.access     : HHH10001501: Connection obtained
from JdbcConnectionAccess
[org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess at 60b4ce86]
for (non-JTA) DDL execution was not in auto-commit mode; the Connection
'local transaction' will be committed and the Connection will be set into
auto-commit mode.
Hibernate: drop table if exists ad_administrative_unit_user CASCADE
Hibernate: drop table if exists ad_authority CASCADE
Hibernate: drop table if exists ad_organisation CASCADE
Hibernate: drop table if exists ad_user CASCADE
Hibernate: drop table if exists ad_user_authority CASCADE
Hibernate: drop table if exists as_author CASCADE
Hibernate: drop table if exists as_building CASCADE
Hibernate: drop table if exists as_business_address CASCADE
Hibernate: drop table if exists as_cadastral CASCADE
Hibernate: drop table if exists as_changelog CASCADE
Hibernate: drop table if exists as_class CASCADE
Hibernate: drop table if exists as_class_keyword CASCADE
Hibernate: drop table if exists as_classification_system CASCADE
Hibernate: drop table if exists as_classified CASCADE
Hibernate: drop table if exists as_comment CASCADE
Hibernate: drop table if exists as_contact_information CASCADE
Hibernate: drop table if exists as_conversion CASCADE
Hibernate: drop table if exists as_correspondence_part CASCADE
Hibernate: drop table if exists as_correspondence_part_internal CASCADE
Hibernate: drop table if exists as_correspondence_part_person CASCADE
Hibernate: drop table if exists as_correspondence_part_unit CASCADE
Hibernate: drop table if exists as_cross_reference CASCADE
Hibernate: drop table if exists as_d_number CASCADE
Hibernate: drop table if exists as_deletion CASCADE
Hibernate: drop table if exists as_disposal CASCADE
Hibernate: drop table if exists as_disposal_undertaken CASCADE
Hibernate: drop table if exists as_document_description CASCADE
Hibernate: drop table if exists as_document_description_comment CASCADE
Hibernate: drop table if exists as_document_description_party CASCADE
Hibernate: drop table if exists as_document_flow CASCADE
Hibernate: drop table if exists as_document_object CASCADE
Hibernate: drop table if exists as_electronic_signature CASCADE
Hibernate: drop table if exists as_event_log CASCADE
Hibernate: drop table if exists as_file CASCADE
Hibernate: drop table if exists as_file_comment CASCADE
Hibernate: drop table if exists as_file_keyword CASCADE
Hibernate: drop table if exists as_file_part CASCADE
Hibernate: drop table if exists as_file_storage_location CASCADE
Hibernate: drop table if exists as_fonds CASCADE
Hibernate: drop table if exists as_fonds_creator CASCADE
Hibernate: drop table if exists as_fonds_fonds_creator CASCADE
Hibernate: drop table if exists as_fonds_storage_location CASCADE
Hibernate: drop table if exists as_keyword CASCADE
Hibernate: drop table if exists as_national_identifier CASCADE
Hibernate: drop table if exists as_part CASCADE
Hibernate: drop table if exists as_part_person CASCADE
Hibernate: drop table if exists as_part_unit CASCADE
Hibernate: drop table if exists as_plan CASCADE
Hibernate: drop table if exists as_position CASCADE
Hibernate: drop table if exists as_postal_address CASCADE
Hibernate: drop table if exists as_record CASCADE
Hibernate: drop table if exists as_record_comment CASCADE
Hibernate: drop table if exists as_record_document_description CASCADE
Hibernate: drop table if exists as_record_keyword CASCADE
Hibernate: drop table if exists as_record_part CASCADE
Hibernate: drop table if exists as_record_storage_location CASCADE
Hibernate: drop table if exists as_residing_address CASCADE
Hibernate: drop table if exists as_screening CASCADE
Hibernate: drop table if exists as_screening_metadata CASCADE
Hibernate: drop table if exists as_series CASCADE
Hibernate: drop table if exists as_series_classification_system CASCADE
Hibernate: drop table if exists as_series_storage_location CASCADE
Hibernate: drop table if exists as_sign_off CASCADE
Hibernate: drop table if exists as_social_security_number CASCADE
Hibernate: drop table if exists as_storage_location CASCADE
Hibernate: drop table if exists as_unit CASCADE
Hibernate: drop table if exists aud_ad_administrative_unit_aud CASCADE
Hibernate: drop table if exists aud_ad_user_aud CASCADE
Hibernate: drop table if exists aud_as_author_aud CASCADE
Hibernate: drop table if exists aud_as_building_aud CASCADE
Hibernate: drop table if exists aud_as_cadastral_aud CASCADE
Hibernate: drop table if exists aud_as_changelog_aud CASCADE
Hibernate: drop table if exists aud_as_class_aud CASCADE
Hibernate: drop table if exists aud_as_classification_system_aud CASCADE
Hibernate: drop table if exists aud_as_classified_aud CASCADE
Hibernate: drop table if exists aud_as_comment_aud CASCADE
Hibernate: drop table if exists aud_as_contact_information_aud CASCADE
Hibernate: drop table if exists aud_as_conversion_aud CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_aud CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_internal_aud
CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_person_aud
CASCADE
Hibernate: drop table if exists aud_as_correspondence_part_unit_aud CASCADE
Hibernate: drop table if exists aud_as_d_number_aud CASCADE
Hibernate: drop table if exists aud_as_deletion_aud CASCADE
Hibernate: drop table if exists aud_as_disposal_aud CASCADE
Hibernate: drop table if exists aud_as_disposal_undertaken_aud CASCADE
Hibernate: drop table if exists aud_as_document_description_aud CASCADE
Hibernate: drop table if exists aud_as_document_flow_aud CASCADE
Hibernate: drop table if exists aud_as_document_object_aud CASCADE
Hibernate: drop table if exists aud_as_electronic_signature_aud CASCADE
Hibernate: drop table if exists aud_as_event_log_aud CASCADE
Hibernate: drop table if exists aud_as_file_aud CASCADE
Hibernate: drop table if exists aud_as_fonds_aud CASCADE
Hibernate: drop table if exists aud_as_fonds_creator_aud CASCADE
Hibernate: drop table if exists aud_as_keyword_aud CASCADE
Hibernate: drop table if exists aud_as_national_identifier_aud CASCADE
Hibernate: drop table if exists aud_as_part_aud CASCADE
Hibernate: drop table if exists aud_as_part_person_aud CASCADE
Hibernate: drop table if exists aud_as_part_unit_aud CASCADE
Hibernate: drop table if exists aud_as_plan_aud CASCADE
Hibernate: drop table if exists aud_as_position_aud CASCADE
Hibernate: drop table if exists aud_as_record_aud CASCADE
Hibernate: drop table if exists aud_as_screening_aud CASCADE
Hibernate: drop table if exists aud_as_screening_metadata_aud CASCADE
Hibernate: drop table if exists aud_as_series_aud CASCADE
Hibernate: drop table if exists aud_as_sign_off_aud CASCADE
Hibernate: drop table if exists aud_as_social_security_number_aud CASCADE
Hibernate: drop table if exists aud_as_storage_location_aud CASCADE
Hibernate: drop table if exists aud_as_unit_aud CASCADE
Hibernate: drop table if exists aud_bsm_base_aud CASCADE
Hibernate: drop table if exists aud_md_correspondence_part_type_aud CASCADE
Hibernate: drop table if exists aud_md_part_role_aud CASCADE
Hibernate: drop table if exists aud_md_postal_code_aud CASCADE
Hibernate: drop table if exists aud_mu_meeting_file_aud CASCADE
Hibernate: drop table if exists aud_mu_meeting_participant_aud CASCADE
Hibernate: drop table if exists aud_mu_meeting_record_aud CASCADE
Hibernate: drop table if exists aud_sa_case_file_aud CASCADE
Hibernate: drop table if exists aud_sa_precedence_aud CASCADE
Hibernate: drop table if exists aud_sa_record_note_aud CASCADE
Hibernate: drop table if exists aud_sa_registry_entry_aud CASCADE
Hibernate: drop table if exists aud_system_id_entity_aud CASCADE
Hibernate: drop table if exists bsm_base CASCADE
Hibernate: drop table if exists md_access_category CASCADE
Hibernate: drop table if exists md_access_restriction CASCADE
Hibernate: drop table if exists md_associated_with_record_as CASCADE
Hibernate: drop table if exists md_bsm CASCADE
Hibernate: drop table if exists md_case_status CASCADE
Hibernate: drop table if exists md_classification_type CASCADE
Hibernate: drop table if exists md_classified_code CASCADE
Hibernate: drop table if exists md_comment_type CASCADE
Hibernate: drop table if exists md_coordinate_system CASCADE
Hibernate: drop table if exists md_correspondence_part_type CASCADE
Hibernate: drop table if exists md_country CASCADE
Hibernate: drop table if exists md_deletion_type CASCADE
Hibernate: drop table if exists md_disposal_decision CASCADE
Hibernate: drop table if exists md_document_medium CASCADE
Hibernate: drop table if exists md_document_status CASCADE
Hibernate: drop table if exists md_document_type CASCADE
Hibernate: drop table if exists md_electronic_signature_security_level
CASCADE
Hibernate: drop table if exists md_electronic_signature_verified CASCADE
Hibernate: drop table if exists md_event_type CASCADE
Hibernate: drop table if exists md_file_type CASCADE
Hibernate: drop table if exists md_flow_status CASCADE
Hibernate: drop table if exists md_fonds_status CASCADE
Hibernate: drop table if exists md_format CASCADE
Hibernate: drop table if exists md_meeting_file_type CASCADE
Hibernate: drop table if exists md_meeting_participant_function CASCADE
Hibernate: drop table if exists md_meeting_registration_status CASCADE
Hibernate: drop table if exists md_meeting_registration_type CASCADE
Hibernate: drop table if exists md_part_role CASCADE
Hibernate: drop table if exists md_postal_code CASCADE
Hibernate: drop table if exists md_precedence_status CASCADE
Hibernate: drop table if exists md_registry_entry_status CASCADE
Hibernate: drop table if exists md_registry_entry_type CASCADE
Hibernate: drop table if exists md_screening_document CASCADE
Hibernate: drop table if exists md_screening_metadata CASCADE
Hibernate: drop table if exists md_series_status CASCADE
Hibernate: drop table if exists md_sign_off_method CASCADE
Hibernate: drop table if exists md_variant_format CASCADE
Hibernate: drop table if exists mu_meeting_file CASCADE
Hibernate: drop table if exists mu_meeting_participant CASCADE
Hibernate: drop table if exists mu_meeting_record CASCADE
Hibernate: drop table if exists revinfo CASCADE
Hibernate: drop table if exists sa_case_file CASCADE
Hibernate: drop table if exists sa_case_file_precedence CASCADE
Hibernate: drop table if exists sa_precedence CASCADE
Hibernate: drop table if exists sa_record_note CASCADE
Hibernate: drop table if exists sa_registry_entry CASCADE
Hibernate: drop table if exists sa_registry_entry_precedence CASCADE
Hibernate: drop table if exists sa_registry_entry_sign_off CASCADE
Hibernate: drop table if exists sa_sequence_generator CASCADE
Hibernate: drop table if exists system_id_entity CASCADE
Hibernate: drop sequence if exists authority_seq
2022-05-02 06:18:04.671 ERROR 31670 --- [           main]
j.LocalContainerEntityManagerFactoryBean : Failed to initialize JPA
EntityManagerFactory: [PersistenceUnit: default] Unable to build Hibernate
SessionFactory; nested exception is
org.hibernate.search.util.common.SearchException: HSEARCH000520: Hibernate
Search encountered failures during bootstrap. Failures:

    default backend:
        failures:
          - HSEARCH400080: Unable to detect the Elasticsearch version
running on the cluster: HSEARCH400007: Elasticsearch request failed:
Connection refused
Request: GET  with parameters {}
Response: (no response)
2022-05-02 06:18:04.672  WARN 31670 --- [           main]
ConfigServletWebServerApplicationContext : Exception encountered during
context initialization - cancelling refresh attempt:
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'entityManagerFactory' defined in class path resource
[org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]:
Invocation of init method failed; nested exception is
javax.persistence.PersistenceException: [PersistenceUnit: default] Unable
to build Hibernate SessionFactory; nested exception is
org.hibernate.search.util.common.SearchException: HSEARCH000520: Hibernate
Search encountered failures during bootstrap. Failures:

    default backend:
        failures:
          - HSEARCH400080: Unable to detect the Elasticsearch version
running on the cluster: HSEARCH400007: Elasticsearch request failed:
Connection refused
Request: GET  with parameters {}
Response: (no response)
2022-05-02 06:18:04.673  INFO 31670 --- [           main]
com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown
initiated...
2022-05-02 06:18:04.677  INFO 31670 --- [           main]
com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown
completed.
2022-05-02 06:18:04.680  INFO 31670 --- [           main]
o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2022-05-02 06:18:04.703  INFO 31670 --- [           main]
ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run
your application with 'debug' enabled.
2022-05-02 06:18:04.725 ERROR 31670 --- [           main]
o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'entityManagerFactory' defined in class path resource
[org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]:
Invocation of init method failed; nested exception is
javax.persistence.PersistenceException: [PersistenceUnit: default] Unable
to build Hibernate SessionFactory; nested exception is
org.hibernate.search.util.common.SearchException: HSEARCH000520: Hibernate
Search encountered failures during bootstrap. Failures:

    default backend:
        failures:
          - HSEARCH400080: Unable to detect the Elasticsearch version
running on the cluster: HSEARCH400007: Elasticsearch request failed:
Connection refused
Request: GET  with parameters {}
Response: (no response)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154)
~[spring-context-5.3.13.jar:5.3.13]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908)
~[spring-context-5.3.13.jar:5.3.13]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
~[spring-context-5.3.13.jar:5.3.13]
at
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:412)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:302)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1301)
~[spring-boot-2.6.1.jar:2.6.1]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1290)
~[spring-boot-2.6.1.jar:2.6.1]
at nikita.N5CoreApp.main(N5CoreApp.java:39) ~[classes/:na]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit:
default] Unable to build Hibernate SessionFactory; nested exception is
org.hibernate.search.util.common.SearchException: HSEARCH000520: Hibernate
Search encountered failures during bootstrap. Failures:

    default backend:
        failures:
          - HSEARCH400080: Unable to detect the Elasticsearch version
running on the cluster: HSEARCH400007: Elasticsearch request failed:
Connection refused
Request: GET  with parameters {}
Response: (no response)
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:421)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
~[spring-beans-5.3.13.jar:5.3.13]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
~[spring-beans-5.3.13.jar:5.3.13]
... 16 common frames omitted
Caused by: org.hibernate.search.util.common.SearchException: HSEARCH000520:
Hibernate Search encountered failures during bootstrap. Failures:

    default backend:
        failures:
          - HSEARCH400080: Unable to detect the Elasticsearch version
running on the cluster: HSEARCH400007: Elasticsearch request failed:
Connection refused
Request: GET  with parameters {}
Response: (no response)
at
org.hibernate.search.engine.reporting.spi.RootFailureCollector.checkNoFailure(RootFailureCollector.java:50)
~[hibernate-search-engine-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.engine.common.impl.SearchIntegrationBuilderImpl.prepareBuild(SearchIntegrationBuilderImpl.java:243)
~[hibernate-search-engine-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.doBootFirstPhase(HibernateOrmIntegrationBooterImpl.java:259)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.mapper.orm.bootstrap.spi.HibernateOrmIntegrationBooterBehavior.bootFirstPhase(HibernateOrmIntegrationBooterBehavior.java:17)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.lambda$bootNow$7(HibernateOrmIntegrationBooterImpl.java:218)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at java.base/java.util.Optional.orElseGet(Optional.java:369) ~[na:na]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.bootNow(HibernateOrmIntegrationBooterImpl.java:218)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
java.base/java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:642)
~[na:na]
at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
~[na:na]
at
java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2073)
~[na:na]
at
org.hibernate.search.mapper.orm.bootstrap.impl.HibernateSearchSessionFactoryObserver.sessionFactoryCreated(HibernateSearchSessionFactoryObserver.java:41)
~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
at
org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1498)
~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
at
org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
~[spring-orm-5.3.13.jar:5.3.13]
at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
~[spring-orm-5.3.13.jar:5.3.13]
... 20 common frames omitted

[INFO]
------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO]
------------------------------------------------------------------------
[INFO] Total time:  13.259 s
[INFO] Finished at: 2022-05-02T06:18:04+02:00
[INFO]
------------------------------------------------------------------------
[ERROR] Failed to execute goal
org.springframework.boot:spring-boot-maven-plugin:2.6.1:run (default-cli)
on project nikita-noark5-core: Application finished with exit code: 1 ->
[Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e
switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions,
please read the following articles:
[ERROR] [Help 1]
http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
make: *** [Makefile:11: run] Error 1

On Sun, May 1, 2022 at 12:56 PM Thomas Sødring via nikita-noark <
nikita-noark at nuug.no> wrote:

> Hi Ole,
>
> The easiest way to get ES working for nikita is with docker
>
>   docker run -p 9200:9200 -p 9300:9300 -e "discovery.type=single-node"
> docker.elastic.co/elasticsearch/elasticsearch:7.10.0 &
>
> I think there is a hibernate / spring limitation that means we currently
> have to use ES7.
>
> The install instructions may not be clear enough seeing as you are
> having difficulty with this. I will look at the instructions again. Here
> are the install instructions.
>
>
> https://gitlab.com/OsloMet-ABI/nikita-noark5-core/-/blob/master/docs/general/Install.md
>
>   - Thomas
>
> On 4/30/22 20:18, Ole Aamot wrote:
> > [ole at fedora ~]$ cat /etc/yum.repos.d/elasticsearch.repo
> > [elasticsearch]
> > name=Elasticsearch repository for 8.x packages
> > baseurl=
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fartifacts.elastic.co%2Fpackages%2F8.x%2Fyum&data=05%7C01%7Ctsodring%40oslomet.no%7C0845b1ec61ee4574bf4d08da2ad5e950%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637869395633802132%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=gxfsrfQ3xoD7EOEJKv0Wa9paOY12lPnYYJNcRXo5nf8%3D&reserved=0
> >
> > gpgcheck=1
> > gpgkey=
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fartifacts.elastic.co%2FGPG-KEY-elasticsearch&data=05%7C01%7Ctsodring%40oslomet.no%7C0845b1ec61ee4574bf4d08da2ad5e950%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637869395633802132%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=IlGHfrwUoVOQ2cc9rZBTlvWFKsjJ913brO0tGwlxAms%3D&reserved=0
> >
> > enabled=0
> > autorefresh=1
> > type=rpm-md
> >
> > sudo dnf install --enablerepo=elasticsearch elasticsearch
> >
> > [ole at fedora ~]$ sudo service elasticsearch stop
> > Redirecting to /bin/systemctl stop elasticsearch.service
> > [ole at fedora ~]$ sudo service elasticsearch start
> > Redirecting to /bin/systemctl start elasticsearch.service
> > [ole at fedora ~]$ git clone
> >
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com%2FOsloMet-ABI%2Fnikita-noark5-core&data=05%7C01%7Ctsodring%40oslomet.no%7C0845b1ec61ee4574bf4d08da2ad5e950%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637869395633802132%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=YlxLyVq3GrijjnVxSjMKvWgvbKMt6pJdNsbkNo5iUeE%3D&reserved=0
> > [ole at fedora ~]$ cd nikita-noark5-core/
> > [ole at fedora ~]$ make run
> > [...]
> > Error starting ApplicationContext. To display the conditions report
> > re-run your application with 'debug' enabled.
> > 2022-04-30 20:16:16.164 ERROR 33206 --- [           main]
> > o.s.boot.SpringApplication               : Application run failed
> >
> > org.springframework.beans.factory.BeanCreationException: Error
> > creating bean with name 'entityManagerFactory' defined in class path
> > resource
> >
> [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]:
>
> > Invocation of init method failed; nested exception is
> > javax.persistence.PersistenceException: [PersistenceUnit: default]
> > Unable to build Hibernate SessionFactory; nested exception is
> > org.hibernate.search.util.common.SearchException: HSEARCH000520:
> > Hibernate Search encountered failures during bootstrap. Failures:
> >
> >     default backend:
> >         failures:
> >           - HSEARCH400080: Unable to detect the Elasticsearch version
> > running on the cluster: HSEARCH400007: Elasticsearch request failed:
> > Connection refused
> > Request: GET  with parameters {}
> > Response: (no response)
> >     at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154)
>
> > ~[spring-context-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908)
>
> > ~[spring-context-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
>
> > ~[spring-context-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145)
>
> > ~[spring-boot-2.6.1.jar:2.6.1]
> >     at
> >
> org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
>
> > ~[spring-boot-2.6.1.jar:2.6.1]
> >     at
> >
> org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:412)
>
> > ~[spring-boot-2.6.1.jar:2.6.1]
> >     at
> >
> org.springframework.boot.SpringApplication.run(SpringApplication.java:302)
> > ~[spring-boot-2.6.1.jar:2.6.1]
> >     at
> >
> org.springframework.boot.SpringApplication.run(SpringApplication.java:1301)
> > ~[spring-boot-2.6.1.jar:2.6.1]
> >     at
> >
> org.springframework.boot.SpringApplication.run(SpringApplication.java:1290)
> > ~[spring-boot-2.6.1.jar:2.6.1]
> >     at nikita.N5CoreApp.main(N5CoreApp.java:39) ~[classes/:na]
> > Caused by: javax.persistence.PersistenceException: [PersistenceUnit:
> > default] Unable to build Hibernate SessionFactory; nested exception is
> > org.hibernate.search.util.common.SearchException: HSEARCH000520:
> > Hibernate Search encountered failures during bootstrap. Failures:
> >
> >     default backend:
> >         failures:
> >           - HSEARCH400080: Unable to detect the Elasticsearch version
> > running on the cluster: HSEARCH400007: Elasticsearch request failed:
> > Connection refused
> > Request: GET  with parameters {}
> > Response: (no response)
> >     at
> >
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:421)
>
> > ~[spring-orm-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396)
>
> > ~[spring-orm-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341)
>
> > ~[spring-orm-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
>
> > ~[spring-beans-5.3.13.jar:5.3.13]
> >     ... 16 common frames omitted
> > Caused by: org.hibernate.search.util.common.SearchException:
> > HSEARCH000520: Hibernate Search encountered failures during bootstrap.
> > Failures:
> >
> >     default backend:
> >         failures:
> >           - HSEARCH400080: Unable to detect the Elasticsearch version
> > running on the cluster: HSEARCH400007: Elasticsearch request failed:
> > Connection refused
> > Request: GET  with parameters {}
> > Response: (no response)
> >     at
> >
> org.hibernate.search.engine.reporting.spi.RootFailureCollector.checkNoFailure(RootFailureCollector.java:50)
>
> > ~[hibernate-search-engine-6.0.6.Final.jar:6.0.6.Final]
> >     at
> >
> org.hibernate.search.engine.common.impl.SearchIntegrationBuilderImpl.prepareBuild(SearchIntegrationBuilderImpl.java:243)
>
> > ~[hibernate-search-engine-6.0.6.Final.jar:6.0.6.Final]
> >     at
> >
> org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.doBootFirstPhase(HibernateOrmIntegrationBooterImpl.java:259)
>
> > ~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
> >     at
> >
> org.hibernate.search.mapper.orm.bootstrap.spi.HibernateOrmIntegrationBooterBehavior.bootFirstPhase(HibernateOrmIntegrationBooterBehavior.java:17)
>
> > ~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
> >     at
> >
> org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.lambda$bootNow$7(HibernateOrmIntegrationBooterImpl.java:218)
>
> > ~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
> >     at java.base/java.util.Optional.orElseGet(Optional.java:364) ~[na:na]
> >     at
> >
> org.hibernate.search.mapper.orm.bootstrap.impl.HibernateOrmIntegrationBooterImpl.bootNow(HibernateOrmIntegrationBooterImpl.java:218)
>
> > ~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
> >     at
> >
> java.base/java.util.concurrent.CompletableFuture$UniApply.tryFire(CompletableFuture.java:646)
>
> > ~[na:na]
> >     at
> >
> java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:510)
>
> > ~[na:na]
> >     at
> >
> java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2147)
>
> > ~[na:na]
> >     at
> >
> org.hibernate.search.mapper.orm.bootstrap.impl.HibernateSearchSessionFactoryObserver.sessionFactoryCreated(HibernateSearchSessionFactoryObserver.java:41)
>
> > ~[hibernate-search-mapper-orm-6.0.6.Final.jar:6.0.6.Final]
> >     at
> >
> org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35)
>
> > ~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
> >     at
> >
> org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:394)
>
> > ~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
> >     at
> >
> org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471)
>
> > ~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
> >     at
> >
> org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1498)
>
> > ~[hibernate-core-5.6.1.Final.jar:5.6.1.Final]
> >     at
> >
> org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58)
>
> > ~[spring-orm-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365)
>
> > ~[spring-orm-5.3.13.jar:5.3.13]
> >     at
> >
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)
>
> > ~[spring-orm-5.3.13.jar:5.3.13]
> >     ... 20 common frames omitted
> >
> > [INFO]
> > ------------------------------------------------------------------------
> > [INFO] BUILD FAILURE
> > [INFO]
> > ------------------------------------------------------------------------
> > [INFO] Total time:  50.146 s
> > [INFO] Finished at: 2022-04-30T20:16:16+02:00
> > [INFO]
> > ------------------------------------------------------------------------
> > [ERROR] Failed to execute goal
> > org.springframework.boot:spring-boot-maven-plugin:2.6.1:run
> > (default-cli) on project nikita-noark5-core: Application finished with
> > exit code: 1 -> [Help 1]
> > [ERROR]
> > [ERROR] To see the full stack trace of the errors, re-run Maven with
> > the -e switch.
> > [ERROR] Re-run Maven using the -X switch to enable full debug logging.
> > [ERROR]
> > [ERROR] For more information about the errors and possible solutions,
> > please read the following articles:
> > [ERROR] [Help 1]
> >
> https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FMAVEN%2FMojoExecutionException&data=05%7C01%7Ctsodring%40oslomet.no%7C0845b1ec61ee4574bf4d08da2ad5e950%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637869395633802132%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PTIsQ7X44Hrn3X4i%2BlBUFk7lYufg87DGOHseP%2B12PqA%3D&reserved=0
> > make: *** [Makefile:11: run] Error 1
> >
> _______________________________________________
> nikita-noark mailing list
> nikita-noark at nuug.no
> https://lists.nuug.no/mailman/listinfo/nikita-noark
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.nuug.no/pipermail/nikita-noark/attachments/20220502/3a6ea5fe/attachment-0001.htm>


More information about the nikita-noark mailing list