Message Boards

  1. Home
  2. Development
  3. service builder not creating tables

service builder not creating tables

marvin ros, modified 4 Years ago.

service builder not creating tables

Junior Member Posts: 35 Join Date: 5/9/19 Recent Posts
Hello everyone,

I have an issue that my DB tables from a service module are not created after I deploy the api and service module for the first time on a new server.
This specific module has an UpgradeStepRegistrator see -> https://help.liferay.com/hc/en-us/articles/360017889772-Creating-Data-Upgrade-Processes-for-Modules-

The required DB tables are not created but an entry in the release_ table with the right schema version is created.

If I comment out the entire UpgradeStepRegistrator class the DB tables will be created at the first deploy of the modules. 
I noticed this because I have a bunch of other modules that dont have an UpgradeStepRegistrator. In these modules the DB tables are created successfully at the first deploy.

I have this problem since I upgraded to Liferay CE 7.1.3 with the comulative patch applied (https://liferay.dev/blogs/-/blogs/security-patches-for-liferay-portal-6-2-7-0-and-7-1)

best regards
thumbnail
Alberto Chaparro Terleira, modified 4 Years ago.

RE: service builder not creating tables

Liferay Master Posts: 549 Join Date: 4/25/11 Recent Posts
Hi Marvin,
Can you provide more details why you need an UpgradeStepRegistrator in this case? That class is useful when you need to change the data definition for a module, are you changing the data definition of a service builder module? Please, provide all details you have to figure out what's happening.
Thanks.
marvin ros, modified 4 Years ago.

RE: service builder not creating tables

Junior Member Posts: 35 Join Date: 5/9/19 Recent Posts
Hello Alberto,

I need this UpgradeStepRegistrator class because in the past there was a feature request for my module so I had to change the db schema (added some columns and some other things) to provide the feature without data loss on our production environment db table.

I am now trying to deploy this module on a fresh liferay Server 7.1.3 with comulative patch applied. On this server my module was never installed.
So when I try to deply my module as it is no DB tables will be created. 
If I remove the UpgradeStepRegistrator class the module creates its tables successfully. 

My main Problem is that this module wont create its db tables if there is its UpgradeStepRegistrator class. I dont know why this is happening.
Can you tell me what is the trigger for a module to create its db tables on the very first deploy? 

I also think I did not have this problem on Liferay 7.1.3 without the patch applied. Can anybody confirm this?

thanks in advance