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')))

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1

Stack trace

  • 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]

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

We couldn't find other users who have seen this exception.