1. Home
  2. Development
  3. RE: Service builder table is not created

RE: Service builder table is not created

Durai pandian, modified 3 Years ago.
Service builder table is not created
New Member Posts: 11 Join Date: 10/25/12 Recent Posts

I have used db-support:clean-service-builder to clean the schema. Then I have updated the schema added new coulumn and used the same table name(namespace). After deploying the jat the table is not created. I am getting this error.

JDBCExceptionReporter:234 - user lacks privilege or object not found:

thumbnail
Olaf Kock, modified 3 Years ago.
RE: Service builder table is not created
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts
  • Typically Servicebuilder only creates tables on first deployment...
  • ...unless Developer-settings are active
  • and, of course, if the user you use to connect to the database has appropriate permissions.
Jamie Sammons, modified 11 Months ago.
RE: Service builder table is not created
New Member Posts: 24 Join Date: 6/13/23 Recent Posts

Hey antony, I faced the same issue and i solved this by

Deleting the existing custom table created in SQL, Deleting the entry created for your service.xml in release table and servicecomponent table in SQL.

Clean, re-build the service-builder and Deploy your service-builder.

Now, Your new fields will be created in custom table in SQL.