Database Recreate - ERROR: relation "public.sec_user" does not exist

Jmix version: 1.1.2
Jmix Studio plugin version: 1.1.4-213
IntelliJ IDEA 2021.3 CE - Build #IC-213.5744.223, built on November 27, 2021
Operating System: macOS 12.0.1 (21A559)
File System: Case-Sensitive Journaled HFS+ (APFS)
Datebase: PostgreSQL 13

Hi Everyone

I am trying to create a new database with Jmix for my migrated project for the first time and receive this “ERROR: relation “public.sec_user” does not exist” failure. Please see the attached file for the complete console output.

The migration created the User.class below…

@Entity(name = “sec$User”)
@Table(name = “SEC_USER”)
public class User implements JmixUserDetails, HasTimeZone {

@Column(name = "ID", nullable = false)
private UUID id;

and I have even tried to modify the entity and table names like in the Petclinic example, which does run, but that did not help.
Liquibase_console_error_public.sec_user_does_not_exist.txt (7.8 KB)

I spent the last week refactoring my code and commenting out a few things, so I could get everything to compile but now I am stuck and do not know what to do. I just downloaded version 1.1.2 and that did not help either.

Any ideas?

Best regards


I was looking in the Database Migration :: Jmix Documentation section and I missed the information in Section 13. of Migration from CUBA :: Jmix Documentation about explicitly creating a new empty database after the migration. My failure.