Message Boards

Service builder table is not created

Durai pandian, modified 2 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 2 Years ago.

RE: Service builder table is not created

Liferay Legend Posts: 6396 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.
vinoth kumar, modified 3 Months ago.

RE: Service builder table is not created

New Member Posts: 17 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.