OK will do,
I haven't modified anything, just haven't loaded all the demo data into the
database, I created our own dataset. It has been working perfect until now. So
it leads me to believe there is something in the data that is causing this.
What is weird though is it is failing when it is using the entity-auto create
method.
The status Item is there and the user login are there, so it leads me to
believe it’s the requirement that is missing... But it's running MRP so it's
creating the requirement in the first place... ugh.
Regards,
Steven Payne
Inventory Control Coordinator
-----Original Message-----
From: Michael Brohl <michael.br...@ecomify.de>
Sent: February 1, 2022 2:09 PM
To: user@ofbiz.apache.org
Subject: Re: MRP Not Working
Hi Steven,
the table RequirementStatus has 3 foreign keys: requirementId, statusId
and changeByUserLoginId.
Are those ids present in their tables (Requirement, StatusItem,
UserLogin)? Is all seed data loaded?
Is this a custom installation or standard OFBiz?
If you think this is a bug, you might want to file a Jira. Please give
as much information as possible there on how to recreate this error.
Thanks and regards,
Michael Brohl
ecomify GmbH - www.ecomify.de
Am 01.02.22 um 21:37 schrieb Steven Payne:
> 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
>>
>>
