Hi Michael,
Thanks for the quick response. Here is the full stacktrace (I think)...
2022-02-01 12:33:36,369 |OFBiz-JobQueue-44 |ServiceDispatcher
|E| Service [createRequirementStatus] threw an unexpected exception/error
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to
queue job [createRequirementStatus.1643747616369])
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
[ofbiz.jar:?]
at sun.reflect.GeneratedMethodAccessor1393.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue
job [createRequirementStatus.1643747616369]
at
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173)
~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
~[ofbiz.jar:?]
... 25 more
2022-02-01 12:33:36,377 |OFBiz-JobQueue-44 |TransactionUtil
|W| Calling transaction setRollbackOnly; this stack trace shows where this is
happening:
java.lang.Exception: Service [createRequirementStatus] threw an unexpected
exception/error
at
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:292)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:764)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
[ofbiz.jar:?]
at sun.reflect.GeneratedMethodAccessor1393.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022-02-01 12:33:36,383 |OFBiz-JobQueue-44 |ServiceDispatcher
|T| [[Sync service failed...- total:0.0,since last(Begin):0.0]] - 'default /
createRequirement'
2022-02-01 12:33:36,383 |OFBiz-JobQueue-44 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2022-02-01 12:33:36,383 |OFBiz-JobQueue-44 |ProposedOrder
|E| Error : createRequirement with parameters =
{userLogin=[GenericEntity:UserLogin][createdStamp,2021-12-20
09:32:20.339(java.sql.Timestamp)][createdTxStamp,2021-12-20
09:32:19.726(java.sql.Timestamp)][currentPassword,$SHA$3dODGJRbK1N$qvpr2vdLN8EgITdcHu4x951M2i8(java.lang.String)][disabledDateTime,2022-01-11
07:55:21.005(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][partyId,10000(java.lang.String)][passwordHint,****(java.lang.String)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,****(java.lang.String)],
requirementTypeId=PRODUCT_REQUIREMENT, facilityId=ACS_Kamloops,
quantity=7.000000, productId=FSR1509, statusId=REQ_PROPOSED,
requiredByDate=2022-02-01 12:30:38.002, description=Automatically generated by
MRP, requirementStartDate=2022-02-01 12:30:38.002}--Cannot run job. (Unable to
queue job [createRequirementStatus.1643747616369])
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to
queue job [createRequirementStatus.1643747616369])
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
[ofbiz.jar:?]
at sun.reflect.GeneratedMethodAccessor1393.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue
job [createRequirementStatus.1643747616369]
at
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173)
~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
~[ofbiz.jar:?]
... 25 more
2022-02-01 12:33:36,388 |OFBiz-JobQueue-44 |TransactionUtil
|W| 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.apache.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:718)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:148)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:323)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022-02-01 12:33:36,389 |OFBiz-JobQueue-44 |GenericDelegator
|E| Failure in findByCondition operation for entity [MrpEvent]:
org.apache.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: Service
[createRequirementStatus] threw an unexpected
exception/errororg.apache.ofbiz.service.GenericServiceException: Cannot run
job. (Unable to queue job [createRequirementStatus.1643747616369]) (Cannot run
job. (Unable to queue job [createRequirementStatus.1643747616369])). Rolling
back transaction.
org.apache.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: Service
[createRequirementStatus] threw an unexpected
exception/errororg.apache.ofbiz.service.GenericServiceException: Cannot run
job. (Unable to queue job [createRequirementStatus.1643747616369]) (Cannot run
job. (Unable to queue job [createRequirementStatus.1643747616369]))
at
org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:136)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:104)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1590)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:452)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:381)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntityQuery.queryOne(EntityQuery.java:423)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.InventoryEventPlannedServices.createOrUpdateMrpEvent(InventoryEventPlannedServices.java:70)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:830)
[ofbiz.jar:?]
at sun.reflect.GeneratedMethodAccessor1393.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.service.GenericServiceException: Cannot run job.
(Unable to queue job [createRequirementStatus.1643747616369])
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
~[ofbiz.jar:?]
... 13 more
Caused by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue
job [createRequirementStatus.1643747616369]
at
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173)
~[ofbiz.jar:?]
at org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
~[ofbiz.jar:?]
... 13 more
2022-02-01 12:33:36,399 |OFBiz-JobQueue-44 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2022-02-01 12:33:36,399 |OFBiz-JobQueue-44 |ServiceUtil
|E| {errorMessage=Error during creation or update MrpEvent, parameters:
{reInitialize=true, userLogin=[GenericEntity:UserLogin][createdStamp,2021-12-20
09:32:20.339(java.sql.Timestamp)][createdTxStamp,2021-12-20
09:32:19.726(java.sql.Timestamp)][currentPassword,$SHA$3dODGJRbK1N$qvpr2vdLN8EgITdcHu4x951M2i8(java.lang.String)][disabledDateTime,2022-01-11
07:55:21.005(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][partyId,10000(java.lang.String)][passwordHint,****(java.lang.String)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,****(java.lang.String)],
manufacturingFacilityId=ACS_Kamloops, mrpId=10352, facilityId=ACS_Kamloops,
defaultYearsOffset=1}, responseMessage=error}
2022-02-01 12:33:36,400 |OFBiz-JobQueue-44 |ServiceDispatcher
|E| Error in Service [executeMrp]: Error during creation or update MrpEvent,
parameters: {reInitialize=true,
userLogin=[GenericEntity:UserLogin][createdStamp,2021-12-20
09:32:20.339(java.sql.Timestamp)][createdTxStamp,2021-12-20
09:32:19.726(java.sql.Timestamp)][currentPassword,$SHA$3dODGJRbK1N$qvpr2vdLN8EgITdcHu4x951M2i8(java.lang.String)][disabledDateTime,2022-01-11
07:55:21.005(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][partyId,10000(java.lang.String)][passwordHint,****(java.lang.String)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,****(java.lang.String)],
manufacturingFacilityId=ACS_Kamloops, mrpId=10352, facilityId=ACS_Kamloops,
defaultYearsOffset=1}
2022-02-01 12:33:36,400 |OFBiz-JobQueue-44 |TransactionUtil
|E| [TransactionUtil.rollback]
java.lang.Exception: Stack Trace
at
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:314)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:290)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:559)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022-02-01 12:33:36,407 |OFBiz-JobQueue-58 |TransactionUtil
|W| Calling transaction setRollbackOnly; this stack trace shows where this is
happening:
java.lang.Exception: rollback called in Entity Engine SQLProcessor
at
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:66)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874)
[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:357)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:114)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022-02-01 12:33:36,407 |OFBiz-JobQueue-58 |GenericDelegator
|E| Failure in create operation for entity [RequirementStatus]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)). Rolling back transaction.
2022-02-01 12:33:36,407 |OFBiz-JobQueue-58 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2022-02-01 12:33:36,407 |OFBiz-JobQueue-58 |EntityAutoEngine
|E| Error doing entity-auto operation for entity [RequirementStatus] in service
[createRequirementStatus]: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)) (Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)))
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)) (Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)))
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:897)
~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:357)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:114)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while
inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails))
at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:172)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:66)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874)
~[ofbiz.jar:?]
... 11 more
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:INSERT INTO REQUIREMENT_STATUS (REQUIREMENT_ID,
STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:435)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:66)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874)
~[ofbiz.jar:?]
... 11 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or
update a child row: a foreign key constraint fails
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1027)
~[mysql-connector-java-8.0.16.jar:8.0.16]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
~[commons-dbcp2-2.5.0.jar:2.5.0]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:431)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:167)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:66)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874)
~[ofbiz.jar:?]
... 11 more
2022-02-01 12:33:36,408 |OFBiz-JobQueue-58 |ServiceUtil
|E| {errorMessage=Error doing entity-auto operation for entity
RequirementStatus in service createRequirementStatus:
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)) (Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails))), responseMessage=error}
2022-02-01 12:33:36,408 |OFBiz-JobQueue-58 |ServiceDispatcher
|E| Error in Service [createRequirementStatus]: Error doing entity-auto
operation for entity RequirementStatus in service createRequirementStatus:
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)) (Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)))
2022-02-01 12:33:36,408 |OFBiz-JobQueue-58 |TransactionUtil
|E| [TransactionUtil.rollback]
java.lang.Exception: Stack Trace
at
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:314)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:290)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:559)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022-02-01 12:33:36,411 |OFBiz-JobQueue-58 |TransactionUtil
|I| Transaction rolled back
2022-02-01 12:33:36,411 |OFBiz-JobQueue-58 |ServiceDispatcher
|T| Sync service [default/createRequirementStatus] finished in [58] milliseconds
2022-02-01 12:33:36,411 |OFBiz-JobQueue-58 |GenericServiceJob
|E| Async-Service failed.
java.lang.Exception: Error doing entity-auto operation for entity
RequirementStatus in service createRequirementStatus:
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)) (Error while inserting:
[GenericEntity:RequirementStatus][changeByUserLoginId,****(java.lang.String)][createdStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][createdTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][lastUpdatedStamp,2022-02-01
12:33:36.4(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
12:33:36.353(java.sql.Timestamp)][requirementId,35665(java.lang.String)][statusDate,2022-02-01
12:33:36.4(java.sql.Timestamp)][statusId,REQ_PROPOSED(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO REQUIREMENT_STATUS
(REQUIREMENT_ID, STATUS_ID, STATUS_DATE, CHANGE_BY_USER_LOGIN_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails)))
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:73)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022-02-01 12:33:36,413 |OFBiz-JobQueue-57 |TransactionUtil
|W| Calling transaction setRollbackOnly; this stack trace shows where this is
happening:
java.lang.Exception: rollback called in Entity Engine SQLProcessor
at
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:66)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:874)
[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericValue.create(GenericValue.java:76)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.EntityAutoEngine.invokeCreate(EntityAutoEngine.java:357)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.EntityAutoEngine.runSync(EntityAutoEngine.java:114)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Regards,
Steven Payne
Inventory Control Coordinator
-----Original Message-----
From: Michael Brohl <michael.br...@ecomify.de>
Sent: February 1, 2022 12:21 PM
To: user@ofbiz.apache.org
Subject: Re: MRP Not Working
Hi Steven,
it seems that you did not provide the whole stacktrace, at least I cannot find
a message containing hints for a failed foreign key constraint.
You should find the name of the failed constraint in the error log, near the
prepared statement log entry.
Please make your credentials shown in the log unreadable next time ;-)
Best regards,
Michael Brohl
ecomify GmbH - www.ecomify.de
Am 01.02.22 um 21:02 schrieb Steven Payne:
Hi All,
I am trying to run the MRP system here and I am coming across a weird error.
Has anyone else had issues with running MRP and it not being able to create a
REQUIREMENT_STATUS?
I managed to find the start of the error (posted below) and I am trying one by
one to add each manufacturing run to see if I can isolate the issue. No luck
so far. It states that there is a foreign key constraint breaking...but what FK
constraint?
2022-02-01 11:59:21,676 |OFBiz-JobQueue-47 |ServiceDispatcher
|E| Service [createRequirementStatus] threw an unexpected exception/error
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to
queue job [createRequirementStatus.1643745561676])
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_312]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_312]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312] Caused
by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue job
[createRequirementStatus.1643745561676]
at
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
~[ofbiz.jar:?]
... 26 more
2022-02-01 11:59:21,677 |OFBiz-JobQueue-47 |TransactionUtil
|W| Calling transaction setRollbackOnly; this stack trace shows where this is
happening:
java.lang.Exception: Service [createRequirementStatus] threw an unexpected
exception/error
at
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:292)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:764)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_312]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_312]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022-02-01 11:59:21,678 |OFBiz-JobQueue-47 |ServiceDispatcher
|T| [[Sync service failed...- total:0.0,since last(Begin):0.0]] - 'default /
createRequirement'
2022-02-01 11:59:21,678 |OFBiz-JobQueue-47 |TransactionUtil
|I| Transaction rollback only not set, rollback only is already set.
2022-02-01 11:59:21,678 |OFBiz-JobQueue-47 |ProposedOrder
|E| Error : createRequirement with parameters =
{userLogin=[GenericEntity:UserLogin][createdStamp,2021-12-20
09:32:20.339(java.sql.Timestamp)][createdTxStamp,2021-12-20
09:32:19.726(java.sql.Timestamp)][currentPassword,$SHA$3dODGJRbK1N$qvpr2vdLN8EgITdcHu4x951M2i8(java.lang.String)][disabledDateTime,2022-01-11
07:55:21.005(java.sql.Timestamp)][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][lastLocale,en_CA(java.lang.String)][lastTimeZone,America/Vancouver(java.lang.String)][lastUpdatedStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][lastUpdatedTxStamp,2022-02-01
10:07:24.345(java.sql.Timestamp)][partyId,10000(java.lang.String)][passwordHint,****(java.lang.String)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,****(java.lang.String)],
requirementTypeId=PRODUCT_REQUIREMENT, facilityId=ACS_Kamloops,
quantity=7.000000, productId=FSR1509, statusId=REQ_PROPOSED,
requiredByDate=2022-02-01 11:36:45.002, description=Automatically generated by
MRP, requirementStartDate=2022-02-01 11:36:45.002}--Cannot run job. (Unable to
queue job [createRequirementStatus.1643745561676])
org.apache.ofbiz.service.GenericServiceException: Cannot run job. (Unable to
queue job [createRequirementStatus.1643745561676])
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:143)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:70)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:748)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runAsync(ServiceDispatcher.java:813)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runAsync(GenericDispatcherFactory.java:181)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:131)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:160)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:191)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:514)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
~[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.ProposedOrder.create(ProposedOrder.java:262)
[ofbiz.jar:?]
at
org.apache.ofbiz.manufacturing.mrp.MrpServices.executeMrp(MrpServices.java:816)
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_312]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_312]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_312]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_312]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:415)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312] Caused
by: org.apache.ofbiz.service.job.InvalidJobException: Unable to queue job
[createRequirementStatus.1643745561676]
at
org.apache.ofbiz.service.job.GenericServiceJob.deQueue(GenericServiceJob.java:151)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.JobPoller.queueNow(JobPoller.java:173)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.JobManager.runJob(JobManager.java:366)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.engine.GenericAsyncEngine.runAsync(GenericAsyncEngine.java:141)
~[ofbiz.jar:?]
... 26 more
2022-02-01 11:59:21,680 |OFBiz-JobQueue-47 |TransactionUtil
|W| 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.apache.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:718)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:148)
~[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:323)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:240)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
[ofbiz.jar:?]
at org.apache.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
[ofbiz.jar:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_312]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
Regards,
Steven Payne
Inventory Control Coordinator
