Hi again,
Ok, I bit the bullet and wiped MariaDB and instead installed MySQL server
("Server version: 5.6.25-0ubuntu0.15.04.1 (Ubuntu)") - also from standard
Ubuntu packaging (apt-get). A very similar issue occurs for some SQL
statements - but in this case the specific OPTION invoked is revealed as
"SQL_SELECT_LIMIT=1" (or default - or whatever).
A quick grep through the enclosed java code the only location I see the
string "SQL_SELECT_LIMIT" is in an array in
framework/entity/src/org/ofbiz/entity/model/ModelEntityChecker.java. But
then I probably don't have full source as I downloaded the "binary"
distribution of OFBiz.
Btw. for reference, I installed the mysql JDBC drivers as per the build
documentation: ./ant download-mySQL-JDBC.
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
(You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'OPTION
SQL_SELECT_LIMIT=1' at line 1)
runtime/logs/error.log:Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=1'
at line 1
Thanks in advance for your assistance.
Best regards,
Morten Jensen
On Wed, Aug 26, 2015 at 8:42 AM, Morten Jensen <[email protected]> wrote:
> Hi,
>
> I'm an OFBiz newbie but have managed to get through installation of OFBiz
> version 13.07.02 with MySQL (MariaDB "Server version:
> 10.0.20-MariaDB-0ubuntu0.15.04.1 (Ubuntu)"). However, I notice in the logs
> errors for some queries:
>
> Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
>
> I have included an example of the rather extensive logging that follows at
> the bottom of this email. The problems have so far not directly caused
> OFBiz to fail at frontend but I do see the errors occuring when I browse
> some areas of the app (or even of its own in the background jobs) - for
> instance when I enter Accounts Chart in Accounts.
>
> Does anyone know what is causing this problem? (At list in MariaDB) there
> doesn't appear to be a system variable 'OPTION' but I'm not entirely
> convinced that this error message isn't misleading?
>
> Thanks in advance for your assistance.
>
> Best regards,
> Morten
>
>
>
> 2015-08-26 00:00:23,370 |OFBiz-JobQueue-0
> |TransactionUtil |W| [TransactionUtil.begin] active
> transaction marked for rollback in place, so no transaction begun; this
> stack trace shows when the exception began:
> java.lang.Exception: Tx Stack Placeholder
> at
> org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:743)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:169)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:314)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> [ofbiz-service.jar:?]
> at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
> [ofbiz-service.jar:?]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [?:1.7.0_79]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [?:1.7.0_79]
> at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
> 2015-08-26 00:00:23,370 |OFBiz-JobQueue-0
> |GenericDelegator |E| Failure in findOne operation for entity
> [OrderHeader]: org.ofbiz.entity.transaction.GenericTransactionException:
> The current transaction is marked for rollback, not beginning a new
> transaction and aborting current operation; the rollbackOnly was caused by:
> Failure in findByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (Unknown system variable 'OPTION'). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION')). Rolling back
> transaction.
> org.ofbiz.entity.transaction.GenericTransactionException: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> findByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (Unknown system variable 'OPTION'). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION'))
> at
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:156)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:124)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1500)
> [ofbiz-entity-test.jar:?]
> at
> org.ofbiz.order.order.OrderReadHelper.<init>(OrderReadHelper.java:132)
> [ofbiz-order.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocsForOrder(OrderServices.java:5800)
> [ofbiz-order.jar:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[?:1.7.0_79]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[?:1.7.0_79]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> at
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5788)
> [ofbiz-order.jar:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[?:1.7.0_79]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[?:1.7.0_79]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> at
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> [ofbiz-service.jar:?]
> at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
> [ofbiz-service.jar:?]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [?:1.7.0_79]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [?:1.7.0_79]
> at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
> Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION')
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:391)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> ~[ofbiz-entity-test.jar:?]
> at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> ~[ofbiz-order.jar:?]
> ... 14 more
> Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> ~[mysql-connector-java-5.1.6.jar:?]
> at
> com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1463)
> ~[mysql-connector-java-5.1.6.jar:?]
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1872)
> ~[mysql-connector-java-5.1.6.jar:?]
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> ~[commons-dbcp-1.4.jar:1.4]
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> ~[commons-dbcp-1.4.jar:1.4]
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> ~[ofbiz-entity-test.jar:?]
> at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> ~[ofbiz-order.jar:?]
> ... 14 more
> 2015-08-26 00:00:23,372 |OFBiz-JobQueue-0
> |TransactionUtil |I| [TransactionUtil.setRollbackOnly]
> transaction rollback only not set, rollback only is already set.
> 2015-08-26 00:00:23,372 |OFBiz-JobQueue-0
> |OrderReadHelper |E| Error finding order with ID [DEMO10090]:
> org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.transaction.GenericTransactionException: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> findByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (Unknown system variable 'OPTION'). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION')) (The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> findByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (Unknown system variable 'OPTION'). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION')))
> org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.transaction.GenericTransactionException: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> findByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (Unknown system variable 'OPTION'). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION')) (The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Failure in
> findByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (Unknown system variable 'OPTION'). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION')))
> at
> org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1534)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.order.order.OrderReadHelper.<init>(OrderReadHelper.java:132)
> [ofbiz-order.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocsForOrder(OrderServices.java:5800)
> [ofbiz-order.jar:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[?:1.7.0_79]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[?:1.7.0_79]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> at
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5788)
> [ofbiz-order.jar:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[?:1.7.0_79]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> ~[?:1.7.0_79]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> at
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> [ofbiz-service.jar:?]
> at
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> [ofbiz-service.jar:?]
> at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
> [ofbiz-service.jar:?]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [?:1.7.0_79]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [?:1.7.0_79]
> at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
> Caused by: org.ofbiz.entity.transaction.GenericTransactionException: The
> current transaction is marked for rollback, not beginning a new transaction
> and aborting current operation; the rollbackOnly was caused by: Failure in
> findByCondition operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (Unknown system variable 'OPTION'). Rolling back
> transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION') (SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION'))
> at
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:156)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:124)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1500)
> ~[ofbiz-entity-test.jar:?]
> ... 26 more
> Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception
> while executing the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID,
> STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME,
> MAX_RETRY, CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
> CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
> START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
> FROM JOB_SANDBOX WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY
> START_DATE_TIME DESC (Unknown system variable 'OPTION')
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:391)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> ~[ofbiz-entity-test.jar:?]
> at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> ~[ofbiz-order.jar:?]
> ... 14 more
> Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> ~[mysql-connector-java-5.1.6.jar:?]
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> ~[mysql-connector-java-5.1.6.jar:?]
> at
> com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1463)
> ~[mysql-connector-java-5.1.6.jar:?]
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1872)
> ~[mysql-connector-java-5.1.6.jar:?]
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> ~[commons-dbcp-1.4.jar:1.4]
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> ~[commons-dbcp-1.4.jar:1.4]
> at
> org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> ~[ofbiz-entity-test.jar:?]
> at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> ~[ofbiz-entity-test.jar:?]
> at
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> ~[ofbiz-order.jar:?]
> ... 14 more
> 2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
> |ServiceDispatcher |T| [[Sync service failed...-
> total:0.0,since last(Begin):0.0]] - 'default /
> createAlsoBoughtProductAssocsForOrder'
> 2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
> |TransactionUtil |I| [TransactionUtil.setRollbackOnly]
> transaction rollback only not set, rollback only is already set.
> 2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
> |OrderServices |E| null
>
>
>
>
