Nikita Noark5 Core 0.7 med ElasticSearch 8.1.3
Ole Aamot
ole at aamotsoftware.no
Tue Aug 2 15:30:22 CEST 2022
On Wed, May 4, 2022 at 4:57 PM Thomas Sødring <tsodring at oslomet.no> wrote:
> Hi Ole,
>
Hi Thomas,
> Sorry for the delay in getting back - I have been very busy the last few
> days. Before you try to run nikita could you try to start the ES instance
> using the following command:
>
I was able to launch docker with the ES instance by running
git clone https://gitlab.com/OsloMet-ABI/nikita-noark5-core
sudo service docker start
sudo docker run -p 9200:9200 -p 9300:9300 -e "discovery.type=single-node"
docker.elastic.co/elasticsearch/elasticsearch:7.10.0 &
cd nikita-noark5-core/
make run
> docker run -p 9200:9200 -p 9300:9300 -e "discovery.type=single-node"
> docker.elastic.co/elasticsearch/elasticsearch:7.10.0
> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdocker.elastic.co%2Felasticsearch%2Felasticsearch%3A7.10.0&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ssznM2edyxndmMB0yt5xqybWRBvdiH3ovIor08CNBts%3D&reserved=0>
> &
>
> Thanks, that was the magic command...
> I will take a look at the scripts and see if anything needs to be updated.
>
Nikita 0.8 from GitLab runs stable on Fedora Core 36 with ES on docker, but
crash with
ibernate: alter table system_id_entity add constraint
FK4wyctfg8e48xs080sjbewmto5 foreign key (owned_by) references
ad_organisation
2022-08-02 15:28:57.710 INFO 8561 --- [ main]
o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform
implementation:
[org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2022-08-02 15:28:59.182 ERROR 8561 --- [ 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: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]
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.Net.pollConnect(Native Method) ~[na:na]
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672) ~[na:na]
at
java.base/sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:946)
~[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:833) ~[na:na]
2022-08-02 15:28:59.197 INFO 8561 --- [ 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-08-02 15:28:59.198 INFO 8561 --- [ main]
org.hibernate.orm.connections.access : HHH10001501: Connection obtained
from JdbcConnectionAccess
[org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess at 733e1e36]
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-08-02 15:28:59.438 ERROR 8561 --- [ 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-08-02 15:28:59.440 WARN 8561 --- [ 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-08-02 15:28:59.441 INFO 8561 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown
initiated...
2022-08-02 15:28:59.449 INFO 8561 --- [ main]
com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown
completed.
2022-08-02 15:28:59.454 INFO 8561 --- [ main]
o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2022-08-02 15:28:59.498 INFO 8561 --- [ main]
ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run
your application with 'debug' enabled.
2022-08-02 15:28:59.526 ERROR 8561 --- [ 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: 29.526 s
[INFO] Finished at: 2022-08-02T15:28:59+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
Best,
Ole
> On 5/2/22 06:19, Ole Aamot wrote:
>
> 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
> <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com%2FOsloMet-ABI%2Fnikita-noark5-core%2F-%2Fblob%2Fmaster%2Fdocs%2Fgeneral%2FInstall.md&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=F3h4mDDuYvCepsAIDnMKBax%2B3y4o7c9udgHTjU%2BtxUk%3D&reserved=0>
>
> I installed docker.io
> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdocker.io%2F&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=KSWJK1I2BvXSL9xbqhWD5z%2BAuCbohfm%2ByHJ%2BQdAspbs%3D&reserved=0>
> from apt on Ubuntu 22.04.
>
> ole at ubuntu:~/nikita-noark5-core$ sudo apt install docker.io
> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdocker.io%2F&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=KSWJK1I2BvXSL9xbqhWD5z%2BAuCbohfm%2ByHJ%2BQdAspbs%3D&reserved=0>
>
> 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
> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdocker.io%2Fnikita5%2Fnoark5-tester%3Alatest&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=yK7KJTGx0dHO%2F4V90ahJQlXVVtnHKGRHUfhSZxvgWR8%3D&reserved=0>
> 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
> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdocker.io%2Foslometabi%2Fnikita-noark5-core%3Alatest&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=vKGVPmP%2FCxG1Kukyjt3kisp1K%2BR679BH2L29nvF3boM%3D&reserved=0>
> 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
> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FMAVEN%2FMojoExecutionException&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=hPoDJLe%2Fn3bVMXkXjoPkAeU6ne9s9b7FcyWoiAeLREY%3D&reserved=0>
> 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
>> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdocker.elastic.co%2Felasticsearch%2Felasticsearch%3A7.10.0&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ssznM2edyxndmMB0yt5xqybWRBvdiH3ovIor08CNBts%3D&reserved=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
>> <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com%2FOsloMet-ABI%2Fnikita-noark5-core%2F-%2Fblob%2Fmaster%2Fdocs%2Fgeneral%2FInstall.md&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=F3h4mDDuYvCepsAIDnMKBax%2B3y4o7c9udgHTjU%2BtxUk%3D&reserved=0>
>>
>> - 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
>> <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fartifacts.elastic.co%2Fpackages%2F8.x%2Fyum&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=f8ciqgWE0RGzWkTBBJochonhmQ5yzf8OEgD0Wm2gqOw%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
>> <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fartifacts.elastic.co%2FGPG-KEY-elasticsearch&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2B9PwTjTs73k%2BvNLAudHe%2FbvdTuLAfdG92GYOfk5q6h8%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
>> <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com%2FOsloMet-ABI%2Fnikita-noark5-core&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=VOVe7llnkcpq3OCjULQPglmbFIMrSHwmODZ0tjoOlss%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
>> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FMAVEN%2FMojoExecutionException&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=hPoDJLe%2Fn3bVMXkXjoPkAeU6ne9s9b7FcyWoiAeLREY%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
>> <https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.nuug.no%2Fmailman%2Flistinfo%2Fnikita-noark&data=05%7C01%7Ctsodring%40oslomet.no%7Cbddabe921e0f4eb4ddb108da2bf30456%7Cfec81f12628645508911f446fcdafa1f%7C0%7C0%7C637870620004467664%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=EbOjPPn8jTZeULkIWcASDd82C%2BZIndNWlZZ7Q2I9VNI%3D&reserved=0>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.nuug.no/pipermail/nikita-noark/attachments/20220802/8efe23d9/attachment-0001.htm>
More information about the nikita-noark
mailing list