Unable to Re generate Database

Support
#1

I had trouble regenerating the database due to an error in the liquidbase changelog. We solved it by deleting the changelog files alltogether and deleting the database separately in navicat.

image

Deleting the changelog solved the issues that stopped me from regenerating the database. So we Regenerated the database, Updated it and regenerated the database scripts.

image

On intelliJ this went on without an issue, but when we checked the database, we noticed it did not regenerate all tables. Only the system tables appear.

image

Jmix is not allowing me to rebuild the database, Is there a way to fix this? it had been working previously without issues

#2

Hi.
Could you please clarify the steps:
First, you recreate the database, then you generate the changelog and after the generation, you run the update?

Did the generated changelog contain scripts with all your entities?

#3

yes:
Recreate the database

image
image

then I Generate the Changelog:
image

And it does contain all the entities:
image

then I update:
image
it says it is synched
image

all I get is the main system tables on the DB
image

I have no errors and no warnings.
Any suggestions here are welcome

#4

Quick update:
To make sure it was not a local error I restarted everything, Laptop, server, and deleted the entire database manually for Jmix to rebuild it.

Now It created quite a few more tables than before, but none of the Entities I created manually.

image

image

#6

Hi I just wanted to update you on this issue,
the problem was that we deleted some files along with the changelog, specifically the changelog and the 010-init-user
image

we regained them form other projects and it rebuild everything propperly