You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Bs Serge <se...@gmail.com> on 2021/11/10 10:56:18 UTC
cleanAll loadAll
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
Re: cleanAll loadAll
Posted by Bs Serge <se...@gmail.com>.
don't bother.
solved. it was my issue.
Best Regards,
On Wed, Nov 10, 2021 at 12:57 PM Bs Serge <se...@gmail.com> wrote:
> The version is: Ofbiz 17.12
> Database : MySQL 8
>
>
> On Wed, Nov 10, 2021 at 12:56 PM Bs Serge <se...@gmail.com> 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
>>
>
Re: cleanAll loadAll
Posted by Bs Serge <se...@gmail.com>.
The version is: Ofbiz 17.12
Database : MySQL 8
On Wed, Nov 10, 2021 at 12:56 PM Bs Serge <se...@gmail.com> 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
>