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
>