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 >
