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
