Schema-validation: missing table [association_value_entry]

I’m facing this issue:

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.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [association_value_entry]

Seems like Axon can’t create AssociationValueEntry entity. I’m using JPA with PostgreSQL driver on top of Spring Boot.

The error disappears if I remove axon-spring-boot-starter dependency.

I can provide example repo if needed.

Issue Analytics

State:
Created 4 years ago
Comments:6 (3 by maintainers)

Top GitHub Comments

6reactions

smcvbcommented, Mar 12, 2020

@DavidArutiunian, sorry for the long wait. I’ve been thorn with travel and other work as well, so I had to keep you waiting. My apologies for that.

However, I have found the problem with your application. From your sample I noticed you are using FlyWay; definitely a good thing by the way. Additionally, you have set the spring.jpa.hibernate.ddl-auto to validate. Also reasonable, given that FlyWay will instantiate the tables for you.

The exception you’re receiving indeed lies through the auto configuration of Axon. Axon requires a set of entities to be created to be able to work, which are the association_value_entry, saga_entry and token_entry tables. However, as you’ve set the ddl-auto, it is expected those tables are already present or created through FlyWay. Neither are the case at the moment, hence a faulty start up of the application.

To solve this you could go two ways:

Add the Axon tables to a dedicated FlyWay script
Change ddl-auto to update

Having said all this, I will be closing this issue with the tag “Question” attached to it. If you happen to have further usage question on different topics, I recommend to post those on the usergroup or on StackOverflow using the axon tag.

Hope this helps you out!

3reactions

DavidArutiuniancommented, Mar 12, 2020

@smcvb thanks!

Top Results From Across the Web

Schema-validation: missing table [game] - Stack Overflow

validate validates that the entities are compatible against the target, to a degree it's not foolproof. Anyway, whatever database you are ...

getting error Schema-validation: missing table [member ...

Does the user that's configured in Spring have access to this table? Because if not, it's as if the table doesn't exist for...

3 Liquibase Support in SQLcl - Oracle Help Center

The Liquibase feature in SQLcl enables you to execute commands to generate a changelog for a single object or for a full schema...

Hibernate ORM 5.4.33.Final User Guide - Red Hat on GitHub

Generating Envers schema with Hibernate hbm2ddl tool; 21.21. ... Whether a Java type is "known" means it has an entry in the JavaTypeDescriptorRegistry...

XML Schema 2.0 User Guide (v1.1 - BSA E-Filing System

All fields require an entry when the filer has the relevant data. This specifies any requirements and/or restrictions involving the value recorded for...