don't bother. solved. it was my issue.
Best Regards, On Wed, Nov 10, 2021 at 12:57 PM Bs Serge <[email protected]> wrote: > The version is: Ofbiz 17.12 > Database : MySQL 8 > > > On Wed, Nov 10, 2021 at 12:56 PM Bs Serge <[email protected]> wrote: > >> Hi >> >> What do you think could be the cause of this exception after running: >> ./gradlew cleanAll loadAll? >> >> The system is looking for a table obviously which have not been created >> yet? >> >> Kindly any help would be appreciated! >> >> Best regards, >> >> 2021-11-10 12:53:0Caused by: >> org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while >> executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, >> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM >> SECURITY_PERMISSION WHERE PERMISSION_ID=? (Table >> 'ofbiz.security_permis0,593 |main |TransactionUtil >> |I| Transaction rolled back >> sion' doesn't exist) >> at >> org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:402) >> at >> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:490) >> at >> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466) >> at >> org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81) >> at >> org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1317) >> ... 13 more >> Caused by: java.sql.SQLSyntaxErrorException: Table >> 'ofbiz.security_permission' doesn't exist >> at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) >> at >> com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) >> at >> com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) >> at >> com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009) >> at >> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) >> at >> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) >> at >> org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) >> ... 17 more >> :ofbiz --load-data FAILED >> >
