You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Steven Payne <st...@acsinc.ca> on 2022/02/01 20:02:51 UTC

MRP Not Working

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,Cat(java.lang.String)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,spayne(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

RE: MRP Not Working

Posted by Steven Payne <st...@acsinc.ca>.

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 <mi...@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 <mi...@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
>>
>>

Re: MRP Not Working

Posted by Michael Brohl <mi...@ecomify.de>.

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 <mi...@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
>>
>>

RE: MRP Not Working

Posted by Steven Payne <st...@acsinc.ca>.

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 <mi...@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
>
>

Re: MRP Not Working

Posted by Michael Brohl <mi...@ecomify.de>.

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,Cat(java.lang.String)][requirePasswordChange,N(java.lang.String)][successiveFailedLogins,0(java.lang.Long)][userLoginId,spayne(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
>
>